debug mode

[asks]

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

[Helter]

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

[asks]

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

[Helter]

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

[asks]

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

[Helter]

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

[asks]

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

[found it]

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...

[asks]

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....

[found it]

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>

[asks]

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