Uknown Column when making heavy mods to code

[jynxy]

I keep getting this message in admin.

i changed the mysql field type for product from int to varchar and as far as i can see from the code it is still looking for an int how can i fix this.

1054 Unknown column 'D' in 'where clause'
in:
[select * from products_to_categories where product_id=0000762-D]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

also get simualar when i click on a cat in admin.

[bunyip]

A lot of the queries to the database use the form

products_id = (int)$products_id

when selecting data: that's where your problem is.

Changing the field type for the product_id means you'd have to modify a huge number of queries throughout the site.

[DrByte]

"huge number of queries" is an understatement.

products_id is a numeric value that is used as a cross-reference value (key) to link numerous database tables together.

You'd be better off using the products_model field to track the varchar-style product number instead of the products_id field.

[jynxy]

ok well i have changed every line of query so that it doesnt use int anymore.

the only problem i now have is when i click on a product that has a product_id of 0002249-C it will remove the -C from the url so it wont work, uet everything in admin works fine

[jynxy]

fixed by removing this line in init_sanitize.php

if (isset($_GET['sku_id'])) $_GET['sku_id'] = ereg_replace('[^0-9a-f:]', '', $_GET['sku_id']);