500 - JDatabaseMySQL::query: 1064 error on debug - Joomla! Forum - community, help and support

-

hi,

could advise me on one.

when enabled "debug system" error

500 - jdatabasemysql::query: 1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'p.product_name asc' @ line 1 sql=select c.* pro25_redshop_category c left join pro25_redshop_category_xref cx on cx.category_child_id=c.category_id c.published = 1 , cx.category_parent_id='211' p.product_name asc

code: select all

jdatabasemysql::query: 1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'p.product_name asc' @ line 1 sql=select c.* pro25_redshop_category c left join pro25_redshop_category_xref cx on cx.category_child_id=c.category_id c.published = 1 , cx.category_parent_id='211' p.product_name asc
call stack
#   function   location
1   jsite->dispatch()   jroot/index.php:42
2   jcomponenthelper::rendercomponent()   jroot/includes/application.php:197
3   jcomponenthelper::executecomponent()   jroot/libraries/joomla/application/component/helper.php:351
4   require_once()   jroot/libraries/joomla/application/component/helper.php:383
5   jcontroller->execute()   jroot/components/com_redshop/redshop.php:192
6   jcontroller->display()   jroot/libraries/joomla/application/component/controller.php:761
7   categoryviewcategory->display()   jroot/libraries/joomla/application/component/controller.php:722
8   categorymodelcategory->getdata()   jroot/components/com_redshop/views/category/view.html.php:84
9   jmodel->_getlist()   jroot/components/com_redshop/models/category.php:370
10   jdatabase->loadobjectlist()   jroot/libraries/joomla/application/component/model.php:301
11   jdatabasemysql->execute()   jroot/libraries/joomla/database/database.php:1100
12   jerror::raiseerror()   jroot/libraries/joomla/database/database/mysql.php:548
13   jerror::raise()   jroot/libraries/joomla/error/error.php:251


i have notice when created new menu item redshop results in blank page.

j2.5.8
mamp
php 5.3.2

seems missing in query:
where c.published = 1 , cx.category_parent_id='211' order by p.product_name asc





Comments

Post a Comment

Popular posts from this blog

How to change text Component easybook reloaded *newbee* - Joomla! Forum - community, help and support

-
Image
hi all, i started building websites joomla not long ago, can use help.. for got problem guestbook. i have installed easybook. , running on following website http://odoorn321.nl/ (under gastenboek) i want change text: waardering website (is dutch valuate website) waardering. idea rid of word website, because have valuate vacation home, not website. i have made screenshot of text want change. where , how going find css file change text? your appreciated! thanks no one? Board index Joomla! Older Version Support Joomla! 2.5 General Questions/New to Joomla! 2.5
Read more

After Effect warning: A problem occurred when processing OpenGL commands

-
i have after effects cs6 in computer cs5.5 installed. 64bit windows 7 ultimate 20gb memory , 2 amd radeon hd 6900 series display adapters drivers updated hour ago (driver date 27.7.2012, version 8.982.0.0).   when trying use after ecffects, error message " after effect warning: problem occurred when processing opengl commands " when clicking composition window.   what done? not much, i'm afraid. need older graphics driver. other disable second card or play configuration. unfortunately not smart person decided cs6 no longer need manual opengl control user, there's no way suppress within program force-revert software-only modes in case of such issues...   mylenium More discussions in After Effects adobe
Read more

Preconditions Failed. - Joomla! Forum - community, help and support

-
hello! i'm having problem; every time click save&close button, or save button, or close button module; following message appears: "precondition failed the precondition on request url /administrator/index.php evaluated false. additionally, 404 not found error encountered while trying use errordocument handle request." it happens modules. thanks in advance. problem description :: forum post assistant (v1.2.3) : 13th november 2012 wrote: can\'t save changes or close module. log/error message :: forum post assistant (v1.2.3) : 13th november 2012 wrote: precondition failed precondition on request url /administrator/index.php evaluated false. additionally, 404 not found error encountered while trying use errordocument handle request. last php error(s) reported :: forum post assistant (v1.2.3) : 13th november 2012 wrote: [04-mar-2012 01:25:56] php fatal error: call member function get() on non-object in /home/joommmy1/addon/youngstaer/sub/teenace/public_html/templates/...
Read more