| Index
» Projects
» phpMyEdit
» Forum
» Error message on CHANGE |
 |
gwhite12
Joined: 27 May 2011
Posts: 5
Posted: 2011-05-27 15:20
Back to top
Reply with quote
|
I get this message when I change a field in database.
MySQL error 1064
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 'primary=9)' at line 1
Warning: Invalid argument supplied for foreach() in /xxxx/xxxx/xxxx/xxxx/localhost/xxxx/admin/Edit/phpMyEdit.class.php on line 2731
xxxx = my system info
It does not matter which record I change.
Thank you
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2011-05-28 14:29
Back to top
Reply with quote
|
One possibility is that odd field names are used. Post the schema for the table, as exported using phpMyAdmin.
|
gwhite12
Joined: 27 May 2011
Posts: 5
Posted: 2011-05-28 16:06
Back to top
Reply with quote
|
events
Field Type Null Default
eventID int(5) No
eventPURPOSE varchar(254) No
eventNAME varchar(254) No
eventLic_Num varchar(10) No
eventStart date No 0000-00-00
eventFinish date No 0000-00-00
tourney
Field Type Null Default
primary int(5) No
start_time text No
day_of_week text No
tourney text No
buy_in decimal(4,0) No
start_chips text No
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2011-05-29 15:17
Back to top
Reply with quote
|
"primary" is a reserved word, thus try renaming the column.
http://www.hockinson.com/index.php?s=147
|
gwhite12
Joined: 27 May 2011
Posts: 5
Posted: 2011-06-01 13:33
Back to top
Reply with quote
|
Fixed, Thanks
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
