Updating from 2.4.7 to 2.4.10, getting database errors

Having a problem getting Nova installed? Can't figure out why something isn't working right? This is the place to get help and report any bugs you find with Nova!

Moonsword Thu Sep 07, 2017 4:03 am

Updating from 2.4.7 to 2.4.10, getting database errors

I am getting multiple database errors when trying to update to the latest version of Nova.

Code: Select all
A Database Error Occurred

Error Number: 1060

Duplicate column name 'rankcat_genre'

ALTER TABLE `nova_catalogue_ranks` ADD `rankcat_genre` VARCHAR(10) DEFAULT 'ds9' NOT NULL

Filename: /home2/solarion/public_html/nova/modules/assets/update/update_101.php

Line Number: 135


Code: Select all
A Database Error Occurred

Error Number: 1060

Duplicate column name 'data_item'

ALTER TABLE `nova_specs_data` ADD `data_item` INT(5) NOT NULL

Filename: /home2/solarion/public_html/nova/modules/assets/update/update_106.php

Line Number: 158


I have tried deleting the errored lines and they get put back in when I rerun the update and it finds a new error to throw at me.

Please help.

Code: Select all
PHP   5.1   5.6.30   Success
Database Platform   mysql, mysqli   mysql   Success
Database Version   4.1, -   5.5.51-38.2   Success
Register Globals   Off   Off   Success
Memory Limit   8   256   Success
File Handling   On   On   Success

Posts: 40


AgentPhoenix Thu Sep 07, 2017 5:17 pm

Re: Updating from 2.4.7 to 2.4.10, getting database errors

viewtopic.php?f=60&t=4208&p=23177

Instead of 2.3.2 though, set it to 2.4.7 and re-run the update.
User avatar

Posts: 7499


Moonsword Fri Sep 08, 2017 8:17 am


Posts: 40



Return to Help

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron