Database error 1064 in PO_SelectOSPurchOrder.php The SQL did not produce any requests because you have an error in your SQL syntax; see the manual that corresponds to your MySQL server version for the correct syntax to use around 'ASC, purchorders.realorderno, providers.suppname, purchorde' on line 25
I am running webERP 4.15.2, MySQL Server 8.0.30 Ubuntu 20.04.2 Any ideas on what could be causing this?
RE: Database error 1064 in PO_SelectOSPurchOrder.php
It looks like MySQL 8 has changed GROUP BY syntax to no longer have ASC/DESC qualifiers:
Quote:The deprecated ASC or DESC qualifiers for GROUP BY clauses are removed. Queries that previously relied on GROUP BY sorting may produce results that differ from previous MySQL versions. To produce a given sort order, provide an ORDER BY clause.
RE: Database error 1064 in PO_SelectOSPurchOrder.php
(10-05-2022, 12:03 PM)TurboPT Wrote: It looks like MySQL 8 has changed GROUP BY syntax to no longer have ASC/DESC qualifiers:
Quote:The deprecated ASC or DESC qualifiers for GROUP BY clauses are removed. Queries that previously relied on GROUP BY sorting may produce results that differ from previous MySQL versions. To produce a given sort order, provide an ORDER BY clause.
RE: Database error 1064 in PO_SelectOSPurchOrder.php
at address /var/apache2/ in error.log file I get errorĀ
[Sat Oct 15 10:11:18.705762 2022] [php7:error] [pid 101685] [client 190.104.121.195:2767] PHP Fatal error: Uncaught Error: Call to undefined function simplexml_load_file() in /var/www/html/webERP/PO_PDFPurchOrder.php:196\nStack trace:\n#0 {main}\n thrown in /var/www/html/webERP/PO_PDFPurchOrder. php on line 196, referer: http://44.207.52.199/webERP/PO_PDFPurchO...?OrderNo=1
RE: Database error 1064 in PO_SelectOSPurchOrder.php
My version of php 7.4.3
run command php -m and there was no xml in the output.
run command sudo apt-get install php-xml
again run command php -m and now xml appears in the output.
I try to print the purchase order and again I get an error, the error that the log shows me is the following:
[Sat Oct 15 12:35:57.993542 2022] [php7:error] [pid 101487] [client 190.104.121.195:35513] PHP Fatal error: Uncaught Error: Call to undefined function simplexml_load_file() in /var/www/html/ webERP/PO_PDFPurchOrder.php:196\nStack trace:\n#0 {main}\n thrown in /var/www/html/webERP/PO_PDFPurchOrder.php on line 196, referer: http://44.207.52.199/webERP/ PO_PDFPurchOrder.php?OrderNo=1