News:

Looking for documentation? Take a look on our wiki

Main Menu

Syntax error near '' at line 1

Started by extonjaez, May 09, 2019, 20:44:37 PM

Previous topic - Next topic

extonjaez

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

Jörgen

#1
A menu system with more than 15000 menu entries ?

Quote&Itemid=15190

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

extonjaez

#2
error caused by Content - JLexReview Plugin (2.3.9)... 8)

Milbo

"nice".
Good that you use the new core, so it works for you.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Milbo

It is nowadays also enough to enable the joomla debug.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/