mmstoned Posted December 22, 2008 Share Posted December 22, 2008 Hello All! I've tried to install the Categories Description Contribtion several times to no avail. I get the following error on pages when I click on product categories that have no sub-categories. I do have the field to add the product description from the admin panel, but it is messed up otherwise. ------------------------------------------------------------------------------------------------------------------- 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 'select cd.categories_description from categories c, categories_description cd wh' at line 1 select cd.categories_name, select cd.categories_description from categories c, categories_description cd where c.categories_id = '27' and cd.categories_id = '27' and cd.language_id = '1' [TEP STOP] ------------------------------------------------------------------------------------------------------------------- I'm assuming the problem lies somewhere in the index.php file. I'm rather new at this and troubleshooting isn't one of my stong points yet. I was wondering if somebody can lend me a hand in fixing this? The contribution is exactly what I need and I look forward to getting it to work. Thanks! Jeff Quote Link to comment Share on other sites More sharing options...
lindsayanng Posted December 22, 2008 Share Posted December 22, 2008 did you upload or run that mysql query that came witht he contribution??? that seems like what you are missing Quote A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
mmstoned Posted December 22, 2008 Author Share Posted December 22, 2008 Yes I did. When I logged into the admin section there was a place to type in the description for each category. I'm assuming that means the sql installation went ok. Thanks! Quote Link to comment Share on other sites More sharing options...
dodog Posted January 3, 2009 Share Posted January 3, 2009 any solution? I have got the same problem. Quote Link to comment Share on other sites More sharing options...
gaverp Posted January 4, 2009 Share Posted January 4, 2009 I think there's an error in your SQL shown above. You are showing: select cd.categories_name, select cd.categories_description from categories c, categories_description cd where c.categories_id = '27' and cd.categories_id = '27' and cd.language_id = '1' and it should be: select cd.categories_name, cd.categories_description from categories c, categories_description cd where c.categories_id = '27' and cd.categories_id = '27' and cd.language_id = '1' BTW - MySQL.org is giving away an SQL utility program (actually a set of them) that allows you to connect to your osCommerce MySQL database; run queries on the DB; modify tables; add; modify or delete records. It's called MySQL workbench and can be seen / downloaded here: MySQL Workbench. You can connect remotely to your store database using the utility. Did I mention it was free? With the workbench utility program you can run queries (like the one above) and test it to see where the problems are - it has some minor SQL troubleshooting help - but the user interface is where the real "help" exists. Hope this helps... Gaver SurfboardSigns.com & AuthenticEndlessSummer.com Quote Gaver diplomacy is the art of saying "nice doggie" - while you look for a rock. Link to comment Share on other sites More sharing options...
lindsayanng Posted January 5, 2009 Share Posted January 5, 2009 no. Just because the fields are there does not mean that your ran the sql queries correctly. OR the contribution that you used was made for an older version of PHP/MySql which would mean that the syntax used in the query you ran was correct at teh time, but because there were updates to the syntax since the contribution was made, it is no longer valid. Quote A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2009 Share Posted January 5, 2009 Hello All! I've tried to install the Categories Description Contribtion several times to no avail. I get the following error on pages when I click on product categories that have no sub-categories. I do have the field to add the product description from the admin panel, but it is messed up otherwise. ------------------------------------------------------------------------------------------------------------------- 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 'select cd.categories_description from categories c, categories_description cd wh' at line 1 select cd.categories_name, select cd.categories_description from categories c, categories_description cd where c.categories_id = '27' and cd.categories_id = '27' and cd.language_id = '1' [TEP STOP] ------------------------------------------------------------------------------------------------------------------- I'm assuming the problem lies somewhere in the index.php file. I'm rather new at this and troubleshooting isn't one of my stong points yet. I was wondering if somebody can lend me a hand in fixing this? The contribution is exactly what I need and I look forward to getting it to work. Thanks! Jeff Was it http://www.oscommerce.com/community/contributions,4294 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.