zzzzsys_php issue

[alf1976]

Hi Steven,

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====

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

Code: Select all

CREATE TABLE ___nu15bf1f23c162db___ SELECT zzzzsys_php_id AS theid FROM zzzzsys_php WHERE sph_system != '1'

it successfully runs the query


Andrew

[admin]

Andrew,

Try the latest from Github (updated today) and run the Update Button.


Steven