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???

 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Would you like to PM me a zipped copy of your database so I can compare it to my 5.6 databases?
dinny123 replied on at Permalink Reply
Hi yes that would be great. I'll PM you now.
dinny123 replied on at Permalink Reply
I sent the zip file direct to you, hopefully you will find out what the issue is.
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
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
TRUNCATE PageStatistics
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
I have sent you a file by PM to show the table name errors..
dinny123 replied on at Permalink Reply
Hi I don't appear to have had any PMs, could you just paste the tables here?
ConcreteOwl replied on at Permalink Reply 1 Attachment
ConcreteOwl
Here you go..
dinny123 replied on at Permalink Reply
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?
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
I have replied to your PM..
dinny123 replied on at Permalink Reply
Don't seem to be getting your PMs, can you resend or advise here?
spencerhudson replied on at Permalink Reply
spencerhudson
was there a resolution to this issue?