Warning: The author of this contribution does not provide support for it anymore.

Thanks for posts

SQL Error when try to open memberlist - Thanks for posts

SQL Error when try to open memberlist

by Tigger286 » Thu Oct 04, 2012 6:04 am

Thank you for this mod! It's awesome! Everything works great except for when anyone tries to view someone's profile or open the memberlist.

Then, this SQL general error pops up:

General Error
SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: [ROOT]/includes/db/dbal.php
LINE: 389
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_thanks.php
LINE: 352
CALL: dbal->sql_in_set()

FILE: [ROOT]/memberlist.php
LINE: 674
CALL: output_thanks_memberlist()


I checked to be sure that my includes/constants.php file was correct. What else can I do to fix this?

Thank you for your help!! :)
Tigger286
Registered User
Posts: 14
Joined: Sun Dec 23, 2007 11:37 pm
Contact:

Re: SQL Error when try to open memberlist

by Палыч » Thu Oct 04, 2012 5:32 pm

Check
test.png
test.png (11.52 KiB) Viewed 356 times
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: SQL Error when try to open memberlist

by Tigger286 » Thu Oct 04, 2012 9:30 pm

THANK you so much!!! That fixed it!! Thank you for your help and your mod!
Tigger286
Registered User
Posts: 14
Joined: Sun Dec 23, 2007 11:37 pm
Contact:

Re: SQL Error when try to open memberlist

by Палыч » Fri Oct 05, 2012 3:27 pm

Ok
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: SQL Error when try to open memberlist

by QQRIQ » Sun Jan 20, 2013 12:30 pm

hi
I have the same problem.I like what you said but it did not help :/
Image
http://slike.milf-hosting.info/images/1358685041.jpg
QQRIQ
Registered User
Posts: 5
Joined: Mon Sep 26, 2011 12:15 pm
Name: Luka
Contact:

Re: SQL Error when try to open memberlist

by Палыч » Mon Jan 21, 2013 5:20 am

Nothing new
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: SQL Error when try to open memberlist

by mathdlir » Wed Aug 21, 2013 2:01 pm

Палыч wrote:Nothing new

Some users like me, have a mistake! There are two of "$topic_id = request_var('t', 0);" in memberlist.php .

Users must add after $topic_id = request_var('t',0); in first lines of memberlist.php .

Thanks.
mathdlir
Registered User
Posts: 36
Joined: Thu Jun 27, 2013 10:08 am
Contact: