An unexpected error occurred.

Permalink
I changed the hosting but after uploading the files on the web folder and changed the database file with the new information, when I visit the site I get the following error:
"An exception occurred while executing 'SELECT t0.pkgID AS pkgID_1, t0.pkgHandle AS pkgHandle_2, t0.pkgVersion AS pkgVersion_3, t0.pkgIsInstalled AS pkgIsInstalled_4, t0.pkgAvailableVersion AS pkgAvailableVersion_5, t0.pkgDescription AS pkgDescription_6, t0.pkgDateInstalled AS pkgDateInstalled_7, t0.pkgName AS pkgName_8 FROM Packages t0 WHERE t0.pkgIsInstalled = ? ORDER BY t0.pkgID ASC' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Sql1138672_3.Packages' doesn't exist"

I tried the site locally with MAMP on mac and it works perfectly.

Help Me Please!

wells
 
ConcreteOwl replied on at Permalink Best Answer Reply
ConcreteOwl
Possibly a lower case table names problem.
Does the database table 'Packages' exist or is it spelled 'packages'
If it is spelled 'packages' then your mamp has exported the database with lower case table names..
EDIT Table names should be camel case..
wells replied on at Permalink Reply
wells
The table names are all with lowercase initial. How can I change?
I use a mysql database of aruba.
wells replied on at Permalink Reply
wells
I have exported the database from "register.it".
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
There is a sql script that may help you, look here..
https://www.concrete5.org/community/forums/installation/concrete5-8-...
If you want me to attempt this for you, just send me a zipped copy of the database by private message..
wells replied on at Permalink Reply 1 Attachment
wells
I have set up the database and now the site is visible.
In edit mode I do not see all the blocks but only some.
I enclose a screenshort of visible blocks.
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
What is the website address..
wells replied on at Permalink Reply
wells
www.agricolaproverbio.com
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
I see no errors in the browser console other than the missing favicon.png file and that is a trivial thing, nothing to be too concerned about.
Maybe clear the cache would help although I suspect you have already done that..