Merging online/offline
Permalink
Hey there,
i've got 2 installs of c5. One running offline on a XAMPP environment for development etc (running really good btw) and a untouched version on a live server. both are working as intended.
My problem now is i cant seem to find a how-to or wateva on merging the "styled" offline version on the live server. Tried dumping the offline sql and import it to the live one... doesnt work :/ changed the config file accordingly... doesent work :/
oh wait. am getting an errormessage ;)
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'db266719568.Config' doesn't exist] in EXECUTE("select cfValue from Config where cfKey = 'PERMISSIONS_MODEL'") ' in /homepages/2/d178249993/htdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb.inc.php(918): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'db266719...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb.inc.php(874): ADOConnection->_Execute('select cfValue ...') #2 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb.inc.php(1472): ADOConnection->Execute('select cfValue ...', Array) #3 [internal function]: ADOConnection->GetRow('select cfValue ...', Array) #4 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/database.php(62): call_user_func_array(Array, Arr in /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I'd really appreciate any help.
i've got 2 installs of c5. One running offline on a XAMPP environment for development etc (running really good btw) and a untouched version on a live server. both are working as intended.
My problem now is i cant seem to find a how-to or wateva on merging the "styled" offline version on the live server. Tried dumping the offline sql and import it to the live one... doesnt work :/ changed the config file accordingly... doesent work :/
oh wait. am getting an errormessage ;)
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'db266719568.Config' doesn't exist] in EXECUTE("select cfValue from Config where cfKey = 'PERMISSIONS_MODEL'") ' in /homepages/2/d178249993/htdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb.inc.php(918): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'db266719...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb.inc.php(874): ADOConnection->_Execute('select cfValue ...') #2 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb.inc.php(1472): ADOConnection->Execute('select cfValue ...', Array) #3 [internal function]: ADOConnection->GetRow('select cfValue ...', Array) #4 /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/database.php(62): call_user_func_array(Array, Arr in /homepages/2/somenumber/htdocs/somefolder/mainfolder/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I'd really appreciate any help.
block style or theme style? I assume you are trying to copy over the db 1 to 1 and the entire site, but the best way to do this is to ftp up your entire site, dump your db, replicate the db 1:1 on the live server and then edit the config/site.php with the necessary values for db name server and password.
i managed to get it up and running on the live server. somehow the db names are case sensitive and exporting the offline db got all table names in lower case. that's why c5 wasnt able to find the tables.
been a bit of work and i honestly been thinking about swearing ;) tho it' running sweet now and i'm al good again ;)
cheers
been a bit of work and i honestly been thinking about swearing ;) tho it' running sweet now and i'm al good again ;)
cheers
i have the exact problem. its the last step before i put my clients site on live.
how did you solve it?! im dying to know!
how did you solve it?! im dying to know!
I am getting a similar error once i moved my site from my dev machine (win xp running apache) to the live machine (linux). On both machines all the table names seem to be lowercase (using MySQL Administrator locally and phpMyAdmin remotely to confirm this). Yet i get an ADODB error looking for table "Packages." Should i start renaming these tables to capitalize them or how did you fix this?! Thanks so much!
Heyho,
what I did was renaming all the tablenames. took for ages and i have to admit i had dirty thaughts about whoever coded it that way... :)
cheers
what I did was renaming all the tablenames. took for ages and i have to admit i had dirty thaughts about whoever coded it that way... :)
cheers
Just an update on what fixed it for me. Turns out mysql installed in windows by default has case insenstive tablenames and so creates them all lowercase. So you need to add this line to your my.ini
set-variable=lower_case_table_names=0
BUT if you've already craeted the db and you now need to port it to another environment (linux for example) where case does matter, you have to manually chagne each table name before you do the database backup and restore. It's ugly. but it worked.
set-variable=lower_case_table_names=0
BUT if you've already craeted the db and you now need to port it to another environment (linux for example) where case does matter, you have to manually chagne each table name before you do the database backup and restore. It's ugly. but it worked.
It's a well known-problem. Check this remedium:
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
How it works:
http://www.concrete5.org/files/1112/9040/0018/MySQLCaseInsensitiveH...
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
How it works:
http://www.concrete5.org/files/1112/9040/0018/MySQLCaseInsensitiveH...
