cheekydump Posted August 18, 2007 Share Posted August 18, 2007 after yest i got my reg form working after i signed my first preson up the code stoped wokring so this morning i delete the account from the datebase and the code worked again... so i signed up again and try it and the code stoped working System Error You could not be registered due to system error. we apologize for any inconvenience. Duplicate entry '0' for key 1 Query:INSERT INTO users (first_name, last_name, email, password, registraion_date ) VALUES ('nick', 'nick', 'nick_flowitt@hotmail.com', SHA('ddd'), NOW() ) could it to be with the code or the datebase? Quote Link to comment https://forums.phpfreaks.com/topic/65568-solved-hum-ok-need-a-little-bit-of-help-again/ Share on other sites More sharing options...
matthewhaworth Posted August 18, 2007 Share Posted August 18, 2007 Make sure auto_increment is set in the database to the primary key Quote Link to comment https://forums.phpfreaks.com/topic/65568-solved-hum-ok-need-a-little-bit-of-help-again/#findComment-327354 Share on other sites More sharing options...
NArc0t1c Posted August 18, 2007 Share Posted August 18, 2007 Also try making the Id a blink field, In you're script. take for example, INSERT INTO users (id, first_name, last_name, email, password, registraion_date ) VALUES ('', 'nick', 'nick', 'nick_flowitt@hotmail.com', SHA('ddd'), NOW() ) Quote Link to comment https://forums.phpfreaks.com/topic/65568-solved-hum-ok-need-a-little-bit-of-help-again/#findComment-327360 Share on other sites More sharing options...
cheekydump Posted August 18, 2007 Author Share Posted August 18, 2007 thats it was my bad i forgot to set it as auto_increment in the extra's Quote Link to comment https://forums.phpfreaks.com/topic/65568-solved-hum-ok-need-a-little-bit-of-help-again/#findComment-327361 Share on other sites More sharing options...
matthewhaworth Posted August 18, 2007 Share Posted August 18, 2007 thats it was my bad i forgot to set it as auto_increment in the extra's mark the topic as solved Quote Link to comment https://forums.phpfreaks.com/topic/65568-solved-hum-ok-need-a-little-bit-of-help-again/#findComment-327365 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.