Oh Noes! Error On 3.1.1 To 3.2.0 Upgrade

[garybarr]

I upgraded from 3.1.1 to 3.2.0 and uploaded the files like normal, however, when I went to ~/admin/upgrade and clicked update, I got this:

 

Oh noes!

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1-revenue_year' for key 'PRIMARY' on line 124 in /home/digicom/public_html/blesta/lib/model.php 

Printing Stack Trace:
#0 /home/digicom/public_html/blesta/lib/model.php(124): PDOStatement->execute(Array)
#1 /home/digicom/public_html/blesta/components/record/record.php(216): Model->query('INSERT INTO `bi...', Array)
#2 /home/digicom/public_html/blesta/plugins/billing_overview/billing_overview_plugin.php(118): Record->insert('billing_overvie...', Array)
#3 /home/digicom/public_html/blesta/app/models/plugin_manager.php(274): BillingOverviewPlugin->upgrade('1.0.0', '3')
#4 /home/digicom/public_html/blesta/components/upgrades/upgrades.php(210): PluginManager->upgrade('3')
#5 /home/digicom/public_html/blesta/components/upgrades/upgrades.php(74): Upgrades->processExtension('plugin', NULL)
#6 /home/digicom/public_html/blesta/app/controllers/admin_upgrade.php(80): Upgrades->start('3.1.1', '3.2.0')
#7 /home/digicom/public_html/blesta/lib/dispatcher.php(111): AdminUpgrade->process()
#8 /home/digicom/public_html/blesta/index.php(21): Dispatcher::dispatch('/admin/upgrade/...')
#9 {main}

 

But it seems to be working?  Shows 3.2.0... Seems to be working ok, as far as I can tell... I added a client. Added an invoice, all went well.  Should I be concerned?

 

 

 

 

[Michael]

How did you overwrite the files? FTP mate? Just wondering if a file for the billing plugin didn't get uploaded probably?

[garybarr]

FileZilla...Like I normally do.   It shows 6253 successful transfers, 0 Failed transfers.  That part all seems to have gone fine.  But open to suggestions.

[Michael]

FileZilla...Like I normally do.   It shows 6253 successful transfers, 0 Failed transfers.  That part all seems to have gone fine.  But open to suggestions.

 

Weird :s try permissions in the /plugin/billing_overview should all be 0666 (files) and 02755 (folders)

[garybarr]

Odd, the permissions are 0644 for the files in the billing_overview directories (and dir are 755).  I assume I should change them all to 0666... Does that fix it, or do I need to rerun the ~/admin/upgrade feature?

[garybarr]

Actually, ALL my PHP files are all set for 644, is that wrong?

[Michael]

Actually, ALL my PHP files are all set for 644, is that wrong?

 

Oh yeah that's fine too and folders are 0755? it varies for control panels sorry

[garybarr]

Yes, directories all are 0755 and php's are 0644.

[Paul]

Looks like a problem with the billing overview plugin. If so, the core is probably fine. You might uninstall and re-install the billing overview plugin widget under Settings > Company > Plugins.

[garybarr]

I went in, saw Billing at a Glance (and all other plugins) had Upgrade button.  I clicked on Upgrade with Billing at a Glance, and got the same error.  So I did as you said, uninstalled it, reinstalled it and it went just fine... I then upgraded all the other plugins and had no errors on them.  So that seemed to do the trick... I wonder what caused it, but as long as we are going, it's all good!  :-)

 

Thanks for the help!

[Michael]

I went in, saw Billing at a Glance (and all other plugins) had Upgrade button.  I clicked on Upgrade with Billing at a Glance, and got the same error.  So I did as you said, uninstalled it, reinstalled it and it went just fine... I then upgraded all the other plugins and had no errors on them.  So that seemed to do the trick... I wonder what caused it, but as long as we are going, it's all good!  :-)

 

Thanks for the help!

 

Glad you and Paul found the reason, there must have been some issue when it tried to upgrade the plugins automatically.