Thread

Well, it borked out on me when I tried to upgrade from 1.5.2 to 1.6.1.  I got a exp_site error like the original poster to this thread had.

MySQL ERROR:
Error Number: 1146
Description: Table ‘databaseName.exp_sites’ doesn’t exist
Query: SELECT es.* FROM exp_sites AS es WHERE es.site_id = ‘1’

I went ahead and split this off from the original thread as there are likely differences in what’s going on.

Can you start by laying out what happened when you ran the update.php?  Did you get the first link to upgrade from 1.5.2- click it, get success message….  How far in that process did you get.  And if you look at update.php now, what does it say you’re running- and does it give you any more links in the upgrade path?

Thanks.  What “first link to upgrade from 1.5.2”?  The EE that I am working on is at 1.5.2 for a not for profit org and had a link to “Upgrade to 1.6.1” on the control panel page. 

There’s no other links.  When I run upgrade.php, it bombs out at that.  I went ahead and downloaded a EECore 1.6.1 and created one on my local pc (running apache, etc).  Copied the entry it created in exp_sites over to the org’s database (with slight modifications for url and server path).

Upgrade.php then was happy but puked at this:

MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘g.site_id’ in ‘where clause’

Query: SELECT m.weblog_id, m.tmpl_group_id, m.username, m.screen_name, m.member_id, m.email, m.url, m.location, m.join_date, m.last_visit, m.last_activity, m.total_entries, m.total_comments, m.total_forum_posts, m.total_forum_topics, m.last_forum_post_date, m.language, m.timezone, m.daylight_savings, m.time_format, m.profile_theme, m.forum_theme, m.private_messages, m.accept_messages, m.last_view_bulletins, m.last_bulletin_date, m.display_signatures, m.display_avatars, m.last_email_date, m.notify_by_default, m.ignore_list, g.* FROM exp_members AS m, exp_member_groups AS g WHERE g.site_id = ‘1’ AND unique_id = ‘’ AND password = ‘’ AND m.group_id = g.group_id

At that point, I realized that the schema for certain tables changed between 1.5.2 and 1.6.1 and stopped upgrading.  I didn’t have time this morning to do additional research in the updates folder.  I also didn’t want to write a conversion sql script to upgrade the exp_member_groups from the 1.5.2 schema to 1.6.1, since I think this was already done (by reading between Derek’s lines in the previous thread).  😊

Thanks,
Todd

Yep- unless you’re pretty up on it, you don’t want to directly muck with things.  But- you have me a little confused.  You saw a ‘upgrade to 1.6.1’ message in the control panel.  You were running 1.5.2.  So- you went, grabbed a fresh copy of the 1.6.1 from your download area- then updated according to the docs.

As part of upgrading, you go to the mysite.com/system/update.php page- after uploading a fresh copy of all the files.  Now- when you go to that page?  It should have said ‘You are running 1.5.2, click here to upgrade to 1.6.0’.  After you click- you get another link ‘Upgrade from 1.6.0 -> 1.6.1’.

Sound like what you did?

Wow.  That’s not what I am seeing. 

I followed everything up to the Update Wizard section (4th section).  I pointed the web browser to that link and nothing came up except these errors (the original exp_sites one and the member_groups one after my “hack”).

No links, nada, nil.  I downloaded the 1.6.1 version from the “My Downloads” page. 

Todd

Hm- ok, go in via ftp and delete system/update.php and the system/updates/ folder.  Upload fresh copies of both.  Then- double check that you’ve got the url correct.  It sort of sounds like you don’t- because the update file just doesn’t show that on the first page.

Done that and did that.  That didn’t work.  I used my ftp program to delete these folders listed in the upgrade documentation.  I uploaded the folders that I deleted from the EE 1.6.1 folder that I had downloaded from the EE site.  I also uploaded the updates.php file.

I double checked the permissions before running update.php.  Got the same error: 

MySQL ERROR:
Error Number: 1146
Description: Table ‘sk8ter_ee.exp_sites’ doesn’t exist
Query: SELECT es.* FROM exp_sites AS es WHERE es.site_id = ‘1’

No links or anything that you said came up.

I did an update for another site which went from 1.6 to 1.6.1.  That update was fine.  After all, it was on the same 1.6 level.

Sorry you got skipped there, ASLFilms.  OK- go in and grab your config.php file- what version does it show you’re currently running?

Hi Robin,

The config.php file says: $conf[‘app_version’] = “152”;

Thanks,
Todd

Weird- a search for ‘site’ in update.php and the 152 update file comes back with nothing.  I can’t spot where that query would be generated by simply loading the update.php file.  Try clearing all caches and let me talk with the crew.

(And if we ever skip you again like we did here- feel free to bump.  We should have had this cleared up for you before the weekend hit!)

Robin,

Apparently the cache got populated again during my update.  Clearing it out helped.  I was able to upgrade to 1.6.1.  Thanks again.

Todd

Ah- at least that makes some sense!  I still can’t spot where the error would have been triggered in the first place, but if it works?  I’ll take it.