Centova Technologies Forum

Centova Cast v3 => Bugs and issues => Topic started by: cityedvlinz on July 21, 2017, 05:25:44 pm

Title: SQL-Error @ Create new account (Version 3.2.10.20170712.stable-517r4026)
Post by: cityedvlinz on July 21, 2017, 05:25:44 pm

Hello,

I've a big problem with the newest update:

Quote

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:

Quote

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

Title: Re: SQL-Error @ Create new account (Version 3.2.10.20170712.stable-517r4026)
Post by: Roger on July 21, 2017, 07:26:21 pm

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.

Title: Re: SQL-Error @ Create new account (Version 3.2.10.20170712.stable-517r4026)
Post by: cityedvlinz on July 25, 2017, 06:20:05 am

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

Title: Re: SQL-Error @ Create new account (Version 3.2.10.20170712.stable-517r4026)
Post by: javier on July 25, 2017, 12:12:47 pm

 >:( . 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

Title: Re: SQL-Error @ Create new account (Version 3.2.10.20170712.stable-517r4026)
Post by: Roger on July 25, 2017, 02:59:29 pm

A patch has been release to fix this issues.

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

Title: Re: SQL-Error @ Create new account (Version 3.2.10.20170712.stable-517r4026)
Post by: cityedvlinz on July 25, 2017, 03:47:33 pm

Hey!

Many thanks for the quick fix release.  8)

Best regards,
Jürgen