I need some help with adding a text box

[Jenica77]

I've been following these instructions:

http://www.oscommerce.com/community/contributions,4881

 

And I'm doing fine until I get here:

7. DO NOT FORGET TO DO THIS PART - SQL

 

Use your friendly database editor (phpMyAdmin, etc) to navigate to the orders_status_history table and add a field with the same name you chose for YOUR_NEW_BOX, it should be set type as text, null as YES and default as NULL, basically whatever you see your comments field is set to, do the same.

 

I have never used a DB editor and have looked everywhere for any tables. I see reference to them but have no idea where they are stored. Can anyone hlp me with this part? Thanks!

[andy_1984]

I've been following these instructions:

http://www.oscommerce.com/community/contributions,4881

 

And I'm doing fine until I get here:

 

 

I have never used a DB editor and have looked everywhere for any tables. I see reference to them but have no idea where they are stored. Can anyone hlp me with this part? Thanks!

 

 

do you mean you dont know where to find your database editor or you dont know how to use it ?

 

heres a few things for you to try.

 

1. (go to) http://yourwebsite.com/phpMyAdmin

 

if you are presented with a login screen for phpmyadmin then excellent you have got it. most web hosting companies use phpMyAdmin its a great tool for editing databases so chances you have it are high. if you get a 404 error page cant be found go to your web host control panel and look for database options or manage database or something to that effect.

 

2. login with your database username and password.

 

if you dont have these then you will find the information in your osCommerce configuration file located in Catalog/includes/configure.php

 

it will look like this at the end of the file:

 

 define('DB_SERVER', 'localhost');
 define('DB_SERVER_USERNAME', '------');
 define('DB_SERVER_PASSWORD', '-----');
 define('DB_DATABASE', '-----');
 define('USE_PCONNECT', 'false');
 define('STORE_SESSIONS', 'mysql');

 

if you know this already then great just ignore me. in the code above you want to take a note of DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE so now login to phpmyadmin or what ever editor your hosts uses and select the database which is set in DB_DATABASE above in this case it would be ----- but this is fake for the purpose of this post.

 

brilliant you are now in the oscommerce database. ill tell you now back up before doing anything please, look for an export or back up option select to back up ALL tables, export it to a text file and save it. if things go wrong here oscommerce might not work but with a backup you can automagically import the database you saved and hey presto oscommerce working again.

 

now on to your origonal question

 

on the left hand side you will see a lot of text like products, product_description and orders_status_history

 

these are things called tables, click on the one that the contribution is telling you to do, basicly if you look at the bottom of the orders_status_history rows you will see add new row after: [dropdown box] [GO].

 

once you are at this point things should be a lot clearer.

[Jenica77]

PERFECT!!!

 

Thank you so much!