rayjuan Posted May 25, 2010 Posted May 25, 2010 Hi All, i have migrated my website to another hosting company recently and i am facing some uncomprehensible errors on my end. i have created a new mySQL database on the new hosting server and changed it accordingly under /includes/configure.php file. after i loaded the website again i get this error 1146 - Table 'ctckhi_uber1.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] Is there another configuration file to change the mysql settings? please kindly advice. thanks again! Ray
Guest Posted May 25, 2010 Posted May 25, 2010 There are two configuration files, one is in catalog/includes/configure.php and the other in catalog/admin/includes/configure.php
Guest Posted May 25, 2010 Posted May 25, 2010 Ray, Import your database again, for some reason the configuration table did not import into the new database. Chris
rayjuan Posted May 26, 2010 Author Posted May 26, 2010 hi hal and chris, thanks for the replies, i will proceed to change the other configuration file and im actually not quite sure what chris meant by reimporting my database again. do u mean creating another mySQL management ? thanks again! ray
rayjuan Posted May 26, 2010 Author Posted May 26, 2010 hi hal , i have changed both the configure.php files on both folders but to no avail still i still get this error 1146 - Table 'ctckhi_uber1.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP]
Guest Posted May 27, 2010 Posted May 27, 2010 Ray, What Chris means is that you should have a copy of your oscommerce database from your last host and you should import it into the new oscommerce database you have created at your new host. - Hal
rayjuan Posted May 27, 2010 Author Posted May 27, 2010 hi hal, i copied the entire system from the other hosting server to the new one. the database was left untouched . could you enlighten me on the steps taken to to import a database? are you refering to the mysql settings? sorry for the noob questions thanks hal ray
Guest Posted May 27, 2010 Posted May 27, 2010 Ray, The best way to import your database in my opinion is to do it using phpMyAdmin which most web hosts offer through your web host control panel. Read the phpMyAdmin documentation if you have any trouble. - Hal
jaydigital Posted August 28, 2011 Posted August 28, 2011 Ray, The best way to import your database in my opinion is to do it using phpMyAdmin which most web hosts offer through your web host control panel. Read the phpMyAdmin documentation if you have any trouble. - Hal
jaydigital Posted August 28, 2011 Posted August 28, 2011 Hi Hal, I have the same problem after an attempted migration. I cannot copy the database, but I do have a database backup file, db_oscommerce-20110828083534.sql, made with the osCommerce database backup tool. Could this be used to get rid of the "1146 Error"? Thanks, John
satish Posted August 29, 2011 Posted August 29, 2011 Table 'ctckhi_uber1.configuration' doesn't exist or dbname.configuration points to configuration table and this table for some reason is not there in data base or you need to repairthat table. satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does.
jaydigital Posted August 29, 2011 Posted August 29, 2011 Thanks Satish I was able to import the oCcommerce backup manager's database backup file using phpMyAdmin. That is the route I will go in future migrations. John Table 'ctckhi_uber1.configuration' doesn't exist or dbname.configuration points to configuration table and this table for some reason is not there in data base or you need to repairthat table. satish
Recommended Posts
Archived
This topic is now archived and is closed to further replies.