2 errors after ExtraImages install.. should be easy fix

[ftwvampftw]

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.