This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use the new forum.
Home » plugins » User management plugins » sf_guard_user: Need help on 1005 Can't create table
sf_guard_user: Need help on 1005 Can't create table [message #100849] Sun, 13 June 2010 05:47 Go to next message
ngkung  is currently offline ngkung
Messages: 4
Registered: June 2010
Junior Member
Hi all,

I got the following message:
SQLSTATE[HY000]: General error: 1005 Can't create table 'jobeet.#sql-70d_5498' (errno: 121). Failing Query: "ALTER TABLE sf_guard_user_group ADD CONSTRAINT sf_guard_user_group_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE". Failing Query: ALTER TABLE sf_guard_user_group ADD CONSTRAINT sf_guard_user_group_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE

Mysql version 5.1.37
PHP version 5.2.9
OS: Fedora

Any idea about what happened?

Re: sf_guard_user: Need help on 1005 Can't create table [message #100850 is a reply to message #100849 ] Sun, 13 June 2010 06:31 Go to previous messageGo to next message
ngkung  is currently offline ngkung
Messages: 4
Registered: June 2010
Junior Member
Don't know what happened.
I dropped the whole database and rebuilt with the Plugin only. It got no problem.
I am trying to rebuild whole project, hope it will get fixed this time.
I wondered if I need to drop the database everytime I rebuild the project. Hope not.
Re: sf_guard_user: Need help on 1005 Can't create table [message #100851 is a reply to message #100849 ] Sun, 13 June 2010 06:41 Go to previous message
ngkung  is currently offline ngkung
Messages: 4
Registered: June 2010
Junior Member
Confirmed.
I have to drop the database and recreate it.
Maybe next time, I will drop the related table. It is more convenient to drop and recreate the database. Ha ha
Previous Topic:Look for a full user guide for User Management Plugins
Next Topic:sf_guard_user question
Goto Forum:
  

powered by FUDforum - copyright ©2001-2004 FUD Forum Bulletin Board Software