Database error updating from 1.11.13 to 1.12.1

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
zzmarker
Forum Members
Forum Members
Posts: 20
Joined: Fri Oct 03, 2008 7:37 am

Database error updating from 1.11.13 to 1.12.1

Post 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
scooper
Forum Members
Forum Members
Posts: 242
Joined: Fri Dec 09, 2005 12:36 pm

Re: Database error updating from 1.11.13 to 1.12.1

Post 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.
Post Reply

Return to “The Lounge”