7.0.2 to 7.1.0 -> "Update Failed" -> site down

[Himeko]

Hi,

 

When attempting to upgrade from 7.0.2 to 7.1.0 I get the following error:

 

Update Failed

 

An error occurred that prevented the update from completing successfully.

Unable to complete incremental updates: Unable to import the 7.1.0 Alpha1 database file. Unable to import /home/x/public_html/sales/resources/sql/upgrade710alpha1.sql: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1

 

after which I can't access my WHMCS anymore until I do a restore of the database and the files.

[xyzulu]

Try repairing your database first and then attempting the upgrade.

[Himeko]

Got it solved after some messages with support:

 

* table "tbldomainpricing_premium" was missing (?)

* table "tblconfiguration" had 5 fields, had to remove "id"

 

1) Deleted "id" from that table

2) Executed these queries

CREATE TABLE IF NOT EXISTS `tbldomainpricing_premium` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`to_amount` decimal(10,2) NOT NULL DEFAULT '0.00',

`markup` decimal(8,5) NOT NULL DEFAULT '0.00000',

`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

PRIMARY KEY (`id`),

UNIQUE KEY `tbldomain_pricing_premium_to_amount_unique` (`to_amount`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

 

TRUNCATE tbldomainpricing_premium;

 

INSERT INTO `tbldomainpricing_premium` (`to_amount`, `markup`, `created_at`, `updated_at`) VALUES ('200', '20', now(), now()), ('500', '25', now(), now()), ('1000', '30', now(), now()), ('-1', '20', now(), now());

 

INSERT INTO `tblconfiguration` VALUES ('PremiumDomains', 0, NOW(), NOW());

 

INSERT INTO `tbladminperms` VALUES (1, 137);

 

And then the update worked.

 

Only thing.. after removing that field I got this message in phpmyadmin:

 

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

[xyzulu]

That phpmyadmim message is normal for tables setup the way WHMCS has.

Great work getting the issue resolved!