Bad bug?

[scottjess]

Hello.

Alot of my members are unable to login to the forum for some strange reason it keeps coming up with a database error.

Apply Filter: Only show the error messages of this member  cazaya       Today at 06:13:12 PM
Apply Filter: Only show the error messages of this IP address 25654654656      Apply Filter: Only show the error messages of this session d7037baa299358a0663527a76c06663b
Apply Filter: Only show the error messages of this URL http://lovebirds.co.nz/forum/index.php?action=register
Apply Filter: Only show the errors with the same message
Database Error: 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 3
File: /home/scott/public_html/lovebirds/forum/Sources/Load.php
Line: 628

they cannot seem to login and it is driving me insane.

I have just upgraded to the newist version from 1.05 and the errors still persist.

[oscar2001]

Have you tried repairing your tables via phpMyadmin?

Login probs are usually browser related but try changing the name of your forums` cookie,, might help.

Nice bird forum BTW,,, hope you get worked out

[scottjess]

Have you tried repairing your tables via phpMyadmin?

Login probs are usually browser related but try changing the name of your forums` cookie,, might help.

Nice bird forum BTW,,, hope you get worked out

I will try repairing them in the morning.. too tired at the moment been up all day creating a new website.. http://www.kiwisinusa.com/test2.html and yes I will be using SMF for the forum lol

[scottjess]

Have you tried repairing your tables via phpMyadmin?

Login probs are usually browser related but try changing the name of your forums` cookie,, might help.

Nice bird forum BTW,,, hope you get worked out

I still keep getting the same errors i have repaired the database too.

[scottjess]

I am still getting the errors and they are more fewquent.

It seems that the errors are only occuring to people that have had member IDs deleted on one or both sides of their Member ID such as this..

ID 222 Deleted
ID 223 Ken3k

or

ID 175 Deletd
ID 176 B0b
ID 177 Deleted

What could be causing this? I have  repaired the database through phpmyadmin and through the forum mantinence this is peeing me off lol.

Thanks

http://www.lovebirds.co.nz/forum

[scottjess]

Heres some errors on the forum from the error list, notice they are all the same.

Apply Filter: Only show the error messages of this member  cynsanpablo       Today at 02:45:42 AM
Apply Filter: Only show the error messages of this IP address *******      Apply Filter: Only show the error messages of this session 92943f4c01568ebd5836efedd2476d4d
Apply Filter: Only show the error messages of this URL http://www.lovebirds.co.nz/forum/index.php?action=unread
Apply Filter: Only show the errors with the same message
Database Error: 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 3
File: /home/scott/public_html/lovebirds/forum/Sources/Load.php
Line: 628

Apply Filter: Only show the error messages of this member  yukadollar       Today at 01:57:06 AM
Apply Filter: Only show the error messages of this IP address *******      Apply Filter: Only show the error messages of this session 00ccbf140a23a44106d3a880e85d1769
Apply Filter: Only show the error messages of this URL http://www.lovebirds.co.nz/forum/index.php
Apply Filter: Only show the errors with the same message
Database Error: 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 3
File: /home/scott/public_html/lovebirds/forum/Sources/Load.php
Line: 628

Apply Filter: Only show the error messages of this member  kendek       January 23, 2006, 08:56:48 PM
Apply Filter: Only show the error messages of this IP address ******      Apply Filter: Only show the error messages of this session 15727616ee014e9560f4c67991eefd96
Apply Filter: Only show the error messages of this URL http://www.lovebirds.co.nz/forum/index.php?action=jsoption;var=collapse_header;val=0;sesc;1137992193203
Apply Filter: Only show the errors with the same message
Database Error: 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 3
File: /home/scott/public_html/lovebirds/forum/Sources/Load.php
Line: 628

Operating system     Linux
Kernel version    2.4.31
Machine Type    i686
Apache version    1.3.34 (Unix)
PERL version    5.8.0
Path to PERL    /usr/bin/perl
Path to sendmail    /usr/sbin/sendmail
PHP version    4.4.1
MySQL version    4.0.25-standard

[Leipe Po]

maybe try:
http://www.simplemachines.org/download.php?thanks;filename=repair_settings.php
dont know if it helps, never needed the file, but it seem to work magic for most problems

[scottjess]

I have changed a few settings but  I doubt its going to work since it seems to be a database problem.

[scottjess]

Any other sugestions?

this is the line that it is pointing out has the error.

WHERE ID_GROUP IN (" . implode(', ', $user_info['groups']) . ')', __FILE__, __LINE__);

[scottjess]

I Could really do with some help on this one guys...

I have found that if I change their email and password it seems to correct the indivudal problem but how can i fix them all at once, not even sure how many people there are that cnt log in but I know there is over 100