newbie1000 Posted March 28, 2018 Share Posted March 28, 2018 Hey total newbie and migrating a client site to different server and pulled all files and database and after a few hiccups in missing files I get to this point 1146 - Table 'merchand_shop.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration[TEP STOP] There is no - Table 'merchand_shop.configuration' in the existing site, database, any ideas? Link to comment Share on other sites More sharing options...
ArtcoInc Posted March 28, 2018 Share Posted March 28, 2018 @newbie1000 What version of osCommerce? What version of PHP (on both the old server and the new server)? What add-ons have been installed? Link to comment Share on other sites More sharing options...
ArtcoInc Posted March 28, 2018 Share Posted March 28, 2018 Link to comment Share on other sites More sharing options...
newbie1000 Posted March 28, 2018 Author Share Posted March 28, 2018 Hi have just checked existing server ea-php56 , new server 5.6.34 and // Define the project version --- obsolete, now retrieved with tep_get_version() define('PROJECT_VERSION', 'osCommerce Online Merchant v2.3'); I have created the new database on the new server and imported all the data into that database, and transferred the files over as required. DO I need to have run an installation wizard first then drop the tables in? thanks Link to comment Share on other sites More sharing options...
♥raiwa Posted March 28, 2018 Share Posted March 28, 2018 Your configuration files need to be updated to the new server settings: absolute paths, database server, database name, database user and passw. if you are not sure how to do this, yes, you could do a new installation of a downloaded complete oscommerce package. Try to use the same version of your real store. Use the installation script and install into a subdirectory and linked to a separate database. Then open and compare both configuration files to see which definitions to update and how to update them. the files are: includes/configure.php admin(or whatever your admin directory is called)/includes/configure.php About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
MrPhil Posted March 28, 2018 Share Posted March 28, 2018 I think "configuration" is one of the first tables hit when running. The first thing to check is whether you did something silly at some point, and misspelled "merchant_shop" (the DB table prefix) as "merchand_shop" (or vice-versa) in either setting up the database, or in osC's configuration. They can be spelled either way, but need to be consistent! While you're going through the effort of migration, consider upgrading to the latest and greatest: osC 2.3.4.1BS "Edge". Note that this is not the official release, but has to be obtained from GitHub (see my signature below). Link to comment Share on other sites More sharing options...
newbie1000 Posted March 29, 2018 Author Share Posted March 29, 2018 thanks everyone for your help, woke up this morning and fresh eyes missed 2 tables out of database, should not work night shift but now working on the other server Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.