Thread

After a couple of succesful upgrades from 1.7.2 EE installs we want to upgrade our biggest database to EE 2.5. Database is 300 MB large, 40.000+ entries and was setup in 2004, I think when EE first came out.

We are on a test location and after the Database Too large error we ran the sh file. After that we are running into some other errors regarding indexes, primary keys etc etc.

For example

Can’t DROP ‘entry_id’; check that column/key exists

ALTER TABLE `exp_weblog_data` DROP KEY `entry_id`

After running that code in phpmyadmin i will get the message “#1091 - Can’t DROP ‘entry_id’; check that column/key exists”.

Another error

Error Number: 1068

Multiple primary key defined

ALTER TABLE `exp_weblog_data` ADD PRIMARY KEY `entry_id` (`entry_id`)

Anyone ideas how to smoothing things up in the database regarding primary keys, indexes?

Hi Steve,

Can you describe your experience to me?

With the Large Database Script, you should run the script and then return to your browser in the state it was in before the script was ran.

You do not restart the update at the beginning, which sounds like what has happened here.

I look forward to your reply!

Cheers,

Hi Dan,

Was a two man Job. I ran the wizard, and another guy was running the sh script. After he told me he was finished, i got back to http://www.url/admin.php.

So not go to the beginning, but refresh the page with the note that te database was too big?

regards,

Steve

Ran the wizard like above and it is going a little further. Now i am facing this error:

{"error":"

Error Number: 1062<\/p>\n\n

Duplicate entry '1' for key 'PRIMARY'<\/p>\n\n

ALTER TABLE `exp_member_homepage` ADD PRIMARY KEY `member_id` (`member_id`)<\/p>\n\n

Filename: updates\/ud_200.php<\/p>\n\n

Line Number: 1700<\/p>"}

Any suggestions what to do?

Hey Steve,

This error is after the shell script?

The updates in ud_200.php have been applied by the shell script. Open ud_200.php and comment out lines 1692 to 1700 and refresh the installer.

Let me know what happens next.

Cheers,

Hey,

Did it the way you described, and the installer is going a little further. But again a error.

{"error":"

Error Number: 1146<\/p>\n\n

Table 'mydatabase.exp_accessories' doesn't exist<\/p>\n\n

INSERT INTO `exp_accessories` (`member_groups`, `controllers`, `class`, `accessory_version`) VALUES ('1|5', 'addons|addons_accessories|addons_extensions|addons_fieldtypes|addons_modules|addons_plugins|admin_content|admin_system|content|content_edit|content_files|content_files_modal|content_publish|design|homepage|members|myaccount|tools|tools_communicate|tools_data|tools_logs|tools_utilities', 'Expressionengine_info_acc', '1.0')<\/p>\n\n

Filename: controllers\/wizard.php<\/p>\n\n

Line Number: 2301<\/p>"}

Hi Steve,

Sorry for the delay. I think we might want to have a look at this. be on the lookout for an email from me.

Cheers,