EE 1.6.8 to EE 2.5.2 Upgrade Error / Forums / Community / EllisLab

Forum Logo

EE 1.6.8 to EE 2.5.2 Upgrade Error

Posted: 11 June 2012 05:15 PM

[ Ignore ]

Joined: 2009-02-20
117 posts

Current EE: EE 1.6.8

I recently started working with a new client to help upgrade to EE 2.5.2 from EE 1.6.8 and am running into some issues. You can see my upgrade steps below:

1) I backed-up all the files and got the site working locally.
2) I reviewed all the upgrade instructions and add-ons.
3) I ran the upgrade and get into a database error. I tried running the update twice and have encountered the same error each time.

A Database Error Occurred
Error Number: 1449

The user specified as a definer ('root'@'%') does not exist

UPDATE `exp_weblog_titles` SET `entry_id` = '28531', `site_id` = '1', `weblog_id` = '2', `author_id` = '3', `pentry_id` = '0', `forum_topic_id` = '0', `ip_address` = '67.185.224.214', `title` = 'GSI Outdoors… innovative cookware design', `url_title` = 'gsi_outdoors_innovative_cookware_design', `status` = 'open', `allow_ratings` = 'y', `versioning_enabled` = 'y', `view_count_one` = '0', `view_count_two` = '0', `view_count_three` = '0', `view_count_four` = '0', `allow_comments` = 'y', `allow_trackbacks` = 'n', `sticky` = 'n', `entry_date` = '1333080381', `dst_enabled` = 'n', `year` = '2012', `month` = '03', `day` = '29', `expiration_date` = '0', `comment_expiration_date` = '0', `edit_date` = '20120404191322', `rating_count` = '0', `rating_avg` = '0', `rating_total` = '0', `recent_rating_date` = '0', `recent_comment_date` = '0', `comment_total` = '0', `trackback_total` = '0', `sent_trackbacks` = '', `recent_trackback_date` = '0' WHERE `entry_id` = '28531' AND `site_id` = '1' AND `weblog_id` = '2' AND `author_id` = '3' AND `pentry_id` = '0' AND `forum_topic_id` = '0' AND `view_count_one` = '0' AND `view_count_two` = '0' AND `view_count_three` = '0' AND `view_count_four` = '0' AND `entry_date` = '1333080381' AND `year` = '2012' AND `month` = '03' AND `day` = '29' AND `expiration_date` = '0' AND `comment_expiration_date` = '0' AND `edit_date` = '20120404191322' AND `rating_count` = '0' AND `rating_avg` = '0' AND `rating_total` = '0' AND `recent_rating_date` = '0' AND `recent_comment_date` = '0' AND `comment_total` = '0' AND `trackback_total` = '0' AND `recent_trackback_date` = '0' AND `entry_id` = '28531' AND `site_id` = '1' AND `weblog_id` = '2' AND `author_id` = '3' AND `pentry_id` = '0' AND `forum_topic_id` = '0' AND `view_count_one` = '0' AND `view_count_two` = '0' AND `view_count_three` = '0' AND `view_count_four` = '0' AND `entry_date` = '1333080381' AND `year` = '2012' AND `month` = '03' AND `day` = '29' AND `expiration_date` = '0' AND `comment_expiration_date` = '0' AND `edit_date` = '20120404191322' AND `rating_count` = '0' AND `rating_avg` = '0' AND `rating_total` = '0' AND `recent_rating_date` = '0' AND `recent_comment_date` = '0' AND `comment_total` = '0' AND `trackback_total` = '0' AND `recent_trackback_date` = '0'

Filename: updates/ud_200.php

Line Number: 461 

Any ideas on how to resolve this upgrade issue?

Shane Eckert

Posted: 13 June 2012 11:44 AM

[ Ignore ] [ # 1 ] [ Rating: 0 ]

Joined: 2011-11-25
7174 posts

Hey mz91184,

I am sorry to hear you are running into this problem.

It sounds like this user does not have proper privileges. Something like grant all on *.* to ‘root’@’%’ should fix this, but I would not be using root as an account.

You might want to look at setting up a proper account for your installation.

I hope this helps!

Cheers,

Signature

Recent version: EE 2.5.4 | Forum Module 3.1.10 | MSM 2.1.4 | 2.x Bug Tracker | Version Upgrade

mz91184

Posted: 13 June 2012 11:50 AM

[ Ignore ] [ # 2 ] [ Rating: 0 ]

Joined: 2009-02-20
117 posts

I haven’t worked on the website before and was brought in to help upgrade to EE 2. I am attempting the update locally before I run it on the live server.

I am a little confused by your response. Is it an issue with Mac Lion, MySQL, PHP or EE? I think you are saying there are issue with some Mac Lion file privileges?

Shane Eckert

Posted: 13 June 2012 03:57 PM

[ Ignore ] [ # 3 ] [ Rating: 0 ]

Joined: 2011-11-25
7174 posts

Hello mz91184,

The user does not have proper privileges in MySQL. But using the root user is not a good idea. But if that’s how you have it set up, then granting privileges should fix this.

Does that help?

If you are unfamiliar with MySQL then you may want to higher a developer to help you with the process.

Cheers,

Signature

Recent version: EE 2.5.4 | Forum Module 3.1.10 | MSM 2.1.4 | 2.x Bug Tracker | Version Upgrade

mz91184

Posted: 13 June 2012 04:49 PM

[ Ignore ] [ # 4 ] [ Rating: 0 ]

Joined: 2009-02-20
117 posts

Thanks for the extra help, I really appreciate it. I did a little more search and found a old trigger that was using root. It wasn’t being used so I removed it.

After removing it, I was able to upgrade to EE 2.5.2. Thanks!

Shane Eckert

Posted: 13 June 2012 04:51 PM

[ Ignore ] [ # 5 ] [ Rating: 0 ]

Joined: 2011-11-25
7174 posts

Hey mz91184,

WOOT!!!

Glad to hear it. Nice save!

If you need anything else, please just let me know by opening a new thread.

Cheers,

Signature

Recent version: EE 2.5.4 | Forum Module 3.1.10 | MSM 2.1.4 | 2.x Bug Tracker | Version Upgrade