Hello,
Somewhere along the line when SC updated its code I started to get the following error…
(mysqlt): SELECT COUNT() FROM tb_docs WHERE linkID =
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
ADOConnection._Execute(SELECT COUNT() FROM tb_docs WHERE linkID = , false) % line 1085, file: adodb.inc.php
ADOConnection.Execute(SELECT COUNT(*) FROM tb_docs WHERE linkID = ) % line 5528, file: form_tb_byob_orders_apl.php
form_tb_byob_orders_apl.ValidateField_documents(null, Array[15], Array[15]) % line 3040, file: form_tb_byob_orders_apl.php
form_tb_byob_orders_apl.Valida_campos(null, Array[15], Array[15]) % line 2057, file: form_tb_byob_orders_apl.php
form_tb_byob_orders_apl.controle() % line 2140, file: index.php
Error Close
Error inserting:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
View SQL
Script: C:inetpubwwwrootscriptcase8appBYOB_Order_Apporm_tb_byob_ordersorm_tb_byob_orders_apl.php (5531)
It has something to do with the multi upload i have.
When I remove the multi upload I can save a “New Record” with no issues but as soon as I add it back in I get the error.
It used to work fine but now the error.
The Multi-Upload is setup as the image below shows…
MySql Table for the Multi-Upload is as below…
Any help is greatly appreciated.
