Menu
▾
▴
#1059 Field editing SQL error
invalid
1
2013-06-11
2003-11-04
No
Having listed some records via browse, I click on the edit
icon, and get this error:
SQL-query :
SELECT display_field
FROM WHERE db_name = 'mydb' AND table_name =
'mytable'
MySQL said:
You have an error in your SQL syntax near 'WHERE db_name
= 'mydb' AND table_name = 'mytable'' at line 1
You can see that the table name is missing from the SQL
query that PMA generated.
I get about half the fields for the record displayed before the
error appears - the error seems to occur at the point where
a value is about to be displayed (it happens to be an indexed
integer field). Editing does work for other tables/databases
(e.g. PMA's own), so there's some nasty intermittent thing at
work here.
Logged In: YES
user_id=473563
What is the exact MySQL query you used to browse the table?
If possible, please dump your tables (and the relations in
your PMA_* tables) here, so that we can try to reproduce that.
Regards,
Garvin.
Logged In: YES
user_id=473563
Any news on this?
Logged In: YES
user_id=602594
I tracked this down. When updating to 2.5.4 I had missed a
character in a PMA table name in the config file. I think it was
when there was a comment or somethign that would appear in a
title attribute. I gues this counts as anoter request to have configs
held in the DB...
Logged In: YES
user_id=602594
I tracked this down. When updating to 2.5.4 I had missed a
character in a PMA table name in the config file. I think it was
when there was a comment or somethign that would appear in a
title attribute. I gues this counts as anoter request to have configs
held in the DB...