VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: extonjaez on May 09, 2019, 20:44:37 PM

Title: Syntax error near '' at line 1
Post by: extonjaez on May 09, 2019, 20:44:37 PM
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
Title: Re: Syntax error near '' at line 1
Post by: Jörgen on May 09, 2019, 22:55:42 PM
A menu system with more than 15000 menu entries ?

Quote&Itemid=15190

Jörgen @ Kreativ Fotografi
Title: Re: Syntax error near '' at line 1
Post by: extonjaez on May 10, 2019, 19:38:33 PM
error caused by Content - JLexReview Plugin (2.3.9)... 8)
Title: Re: Syntax error near '' at line 1
Post by: Milbo on May 11, 2019, 22:40:14 PM
"nice".
Good that you use the new core, so it works for you.
Title: Re: Syntax error near '' at line 1
Post by: GJC Web Design on May 12, 2019, 10:33:25 AM
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
Title: Re: Syntax error near '' at line 1
Post by: Milbo on May 13, 2019, 08:42:38 AM
It is nowadays also enough to enable the joomla debug.