Re: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Stuart Felenstein
--- Stuart Felenstein [EMAIL PROTECTED] wrote: I know recently the server was update from PHP 4.3.8 to 4.3.9 but that shouldn't have effected anything. Code: $query = INSERT INTO table1 (ProfileID, LurkID, ProfileName, Edu,... VALUES (null,...

Re: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Stuart Felenstein
--- denys [EMAIL PROTECTED] wrote: hi! what if you try to ignore the primary key in fields and values list ? MySQL should assign a valid primary key. It's what I'm doing on 4.0.22 and it's working If not, try to echo your query and write it in MySQL( GUI or console). Tried

Re: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Stuart Felenstein
--- Stuart Felenstein [EMAIL PROTECTED] wrote: One last thing to add on this issue. This table was created using tabletype InnoDB. Now I discovered earlier that this table and (many others) had switched over to MyISAM. I'm still trying to trace down the cause with my ISP. Anyway, using a

Re: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread denys
Stuart Felenstein a écrit : --- Stuart Felenstein [EMAIL PROTECTED] wrote: I know recently the server was update from PHP 4.3.8 to 4.3.9 but that shouldn't have effected anything. Code: $query = INSERT INTO table1 (ProfileID, LurkID, ProfileName, Edu,... VALUES

RE: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Ford, Mike
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,

RE: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Stuart Felenstein
--- Ford, Mike [EMAIL PROTECTED] wrote: 0: INSERT INTO Table1 (LurkID, ProfileName, Edu, WorkAuth, WorkExp, CarLev, Secu, Confi, Relo, Telecomu, City1, State1, City2, State2, TravelPref, SalaryAnnual, SalaryHourly, Available) VALUES (47, '', 7, 2, 1015, 5, , '', '', '', 'fds',

RE: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread dpgirago
--- Ford, Mike [EMAIL PROTECTED] wrote: 0: INSERT INTO Table1 (LurkID, ProfileName, Edu, WorkAuth, WorkExp, CarLev, Secu, Confi, Relo, Telecomu, City1, State1, City2, State2, TravelPref, SalaryAnnual, SalaryHourly, Available) VALUES (47, '', 7, 2, 1015, 5, , '', '', '',