dj619gior Posted March 19, 2003 Share Posted March 19, 2003 I am in the middle of installing this cool shop and. I have the files uploaded I am useing this guide, http://wiki.oscommerce.com/helpInstallNew I am stuck at this part, "Using phpMyAdmin or other tool, create your database and user, and assign that user to the database. Write down the name of the database, login, and password for this database for the install fields later on." How do I creat my data base I have the myadmin stuff Can someone please tell me what to do. Thank you verry much for takeing the time to help me and read this. My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 did you run the install.php file that is part of the OSC dl - that will create the database for you without you having to go into phpmyadmin Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 run phpmyadmin and simply select create new database (there is an option in the phpmyadmin screen to do this) remember your root login and password and then run the install.php script and enter that information into the fields when it asks for it Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 I ran the install file and I am still lost I am horrible at this sorry. I get this error "A test connection made to the database was NOT successful" I entered the info my host gave me, to connect to my data base please help me thanks! My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 then you need to use phpmyadmin and use it to create an empty database and then re-run the install script or.... it could be that you dont have the correct login/password Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 I am at the myadmin thing at the bottom there is a forum that says! Create new table on database gamesand : Name : Fields : What do I put there? Than when I go to the next screen there is. Field: Type: Length/Values*: Attributes: Null: Default: Extra What do I put there? THan there is , Primary: Index: Uniqu : (thoes are check boxes) And than. Table comments : Table type : Thanks again I thank you verry much for helping me/. My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 all you want to do is create an empty/blank database and call it catalog or whatever you like - you do not need to enter any table or field names - just create the database are you using myadmin or phpmyadmin? Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 I am useing phpmyadmin You said database ummm? What I was trying to do is make a table inside a database. I need to email my host and ask for another db My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 so you already have a database created? you don't need to create another one unless the existing database is being used for something else if its not being used for anything other than OSC, than in phpmyadmin, select the database from the drop down menu in the left column and if tables exist in it already you should see a list of the existing tables, each with a checkbox next to the name of the table - scroll down the list and you should see a Select All checkbox - click that and then select 'Drop' from the popup menu next to it - that will clear all the tables from the database leaving you an empty database with no tables - write down the name of the database, make sure you have you login and password and then run the install.php script for OSC and enter the database name, login, password, etc, in the install form Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 I am useing it for a lot of things. If I delete them I will be in for a long night :shock: My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 thats why I asked first :) so then you need to create a new database for OSC - you have to have your host do that or can you do it yourself with phpmyadmin? Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 Ok I will have them make me a database what should I name it? "catalog" My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 thats your choice :wink: catalog, mystore, whatever........ 8) Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 whatever you decide to name, just remember the name as you will need to enter it into the install.php script when you run it to point at that database 8) Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 Ok I sent them a email. So once its created I just enter the database name in the installer and thats it. My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 once they create the new db for you then you will run the install.php script to install OSC and enter the information on each screen - that will get you going into the wonderful world of OSC :wink: Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 THey want me to pay $5 extra a month. I found out why I couldent connect I havent done it in a while I was supposed to enter in "localhost" And it worked I dont need a new db I am at the shop config. Ty verry much lots of love to you. My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 $5/mo :shock: capatilism is alive and well :? great - welcome to OSC! 8) Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 I set it up last night it I added stuff it was working great now all of a sudden I got this error 1146 - Table 'test.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] What do I do I cant even access the site I got the error when I was adding one of thoes feilds like for extra stuff you can get with the product. My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 sounds like a table is missing from the database Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 I looked in the data base called Test. There is nothing in there.. No tables. I am useing a manualipated database. (you know a db inside a db) What should I do? My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 well you have to install all the OSC tables into the db - you may have to do it manually using phpmyadmin Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 you think you might be about to tell me how? I have no clue sorry :( My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 did you try running the install.php script using that database? that should insert the fields for you if not, then you will need to: run phpmyadmin select your database click the SQL tab that appears over the database listing click the browse button and select the oscommerce.sql file that is included with the install folder for OSC click the Go button and hopefully all the fields will be imported into the database Link to comment Share on other sites More sharing options...
dj619gior Posted March 19, 2003 Author Share Posted March 19, 2003 Ty! It added all the fields and now my shop works again but I lost all my stuff. Oh whell better than haveing it now work :D Ty again. My Website: Tutorials,Reviews,Shop. fun fun fun Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.