vrod Posted November 3, 2009 Share Posted November 3, 2009 Hi. Today i have been changing from the MSDB to MySQL. The change were succesfull, but after the change, i am now experiencing that sometimes, the control panel webpages is missing some stuff, or doesnt even load anything of it. My customers are also experiencing this. I have the MySQL server on a external machine, which is located in the same Datacenter (1<MS ping) Thx in advance Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 3, 2009 Share Posted November 3, 2009 You should check the logs folder for MySQL errors. If your page is blank, thats usually because your MySQL server lost connection with your master monitor. (Thats always what its been for me in the past before, we eventually fixed it). Link to comment Share on other sites More sharing options...
vrod Posted November 3, 2009 Author Share Posted November 3, 2009 There are no errors to see on the server :S Link to comment Share on other sites More sharing options...
vrod Posted November 3, 2009 Author Share Posted November 3, 2009 I have just spotted this error: There is no row at position 0. Link to comment Share on other sites More sharing options...
Santino Cid Posted November 3, 2009 Share Posted November 3, 2009 Is it slow, or just missing certain data? If it is super slow, you should try adding "skip-name-resolve" to your MySQL config. Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 3, 2009 Share Posted November 3, 2009 That actually means allot. Heres what I would assume first: You had your MSSQL setup running all fine and dandy, TCA uses a static integer somewhere to call row 0, when you did the import to mysql it incremented or omitted that integer all together. Causing your error. A full copy paste of the log in question would make things easier to debug though. Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 3, 2009 Share Posted November 3, 2009 Is it slow, or just missing certain data? If it is super slow, you should try adding "skip-name-resolve" to your MySQL config. +1 for support on disabling name based lookups. Link to comment Share on other sites More sharing options...
vrod Posted November 3, 2009 Author Share Posted November 3, 2009 That actually means allot. Heres what I would assume first: You had your MSSQL setup running all fine and dandy, TCA uses a static integer somewhere to call row 0, when you did the import to mysql it incremented or omitted that integer all together. Causing your error. A full copy paste of the log in question would make things easier to debug though. A log from the MySQL server? Or the TCAdmin service? Link to comment Share on other sites More sharing options...
Steven Crothers Posted November 3, 2009 Share Posted November 3, 2009 Both would provide good data on whats going on. MySQL error log + TCAdmin logs for everything on your master (Minus user info and logins of course). With that data available, it'll be easy to pinpoint the problem. TCAdmin isn't the easiest program to debug an error on, but when you have all the logs involved sitting in front of you, its easier. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.