Image magic + PDF catalogue Error 1054

[cmgrant]

I decided to install Image magic plus PDF catalogue Contrib http://www.oscommerce.com/community/contri...rch,image+magic date 7th Aug 2006

First I installed image magic over a well modified MS2 store, with no problems, :D

then installed the pdf catalog part. all seemed to go ok but when I try to generate the catalog in admin, I get this error :(

 

1054 - Unknown column 'p.products_id' in 'on clause'select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='29' order by pd.products_name, p.products_date_added DESC[TEP STOP]

 

Having read through the forums I know it's something to do with Mysql 5 but I'm at a loss as to how to solve it. I have for now removed the pdf installation, but I would like to use it.

I have tried using one of the other versions without image magic but I still get the same error

 

Any suggestions would be gratefully received :unsure:

[jasonabc]

http://www.oscommerce.com/community/bugs,3171

 

Scroll down to the 9 Jan 2006 05:25:14 for the correct fix.

[cmgrant]

http://www.oscommerce.com/community/bugs,3171

 

Scroll down to the 9 Jan 2006 05:25:14 for the correct fix.

Thanks. I've done all that and still get an error

PDF Catalog(s) Generation

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='22' order by pd.products_name, p.products_date_added DESC

 

[TEP STOP]

 

when I try to generate a catalogue in the admin. There must be something I can do. I've removed thod contribution 6 times now after each attempt to rectify the Mysql problem SOMEONE MUST have an answer please! :angry:

[jasonabc]

you can't have "done all that" and still be seeing that error. Double check your code.

[cmgrant]

Ok gone through everything again. Now I've got the following error

 

1054 - Unknown column 'p2c.products_id' in 'where clause'

 

select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products p, products_description pd, manufacturers m) left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='22' order by pd.products_name, p.products_date_added DESC

 

[TEP STOP]

 

Now what? any ideas? :(

[jasonabc]

You still can't be implementing the code from the 9 Jan 2006 05:25:14 post correctly. You just copy and paste it into index.php. This will fix your problem. You can also search on Google for the error you are getting - it brings back plenty of results.