Re: mysql upgrade kills a working web page

#1

On 1/8/2012 9:05 PM, horus wrote:

Quote:

original mysql Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using
readline 4.3
php = PHP 5.3.8 (cli) (built: Nov 15 2011 16:44:23)

new mysql version Ver 14.14 Distrib 5.1.54, for debian-linux-gnu (x86_64)
using readline 6.2

================================================== ========================================
snip over 400 lines of code
web error message:

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 'trigger=511235,
grb_id='GRB 120106A', burst_ra='04:24:31', `burst_dec`='64:01:42' at line 1

HELP!

thanks ahead of time.

dmc

Please don't post all that code. No one here is going to spend time
looking though it. We're all volunteers, after all.

Find out the failing SQL statement and post the actual SQL being used as
well as your CREATE TABLE for the table in question.

And when you upgraded, did you follow all the steps in the upgrade
instructions?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#2

Quote:

web error message:

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 'trigger=511235,
grb_id='GRB 120106A', burst_ra='04:24:31', `burst_dec`='64:01:42' at line 1

HELP!

I'm going to guess here that 'trigger' is now a keyword and that column
name either needs to be changed, or used as `trigger` (note backquotes,
not single quotes) in queries.

New keywords are not uncommon in new versions of MySQL.

#3

horus wrote:

Quote:

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 'trigger=511235,
grb_id='GRB 120106A', burst_ra='04:24:31', `burst_dec`='64:01:42' at line 1

HELP!

My guess is that you have lost 'magic quotes' as a default setting and
the old code relies on it.

Same happened to me.. had to re-enable it and then undo what it was
doing to the never code..

Quote:

thanks ahead of time.

dmc

#4

"Gordon Burditt" <gordonb.drnbz (AT) burditt (DOT) org> wrote

Quote:

web error message:

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
'trigger=511235,
grb_id='GRB 120106A', burst_ra='04:24:31', `burst_dec`='64:01:42' at line
1

HELP!

I'm going to guess here that 'trigger' is now a keyword and that column
name either needs to be changed, or used as `trigger` (note backquotes,
not single quotes) in queries.

New keywords are not uncommon in new versions of MySQL.

backquotes did the trick\

thanks everyone!

-david

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: mysql upgrade kills a working web page

comp.databases.mysql comp.databases.mysql

Re: mysql upgrade kills a working web page - 01-08-2012 , 09:07 PM

Re: mysql upgrade kills a working web page - 01-09-2012 , 12:41 AM

Re: mysql upgrade kills a working web page - 01-09-2012 , 06:14 AM

Re: mysql upgrade kills a working web page - 01-09-2012 , 09:36 AM