Вот примеры
При добавлении в gps трекере, действия.
Код: Выделить всё
Error
Details
http://192.168.1.125/admin.php?pd=cGFuZWw6e2FjdGlvbj1hcHBfZ3BzdHJhY2t9pz_&md=app_gpstrack&inst=adm&
1366: Incorrect integer value: '' for column 'SCRIPT_ID' at row 1
INSERT INTO `gpsactions`(`LOCATION_ID`, `USER_ID`, `ACTION_TYPE`, `SCRIPT_ID`, `CODE`) VALUES('6', '1', '1', '', '')
Backtrace
#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('1366: Incorrect...', 0)
#1 /var/www/lib/mysqli.class.php(185): mysql->Error('INSERT INTO `gp...', 0)
#2 /var/www/lib/mysqli.class.php(329): mysql->Exec('INSERT INTO `gp...')
#3 /var/www/lib/sqlFunctions.class.php(111): mysql->Insert('gpsactions', Array)
#4 /var/www/modules/app_gpstrack/gpsactions_edit.inc.php(55): SQLInsert('gpsactions', Array)
#5 /var/www/modules/app_gpstrack/app_gpstrack.class.php(338): require('/var/www/module...')
#6 /var/www/modules/app_gpstrack/app_gpstrack.class.php(222): app_gpstrack->edit_gpsactions(Array, '')
#7 /var/www/modules/app_gpstrack/app_gpstrack.class.php(100): app_gpstrack->admin(Array)
#8 /var/www/lib/jTemplate.class.php(713) : eval()'d code(8): app_gpstrack->run()
#9 /var/www/lib/jTemplate.class.php(713): eval()
#10 /var/www/lib/jTemplate.class.php(195): jTemplate->parseModules('...', Array, './templates/')
#11 /var/www/lib/jTemplate.class.php(109): jTemplate->parse('...', Array, './templates/')
#12 /var/www/lib/parser.class.php(93): jTemplate->__construct('./templates/pan...', Array, Object(panel))
#13 /var/www/lib/parser.class.php(63): parser->jtemplate_parse('./templates/pan...', Array)
#14 /var/www/modules/panel.class.php(180): parser->__construct('./templates/pan...', Array, Object(panel))
#15 /var/www/admin.php(34): panel->run()
#16 {main}
Error
Details
http://192.168.1.125/admin.php?pd=cGFuZWw6e2FjdGlvbj1hcHBfZ3BzdHJhY2t9pz_&md=app_gpstrack&inst=adm&
1366: Incorrect integer value: '' for column 'SCRIPT_ID' at row 1
INSERT INTO `gpsactions`(`LOCATION_ID`, `USER_ID`, `ACTION_TYPE`, `SCRIPT_ID`, `CODE`) VALUES('6', '1', '1', '', '')
Backtrace
#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('1366: Incorrect...', 0)
#1 /var/www/lib/mysqli.class.php(331): mysql->Error('INSERT INTO `gp...')
#2 /var/www/lib/sqlFunctions.class.php(111): mysql->Insert('gpsactions', Array)
#3 /var/www/modules/app_gpstrack/gpsactions_edit.inc.php(55): SQLInsert('gpsactions', Array)
#4 /var/www/modules/app_gpstrack/app_gpstrack.class.php(338): require('/var/www/module...')
#5 /var/www/modules/app_gpstrack/app_gpstrack.class.php(222): app_gpstrack->edit_gpsactions(Array, '')
#6 /var/www/modules/app_gpstrack/app_gpstrack.class.php(100): app_gpstrack->admin(Array)
#7 /var/www/lib/jTemplate.class.php(713) : eval()'d code(8): app_gpstrack->run()
#8 /var/www/lib/jTemplate.class.php(713): eval()
#9 /var/www/lib/jTemplate.class.php(195): jTemplate->parseModules('...', Array, './templates/')
#10 /var/www/lib/jTemplate.class.php(109): jTemplate->parse('...', Array, './templates/')
#11 /var/www/lib/parser.class.php(93): jTemplate->__construct('./templates/pan...', Array, Object(panel))
#12 /var/www/lib/parser.class.php(63): parser->jtemplate_parse('./templates/pan...', Array)
#13 /var/www/modules/panel.class.php(180): parser->__construct('./templates/pan...', Array, Object(panel))
#14 /var/www/admin.php(34): panel->run()
#15 {main}
Код: Выделить всё
Error
Details
http://192.168.1.125/admin.php?pd=cGFuZWw6e2FjdGlvbj10ZXJtaW5hbHN9pz_&md=terminals&inst=adm&
1048: Column 'CANTTS' cannot be null
UPDATE `terminals` SET `ID`='4', `NAME`='Xiaomi RMN3PP', `TITLE`='Xiaomi RMN3PP', `HOST`='192.168.1.113', `CANPLAY`='1', `PLAYER_TYPE`='majordroid', `PLAYER_PORT`='', `PLAYER_USERNAME`='', `PLAYER_PASSWORD`='', `IS_ONLINE`='0', `MAJORDROID_API`='1', `LATEST_REQUEST`='Где находится гидра', `LATEST_REQUEST_TIME`='2018-09-10 23:20:09', `LATEST_ACTIVITY`='2018-10-13 09:23:40', `LINKED_OBJECT`='', `LEVEL_LINKED_PROPERTY`='', `PLAYER_CONTROL_ADDRESS`='', `CANTTS`=NULL, `MIN_MSG_LEVEL`='1' WHERE ID = '4'
Backtrace
#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('1048: Column 'C...', 0)
#1 /var/www/lib/mysqli.class.php(185): mysql->Error('UPDATE `termina...', 0)
#2 /var/www/lib/mysqli.class.php(294): mysql->Exec('UPDATE `termina...')
#3 /var/www/lib/sqlFunctions.class.php(129): mysql->Update('terminals', Array, 'ID')
#4 /var/www/modules/terminals/terminals_edit.inc.php(57): SQLUpdate('terminals', Array)
#5 /var/www/modules/terminals/terminals.class.php(177): require('/var/www/module...')
#6 /var/www/modules/terminals/terminals.class.php(139): terminals->edit_terminals(Array, '4')
#7 /var/www/modules/terminals/terminals.class.php(99): terminals->admin(Array)
#8 /var/www/lib/jTemplate.class.php(713) : eval()'d code(8): terminals->run()
#9 /var/www/lib/jTemplate.class.php(713): eval()
#10 /var/www/lib/jTemplate.class.php(195): jTemplate->parseModules('...', Array, './templates/')
#11 /var/www/lib/jTemplate.class.php(109): jTemplate->parse('...', Array, './templates/')
#12 /var/www/lib/parser.class.php(93): jTemplate->__construct('./templates/pan...', Array, Object(panel))
#13 /var/www/lib/parser.class.php(63): parser->jtemplate_parse('./templates/pan...', Array)
#14 /var/www/modules/panel.class.php(180): parser->__construct('./templates/pan...', Array, Object(panel))
#15 /var/www/admin.php(34): panel->run()
#16 {main}
Error
Details
http://192.168.1.125/admin.php?pd=cGFuZWw6e2FjdGlvbj10ZXJtaW5hbHN9pz_&md=terminals&inst=adm&
1048: Column 'CANTTS' cannot be null
UPDATE `terminals` SET `ID`='4', `NAME`='Xiaomi RMN3PP', `TITLE`='Xiaomi RMN3PP', `HOST`='192.168.1.113', `CANPLAY`='1', `PLAYER_TYPE`='majordroid', `PLAYER_PORT`='', `PLAYER_USERNAME`='', `PLAYER_PASSWORD`='', `IS_ONLINE`='0', `MAJORDROID_API`='1', `LATEST_REQUEST`='Где находится гидра', `LATEST_REQUEST_TIME`='2018-09-10 23:20:09', `LATEST_ACTIVITY`='2018-10-13 09:23:40', `LINKED_OBJECT`='', `LEVEL_LINKED_PROPERTY`='', `PLAYER_CONTROL_ADDRESS`='', `CANTTS`=NULL, `MIN_MSG_LEVEL`='1' WHERE ID = '4'
Backtrace
#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('1048: Column 'C...', 0)
#1 /var/www/lib/mysqli.class.php(296): mysql->Error('UPDATE `termina...')
#2 /var/www/lib/sqlFunctions.class.php(129): mysql->Update('terminals', Array, 'ID')
#3 /var/www/modules/terminals/terminals_edit.inc.php(57): SQLUpdate('terminals', Array)
#4 /var/www/modules/terminals/terminals.class.php(177): require('/var/www/module...')
#5 /var/www/modules/terminals/terminals.class.php(139): terminals->edit_terminals(Array, '4')
#6 /var/www/modules/terminals/terminals.class.php(99): terminals->admin(Array)
#7 /var/www/lib/jTemplate.class.php(713) : eval()'d code(8): terminals->run()
#8 /var/www/lib/jTemplate.class.php(713): eval()
#9 /var/www/lib/jTemplate.class.php(195): jTemplate->parseModules('...', Array, './templates/')
#10 /var/www/lib/jTemplate.class.php(109): jTemplate->parse('...', Array, './templates/')
#11 /var/www/lib/parser.class.php(93): jTemplate->__construct('./templates/pan...', Array, Object(panel))
#12 /var/www/lib/parser.class.php(63): parser->jtemplate_parse('./templates/pan...', Array)
#13 /var/www/modules/panel.class.php(180): parser->__construct('./templates/pan...', Array, Object(panel))
#14 /var/www/admin.php(34): panel->run()
#15 {main}