Hi Noah Romer,
I got the same problem as yours. I think some of the "words" or "variables"
can't be used in MySQL-3.23.32 as in the previous version of MySQL-3.22.xx. The only
think you have to do is to change the "variables" in 3.23.32. In your case, may be
who or when is not allowed to use.
Mark
Noah Romer wrote:
> 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
---------------------------------------------------------------------
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
