Author Topic: Syntax error near '' at line 1  (Read 11590 times)

extonjaez

  • Jr. Member
  • **
  • Posts: 64
Syntax error near '' at line 1
« 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

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3866
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Syntax error near '' at line 1
« Reply #1 on: May 09, 2019, 22:55:42 pm »
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

  • Jr. Member
  • **
  • Posts: 64
Re: Syntax error near '' at line 1
« Reply #2 on: May 10, 2019, 19:38:33 pm »
error caused by Content - JLexReview Plugin (2.3.9)... 8)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10273
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Syntax error near '' at line 1
« Reply #3 on: May 11, 2019, 22:40:14 pm »
"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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10451
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Syntax error near '' at line 1
« Reply #4 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10273
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Syntax error near '' at line 1
« Reply #5 on: May 13, 2019, 08:42:38 am »
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/