Error:

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 ('','testucartz','example.com','217.182.197.124','auto','100','1500','1000','0','0','0','0','0','auto','auto','2','44100','5','128','Unspecified','5','127','ISO-8859-1','','http://example.com','1','0','muses','50','30','1','1','SampleStream','testucartz@ucartz.com','1','0','1','1','1','1','1','1','1','','0','1','custom,embedded,folder,itunes,!lastfm,!amazon','','','enabled','ShoutCast2','0','$2y$10$IqLIrxN.0kjh0lPQ19HvG.B6VFqVr/LBbat78gkSGPQfSma4Es2Ri','down',"f5f536fe1ac1dd1c95dd1aa779868b67",0)

Error: Incorrect integer value: 'auto' for column 'port' at row 1

Call: $SQL->insert_query()

 

As you see in the second last Line of the error "Incorrect integer value: 'auto' for column 'port' at row 1"

The error is causing due to "wrong" interval value in settings "Port range for new servers ". The error is due to the value "Auto" in the filed "port. If you crossed the the range of the port we set in centova, you need manually mention the stream port instead of "Auto" .

 

Was this answer helpful? 8333 Users Found This Useful (0 Votes)