RE: [PHP-DB] Transaction suddenly not working

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 29 November 2004 13:19, Stuart Felenstein wrote: > Now the printout of the query is this: > > 0: INSERT INTO Table1 (LurkID, ProfileName, Edu, > WorkAuth, WorkExp, CarLev, Secu, Confi, Relo, > Telecomu, City1, State1, City2, State2, TravelPref, > SalaryAnnual, SalaryHourly, Available) VALUES (47, > 'ffffffff', 7, 2, 1015, 5, , '', '', '', > 'fds', 5, '', You have 2 successive commas in this last line, with no value in between -- this is your syntax error. > , 4, 26, , 2004-02-02)01062 : Duplicate entry '0-f' for key 1 And again on this line -- twice, in fact, since the previous line ends with a comma, too. Track down whatever is outputting these null values, fix it, and you should be good to go (well, at least less bad!). Cheers! Mike --------------------------------------------------------------------- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Services, JG125, James Graham Building, Leeds Metropolitan University, Headingley Campus, LEEDS, LS6 3QS, United Kingdom Email: m.ford@leedsmet.ac.uk Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211