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:

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.