View previous topic :: View next topic |
Author |
Message |
jeffjohn -
Joined: 02 May 2008 Posts: 38 Location: France 44290 or New Forest,UK
|
Posted: Fri Mar 27, 2009 7:24 pm Post subject: address_book databases |
|
|
I have tried 3 or 4 different address book access PHP scripts and they all fail for the same reason:-
MySQL error number 1366: Incorrect integer value: '' for column 'id' at row 1
All state that the auto-increment ID does not work or not available.
Could someone with more experience please advise, or at least, hazard a guess, please?
many thanks jeffjohn _________________ jeffrey-john UK, and Loire Atlantique, France 44290.
Abyss Web Server and Genie6 FTP Server Naslite Storage Server, ZyXel gateway, VPN, and IP cams.
|
|
Back to top |
|
|
rrinc -
Joined: 24 Feb 2006 Posts: 725 Location: Arkansas, USA
|
Posted: Sat Mar 28, 2009 8:17 am Post subject: |
|
|
I don't have much experience with MySQL and issues, but it is strange that all of those scripts would have the same problem. It probably isn't any problem with the scripts.
What version of PHP and MySQL are you using? Could you tell us what scripts you tried? _________________ -Blake | New Server :D
SaveTheInternet
Soy hispanohablante. Puedes contactarme por mensajes privados. |
|
Back to top |
|
|
jeffjohn -
Joined: 02 May 2008 Posts: 38 Location: France 44290 or New Forest,UK
|
Posted: Sat Mar 28, 2009 10:06 am Post subject: |
|
|
Hi! I have tried a few scripts; the most 'professional' seems to be 'AFC addressbook' but also with 'ScripSearch' and others. They appear to be working but when I try to enter data, I always get a fault message relating to First Column indexing ID' The MySQL Table looks correct with auto -increment on column 1; all other Fields appropriately assigned by the application. I assume there is not an extension from php.ini that needs activating?
Someone out there must have a PHP/MySQL DB search script up and running on Abyss. My other scripts such as Image DB (ZenPhoto) and Music (kplaylist) work perfectly.
Thanks for any help. jeffjohn _________________ jeffrey-john UK, and Loire Atlantique, France 44290.
Abyss Web Server and Genie6 FTP Server Naslite Storage Server, ZyXel gateway, VPN, and IP cams.
|
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|