An unexpected error occurred.
Permalink
Hi we had site which we have moved from old host to new host.
Did this by exporting database using PhpMyAdmin then uploading it to new hosting account.
I had various errors which I have managed to get through they seem to be related to how MySQL has exported the tables (for example instead of Pages it's pages). Each error I got re the table name not being found I fixed by capitalising the first letter. However I haven't done this for every single table as some tables are written camel case like 'atDefault' so I wasn't sure which to do and which not.
Anyway then I got the missing column errors so advice on this post helped me:
https://www.concrete5.org/community/forums/installation/scary-error-...
Now, after all that and fixing each error one by one I just see a screen with 'A database error occurred while processing this request'. Incredibly annoying since now it could be anything - maybe some other tables haven't been updated (for example still says users instead of Users).
Any other thoughts? I even tried manually installing version 5.4.4.2 and then 5.5.2.1 which I believe is the current version. But still having db issues.
Can anyone help???
Did this by exporting database using PhpMyAdmin then uploading it to new hosting account.
I had various errors which I have managed to get through they seem to be related to how MySQL has exported the tables (for example instead of Pages it's pages). Each error I got re the table name not being found I fixed by capitalising the first letter. However I haven't done this for every single table as some tables are written camel case like 'atDefault' so I wasn't sure which to do and which not.
Anyway then I got the missing column errors so advice on this post helped me:
https://www.concrete5.org/community/forums/installation/scary-error-...
Now, after all that and fixing each error one by one I just see a screen with 'A database error occurred while processing this request'. Incredibly annoying since now it could be anything - maybe some other tables haven't been updated (for example still says users instead of Users).
Any other thoughts? I even tried manually installing version 5.4.4.2 and then 5.5.2.1 which I believe is the current version. But still having db issues.
Can anyone help???
Would you like to PM me a zipped copy of your database so I can compare it to my 5.6 databases?
Hi yes that would be great. I'll PM you now.
I sent the zip file direct to you, hopefully you will find out what the issue is.
Yes I have the file now..
There are several table names needing to be ReNamed..
I will look into this further..
Meanwhile, you should turn off 'Statistics' in System & Settings and truncate the PageStatistics table in the database by running this sql on the database
There are several table names needing to be ReNamed..
I will look into this further..
Meanwhile, you should turn off 'Statistics' in System & Settings and truncate the PageStatistics table in the database by running this sql on the database
TRUNCATE PageStatistics
I have sent you a file by PM to show the table name errors..
Hi I don't appear to have had any PMs, could you just paste the tables here?
Here you go..
Thanks for that - it hasn't really solved my issue as I'm getting 5 messages of unexpected error occured and:
mysql error: [1048: Column 'cID' cannot be null] in EXECUTE("insert into PageStatistics (cID, uID, date) values (NULL, 0, NOW())")
I've PM'd you link to the website - can you advise what else I should check?
mysql error: [1048: Column 'cID' cannot be null] in EXECUTE("insert into PageStatistics (cID, uID, date) values (NULL, 0, NOW())")
I've PM'd you link to the website - can you advise what else I should check?
I have replied to your PM..
Don't seem to be getting your PMs, can you resend or advise here?
was there a resolution to this issue?
