Page 1 of 1

Database error updating from 1.11.13 to 1.12.1

Posted: Tue Apr 12, 2016 4:56 pm
by zzmarker
Hi,

Before updating CMS I had all modules upodated then I took back-up from database and files using cPanel.

Then I updated modules and all went fine except when updating Frontend Users module I encountered following error:
ALTER TABLE sf_module_feusers_belongs ADD FOREIGN KEY (userid) REFERENCES sf_module_feusers_users (id) Cannot add or update a child row: a foreign key constraint fails (`srhy_srhy`.`#sql-63d82_e86ef1`, CONSTRAINT `#sql-63d82_e86ef1_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `sf_module_feusers_users` (`id`))

I googled (a foreign key constraint fails) and had some advice, which didn't help.

I tried to go to admin pages but I got the same error.

How can I fix the problems

Re: Database error updating from 1.11.13 to 1.12.1

Posted: Wed Apr 13, 2016 9:09 am
by scooper
I had this problem the other day. I logged a bug with some details in:

http://dev.cmsmadesimple.org/bug/view/10934

Calguy has fixed it in SVN so you could try and grab the development version or just hang on for the next proper FEU release.

Edit: hmm - not quite the same error in fact because yours references a different table but I suspect it'll be a very similar problem.