bluemoonbikes Posted October 17, 2007 Share Posted October 17, 2007 ON OUR SITE WWW.BLUEMOONBIKES.COM SOME OF THE ONLINE STORE CATAGORIES (OSCOMMERCE) ARE SHOWING NO PRODUCT AVAILABLE. THESE "EMPTY" CATAGORIES ARE FULL OF ITEMS BUT NOT OBTAINABLE. ANY HELP ?????? Link to comment Share on other sites More sharing options...
Guest Posted October 17, 2007 Share Posted October 17, 2007 when adding a product did you put avalability date correct? Link to comment Share on other sites More sharing options...
bluemoonbikes Posted October 17, 2007 Author Share Posted October 17, 2007 when adding a product did you put avalability date correct? YES. THIS PROBLEM JUST STARTED WITH NO WARNING. ALSO I AM NOW UNABLE TO ACCESS OUR CONTENT EDITING SECTION. Link to comment Share on other sites More sharing options...
bluemoonbikes Posted October 17, 2007 Author Share Posted October 17, 2007 YES. THIS PROBLEM JUST STARTED WITH NO WARNING. ALSO I AM NOW UNABLE TO ACCESS OUR CONTENT EDITING SECTION. ANY IDEA WHAT THIS IS : DB function failed with error number 1054 Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10 Link to comment Share on other sites More sharing options...
usernamenone Posted October 17, 2007 Share Posted October 17, 2007 You have products for this categorie but explain mambo and the integration with osc? http://bluemoonbikes.com/mambo/component/o...pper/Itemid,34/ Link to comment Share on other sites More sharing options...
bluemoonbikes Posted October 17, 2007 Author Share Posted October 17, 2007 You have products for this categorie but explain mambo and the integration with osc? http://bluemoonbikes.com/mambo/component/o...pper/Itemid,34/ TO THE BEST OF MY KNOWLEDGE OUR WEBSITE WAS SET UP WITH TWO SECTIONS. 1ST SECTION IS INFORMATIONAL CONTENT AND THE 2ND SECTION (OSCOMMERCE) IS FOR OUR ONLINE STORE. THE 2ND SECTION (OSCOMMERCE) HAS RECENTLY GOTTEN SOME BUGS AND IS SHOWING ERRORS, SOME PRUDUCT CATAGORIES ARE ACCESSABLE AND OTHERS ARE NOT. I AM THE SITE "EDITOR", OUR "TECHNICION" IS NO LONGER WITH US, SO I AM TRYING TO UNDERSTAND THESE REPAIRS AND FIX THEM. THANKS FOR ANY HELP. Link to comment Share on other sites More sharing options...
bluemoonbikes Posted October 17, 2007 Author Share Posted October 17, 2007 You have products for this categorie but explain mambo and the integration with osc? http://bluemoonbikes.com/mambo/component/o...pper/Itemid,34/ YES, THIS CATAGORIE IS ACCESSABLE WHILE OTHERS NOT ?????? MAMBO IS A WEBSITE DESIGN TEMPLATE. Link to comment Share on other sites More sharing options...
usernamenone Posted October 18, 2007 Share Posted October 18, 2007 I know what mambo is but the only categories that are showing are linked within mambo and should be in your catalog outside mambo. YES, THIS CATAGORIE IS ACCESSABLE WHILE OTHERS NOT ?????? MAMBO IS A WEBSITE DESIGN TEMPLATE. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.