Re: Transaction suddenly not working
| From: | Stuart Felenstein | Date: | Mon, 29 Nov 2004 13:19:29 +0000 |
| Subject: | Re: Transaction suddenly not working | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37438@lists.php.net to get a copy of this message | ||
--- denys <dbulant@yahoo.fr> 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 ignoring , first removing the null and ProfileID
column name - result still failure.
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,
'',
, 4, 26, , 2004-02-02)01062 : Duplicate entry '0-f'
for key 1 transaction failed
When I tried the Insert statement into a mysql gui it
spit back a syntax error , apparently for the blank
values ..,'', yet those are set to allow null.
I went ahead and tried just an insert on the first 4
columns , that worked.
Stuart