Database improperly updated on Centovacast upgrade

Read 10051 times
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?
Last Edit: December 06, 2021, 05:45:27 pm by SCIFI.radio
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:

Code: [Select]
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.