Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

can not setup mySQL database, help!


lion

Recommended Posts

setup online shop in a fresh machine.

winxp pro,

IIS5.0, PHP5.0, mysql4,navicat2004 GUI

osCommerce 2.2

local IP: 192.168.0.1

mysql running

followed the web install instrcution, install->uncheck import database, check auto->database server:192.168.0.1, user name:root, password: XXX, database:test->no error message, no success message, install page half loaded.

please give me some hints!

thanks!

Link to comment
Share on other sites

tried to fix this problem, i imported the sample database manually, checked mysql, the database was there, name: oscommerce, usename: root, password: XXX, IP:192.168.0.1, which is the web server itself.

i still can not get the install success message.

if osCommerce install successfully, i should be able to see soomething under http://localhost/ then i guess, am i right, expert please help. thanks!

Link to comment
Share on other sites

Just wanted to add a note that osCommerce does not inherently support PHP5.0 (PHP5 came out after MS2). If you can't avoid using PHP5.0 search this forum for +PHP5 +$this for extra information.

 

There are also some configuration issues using IIS as well. You migh want to try a WAMP setup using EasyPHP (free), which is quite popular here for local installation.

 

For the Database Problem above, it might be a good idea to create a new username/password for that database and ensure that you have all access privileges. You can do this easily with phpMyAdmin (also included + configured in EasyPHP).

Link to comment
Share on other sites

Just wanted to add a note that osCommerce does not inherently support PHP5.0 (PHP5 came out after MS2).  If you can't avoid using PHP5.0 search this forum for +PHP5 +$this for extra information.

 

There are also some configuration issues using IIS as well.  You migh want to try a WAMP setup using EasyPHP (free), which is quite popular here for local installation.

 

For the Database Problem above, it might be a good idea to create a new username/password for that database and ensure that you have all access privileges.  You can do this easily with phpMyAdmin (also included + configured in EasyPHP).

i am still not sure my problem was caused by wrong PHP version, but will change to a new php tonite, let's see what happen then, anyway, thanks! at least i know something now.

Link to comment
Share on other sites

i am still not sure my problem was caused by wrong PHP version,  but will change to a new php tonite, let's see what happen then, anyway, thanks! at least i know something now.

The problem above was not caused by PHP version but a database privilege error. I mentioned about PHP version above, because after you get pass that problem you'll get a warning about $this (from version compatibility) in your store.

 

Good luck! :thumbsup:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...