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
Database error updating from 1.11.13 to 1.12.1
Re: Database error updating from 1.11.13 to 1.12.1
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.
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.