Ok, being careful to try and avoid any naughty words that might trigger the
bleeding spam filter.
The Tilghman wrote:
>
> 'when' is a reserved word in 3.23
Well, that would explain that. Arrrgghh! I even spent a couple of hours going
through the "upgrading from 3.22"/"major new features of 3.23"/"complete change
list of 3.23" etc pages and never saw this mentioned. Either I'm blind/obtuse
(always possible) or this was extremely under-a d v e r t i s ed. Now I get to
comb
through a few hundred lines of Perl code looking for any hard coded references
to "when."
Thanks,
Noah
> > -----Original Message-----
> > From: Noah Romer [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 02, 2001 14:38
> >
> > 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.
---------------------------------------------------------------------
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
