IntegraMOD

Your phpBB Version: 2.0.
phpBB Type: Standard phpBB
MODs: No
Your knowledge: Beginner
Board URL: [url]http://[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?



What was done to try to solve the problem?




De.scription and Message

Could not query users

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT username, user_id, user_posts, user_avatar, user_avatar_type, user_allowavatar FROM phpbb_users WHERE user_id <> -1 ORDER BY user_posts DESC LIMIT

Line : 38
File : blocks_imp_top_posters.php

dont know if its all about sql or the php block file?
help pls...

thanks

Not all Integramod blocks are supported by phpbb/IM Portal. Many of the Integramod 132-141 blocks were written to support mods added to make Integramod. Remove the top posters block and see if the error stops

hi helter

the error occured when i installed the "top poster block" mod. and i did what u said to remove the top poster block file in my ftp but i got alot of errors.

i did copy all the files to my ftp, i dont know why i still got error. here is the install.txt from the top poster block. hope u can help me figure out. do i still need to copy it to sql? thanks in advance.

Code: Select all

############################################################## ## MOD Title]http://www.integramod.com#[/url]# MOD De.scription:  Top Posters block for IM Portal##                   ## MOD Version: 1.0.1#### Installation Level: Easy## Installation Time:  1 Minute ## Files To Edit:  none#### Included Files: blocks_imp_top_posters.php##          blocks_imp_top_posters.cfp##          lang_top_posters_block.php##          top_posters_block.tpl############################################################## ## Author Notes: Backup first your files and database before proceeding with the installation.################################################################## MOD History: ####   2004-05-29 - Version 1.0.1##   - made compatible with IM Portal 1.2.0##   - blocks config file included####   2004-05-15 - Version 1.0.0##   - first release################################################################ ## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD ##############################################################  # #-----[ COPY ]------------------------------------------ #  copy blocks_imp_top_posters.php to blocks/blocks_imp_top_posters.phpcopy blocks_imp_top_posters.cfg to blocks/blocks_imp_top_posters.cfgcopy lang_top_posters_block.php to blocks/language/lang_english/lang_top_posters_block.phpcopy top_posters_block.tpl to templates/YOUR_THEME/blocks/top_posters_block.tpl  # #-----[ OTHERS ]------------------------------------------ #  Note: This block can be cached with cache duration according to the frequency of changes in number of posts by your members.  You can download the new IM Portal Manual in [url=http://www.integramod.com]http://www.integramod.com[/url] download section for complete information on using IM Portal.  # #-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ # # EoM

what version of mysql are you running? I just installed it with no troubles on my test forum, but im running php5/mysql4

to remove it you would need to disable the block in your acp/IM Portal/Blocks Management

i disabled the block already in blocks management in my acp but everytime i click reply to posts, i get this error

[color=red]Could not query recent topics information

DEBUG MODE

SQL Error ]

my php version is 2.11.4 and my sql is 4.1.22

maybe i have to run sql for this "top poster" block?

thanks in advance

2.11.4 is your phpmyadmin version. your php version is different. Im sure it starts either with a 4. or a 5.

there is no sql for the block. try deleting the cach in acp/IM Portal/delete cache

if you cant get to the acp, just empty roof/var_cache but leave the index.html there

i deleted already the cache in acp/im portal but still the same. i tired to empty the var_cache in the root folder and leave the index.html but nothing works... <img>

i need to solve this error but just dont know what to do...

more thanks in advance for helping

have you removed all the files relating to top posters block and is there anything else you did at all...

Also a link if you have one....pm Helter or myself if you want it kept private...

hi found it

i'm not sure what kind of link u are referring too but i sent u my board link.

right now, i have the system-wide portal header and footer.

only i get the error when i enable to "yes" the system-wide portal in my acp/im portal/config.

i removed all the files relating top poster block but then i got a lot more errors and i dont know why <img> i have copied the files again til i dont figure out how to remove the sql error....

Hi

I had a look at your site but could not see the error you received though I did try to join so I might see more of your board but it wouldnt let me past the visual confirmation just stated I add the wrong text all the time...

<img>

hi found it

yes, u have to join the site so u will see the error. u click "post reply" and then scroll a bit and u'll see the error. u can also see the error when u click "view more emoticons"....

i was changing the template supposing i can get it work but its not. its back now to subsilver...

maybe i have an error inserting in sql?

thanks in advance