Thread

When you replace a working MySQL database with an older one, you need to upgrade the database fields. The error you’re getting involves site_id, which was added in EE 1.6.0.

When you replace a working MySQL database with an older one, you need to upgrade the database fields. The error you’re getting involves site_id, which was added in EE 1.6.0.

Well yes, the update.php does that correct?

Wait, it wasn’t replaced with an old one, it was created with an old one. This is a new server.

Well yes, the update.php does that correct?

Yes, it does. But you’d have to edit config.php and put back in the version you upgraded from so EE can “see” it needs to update you.

$conf[‘app_version’] is the line you are looking for.

Well yes, the update.php does that correct?

Yes, it does. But you’d have to edit config.php and put back in the version you upgraded from so EE can “see” it needs to update you.

$conf[‘app_version’] is the line you are looking for.

It did run the update, all they way up to the new version.  That’s the install/update that was so slow.

Let me try it again.

Eh.

So I created a new db, and loaded the backed up database tables on it.

Changed the config.php to point to the new db, and up pops the site.  Still at 1.5.2 however.  Now I’m reluctant to update it.

And by the way:  Script Executed in 0.6888 seconds

It is at 1.6.4 because the update errors out with an exp_site (something or other) already exists.

OK, in that case put back the right version in config.php.

Whadda ya know..

ExpressionEngine Discussion Forum - Version 2.1.0 (20080710)
Script Executed in 0.7471 seconds

Using the default template.

Astro, when I visited your forum via the link you provided earlier, I noticed the delay you were mentioning no longer occurs.

http://www.gulfcoastpundit.com/index.php?/forums/

Are you seeing the same thing on your end? Keep in mind I’m not logged in.

Yes.  I still had the 1.5.2 in the config file, once I changed that it all showed the correct version.  And it’s running like greased wheels now.

I’d like to request an addition to the Install/Update docs, to mention the case of moving to a new server and having a fresh database.  Also that trick of changing the version number in the config file would have been lovely to know.  😊

Thanks for all your help!

Thanks Astro.  Doc request duly noted - and also please feel free to add a user note to the docs whereever you think its most appropriate, I’m sure others would benefit from your experience.  Glad you’re back up to proper spEEds again 😉