Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

2 errors after ExtraImages install.. should be easy fix


ftwvampftw

Recommended Posts

This should be an easy fix for those veterns out there.

 

Ok, i'm totally noob when it comes to PHP and all this jazz. I have a OSC site set up with Filebrowse and now I tried to do the copy and paste install of the oscExtraImages.

 

So I am getting the following error (i have searched.. 2 hours and i'm very frustrated and tired).

 

1st error. This is when I go toedit an already setup product-

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.p.products_image_1, p.products_image_2, p.products_image_3, p.products_image_4,' at line 1

 

.p.products_image_1, p.products_image_2, p.products_image_3, p.products_image_4, . select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '30' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

 

 

Now I remember the 1st installation insturction said ". Run the query in your database admin tool. Feel free to add or remove the number of extra image fields.

 

ALTER TABLE `products` 
ADD `products_image_1` VARCHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
ADD `products_image_2` VARCHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
ADD `products_image_3` VARCHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
ADD `products_image_4` VARCHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

 

This is probably where I tottally killed it. I am using phpMyAdmin on my server. Now I probably messed up tables while I was trying to figure out how to run it.

 

 

Now number 2 problem.

 

When I go to add a picture, the thumbs nails are broken. They are linked to: /catalog/admin/includes/filebrowser/images/mimetypes/image.png when they should probably be linked /catalog/images not /catalog/admin/etc/etc/

 

I have ALSO just noticed that my poduct names are now near the bottom of their product page along w/ the image. I kinda wanted the Name and Image to stay on top and just add maybe 2-3 images at the bottom w/ the enlarge here.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...