Thread

I’m trying to replicate my site on a staging sub domain, so I made a copy of everything on my live domain to my staging domain including db, made the path changes, etc.  But when I login I get this db error:

A Database Error Occurred

Error Number: 1054

Unknown column ‘site_id’ in ‘field list’

INSERT INTO `exp_sessions` (`admin_sess`, `session_id`, `ip_address`, `member_id`, `last_activity`, `site_id`, `user_agent`) VALUES (1, ‘43a80dd73fcf655cc9c13fba6aa55c9d16d97f04’, ‘74.217.86.15’, 1, 1319909751, 1, ‘Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1’)

Filename: libraries/Session.php

Line Number: 421

Running MSM on the live site, which sounds like is causing the problem on my staging site when it’s trying to insert the session in to the db.

But not quite sure of a work around. Thanks for any help!

Hi Marshall,

can you try deleting your staging database and reimporting. Check the exp_sessions table columns match your live exp_sessions tables’

What are you using to login? The admin.php or system/index.php

What version and build of EE are you using?

Thanks John -

Yes, the tables match; and that column is indeed missing in both live and staging.  Using system/index.php to login and running 2.3.1 build 20111017.

When I go to the staging home page I get this message:

Site Error: Unable to Load Site Preferences; No Preferences Found

Not sure if that helps.

Doesn’t appear that I can pull the latest version down from Downloads & Support.  It says I’m not logged in.

Hi, Grant. Try logging in again… can you now download?

Was this ever resolved? I am having the same issue.

I’m running 2.1.3, and my live site is working fine. I just backed up the live site, copied it to the staging server and copied over the live site’s database, and now I am getting this same error. I’ve dropped and re-imported the database, and deleted and re-uploaded the entire site, and am still getting the error.

I’ve checked both databases, and the site_id column is missing from both the live and staging dbs, but I am able to successfully log in to the live site. When I go to the staging home page, I get a blank screen (no php errors).

Both versions of the site are running on the same host, so there should be no issues there.

Hi aircrash,

Are you running MSM and if so did you move those files as well to your staging server?

Sean

No, it was my own fault. I mis-labeled my files, so I was re-uploading my old site files rather than the new ones (both times), so I had the 2.3.1 database and 2.2.x files. Once I uploaded the correct files, everything was fine.

Thanks for the update aircrash.

where are you with this Marshall. Were you able to resolve on your own?