Zoltan Posted October 8, 2013 Report Share Posted October 8, 2013 Hi! When I try to updrage in the admin, I received this: Oh noes! SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'root_web_dir' for key 'PRIMARY' on line 124 in /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php Printing Stack Trace:#0 /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php(124): PDOStatement->execute(Array)#1 /home/cmdesign/public_html/cmhost/ugyfelek/components/record/record.php(215): Model->query('INSERT INTO `se...', Array)#2 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(76): Record->insert('settings', Array)#3 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(49): Upgrade3_0_2->setRootWebDir()#4 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(109): Upgrade3_0_2->process('setRootWebDir')#5 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(58): Upgrades->processObject(Object(Upgrade3_0_2), NULL)#6 /home/cmdesign/public_html/cmhost/ugyfelek/app/controllers/admin_upgrade.php(73): Upgrades->start('3.0.0.b7', '3.0.4')#7 /home/cmdesign/public_html/cmhost/ugyfelek/lib/dispatcher.php(111): AdminUpgrade->process()#8 /home/cmdesign/public_html/cmhost/ugyfelek/index.php(21): Dispatcher::dispatch('/ugyfelek/index...')#9 {main} Any ideas? Thanks Quote Link to comment Share on other sites More sharing options...
0 Paul Posted October 8, 2013 Report Share Posted October 8, 2013 Ooh, upgrading from beta 7. Did you download the full version of 3.0.4? Not the patch, correct? Quote Link to comment Share on other sites More sharing options...
0 Zoltan Posted October 9, 2013 Author Report Share Posted October 9, 2013 I downloaded the patch. I think I forgot to hit the upgrade button a few times, but I uploaded the new files all the time an upgrade came out. Could you tell me what should I do to make this right? Thanks Quote Link to comment Share on other sites More sharing options...
0 Cody Posted October 9, 2013 Report Share Posted October 9, 2013 I downloaded the patch. I think I forgot to hit the upgrade button a few times, but I uploaded the new files all the time an upgrade came out. Could you tell me what should I do to make this right? Thanks So you uploaded files when 3.0.2 came out, then again for 3.0.3, but you never ran the upgrade? That's not good. You might have other issues, but for now what you can do is update /components/upgrades/tasks/upgrade3_0_2.php and change line 76: From: $this->Record->insert("settings", array('key' => "root_web_dir", 'value' => $public_root_web)); To: //$this->Record->insert("settings", array('key' => "root_web_dir", 'value' => $public_root_web)); Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Zoltan Posted October 10, 2013 Author Report Share Posted October 10, 2013 Thank you, the upgrade completed successfully. What do you suggest I should do in the future? Keep upgrading with the patches or completly change the files for the new ones? Thank You Quote Link to comment Share on other sites More sharing options...
0 Michael Posted October 10, 2013 Report Share Posted October 10, 2013 Thank you, the upgrade completed successfully. What do you suggest I should do in the future? Keep upgrading with the patches or completly change the files for the new ones? Thank You Patches. Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted October 10, 2013 Report Share Posted October 10, 2013 After patching, always run the upgrade. It should be the first thing you do after each patch. Michael 1 Quote Link to comment Share on other sites More sharing options...
Question
Zoltan
Hi!
When I try to updrage in the admin, I received this:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'root_web_dir' for key 'PRIMARY' on line 124 in /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php
Printing Stack Trace:
#0 /home/cmdesign/public_html/cmhost/ugyfelek/lib/model.php(124): PDOStatement->execute(Array)
#1 /home/cmdesign/public_html/cmhost/ugyfelek/components/record/record.php(215): Model->query('INSERT INTO `se...', Array)
#2 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(76): Record->insert('settings', Array)
#3 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/tasks/upgrade3_0_2.php(49): Upgrade3_0_2->setRootWebDir()
#4 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(109): Upgrade3_0_2->process('setRootWebDir')
#5 /home/cmdesign/public_html/cmhost/ugyfelek/components/upgrades/upgrades.php(58): Upgrades->processObject(Object(Upgrade3_0_2), NULL)
#6 /home/cmdesign/public_html/cmhost/ugyfelek/app/controllers/admin_upgrade.php(73): Upgrades->start('3.0.0.b7', '3.0.4')
#7 /home/cmdesign/public_html/cmhost/ugyfelek/lib/dispatcher.php(111): AdminUpgrade->process()
#8 /home/cmdesign/public_html/cmhost/ugyfelek/index.php(21): Dispatcher::dispatch('/ugyfelek/index...')
#9 {main}
Any ideas?
Thanks
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.