problem after creating database

[Guest]

Hi all i did the installation bit and clicked finish now when i try to loh into admin or website i get the following error

 

any help appreciated

 

 

 

1146 - Table 'newshop123.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

[Guest]

@@ChrisWarman

 

 

The easiest way to correct the error is to use PHPMYADMIN and import the database manually. For some reason, the installer doesn't always work on all hosting providers.

 

 

Chris

[Guest]

Hi I have no manuel database to import i used the link of the host to first intall then have set website up and the entered database on mysql control panel only this i have is a back up of the website from a day ago I'm a little out my depth here lol

[Guest]

would it be on my server to download? and if so any idea roughly where i should look?

[Guest]

If you used your hosting providers one click installer, then no you wouldn't have a copy. You can download your version from HERE and then you will find the data in the /catalog/install/oscommerce.sql file. Import that using PHP my admin to correct the issue.

 

 

 

 

Chris

[Guest]

sorted thanks very much

[rpdesign]

I have always used Xampp for windows so that i could install my shop in a test environment, not a live site!

Just good practices! :lol:

[Guest]

cool do they do a mac version?

[rpdesign]

@@ChrisWarman sorry been a while since getting to the forums and yes they do make a mac version!

here is the link

http://www.apachefriends.org/en/xampp-macosx.html

[MrPhil]

Frankly, my recommendation is to install in a private development directory on your real server (e.g., in /mydev1234). That way, there's no question that the correct PHP and MySQL levels are being used for your development, and it reduces the chances of forgetting to fix some file path or URL when you upload to the server (some entries in the configure.php files will have to be updated in either case). You can password product your development store if you don't want anyone else to see it, although avoiding any links to it from a public page (cataloged in search engines) should be enough. It's possible that 3rd party links such as to PayPal may not work, but you will have that problem on your PC *AMPP installation anyway.

[Guest]

@

@@MrPhil

@@ChrisWarman

 

I agree with Phil. Don't waste your time with any of the local environments. If you set it up on a live server in a private directory, you can install/configure/design/populate and text it from there. No hassles, no re-configuring when you make it live.

 

 

 

 

Chris