469,599 Members | 2,893 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,599 developers. It's quick & easy.

Probably a permissions problem.

Hi

I connect to my MySQL database using MyODBC.

I have a table called 'log' in a database called 'home'. When I try to
do an insert like this:
insert into log (userid,event,event_date) values (blah blah....

I get this error response from MySQL:
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 'log
(userid,event,event_d
ate) values ('nt','HomeDB Started',now())' at line 1

However, if I use :
insert into home.log (userid,event,event_date) values (blah blah....

It all works OK.
I have another table in the same database which doesn't exhibit this
problem.

Is this some sort of permissions or access rights issue?

Any help appreciated.

Regards

Nick

Jul 27 '06 #1
5 2147
>I connect to my MySQL database using MyODBC.
>
I have a table called 'log' in a database called 'home'. When I try to
do an insert like this:
insert into log (userid,event,event_date) values (blah blah....

I get this error response from MySQL:
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 'log
(userid,event,event_d
ate) values ('nt','HomeDB Started',now())' at line 1
Is log a MySQL keyword in your version of MySQL?
If so, quote the table name (`log`). Or perhaps it's `event`
that's a keyword (5.1.6 and later). What version are you running?
>However, if I use :
insert into home.log (userid,event,event_date) values (blah blah....

It all works OK.
I have another table in the same database which doesn't exhibit this
problem.

Is this some sort of permissions or access rights issue?
Permissions and access rights issues should not draw 'syntax error'
error messages. If they do, file a bug report.
Jul 28 '06 #2

Gordon Burditt wrote:
I connect to my MySQL database using MyODBC.

I have a table called 'log' in a database called 'home'. When I try to
do an insert like this:
insert into log (userid,event,event_date) values (blah blah....

I get this error response from MySQL:
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 'log
(userid,event,event_d
ate) values ('nt','HomeDB Started',now())' at line 1

Is log a MySQL keyword in your version of MySQL?
If so, quote the table name (`log`). Or perhaps it's `event`
that's a keyword (5.1.6 and later). What version are you running?
MySQL version 4.1.9-nt. On Win2K.
>
However, if I use :
insert into home.log (userid,event,event_date) values (blah blah....

It all works OK.
I have another table in the same database which doesn't exhibit this
problem.

Is this some sort of permissions or access rights issue?

Permissions and access rights issues should not draw 'syntax error'
error messages. If they do, file a bug report.
Well, I don't understand it. I have the same Database setup at home,
and it all works fine. Both systems are Win2K with the same versions of
MyODBC and MySQL. There must be some difference in user permissions
causing this.

Thanks for the suggestions anyway.

Jul 28 '06 #3

Gordon Burditt wrote:
I connect to my MySQL database using MyODBC.

I have a table called 'log' in a database called 'home'. When I try to
do an insert like this:
insert into log (userid,event,event_date) values (blah blah....

I get this error response from MySQL:
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 'log
(userid,event,event_d
ate) values ('nt','HomeDB Started',now())' at line 1

Is log a MySQL keyword in your version of MySQL?
If so, quote the table name (`log`). Or perhaps it's `event`
that's a keyword (5.1.6 and later). What version are you running?
MySQL version 4.1.9-nt. On Win2K.
>
However, if I use :
insert into home.log (userid,event,event_date) values (blah blah....

It all works OK.
I have another table in the same database which doesn't exhibit this
problem.

Is this some sort of permissions or access rights issue?

Permissions and access rights issues should not draw 'syntax error'
error messages. If they do, file a bug report.
Well, I don't understand it. I have the same Database setup at home,
and it all works fine. Both systems are Win2K with the same versions of
MyODBC and MySQL. There must be some difference in user permissions
causing this.

Thanks for the suggestions anyway.

Jul 28 '06 #4
Control Freq wrote:
I have the same Database setup at home,
and it all works fine. Both systems are Win2K with the same versions of
MyODBC and MySQL.
I just thought of a possibility: LOG() is a built-in math function.
MySQL treats a space between a function and its parentheses as
significant. So "LOG (...)" is different from "LOG(...)".

Is it possible that in one environment, you don't have a space after
"LOG", so MySQL thinks you mean the LOG() math function? Which would of
course be nonsensical in the context of an INSERT statement, in a place
where a table name belongs.

If you are building the SQL statement with string concatenation, watch
out for situations like the following:

$sql_statement = "insert into log"
+ "(userid, event, event_date) values ..."

Notice the above creates a string with "log" right next to the following
parenthesis, with no space in between. This may confuses the MySQL
parser.

In fact, trying it in my MySQL instance, I was able to reproduce the
error you saw by putting no space in "log(...", and it works correctly
by putting a space in "log (...".

Regards,
Bill K.
Jul 30 '06 #5
Probably a silly questions, but is the same user which created the
table log, the same user which is trying to access the table?

Failing that you can always create a synonym name for the table...

Description:

The CREATE SYNONYM statement (create_synonym_statement) defines a
synonym (alternative name) for a table name.

Syntax:

<create_synonym_statement::=
CREATE [PUBLIC] SYNONYM [<schema_name>.]<synonym_nameFOR
<table_name>
Control Freq wrote:
Gordon Burditt wrote:
>I connect to my MySQL database using MyODBC.
>
>I have a table called 'log' in a database called 'home'. When I try to
>do an insert like this:
>insert into log (userid,event,event_date) values (blah blah....
>
>I get this error response from MySQL:
>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 'log
>(userid,event,event_d
>ate) values ('nt','HomeDB Started',now())' at line 1
Is log a MySQL keyword in your version of MySQL?
If so, quote the table name (`log`). Or perhaps it's `event`
that's a keyword (5.1.6 and later). What version are you running?

MySQL version 4.1.9-nt. On Win2K.
>However, if I use :
>insert into home.log (userid,event,event_date) values (blah blah....
>
>It all works OK.
>I have another table in the same database which doesn't exhibit this
>problem.
>
>Is this some sort of permissions or access rights issue?
Permissions and access rights issues should not draw 'syntax error'
error messages. If they do, file a bug report.

Well, I don't understand it. I have the same Database setup at home,
and it all works fine. Both systems are Win2K with the same versions of
MyODBC and MySQL. There must be some difference in user permissions
causing this.

Thanks for the suggestions anyway.
Jul 31 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by lkrubner | last post: by
7 posts views Thread by Kim Lots | last post: by
2 posts views Thread by beary | last post: by
13 posts views Thread by eclipsme | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.