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
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
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 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 ;
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »