Hello,
When i click on product 74 in my site at this url :
index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=74&virtuemart_category_id=5&Itemid=15190&lang=en
or =fr
i have this error :
Syntax error near '' at line 1
...\libraries\joomla\database\driver\mysqli.php:665
660 // The server was not disconnected.
661 else
662 {
663 JLog::add(JText::sprintf('JLIB_DATABASE_QUERY_FAILED', $this->errorNum, $this->errorMsg), JLog::ERROR, 'database-error');
664
665 throw new JDatabaseExceptionExecuting($query, $this->errorMsg, $this->errorNum);
666 }
667 }
668
669 return $this->cursor;
670 }
Thanks for your help.. ;)
System Information
com_virtuemart.3.4.5.10054_package
French and English site
PHP Built On Windows NT INTERNET-PC 10.0 build 17134 (Windows 10) AMD64
Database Type mysql
Database Version 5.7.19
Database Collation utf8mb4_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.14
Web Server Apache/2.4.27 (Win64) PHP/7.2.14
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.9.6 Stable [ Amani ] 7-May-2019 15:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36
A menu system with more than 15000 menu entries ?
Quote&Itemid=15190
Jörgen @ Kreativ Fotografi
error caused by Content - JLexReview Plugin (2.3.9)... 8)
"nice".
Good that you use the new core, so it works for you.
tip
if u add
663 JLog::add(JText::sprintf('JLIB_DATABASE_QUERY_FAILED', $this->errorNum, $this->errorMsg), JLog::ERROR, 'database-error');
664 print 'Debug Line '.__LINE__.' $query <pre>'; print_r ($query); print "</pre><br />\n"; // add to see query
665 throw new JDatabaseExceptionExecuting($query, $this->errorMsg, $this->errorNum);
you can see the full problem query
It is nowadays also enough to enable the joomla debug.