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
Latest News: (loading..)
0
11 replies to this topic
#3
-
- Community Sponsor
-
- 10,458 posts
- Real Name:Chris Dunn
- Gender:Male
- Location:Tecumseh, Ontario, Canada N8N 1X8
Posted 25 May 2010, 15:01
Ray,
Import your database again, for some reason the configuration table did not import into the new database.
Chris
Import your database again, for some reason the configuration table did not import into the new database.
Chris
:|: Was this post helpful ? Click the LIKE THIS button :|:
:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:
:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:
:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:
:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:
#4
Posted 26 May 2010, 12:31
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
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
#5
Posted 26 May 2010, 13:18
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]
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]
#6
Posted 27 May 2010, 15:29
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
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
#7
Posted 27 May 2010, 16:10
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
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
#8
Posted 27 May 2010, 16:19
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
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
#9
Posted 28 August 2011, 19:05
mrwebdomain, on 27 May 2010, 16:19, said:
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
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
#10
Posted 28 August 2011, 19:07
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
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
#11
Posted 29 August 2011, 03:33
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
satish
Ask for osCommerce value addon suggestion tips for your site.
Check My About US For who am I and what My company does.
Check My About US For who am I and what My company does.
#12
Posted 29 August 2011, 12:10
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
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
satish, on 29 August 2011, 03:33, said:
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
satish
