Cannot Save or Create a New Artist

0
I recently updated from Joomla 1.5 to Joomla 2.5. I am running Music Collection Version 2.3.1. Everything else seems to be working except when I try to modify or add a new artist and click the Save or Save and Close icon i get a blank page.

When viewing the page to edit the artist info on the right under these areas they say the following in the input feild:
City:
Notice: Undefined property: stdClass::$url in /home/wnpvnew/public_html/administrator/components/com_muscol/views/artist/tmpl/form.php on line 110


Website:
Notice: Undefined property: stdClass::$years_active in /home/wnpvnew/public_html/administrator/components/com_muscol/views/artist/tmpl/form.php on line 114


Years Active:
Notice: Undefined property: stdClass::$city in /home/wnpvnew/public_html/administrator/components/com_muscol/views/artist/tmpl/form.php on line 102


I turned on error reporting and this is what I get:

JDatabaseMySQLi::query: 1054 - Unknown column 'years_active' in 'field list' SQL=UPDATE `j25_muscol_artists` SET `artist_name`='Buxmont LIVE',`letter`='B',`review`='
Listen live on TuneIn
',`image`='buxmont-live-poster.jpg',`picture`='1309352659_buxmont-live-poster.jpg',`class_name`='Buxmont LIVE',`keywords`=' bucks county live montgomery county indian valley ',`country`='',`metakeywords`='',`metadescription`='',`years_active`='Notice: Undefined property: stdClass::$years_active in /home/wnpvnew/public_html/administrator/components/com_muscol/views/artist/tmpl/form.php on line 114',`city`='Notice: Undefined property: stdClass::$city in /home/wnpvnew/public_html/administrator/components/com_muscol/views/artist/tmpl/form.php on line 102',`url`='Notice: Undefined property: stdClass::$url in /home/wnpvnew/public_html/administrator/components/com_muscol/views/artist/tmpl/form.php on line 110',`genre_id`='3' WHERE `id`='17'
Call stack
# Function Location
1 JAdministrator->dispatch() JROOT/administrator/index.php:46
2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351
4 require_once() JROOT/libraries/joomla/application/component/helper.php:383
5 JController->execute() JROOT/administrator/components/com_muscol/muscol.php:153
6 ArtistsControllerArtist->save() JROOT/libraries/joomla/application/component/controller.php:761
7 ArtistsModelArtist->store() JROOT/administrator/components/com_muscol/controllers/artist.php:38
8 JTable->store() JROOT/administrator/components/com_muscol/models/artist.php:147
9 JDatabase->updateObject() JROOT/libraries/joomla/database/table.php:611
10 JDatabaseMySQLi->execute() JROOT/libraries/joomla/database/database.php:1650
11 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
12 JError::raise() JROOT/libraries/joomla/error/error.php:251

Accepted Answer

Friday, October 11 2013, 05:45 PM - #Permalink
0
this means you were running a pretty old version of Music Collection..
the DB has missing fields, in particular the artist table.

have you access to the DB?
can you add the following fields?

ALTER TABLE `j25_muscol_artists` ADD `city` varchar(255) NOT NULL,
ADD `years_active` varchar(255) NOT NULL,
ADD `url` varchar(255) NOT NULL,
ADD `genre_id` int(11) NOT NULL ;
The reply is currently minimized Show
Responses (1)
  • Accepted Answer

    Friday, October 11 2013, 05:55 PM - #Permalink
    0
    I will give it a shot and let you know what happens.
    Thank you
    The reply is currently minimized Show
Your Reply