Geeklog Forums

Hi,
I get this error "An SQL error has occured. Please see error.log for details." when I try to remove a user, or when changing the password of a user.
Even when I try to register as a new user...

Please quote the error message from error.log then ...

bye, Dirk

Hi Dirk,
I could not figure out which error, so this is the whole file (sorry).
Now, I can't even log in as admin or a user. When I tried to do the forget password, it said email has been sent, but there is no mail...

thanks,

Mon Aug 14 07:25:31 2006 - [pear_error: message="mail() returned failure" code=0 mode=return level=notice prefix="" info=""]
Sat Jul 22 14:52:46 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 14:52:52 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 14:52:58 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 14:53:32 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 14:53:38 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 14:54:45 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 14:55:13 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 14:55:59 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 15:36:21 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 17:08:03 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 17:09:59 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 17:11:43 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sat Jul 22 18:42:39 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (233,'threaded','100')
Sat Jul 22 18:44:17 2006 - Error, invalid username: 'ngodung'
Sun Jul 23 15:43:30 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sun Jul 23 15:46:46 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sun Jul 23 15:54:27 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sun Jul 23 16:06:43 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sun Jul 23 17:10:53 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sun Jul 23 18:51:13 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Sun Jul 23 19:10:12 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentmode,commentorder,commentlimit FROM gl_usercomment WHERE uid = 44
Mon Jul 24 00:48:46 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (234,'threaded','100')
Mon Jul 24 04:34:16 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (235,'threaded','100')
Mon Jul 24 04:43:16 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '235'
Mon Jul 24 04:43:22 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '235'
Mon Jul 24 23:20:38 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (236,'threaded','100')
Wed Jul 26 23:04:56 2006 - Error, invalid username: 'virtually
Content-Transfer-Encoding: base64
Content-Type: text/plain
Subject: server that
cc: burneese99@aol.com

bGlicmFyaWVzLCBpYiBsaWJyYXJ5LiBldHdvcmtzIGlzIG5vdCByZXNwb25zaWJsZSBmb3IgdGhl
IGNvbnRlbnQgb2YgdGhpcyB1Ymxpc2hlciBzIGVzY3JpcHRpb24uIGUgZW5jb3VyYWdlIHlvdSB0
byBkZXRlcm1pbmUKCgo=


a70330368eaa57dd0e9b8e630455256c'
Thu Jul 27 23:25:08 2006 - Error, invalid username: 'tantam1'
Thu Jul 27 23:25:23 2006 - Error, invalid username: 'tantam1'
Thu Jul 27 23:25:46 2006 - Error, invalid username: 'TANTAM1'
Fri Jul 28 00:36:06 2006 - Error, invalid username: 'goretti_1_1'
Fri Jul 28 00:36:16 2006 - Error, invalid username: 'goretti_1_1'
Fri Jul 28 00:36:18 2006 - Error, invalid username: 'goretti_1_1'
Sun Jul 30 14:36:59 2006 - Error, invalid username: 'tran_ductan14'
Sun Jul 30 14:37:24 2006 - Error, invalid username: 'tran_ductan14'
Mon Jul 31 21:13:57 2006 - Error, invalid username: 'nyn'
Mon Jul 31 21:14:28 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (237,'threaded','100')
Tue Aug 1 06:20:26 2006 - Error, invalid username: 'nyn'
Tue Aug 1 06:28:26 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '237'
Wed Aug 2 20:46:33 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (238,'threaded','100')
Thu Aug 3 22:42:56 2006 - Error, invalid username: '
Content-Transfer-Encoding: 7bit
x-: eb417f5a644aaf586cf975f904b69d68
Content-Type: text/plain
Subject:
bcc: buletmann@aol.com












