The following exception has occurred:
Exception:
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 'and p.productNumber like 'be-36-1-ss-np'' at line 1 (error number: 1064)
SQL query: select p.id as prodID from ProductCategoryProducts pcp, Product p where pcp.productID = p.id and pcp.categoryID = and p.productNumber like 'be-36-1-ss-np'
Connection: bhs@localhost/bhs_admin
FILE: /var/www/vhosts/bhs1.com/grunt/lib/DB.php LINE: 521 BACKTRACE: #1: error() in /var/www/vhosts/bhs1.com/grunt/lib/DB.php on line 449 #2: query() in /var/www/vhosts/bhs1.com/apps/products/views/main.php on line 290 #3: getProductID() in /var/www/vhosts/bhs1.com/apps/products/views/main.php on line 434 #4: product() #5: call_user_func() in /var/www/vhosts/bhs1.com/grunt/lib/ViewResponder.php on line 109 #6: getResponse() in /var/www/vhosts/bhs1.com/grunt/lib/ViewResponder.php on line 188 #7: getResponse() in /var/www/vhosts/bhs1.com/grunt/lib/Application.php on line 982 #8: start() in /var/www/vhosts/bhs1.com/apps/products/app.php on line 16 #9: require_once() in /var/www/vhosts/bhs1.com/httpdocs/products.php on line 2 PHP INCLUDE PATH: .:/usr/share/pear:/usr/share/php:/var/www/vhosts/bhs1.com/:/var/www/vhosts/bhs1.com/apps/products/
$_GET |
array ( ) |
$_POST |
array ( ) |
$_SERVER |
array ( 'REDIRECT_STATUS' => '200', 'HTTP_X_CC_ID' => 'ccc01-01', 'HTTP_HOST' => 'www.bhs1.com', 'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5', 'HTTP_ACCEPT_LANGUAGE' => 'en-us,en;q=0.5', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_ACCEPT_CHARSET' => 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_CONNECTION' => 'close', 'HTTP_CACHE_CONTROL' => 'no-cache', 'HTTP_PRAGMA' => 'no-cache', 'PATH' => '/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin', 'SERVER_SIGNATURE' => 'Apache/2.0.52 (CentOS) Server at www.bhs1.com Port 80 ', 'SERVER_SOFTWARE' => 'Apache/2.0.52 (CentOS)', 'SERVER_NAME' => 'www.bhs1.com', 'SERVER_ADDR' => '72.47.212.32', 'SERVER_PORT' => '80', 'REMOTE_ADDR' => '38.107.191.82', 'DOCUMENT_ROOT' => '/var/www/vhosts/bhs1.com/httpdocs', 'SERVER_ADMIN' => 'root@localhost', 'SCRIPT_FILENAME' => '/var/www/vhosts/bhs1.com/httpdocs/products.php', 'REMOTE_PORT' => '61198', 'REDIRECT_URL' => '/products/batteryextractors/product/be-36-1-ss-np/', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'REQUEST_URI' => '/products/batteryextractors/product/be-36-1-ss-np/', 'SCRIPT_NAME' => '/products.php', 'PATH_INFO' => '/batteryextractors/product/be-36-1-ss-np/', 'PATH_TRANSLATED' => '/var/www/vhosts/bhs1.com/httpdocs/batteryextractors/product/be-36-1-ss-np/', 'PHP_SELF' => '/products.php/batteryextractors/product/be-36-1-ss-np/', 'REQUEST_TIME' => 1284091528, ) |
PHP Version |
5.2.11 |
Operating Env. |
Linux cs2.pnmg.com 2.6.9-023stab048.6-enterprise #1 SMP Mon Nov 17 19:09:18 MSK 2008 i686 |
Error message generated by Grunt.
09/09/2010 23:05:29