Hello,

I've a big problem with the newest update:

Web Interface System Information
Version number   3.2.10.20170712.stable-517r4026
Build date   2017-07-12

The problem happens, when i setup a new account:

SQL Error: Could not execute query in /usr/local/centovacast/system/class_AccountControl.php:134
Query:    INSERT INTO accounts (`ignoremeta`,`username`,`hostname`,`ipaddress`,`port`,`maxclients`,`transferlimit`,`diskquota`,`noxferlimit`,`nodiskquota`,`allowproxy`,`rawconfig`,`mountlimit`,`quotaexceed`,`xferexceed`,`channels`,`samplerate`,`crossfade`,`maxbitrate`,`genre`,`recenttracks`,`timezone`,`charset`,`locale`,`url`,`useserver`,`nextsongdebug`,`webplayer`,`requestprobability`,`requestdelay`,`autoqueuerequests`,`emailunknownrequests`,`title`,`email`,`usesource`,`royaltymode`,`autorebuildlist`,`randomplaylist`,`usestartpage`,`allowrequests`,`allowondemand`,`allowrecent`,`allowgmaps`,`organization`,`songlengthlimit`,`rpchostid`,`adspriority`,`extraports`,`customvalues`,`status`,`servertype`,`parentresellerid`,`password`,`expectedstate`,`secret`,`reseller`) VALUES ('','tutorial','example.com','51.255.104.137','8109','10','0','1024','1','0','1','0','0','auto','auto','2','44100','0','320','Tutorial Genre','5','127','ISO-8859-1','','','1','0','musessc1','50','30','1','1','Tutorial Stream','office@cityedv.at','0','0','1','1','1','1','1','1','1','','0','1','custom,embedded,folder,itunes,!amazon,!lastfm','','','enabled','ShoutCast','0','$2y$10$EZRZAwfr3FV0vHjAfdsEW.EnBvDqtlBDHLzuD0FXd7ycnNtwkQcpG','down',"08d13cc71e39fdbbdf017f745cd1b27f",0)
Error:   Field 'statuscache' doesn't have a default value
Call:   $SQL->insert_query()SQL Error: Could not execute query in /usr/local/centovacast/system/class_AccountControl.php:134
Query:    INSERT INTO accounts (`ignoremeta`,`username`,`hostname`,`ipaddress`,`port`,`maxclients`,`transferlimit`,`diskquota`,`noxferlimit`,`nodiskquota`,`allowproxy`,`rawconfig`,`mountlimit`,`quotaexceed`,`xferexceed`,`channels`,`samplerate`,`crossfade`,`maxbitrate`,`genre`,`recenttracks`,`timezone`,`charset`,`locale`,`url`,`useserver`,`nextsongdebug`,`webplayer`,`requestprobability`,`requestdelay`,`autoqueuerequests`,`emailunknownrequests`,`title`,`email`,`usesource`,`royaltymode`,`autorebuildlist`,`randomplaylist`,`usestartpage`,`allowrequests`,`allowondemand`,`allowrecent`,`allowgmaps`,`organization`,`songlengthlimit`,`rpchostid`,`adspriority`,`extraports`,`customvalues`,`status`,`servertype`,`parentresellerid`,`password`,`expectedstate`,`secret`,`reseller`) VALUES ('','tutorial','example.com','51.255.104.137','8109','10','0','1024','1','0','1','0','0','auto','auto','2','44100','0','320','Tutorial Genre','5','127','ISO-8859-1','','','1','0','musessc1','50','30','1','1','Tutorial Stream','office@cityedv.at','0','0','1','1','1','1','1','1','1','','0','1','custom,embedded,folder,itunes,!amazon,!lastfm','','','enabled','ShoutCast','0','$2y$10$EZRZAwfr3FV0vHjAfdsEW.EnBvDqtlBDHLzuD0FXd7ycnNtwkQcpG','down',"08d13cc71e39fdbbdf017f745cd1b27f",0)
Error:   Field 'statuscache' doesn't have a default value
Call:   $SQL->insert_query()

Is this already known? What can i do? Is a fixed update planned in very near future?

Best regards,
Jürgen

Hello cityedvlinz,

Thank you for reporting this issue, it should be fixed on our next release.

Unfortunately in the meantime, the only way to work around this issue would be to disable strict_trans_tables for your database server.

Would you need help doing that, feel free to open a ticket to our support department.

Hello,

Many thanks for your help...

When will the next release be?

Should "disable strict_trans_tables" activated after the fix, what is the (negative) effect of this work around?

Best regards,
Jürgen

  . I have the same problem after updating to  Version number   3.2.10.20170712.stable-517r4026

SQL Error: Could not execute query in /usr/local/centovacast/system/class_AccountControl.php:134

Error:   Field 'statuscache' doesn't have a default value

A patch has been release to fix this issues.

Anybody affected should run "/usr/local/centovacast/sbin/update" to get the latest hotfix.

Hey!

Many thanks for the quick fix release. 

Best regards,
Jürgen