Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ALTER TABLE uppdate database


Guest

Recommended Posts

I recently download Jan Skopek Big Image contribution. In the read me file I am instructed to:

 

Update your products-table in database:

ALTER TABLE `products` ADD `products_bimage` VARCHAR(64) AFTER `products_image`;

 

Where am I supposed to do this.

Do i need to download Mysql?

 

This can also be read in the read me file:

 

U also can replace code line for line instead of replacing the original files (recommended). All necessary changes to files are marked as follows:

 

What does this actually mean?. Is it recommended to replace all the files (after backing them up) or replace the code line by line?

Link to comment
Share on other sites

I recently download Jan Skopek Big Image contribution. In the read me file I am instructed to:

 

Update your products-table in database:

ALTER TABLE `products` ADD `products_bimage` VARCHAR(64) AFTER `products_image`;

 

Where am I supposed to do this.

Do i need to download Mysql?

 

This can also be read in the read me file:

 

U also can replace code line for line instead of replacing the original files (recommended). All necessary changes to files are marked as follows:

 

What does this actually mean?. Is it recommended to replace all the files (after backing them up) or replace the code line by line?

on your webserver, do you have phpmyadmin? that is where you would do that mod at

if not, then i would say you would have to have a script that would do the writing to the dbase for you and run the sql commands.

 

later,

dosdawgs

Link to comment
Share on other sites

U also can replace code line for line instead of replacing the original files (recommended). All necessary changes to files are marked as follows:

 

That means that if you have not made any modifications to the files *this* contribution uses, and if your version of osc is the same as the one the author was using when they wrote this contribution, that you can replace your file(s) with the one(s) provided in the contribtuion (BACK UP FIRST).

 

However, you'll probably either have already made modifications to thoese files, or are not using the exact same version of OSC, so you'll have to go through the files provided, and physically find all of the modifications he made, usually maked by a comment tag

 

// WaW contribuition edit start

 

some code

 

// WaW contribuition edit stop

 

and find the appropriate spot in your own files to add this code to, or replace existing code.

 

In all honesty, I hate when contributions do not have exact instructions on how to install, i.e. find some code, replace with this... Or find some code, add after. IMO, if it doesn't have explicit instuctions, the author was a little on the lazy side.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

This can also be read in the read me file:

 

U also can replace code line for line instead of replacing the original files (recommended). All necessary changes to files are marked as follows:

 

What does this actually mean?. Is it recommended to replace all the files (after backing them up) or replace the code line by line?

 

If you haven't previously modified the file(s) in question, you can simply replace the originals with the new ones from the contribution.

 

If you have made earlier mods to the file(s) in question, you'll have to make line-by-line code changes.

 

----

Oops, slow response. ;)

 

For making those lin-by-line edits, you might find a code comparsion tool such as Beyond Compare useful...

"Buy the ticket, take the ride..." -HST

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...