Thread

I’m in the process of moving my EE install to another server.  After doing so, almost everything seems to work, but when I log out of the admin I get a MySQL error.  I’ve got MSM installed, and I can tell that my database expects a site ID, but the MySQL code being passed doesn’t have that. 

Its almost like the admin doesn’t think I have MSM, or at least the log-out function doesn’t know it.

MSM does seem to work fine, as I can change to different sites, but I just can’t seem to be able to log out of the admin.

Thanks.

Hi and welcome to the forums, jgeddes!

Can you verify the version and build of EE and MSM you’re using? What specifically is the full MySQL error?

Sorry Brandon, I should have put that in the first post.

Build: 1.6.8

MySQL ERROR:

Error Number: 1366

Description: Incorrect integer value: ‘’ for column ‘id’ at row 1

Query: INSERT INTO `exp_cp_log` (`id`, `member_id`, `username`, `ip_address`, `act_date`, `action`, `site_id`) VALUES (’‘, ‘1’, ‘administrator’, ‘10.10.1.10’, ‘1274466393’, ‘Logged out’, ‘1’)

My MySQL table has a column for Site, but the query doesn’t include that column.  It’s like the log-out function doesn’t know that I have MSM.

Can you go into the Admin ›  Utilities ›  SQL Manager ›  Database Query Form and query for:

describe exp_cp_log

what is the value for id?

jgeddes,

I suspect the issue is that your new server is running MySQL in ‘strict’ mode. Please contact your host (for the new server) and confirm that’s the case, and if so, ask that they disable strict mode. Keep us posted.

Thanks Brandon, that did it!  Sorry for the late reply.

Glad to see you’re all set. Please post again as needed.