Fatal Error after moving from MAMP to webhost

Permalink
hi, following the instructions "moving a site" I get a Fatal error message when calling the website within the browser.
URL ishttp://www.orienta-web.ch

and the error message reads:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1146: Table 'uheb_concrete5.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in /home/uheb/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/uheb/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 1146, 'Table 'uheb_con...', 'select * from C...', false, Object(ADODB_mysqlt)) #1 /home/uheb/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('select * from C...', false) #2 /home/uheb/public_html/concrete/core/models/config.php(182): ADOConnection->Execute('select * from C...') #3 /home/uheb/public_html/concrete/core/models/config.php(173): Concrete5_Model_ConfigStore->load() #4 /home/uheb/public_html/concrete/core/models/config.php(48): Concrete5_Model_ConfigStore->__construct() #5 /home/uheb/public_html/concrete/core/models/config.php(68): Concrete5_Model_Config::getStor in /home/uheb/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

uhebeisen
 
goodnightfirefly replied on at Permalink Reply
goodnightfirefly
It is possible your local environment is using lowercase table names, which causes problems as most servers are case sensitive.

You can verify this by looking at your table names in phpMyAdmin, and if they are indeed lowercase this add-on can help http://www.concrete5.org/marketplace/addons/database-case-sensitivi...
uhebeisen replied on at Permalink Reply
uhebeisen
thanks for your info, the table names are all lowercase. I've checked this and there is no way of modify the "my.ini" file (me webhoster told me so).
I am using C5 version 5.6.2.1 in a MAMP environment. When adding the addon "dbtablename - DbTableName" to my project (and assign it) I don't see its entry in the dashboard. The Backup&Restore section only shows:
Backup Database
Update concrete5
Database XML
But there is no entry "Database Migration"?

ps.: I am trying to follow step 2 in the documentation of the "dbtablename->DbTableName" add on
goodnightfirefly replied on at Permalink Best Answer Reply
goodnightfirefly
Perform the my.ini changes on your own computer, then you can transfer your repaired table from your computer to your server.

Its location will vary depending on what you used to install your MAMP environment. I am using XAMPP on Windows, so mine is at D:\My Websites\xampp\mysql\bin\my.ini

It sounds like you have assigned the add-on to your project, but haven't actually installed it yet. Visit Dashboard > Extend concrete5 and it should show up as available to download and install.
uhebeisen replied on at Permalink Reply
uhebeisen
shame on me, I have forgotten this.
Adding themes or addons is a two step process as you remind me. And downloading and installing must be started from the website.
I have tested c5 last november and since then this project was set to wait. But now I will to put it into a live website. Let's see how fast I can move things over from dev to live and let's also see how easy it will be to maintain a website based on c5.