Help needed

[KJ666]

I need help, i tried to instaill this, Shipping Agree To Terms (http://www.oscommerce.com/forums/index.php?showtopic=277380)

Got an error (same error now)

An it did not work so took it off but still get the error in checkout_shipping.php

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 ') and products_id in (22)' at line 1

 

select * from products_to_categories where categories_id not in () and products_id in (22)

 

[TEP STOP]

[KJ666]

How do you edit ??

 

I have uploaded a fresh copy of checkout_shipping.php but the problem is still there. :(

[KJ666]

I found this on the net, will this sort my problem or is there any other code i can place in myphpadmin.

 

ALTER TABLE `products_to_categories` DROP PRIMARY KEY;

 

ALTER TABLE `products_to_categories` ADD INDEX `idx_p2c_categories_id` ( `categories_id` );

 

ALTER TABLE `products_to_categories` ADD INDEX `idx_p2c_products_id` ( `products_id` );

 

 

 

I also added an index on the products_id column for the specials table with great success.

 

 

CODE

ALTER TABLE `specials` ADD UNIQUE `idx_s_products_id` ( `products_id` );