----------------------------------------
Exception happened during processing of request from ('192.168.0.112', 36156)
Traceback (most recent call last):
File "/usr/local/lib/python2.2/SocketServer.py", line 439, in process_request
self.finish_request(request, client_address)
File "/usr/local/lib/python2.2/SocketServer.py", line 253, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/local/lib/python2.2/SocketServer.py", line 514, in __init__
self.handle()
File "./papercut.py", line 182, in handle
getattr(self, "do_%s" % (command))()
File "./papercut.py", line 225, in do_GROUP
if not backend.group_exists(self.tokens[1]):
File "./storage/phorum_mysql.py", line 64, in group_exists
self.cursor.execute(stmt)
File "/usr/local/lib/python2.2/site-packages/MySQLdb/cursors.py", line 95, in execute
return self._execute(query, args)
File "/usr/local/lib/python2.2/site-packages/MySQLdb/cursors.py", line 114, in _execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.2/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (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 'check\n FROM\n forums\n ")
----------------------------------------
This is when using my newserver (papercut) and trying to interact with the newserver. I have this working on another box, but this new setup fails. The only major difference is that I'm running MySQL 4.0.13 on this new box.
I had made a mistake by compiling MySQLdb against an old version of MySQL (3.2.x) and then upgrading to MySQL 4.0.13 and not recompiling MySQLdb. I rm -rf'd /usr/local/lib/python2.2/site-packages before recompiling the package against my new MySQL install.
I could not compile without setting thread_safe_library to NO.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The text to the error reads "You have an error in your SQL syntax. This is likely not a problem with the MySQLdb library, but rather a problem with your application. If this is your software, please post the offending SQL code. Otherwise, please contact the developers of the software you are trying to get working.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-07-29
I will do that. The funny thing is that this works perfectly with the same version of MySQLdb and Papercut on another setup. The only difference is that the working setup uses MySQL 3.23.56, and the broken setup uses MySQL 4.0.13.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-07-29
Papercut was at fault. There were a few SQL statements that looked like this:
SELECT COUNT(*) as check FROM forums
CHECK is a reserved word in MySQL. I changed all 'check' references to 'check_' and all seems to be working fine now.
Thanks for the help!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello!
I'm receiving the following error:
----------------------------------------
Exception happened during processing of request from ('192.168.0.112', 36156)
Traceback (most recent call last):
File "/usr/local/lib/python2.2/SocketServer.py", line 439, in process_request
self.finish_request(request, client_address)
File "/usr/local/lib/python2.2/SocketServer.py", line 253, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/local/lib/python2.2/SocketServer.py", line 514, in __init__
self.handle()
File "./papercut.py", line 182, in handle
getattr(self, "do_%s" % (command))()
File "./papercut.py", line 225, in do_GROUP
if not backend.group_exists(self.tokens[1]):
File "./storage/phorum_mysql.py", line 64, in group_exists
self.cursor.execute(stmt)
File "/usr/local/lib/python2.2/site-packages/MySQLdb/cursors.py", line 95, in execute
return self._execute(query, args)
File "/usr/local/lib/python2.2/site-packages/MySQLdb/cursors.py", line 114, in _execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.2/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (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 'check\n FROM\n forums\n ")
----------------------------------------
This is when using my newserver (papercut) and trying to interact with the newserver. I have this working on another box, but this new setup fails. The only major difference is that I'm running MySQL 4.0.13 on this new box.
I had made a mistake by compiling MySQLdb against an old version of MySQL (3.2.x) and then upgrading to MySQL 4.0.13 and not recompiling MySQLdb. I rm -rf'd /usr/local/lib/python2.2/site-packages before recompiling the package against my new MySQL install.
I could not compile without setting thread_safe_library to NO.
The text to the error reads "You have an error in your SQL syntax. This is likely not a problem with the MySQLdb library, but rather a problem with your application. If this is your software, please post the offending SQL code. Otherwise, please contact the developers of the software you are trying to get working.
I will do that. The funny thing is that this works perfectly with the same version of MySQLdb and Papercut on another setup. The only difference is that the working setup uses MySQL 3.23.56, and the broken setup uses MySQL 4.0.13.
Papercut was at fault. There were a few SQL statements that looked like this:
SELECT COUNT(*) as check FROM forums
CHECK is a reserved word in MySQL. I changed all 'check' references to 'check_' and all seems to be working fine now.
Thanks for the help!