cooldude832 Posted August 11, 2008 Share Posted August 11, 2008 I was playing around with innoDB engine /foriegn keys and accidently made a loop FunctionID in table Users_Functions is foriegn keyed to User_Grant_functions field Function ID FunctionID in User_Grant_functions is foreign keyed to Users_Functions FunctionID I can not do anything to a table I get child key problems or error renaming problems Any ideas? I can't be a super user as its on my remote server. so SHOW STATUS INNODB can't be ran Link to comment https://forums.phpfreaks.com/topic/119095-solved-innodb-and-foreign-key-issues/ Share on other sites More sharing options...
fenway Posted August 11, 2008 Share Posted August 11, 2008 Why not disable FK checks? Link to comment https://forums.phpfreaks.com/topic/119095-solved-innodb-and-foreign-key-issues/#findComment-614095 Share on other sites More sharing options...
cooldude832 Posted August 12, 2008 Author Share Posted August 12, 2008 I just dumped the db in phymadmin and then emptied it and rebuilt it Link to comment https://forums.phpfreaks.com/topic/119095-solved-innodb-and-foreign-key-issues/#findComment-614161 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.