Might not be your exact problem, but I once had some issues porting of
the the data from one machine to another. The auto increment was failing
with a "duplicate index" error, but I could not find any duplicate
indices. There was, however, a 0 value in the indexed column, which upon
removal, fixed the issue. I think the table was initially populated and
then maybe later converted to an auto-increment type without throwing an
error. But, when I did an export and import into another machine, it
kept failing.
~Rolan
PaulCheung wrote:
The application is a classic traditional computer applications of add,
update and read selected record. The add record routine lines up the
next record to be added by checking what the last record added number was.
The application was developed on “localhost”, Windows environment, and
all working as expected, adding, updating and reading records up to a
preset maximum of 100.
Then thethe whole application was transfered into its' “production
environment” on my web space, Linux environment for testing.
Everything works fine for the first record only. I cannot add records
thereafter. I have “desk checked” the coding and with the exception of
the MySQL database parameters (host, user, password and database). All
coding remains the same.
I cannot understand what is wrong is it because of the different
operating environments or could it be something else? Has anybody got
any ideas
.
------------------------------------------------------------------------
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
