In the process of moving a database to a new server, I decided to upgrade to
the 3.23 series MySQL, as it had been declared "stable" and has some new
features I want to investigate. However, I've had to drop back to 3.22.22, as I
started getting an "invalid SQL syntax" error on certain insert commands.
Specifically, when I try to do an insert into a change logging table in our bug
tracking database, I get "ERROR 1064: You have an error in your SQL syntax". An
example would be the following, which I tried from the command line mysql
client when our bug tracking software started complaining about not being able
to log changes:
mysql> insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue)
values (334,18,20010131145149,'bug_status','NEW','RESOLVED');
ERROR 1064: You have an error in your SQL syntax near
'when,field,oldvalue,newvalue) values
(334,18,20010131145149,'bug_status','NEW','' at line 1
I can't find anything in the above SQL command that would constitute invalid
syntax, and MySQL 3.22.22 doesn't have any problems with it, so I was wondering
if anyone on this list might have an idea as to what's going on.
The systems involved here are dual processor Linux machines. I've tried this
using the MySQL-3.23.32-1 rpms (installed on the new system, which is running
RedHat 6.2 on dual PIII 933's) and using the source code
(mysql-3.23.32.tar.gz), compiled and running on the old system (a dual PPro
system running a heavily modified RedHat 5.1). The result are the same in
either case.
Thanks,
Noah Romer
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
