SQL Error: Incorrect integer value ‘auto’ for Port in Centova Cast

SQL Error: Incorrect integer value: 'auto' for column 'port'

Error Message

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

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

What Does This Error Mean?

The important part of the error is:

Incorrect integer value: 'auto' for column 'port'

This means the system attempted to store the value auto in the port field, but the database expects a numeric port number (such as 8000, 8050, or 9000).

Why Does This Happen?

This issue is usually caused by an incorrect or exhausted port range configured in Centova Cast.

• Centova Cast assigns ports automatically only when free ports are available.
• If all ports in the configured range are already used, the system still tries to insert auto.
• Since auto is not a numeric value, the database rejects it and throws this error.

Root Cause

• Setting involved: Port range for new servers
• Problem:
  • Invalid port range
  • Port range too small
  • All ports in the range already used

How to Fix the Issue

Option 1: Increase or Correct the Port Range (Recommended)

1. Log in to the Centova Cast Admin Panel
2. Navigate to:
   Settings → Streaming Servers → Port range for new servers
3. Set a valid and sufficient port range (example):
   8000 - 9000
4. Save the settings and try creating the account again.

Option 2: Manually Specify a Port

If the configured port range is already exhausted:

• Do not use Auto
• Manually enter a free numeric port (example: 8055) while creating the stream

Important Notes

• The port field must always contain a numeric value
• Auto works only when free ports are available in the defined range
• This is a configuration issue, not a software bug

Summary

If the issue continues after correcting the port range, please contact your server administrator or hosting provider for further assistance.