Ozguru Posted November 5, 2006 Share Posted November 5, 2006 Hi i have install osc 2.2 on localhost and have it runing ok i then downloaded PC Pro Creator V2.3.4 and followed the instruction ( or atleast i think i did anyway but now com up with this error in admin when i add a new item to the catalogue Dependences: 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 ') or (product2_id = )) and pd1.language_id =1 and pd2.language_i SELECT product1_id as p1id, pd1.products_name as p1name, catdes.categories_name as p1cat, product2_id as p2id, pd2.products_name as p2name, catdes2.categories_name as p2cat FROM compbuild_dependence as cd INNER JOIN products_description as pd1 on pd1.products_id = cd.product1_id INNER JOIN products_description as pd2 on pd2.products_id = cd.product2_id INNER JOIN products_to_categories as ptc on ptc.products_id = product1_id INNER JOIN categories_description as catdes on catdes.categories_id = ptc.categories_id INNER JOIN products_to_categories as ptc2 on ptc2.products_id = product2_id INNER JOIN categories_description as catdes2 on catdes2.categories_id = ptc2.categories_id WHERE ((product1_id = ) or (product2_id = )) and pd1.language_id =1 and pd2.language_id =1 and catdes.language_id=1 and catdes2.language_id=1 [TEP STOP] and when trying to use the PC Pro Creator V2.3.4 build system i get the following in every drop down 1065 - Query was empty [ TEP STOP] if anyone can give me a hint / some help to where i went wrong i would be greatfull Quote Link to comment Share on other sites More sharing options...
Guest Posted May 2, 2007 Share Posted May 2, 2007 Hi, I have now got the EXACT same problem. Did you manage to resolve this? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.