.
'
Thu Aug 3 22:43:36 2006 - Error, invalid username: '3290@saigonforsaigon.org'
Fri Aug 4 20:08:10 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentmode,commentorder,commentlimit FROM gl_usercomment WHERE uid = 237
Fri Aug 4 20:08:58 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '237'
Sat Aug 5 19:16:26 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: SELECT commentorder,commentmode,commentlimit FROM gl_usercomment WHERE uid = '2'
Mon Aug 7 01:32:48 2006 - Error, invalid username: 'thanh'
Mon Aug 7 01:33:21 2006 - Error, invalid username: 'thanh'
Mon Aug 7 01:34:43 2006 - Error, invalid username: 'thanh'
Mon Aug 7 01:35:07 2006 - Error, invalid username: 'thanh'
Mon Aug 7 01:35:31 2006 - Error, invalid username: 'thanh'
Mon Aug 7 01:35:58 2006 - Error, invalid username: 'thanh'
Wed Aug 9 10:21:41 2006 - Error, invalid username: 'mai'
Wed Aug 9 10:21:57 2006 - Error, invalid username: 'kathymai'
Wed Aug 9 10:22:31 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (239,'threaded','100')
Wed Aug 9 17:41:22 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (240,'threaded','100')
Wed Aug 9 17:47:06 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '52'
Wed Aug 9 17:47:11 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '52'
Wed Aug 9 17:47:31 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '52'
Wed Aug 9 17:55:26 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '52'
Wed Aug 9 18:11:08 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '52'
Wed Aug 9 18:11:54 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '44'
Wed Aug 9 18:15:49 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '44'
Wed Aug 9 18:18:46 2006 - error in get_userdata
Wed Aug 9 18:18:46 2006 - 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 ' 1155161926, '205.246.139.2')' at line 1. SQL in question: INSERT INTO gl_sessions (sess_id, uid, start_time, remote_ip) VALUES (146690942, , 1155161926, '205.246.139.2')
Wed Aug 9 18:20:23 2006 - error in get_userdata
Wed Aug 9 18:20:23 2006 - 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 1. SQL in question: DELETE FROM gl_sessions WHERE uid =
Wed Aug 9 18:21:58 2006 - error in get_userdata
Wed Aug 9 18:21:58 2006 - 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 ' 1155162118, '205.246.139.2')' at line 1. SQL in question: INSERT INTO gl_sessions (sess_id, uid, start_time, remote_ip) VALUES (661137871, , 1155162118, '205.246.139.2')
Wed Aug 9 18:22:21 2006 - error in get_userdata
Wed Aug 9 18:22:21 2006 - 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 ' 1155162141, '205.246.139.2')' at line 1. SQL in question: INSERT INTO gl_sessions (sess_id, uid, start_time, remote_ip) VALUES (593966079, , 1155162141, '205.246.139.2')
Wed Aug 9 18:30:29 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '44'
Wed Aug 9 18:45:13 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '44'
Wed Aug 9 18:45:30 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '44'
Wed Aug 9 18:46:39 2006 - 1054: Unknown column 'uid' in 'where clause'. SQL in question: DELETE FROM gl_usercomment WHERE uid = '44'
Wed Aug 9 18:47:56 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (241,'threaded','100')
Wed Aug 9 19:31:56 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (242,'threaded','100')
Thu Aug 10 09:34:40 2006 - Error, invalid username: 'nTran'
Thu Aug 10 09:35:10 2006 - Error, invalid username: 'Ntran'
Thu Aug 10 09:35:38 2006 - Error, invalid username: 'NTran'
Thu Aug 10 09:36:00 2006 - Error, invalid username: 'NTran'
Thu Aug 10 09:37:17 2006 - Error, invalid username: 'NTRan'
Thu Aug 10 09:37:40 2006 - Error, invalid username: 'NTran'
Thu Aug 10 13:05:15 2006 - Error, invalid username: 'laidinhvinh2001'
Thu Aug 10 13:05:36 2006 - Error, invalid username: 'laidinhvinh2001'
Mon Aug 14 06:58:41 2006 - Error, invalid username: 'toilatoi1998'
Mon Aug 14 06:59:14 2006 - Error, invalid username: 'toilatoi1998'
Mon Aug 14 06:59:31 2006 - Error, invalid username: 'toilatoi1998'
Mon Aug 14 07:25:31 2006 - [pear_error: message="mail() returned failure" code=0 mode=return level=notice prefix="" info=""]
Mon Aug 14 07:26:02 2006 - Error, invalid username: 'toilatoi1998'
Mon Aug 14 07:26:04 2006 - Error, invalid username: 'toilatoi1998'
Mon Aug 14 12:35:26 2006 - Error, invalid username: 'tran'
Mon Aug 14 12:35:56 2006 - Error, invalid username: 'TRAN'
Mon Aug 14 22:25:06 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (243,'threaded','100')
Mon Aug 14 23:13:55 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (244,'threaded','100')
Mon Aug 14 23:47:22 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (245,'threaded','100')
Tue Aug 15 00:49:22 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (246,'threaded','100')
Tue Aug 15 00:58:50 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (247,'threaded','100')
Tue Aug 15 01:35:47 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (248,'threaded','100')
Tue Aug 15 01:38:18 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (249,'threaded','100')
Tue Aug 15 04:08:06 2006 - Error, invalid username: 'maithy'
Tue Aug 15 04:08:57 2006 - Error, invalid username: 'maithy'
Tue Aug 15 04:59:58 2006 - 1054: Unknown column 'uid' in 'field list'. SQL in question: INSERT INTO gl_usercomment (uid,commentmode,commentlimit) VALUES (250,'threaded','100')

This doesn't sound good. The gl_usercomment table is supposed to have a field called 'uid'.

It should be possible to repair it if you know what you're doing. Restoring a backup may be easier, though ...

bye, Dirk