Hi there. Thanks again for your help here!
This is what I'm getting from my var_dump's (there's probably more there now than when I first posted):
C:\xampp\htdocs\includes\php\classes\DbConnection.php (at line: 145)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:146:string 'SELECT count(*) FROM Pallet_Production WHERE ID > 165062 AND ID < 167057;' (length=73)
(this->sql ln: 146)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:148:
array (size=3)
0 => string '00000' (length=5)
1 => null
2 => null
(this->errorInfo: 148)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:152:
object(PDOStatement)[4]
public 'queryString' => string 'SELECT count(*) FROM Pallet_Production WHERE ID > 165062 AND ID < 167057;' (length=73)
(vdtemp ln: 152)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:153:
object(PDOStatement)[4]
public 'queryString' => string 'SELECT count(*) FROM Pallet_Production WHERE ID > 165062 AND ID < 167057;' (length=73)
(pdostmt ln: 153)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:154:
array (size=0)
empty
(this->bind ln: 154)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:157:
array (size=0)
empty
(this->bind ln: 157)
I added your recommended var_dump where it reads (this->errorInfo: 148)
Note: I did get this working when I set it up on my local development server. The update query is successful. Same DB's, etc (basically, aside from being truncated). That was using xampp (Windows 11). One database is MS Access .mdb, and the other is MySQL. I can't see what's different here, aside from that their MySQL DB is "remote" on a Linux server, and mine is local under Xampp. but, the php code is the same (sans a few var_dump and comments, etc).
EDIT: i see there's more/ different output after I submit the REQUEST to update the table:
(this->bind ln: 173)
C:\xampp\htdocs\includes\php\classes\DbConnection.php (at line: 145)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:146:string 'DESCRIBE Pallet_Production;' (length=27)
(this->sql ln: 146)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:148:
array (size=3)
0 => string '00000' (length=5)
1 => null
2 => null
(this->errorInfo: 148)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:152:
object(PDOStatement)[4]
public 'queryString' => string 'DESCRIBE Pallet_Production;' (length=27)
(vdtemp ln: 152)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:153:
object(PDOStatement)[4]
public 'queryString' => string 'DESCRIBE Pallet_Production;' (length=27)
(pdostmt ln: 153)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:154:
array (size=0)
empty
(this->bind ln: 154)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:157:
array (size=0)
empty
(this->bind ln: 157)
C:\xampp\htdocs\includes\php\classes\DbConnection.php (at line: 145)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:146:string 'INSERT INTO Pallet_Production (ID, Pallet_Tag_Number, Date_Printed, Time_Printed, Pack_Date, PackDate_Code, Quantity, Commodity, Pack_Location, Storage_Location, Storage_Room_No, Variety, Lid_Label, Size, Grade, Ship_Status, Date_Shipped, Time_Shipped, Qty_Shipped) VALUES (:ID, :Pallet_Tag_Number, :Date_Printed, :Time_Printed, :Pack_Date, :PackDate_Code, :Quantity, :Commodity, :Pack_Location, :Storage_Location, :Storage_Room_No, :Variety, :Lid_Label, :Size, :Grade, :Ship_Status, :Date_Shipped, :Time_Shipped'... (length=528)
(this->sql ln: 146)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:148:
array (size=3)
0 => string '00000' (length=5)
1 => null
2 => null
(this->errorInfo: 148)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:152:
object(PDOStatement)[4]
public 'queryString' => string 'INSERT INTO Pallet_Production (ID, Pallet_Tag_Number, Date_Printed, Time_Printed, Pack_Date, PackDate_Code, Quantity, Commodity, Pack_Location, Storage_Location, Storage_Room_No, Variety, Lid_Label, Size, Grade, Ship_Status, Date_Shipped, Time_Shipped, Qty_Shipped) VALUES (:ID, :Pallet_Tag_Number, :Date_Printed, :Time_Printed, :Pack_Date, :PackDate_Code, :Quantity, :Commodity, :Pack_Location, :Storage_Location, :Storage_Room_No, :Variety, :Lid_Label, :Size, :Grade, :Ship_Status, :Date_Shipped, :Time_Shipped'... (length=528)
(vdtemp ln: 152)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:153:
object(PDOStatement)[4]
public 'queryString' => string 'INSERT INTO Pallet_Production (ID, Pallet_Tag_Number, Date_Printed, Time_Printed, Pack_Date, PackDate_Code, Quantity, Commodity, Pack_Location, Storage_Location, Storage_Room_No, Variety, Lid_Label, Size, Grade, Ship_Status, Date_Shipped, Time_Shipped, Qty_Shipped) VALUES (:ID, :Pallet_Tag_Number, :Date_Printed, :Time_Printed, :Pack_Date, :PackDate_Code, :Quantity, :Commodity, :Pack_Location, :Storage_Location, :Storage_Room_No, :Variety, :Lid_Label, :Size, :Grade, :Ship_Status, :Date_Shipped, :Time_Shipped'... (length=528)
(pdostmt ln: 153)
C:\xampp\htdocs\includes\php\classes\DbConnection.php:154:
array (size=19)
':ID' => string '165357' (length=6)
':Pallet_Tag_Number' => string '22020015' (length=8)
':Date_Printed' => string '2022-07-21 00:00:00' (length=19)
':Time_Printed' => string '09:09:33' (length=8)
':Pack_Date' => string '2022-07-21 00:00:00' (length=19)
':PackDate_Code' => string '202-01' (length=6)
':Quantity' => string '42' (length=2)
':Commodity' => string 'APPLES' (length=6)
':Pack_Location' => string '_redacted_ Cold Storage' (length=19)
':Storage_Location' => string 'PCS HIGHLAND REF. ROOMS' (length=23)
':Storage_Room_No' => string 'R01' (length=3)
':Variety' => string 'DELICIOUS RED' (length=13)
':Lid_Label' => string 'S/R B&B' (length=8)
':Size' => string '3 lb' (length=4)
':Grade' => string 'US EXTRA FANCY' (length=14)
':Ship_Status' => string 'N' (length=1)
':Date_Shipped' => null
':Time_Shipped' => null
':Qty_Shipped' => string '0' (length=1)
(this->bind ln: 154)
( ! ) Warning: PDOStatement::execute(): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'R01' for column `_redacted_`.`Pallet_Production`.`Storage_Room_No` at row 1 in C:\xampp\htdocs\includes\php\classes\DbConnection.php on line 156
C:\xampp\htdocs\includes\php\classes\DbConnection.php:173:
array (size=19)
':ID' => string '165357' (length=6)
':Pallet_Tag_Number' => string '22020015' (length=8)
':Date_Printed' => string '2022-07-21 00:00:00' (length=19)
':Time_Printed' => string '09:09:33' (length=8)
':Pack_Date' => string '2022-07-21 00:00:00' (length=19)
':PackDate_Code' => string '202-01' (length=6)
':Quantity' => string '42' (length=2)
':Commodity' => string 'APPLES' (length=6)
':Pack_Location' => string '_redacted_ Cold Storage' (length=19)
':Storage_Location' => string 'PCS HIGHLAND REF. ROOMS' (length=23)
':Storage_Room_No' => string 'R01' (length=3)
':Variety' => string 'DELICIOUS RED' (length=13)
':Lid_Label' => string 'S/R B&B' (length=8)
':Size' => string '3 lb' (length=4)
':Grade' => string 'US EXTRA FANCY' (length=14)
':Ship_Status' => string 'N' (length=1)
':Date_Shipped' => null
':Time_Shipped' => null
':Qty_Shipped' => string '0' (length=1)
(this->bind ln: 173)
Looks like the (this->errorInfo: 148)
is now related to the DESCRIBE statement? or, is it the this->sql? i don't normally debug like this. am I correct that the line 148 var_dump(_this->error) is RE: the array (size=3)
0 => string '00000' (length=5)
line, and NOT below at C:\xampp\htdocs\includes\php\classes\DbConnection.php:152:
object(PDOStatement)[4]
public 'queryString' => string 'INSERT INTO Pallet_ ...
?
EDIT: I see they're running php 5 on their remote development server, so that's one major difference:
PHP Version 5.6.40-60+0~20220627.67+debian10~1.gbp1f7ffd