0
JInstaller: :Install: erreur SQL Table 'culturegospel35.#__muscol_artists' doesn't exist SQL=ALTER TABLE `#__muscol_artists` ADD `cover` VARCHAR(255) NOT NULL AFTER `tags`;
Extension Mettre à jour : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1146
Table 'culturegospel35.#__muscol_artists' doesn't exist SQL=ALTER TABLE `#__muscol_artists` ADD `cover` VARCHAR(255) NOT NULL AFTER `tags`;
SQL =
ALTER TABLE `#__muscol_artists` ADD `cover` VARCHAR(255) NOT NULL AFTER `tags`;

When I go to the component menu.

1146 Table 'culturegospel35.#__muscol_albums' doesn't exist SQL=SELECT al.*,ar.artist_name,f.format_name, u.name as username FROM #__muscol_albums as al LEFT JOIN #__muscol_artists as ar ON ar.id = al.artist_id LEFT JOIN #__muscol_format as f ON f.id = al.format_id LEFT JOIN #__users as u ON u.id = al.user_id ORDER BY al.added DESC


I am running on joomla 3.6.2
Responses (11)
  • Accepted Answer

    Wednesday, August 10 2016, 04:05 PM - #Permalink
    0
    This doesn't look an error related to Joomla version 3.6.2

    This is an error that can occur if there was a previous version of Music Collection installed on the site (even if it was "long ago")

    is this the case..? was there ever a previous version of MC installed in the site?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 10 2016, 04:28 PM - #Permalink
    0
    I think 2.4.0, I am working from the website backup of an old site from another webmaster. I start a new development from an old site. They used music collection 2.4.0, I saw that it was responding to my needs, so I decided to pay a new license in order to used your product. I am working in localhost...
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 10 2016, 04:51 PM - #Permalink
    0
    yes, well that's the problem. the DB tables were not in your installation, but music collection was "installed" in joomla.

    you need to completely uninstall music collection from that joomla website, and then install fresh.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 10 2016, 05:36 PM - #Permalink
    0
    How can I do with the old data ?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 10 2016, 05:42 PM - #Permalink
    0
    what old data...? the error you were getting was that "there was no tables" of music collection on the site.. if there were no tables, there can't be any data...
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 10 2016, 09:05 PM - #Permalink
    0
    Thanks for your help. I have successfully install the component after uninstall.
    Please, now when I tried to save an artist, there is some errors again

    1054 Unknown column 'tags' in 'field list' SQL=INSERT INTO `#__muscol_artists` (`id`,`artist_name`,`letter`,`review`,`image`,`picture`,`class_name`,`keywords`,`related`,`added`,`country`,`user_id`,`metakeywords`,`metadescription`,`years_active`,`city`,`url`,`genre_id`,`tags`,`cover`) VALUES ('0','Artist','A','','','','Artist',' artist ','','2016-08-10 22:50:49','','221','','','','','','1','1','')

    and it is the same thing when I try to save a song.

    1054 Unknown column 'tags' in 'field list' SQL=UPDATE `#__muscol_songs` SET `name`='Missionnaire',`album_id`='50',`artist_id`='44',`num`='8',`disc_num`='1',`position`='8',`lyrics`='',`filename`='08-missionnaire.mp3',`length`='0',`review`='',`songwriters`='',`chords`='',`genre_id`='1',`video`='',`buy_link`='',`tags`='1' WHERE `id`='341'

    and it seems there is absolutely nothing on the component MC homepage

    Please do you have any solution for this issue ?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, August 11 2016, 08:05 AM - #Permalink
    0
    Hello I have installed your component on a new joomla... But it don't work at all.
    Nothing is displayed, no artists, no albums, no songs...
    There is something I haven't done in the settings... Please...help.

    These the url of the page
    http://agencesecret.com/ecolebiblique.com/ecouter/
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, August 11 2016, 08:52 AM - #Permalink
    0
    On the sample album page, the items in compilation dont load and when you click on the play button nothing happens, no player like your demo website.

    http://agencesecret.com/ecolebiblique.com/music
    The reply is currently minimized Show
  • Accepted Answer

    Melanie
    Melanie
    Offline
    Sunday, September 18 2016, 02:22 PM - #Permalink
    0
    Did you manage to fix yours? I have same problem when I click on my player button nothing happens.
    The reply is currently minimized Show
  • Accepted Answer

    Melanie
    Melanie
    Offline
    Sunday, September 18 2016, 04:23 PM - #Permalink
    0
    Melanie wrote:

    Did you manage to fix yours? I have same problem when I click on my player button nothing happens.


    Hi, you would need to login to see the problem - can I send you details securely somehow? I can see now that my problem is with the module for Albums - it wont play on that. If I can send login details you will be able to see.

    Mel
    The reply is currently minimized Show
  • Accepted Answer

    Melanie
    Melanie
    Offline
    Sunday, September 18 2016, 06:44 PM - #Permalink
    0
    Hi,

    mine is working now. I uninstalled everything, deleted database files and started from scratch following your instructions to the letter in the order you specify. Now it all works beautifully.

    Mel
    The reply is currently minimized Show
Your Reply