while trying to make a new group for the application system, I encountered an error after trying to submit the group. It was obviously a database error, in the spoiler it contains the MySql log, any help is very much appreciated!
Spoiler
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 31 Aug 2014 14:18:02 +0000
Error: 1364 - Field 'moderators' doesn't have a default value
IP Address: 192.168.1.1 - /forums/admin/index.php?adsess=530e8b8a60d4ba2b04c73b88e8624167&app=groupjoin&module=settings§ion=settings&do=add_group
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forumsgroupjoin_freespots (`group_id`,`spots`,`unlimitedSpots`,`action_performed`,`norep`,`enabled`,`start_date`,`end_date`,`age`,`warn`,`noWarn`,`posts`,`days`,`last_warn`,`mod_queue`,`rep`,`reqIsTopic`,`reqIsPost`,`group_req`,`group_visit`,`commentsOn`,`mod_notes`,`promote`,`customText`,`default_status`,`jump_group`,`enable_support`,`group_image`,`group_position`) VALUES(10,'',1,'a:1:{s:8:\"comments\";a:2:{s:9:\"member_id\";s:1:\"1\";s:4:\"time\";i:1409494682;}}',1,'',1406854800,'',16,0,1,100,0,0,0,'','','','a:2:{i:0;s:2:\"15\";i:1;s:2:\"16\";}','a:2:{i:0;s:1:\"4\";i:1;s:1:\"8\";}','a:3:{s:6:\"enable\";N;s:6:\"whoCan\";N;s:9:\"toApprove\";N;}',0,0,'',2,0,0,'',1)
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [db_main_mysql].insert | 262 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].updateDB | 925 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].validateGroups | 95 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [admin_groupjoin_settings_settings].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 31 Aug 2014 14:18:17 +0000
Error: 1364 - Field 'moderators' doesn't have a default value
IP Address: 192.168.1.1 - /forums/admin/index.php?adsess=530e8b8a60d4ba2b04c73b88e8624167&app=groupjoin&module=settings§ion=settings&do=add_group
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forumsgroupjoin_freespots (`group_id`,`spots`,`unlimitedSpots`,`action_performed`,`norep`,`enabled`,`start_date`,`end_date`,`age`,`warn`,`noWarn`,`posts`,`days`,`last_warn`,`mod_queue`,`rep`,`reqIsTopic`,`reqIsPost`,`group_req`,`group_visit`,`commentsOn`,`mod_notes`,`promote`,`customText`,`default_status`,`jump_group`,`enable_support`,`group_image`,`group_position`) VALUES(10,'',1,'a:1:{s:8:\"comments\";a:2:{s:9:\"member_id\";s:1:\"1\";s:4:\"time\";i:1409494697;}}',1,'',1406854800,'',16,0,1,100,0,0,0,'','','','a:2:{i:0;s:2:\"15\";i:1;s:2:\"16\";}','a:2:{i:0;s:1:\"4\";i:1;s:1:\"8\";}','a:3:{s:6:\"enable\";N;s:6:\"whoCan\";N;s:9:\"toApprove\";N;}',0,0,'',2,0,0,'',1)
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [db_main_mysql].insert | 262 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].updateDB | 925 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].validateGroups | 95 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [admin_groupjoin_settings_settings].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 31 Aug 2014 14:18:02 +0000
Error: 1364 - Field 'moderators' doesn't have a default value
IP Address: 192.168.1.1 - /forums/admin/index.php?adsess=530e8b8a60d4ba2b04c73b88e8624167&app=groupjoin&module=settings§ion=settings&do=add_group
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forumsgroupjoin_freespots (`group_id`,`spots`,`unlimitedSpots`,`action_performed`,`norep`,`enabled`,`start_date`,`end_date`,`age`,`warn`,`noWarn`,`posts`,`days`,`last_warn`,`mod_queue`,`rep`,`reqIsTopic`,`reqIsPost`,`group_req`,`group_visit`,`commentsOn`,`mod_notes`,`promote`,`customText`,`default_status`,`jump_group`,`enable_support`,`group_image`,`group_position`) VALUES(10,'',1,'a:1:{s:8:\"comments\";a:2:{s:9:\"member_id\";s:1:\"1\";s:4:\"time\";i:1409494682;}}',1,'',1406854800,'',16,0,1,100,0,0,0,'','','','a:2:{i:0;s:2:\"15\";i:1;s:2:\"16\";}','a:2:{i:0;s:1:\"4\";i:1;s:1:\"8\";}','a:3:{s:6:\"enable\";N;s:6:\"whoCan\";N;s:9:\"toApprove\";N;}',0,0,'',2,0,0,'',1)
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [db_main_mysql].insert | 262 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].updateDB | 925 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].validateGroups | 95 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [admin_groupjoin_settings_settings].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 31 Aug 2014 14:18:17 +0000
Error: 1364 - Field 'moderators' doesn't have a default value
IP Address: 192.168.1.1 - /forums/admin/index.php?adsess=530e8b8a60d4ba2b04c73b88e8624167&app=groupjoin&module=settings§ion=settings&do=add_group
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forumsgroupjoin_freespots (`group_id`,`spots`,`unlimitedSpots`,`action_performed`,`norep`,`enabled`,`start_date`,`end_date`,`age`,`warn`,`noWarn`,`posts`,`days`,`last_warn`,`mod_queue`,`rep`,`reqIsTopic`,`reqIsPost`,`group_req`,`group_visit`,`commentsOn`,`mod_notes`,`promote`,`customText`,`default_status`,`jump_group`,`enable_support`,`group_image`,`group_position`) VALUES(10,'',1,'a:1:{s:8:\"comments\";a:2:{s:9:\"member_id\";s:1:\"1\";s:4:\"time\";i:1409494697;}}',1,'',1406854800,'',16,0,1,100,0,0,0,'','','','a:2:{i:0;s:2:\"15\";i:1;s:2:\"16\";}','a:2:{i:0;s:1:\"4\";i:1;s:1:\"8\";}','a:3:{s:6:\"enable\";N;s:6:\"whoCan\";N;s:9:\"toApprove\";N;}',0,0,'',2,0,0,'',1)
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [db_main_mysql].insert | 262 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].updateDB | 925 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/groupjoin/modules_admin/settings/settings.php| [admin_groupjoin_settings_settings].validateGroups | 95 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [admin_groupjoin_settings_settings].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
0 commentaires:
Enregistrer un commentaire