Centova Technologies Forum
Centova Cast v3 => Bugs and issues => Topic started by: SCIFI.radio on December 06, 2021, 05:43:24 pm
-
During the upgrade to the latest version of Centovacast, it was unable to update the database completely - or at all.
#Error: Upgrade from 3.2.15r4255 failed. 1 error(s) occurred; upgrade codes:
#
#3.2.15r4260-0-0 - Could not execute query: BLOB, TEXT, GEOMETRY or JSON co ...
#
#If you require assistance, please provide the above codes in your support ticket to Centova Cast support.
#Database upgrade failed
It still works, I'm still on the air, but a) I can't see the list of recently played tracks in the Overview section and b) I get the following two SQL errors when I go to view the currently connected listeners:
SQL Error: Could not execute query in /usr/local/centovacast/system/class_SharedContent.php:185
Query: SELECT usecontentfrom FROM accounts WHERE id=2
Error: Unknown column 'usecontentfrom' in 'field list'
Call: $SQL->select_query()
SQL Error: Could not execute query in /usr/local/centovacast/system/class_SharedContent.php:65
Query: SELECT id,username,sharemedia,shareplaylists FROM accounts WHERE (sharemedia>0 OR shareplaylists>0) AND username IN ('')
Error: Unknown column 'sharemedia' in 'field list'
Call: $SQL->select_query()
Is there a way to run the database update as a separate discrete task?
-
I filed a ticket for this, and the answer was to run a SQL command to create the missing fields, as supplied by Roger who answered my trouble ticket in a matter of just a couple of hours.
I couldn't be more pleased.
During the upgrade to the latest version of Centovacast, it was unable to update the database completely - or at all.
#Error: Upgrade from 3.2.15r4255 failed. 1 error(s) occurred; upgrade codes:
#
#3.2.15r4260-0-0 - Could not execute query: BLOB, TEXT, GEOMETRY or JSON co ...
#
#If you require assistance, please provide the above codes in your support ticket to Centova Cast support.
#Database upgrade failed
It still works, I'm still on the air, but a) I can't see the list of recently played tracks in the Overview section and b) I get the following two SQL errors when I go to view the currently connected listeners:
SQL Error: Could not execute query in /usr/local/centovacast/system/class_SharedContent.php:185
Query: SELECT usecontentfrom FROM accounts WHERE id=2
Error: Unknown column 'usecontentfrom' in 'field list'
Call: $SQL->select_query()
SQL Error: Could not execute query in /usr/local/centovacast/system/class_SharedContent.php:65
Query: SELECT id,username,sharemedia,shareplaylists FROM accounts WHERE (sharemedia>0 OR shareplaylists>0) AND username IN ('')
Error: Unknown column 'sharemedia' in 'field list'
Call: $SQL->select_query()
Is there a way to run the database update as a separate discrete task?
-
!...
I hope you get some notification of my message, I hope you answer me before technical support does.
I have the same problem, could you share the SQL queries to create the missing fields and columns?
I filed a ticket for this, and the answer was to run a SQL command to create the missing fields, as supplied by Roger who answered my trouble ticket in a matter of just a couple of hours.
I couldn't be more pleased.
During the upgrade to the latest version of Centovacast, it was unable to update the database completely - or at all.
#Error: Upgrade from 3.2.15r4255 failed. 1 error(s) occurred; upgrade codes:
#
#3.2.15r4260-0-0 - Could not execute query: BLOB, TEXT, GEOMETRY or JSON co ...
#
#If you require assistance, please provide the above codes in your support ticket to Centova Cast support.
#Database upgrade failed
It still works, I'm still on the air, but a) I can't see the list of recently played tracks in the Overview section and b) I get the following two SQL errors when I go to view the currently connected listeners:
SQL Error: Could not execute query in /usr/local/centovacast/system/class_SharedContent.php:185
Query: SELECT usecontentfrom FROM accounts WHERE id=2
Error: Unknown column 'usecontentfrom' in 'field list'
Call: $SQL->select_query()
SQL Error: Could not execute query in /usr/local/centovacast/system/class_SharedContent.php:65
Query: SELECT id,username,sharemedia,shareplaylists FROM accounts WHERE (sharemedia>0 OR shareplaylists>0) AND username IN ('')
Error: Unknown column 'sharemedia' in 'field list'
Call: $SQL->select_query()
Is there a way to run the database update as a separate discrete task?
-
Ok, the support wrote me the following code:
ALTER TABLE `accounts`
ADD `sharemedia` int(10) unsigned NOT NULL DEFAULT 0,
ADD `shareplaylists` int(10) unsigned NOT NULL DEFAULT 0,
ADD `usecontentfrom` text NOT NULL;
I hope it helps someone else.