zzzzsys_php issue
Posted: Mon Nov 19, 2018 1:23 am
Hi Steven,
I keep getting these entries in the nuDebug.
sph_system is varchar(1) field, but the SQL ' WHERE sph_system != 1' is treating it as a number.
pasting this in phpmyadmin generates the same error
if i alter to
it successfully runs the query
Andrew
I keep getting these entries in the nuDebug.
Code: Select all
===PDO MESSAGE===
SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: ''
===SQL===========
CREATE TABLE ___nu15bf1f23c162db___ SELECT zzzzsys_php_id AS theid FROM zzzzsys_php WHERE sph_system != 1
===BACK TRACE====pasting this in phpmyadmin generates the same error
if i alter to
Code: Select all
CREATE TABLE ___nu15bf1f23c162db___ SELECT zzzzsys_php_id AS theid FROM zzzzsys_php WHERE sph_system != '1'Andrew