| Index
» Projects
» phpMyEdit
» Forum
» 1064 error when adding or changing |
 |
markcrobinson
Joined: 05 Oct 2004
Posts: 6
Posted: 2004-10-05 19:57
Back to top
Reply with quote
|
I have just installed phpMyEdit at
http://www.handicappedpets.com/cgi-bin/phpedit/accontacts.php
When I try to add or change, I get an error when I save. Can anyone tell me where I might look for a solution?
Thanks!
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 'Desc,website,phone,fax,type,other1,other2,other3) VALUES ('0','
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-10-05 22:18
Back to top
Reply with quote
|
my first guess is that your first field (id) is an autoincrement and you try to assign a value to it. do not allow to add or change it (options => LFV)
another common problem is with bad column names ( with - or .) or reserved names (sql reserved)
and please make use of the inc option, it took me awfully long to load...
|
markcrobinson
Joined: 05 Oct 2004
Posts: 6
Posted: 2004-10-06 00:25
Back to top
Reply with quote
|
Thank you. inc option done.
I don't understand (options => LFV). Is that "List, Filter, View?"
at the field level I have that field's options set at:
$opts['fdd']['id'] = array(
'name' => 'ID',
'select' => 'T',
'options' => 'AVCPDR', // auto increment
How do I make the id field not write? It's already Read only, isn't it?
| michal wrote: |
my first guess is that your first field (id) is an autoincrement and you try to assign a value to it. do not allow to add or change it (options => LFV)
another common problem is with bad column names ( with - or .) or reserved names (sql reserved)
and please make use of the inc option, it took me awfully long to load... |
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-10-07 17:07
Back to top
Reply with quote
|
remove AC from your options on ID. maybe it won't solve the problem, but it's a good try
|
markcrobinson
Joined: 05 Oct 2004
Posts: 6
Posted: 2004-10-08 15:36
Back to top
Reply with quote
|
The default field length of the mome field "perhaps I labeled it as Long Text, was 16777215, Change it to 4000 and worked great
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
