Contribution Help.

[Brunswick]

Hello,

 

A number of the contributions aparently require you to insert something manually into the database. How exactly do you do that, using phpmyadmin, say? I have a nodding aquaintance with MySQL but don't feel very comfortable doing this. Do you for example add a record to the end? I don't even know what to ask. Can someone point me somewhere for instructions on how to do this. (preferably step-by-step)

 

Help! :(

 

-Hank

 

 

"Everybody was a newby once."

[♥Vger]

If the sql code you get is just a few lines in the install file then you open the SQL query window in phpMyAdmin and paste it in there and click Go.

 

If it is an sql file included with the install then use the SQL or Import tab (varies depending on your version of phpMyAdmin) and then use the Browse function to locate the file on your PC - and then click Go.

 

Vger

[Brunswick]

If the sql code you get is just a few lines in the install file then you open the SQL query window in phpMyAdmin and paste it in there and click Go.

 

If it is an sql file included with the install then use the SQL or Import tab (varies depending on your version of phpMyAdmin) and then use the Browse function to locate the file on your PC - and then click Go.

 

Vger

 

 

Hi Vger,

 

Just want to take a minute to thank you for your response. I finally did solve my problem which wasn't so much what to do with the data shown in the file:

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Minimum Order Amount', 'MIN_ORDER_AMOUNT', '', 'The minimum amount an order must total to be able to checkout. Empty means no minimum.', '1', '23', now());

It was much more basic than that. First of all, I wasn't sure if this had to be inserted in the middle of the table or on the end or even if it mattered. More basic than that, I wasn't even able to see what the table looked like because I did not know how to bring this up in phpmyadmin. After endlessly trying both from the command line as well as phpmyadmin, it finally dawned on me that I had to click here (duh!)

 

 

to view the table. (You have no idea how hard it is to find out something as basic as that.) Once I got past that hurdle, things kind of fell into place. I was then able to see how all the various functions in osCommerce relate to the database information and how to carry on from there.

 

I guess there is a lesson here somewhere. There might be a lot less stumbling going on if some of that really basic stuff was available somewhere.

 

Anyway, thank you again for trying to help as well as your help in the past. After months, my shopping cart is slowly getting ready for "prime time".

 

Best,

 

-Hank Mulder :thumbsup: