Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (4)

Adding album through admin error

Version 2
Monday, March 28 2016, 08:47 PM
onne
onne
Offline
0
Hi Germi,

I try to add an album through my admin but when i click save it give me mysql errors?

Unknown column 'tags' in 'field list' SQL=INSERT INTO `cud_muscol_songs` (`name`,`album_id`,`artist_id`,`num`,`disc_num`,`position`,`filename`,`length`,`added`,`genre_id`,`user_id`,`tags`) VALUES ('01 Ace Hood I Am (beast Mix)','5554','88','1','1','1','Ace Hood - Body Bag 3 (Beast Mix) (RapSearch.com)/01 Ace Hood - I Am (Beast Mix).mp3','0','2016-03-28 16:44:20','2','62','1')

What's wrong?

ps.. your login should still work ;)

Accepted Answer

onne
onne
Offline
Tuesday, March 29 2016, 10:02 AM - #Permalink
0
ok, ill ask my coder, thanks!
The reply is currently minimized Show
Responses (3)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, March 29 2016, 09:38 AM - #Permalink
    0
    well, what's wrong is that there's no "tags" field in the DB. this means the version of MC you're using is very old (at least the DB)... but you must be using files from a newer version.. are you? it's like the version of the files and the version of the DB are not in sync.
    The reply is currently minimized Show

  • Accepted Answer

    onne
    onne
    Offline
    Tuesday, March 29 2016, 09:42 AM - #Permalink
    0
    hhmm...as far as i know we've installed your latest version. there should be a database update in there right?

    Will an second install fix this or will that overwrite all the custom work we did?
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, March 29 2016, 10:00 AM - #Permalink
    0
    it will override.. so better don't do it.

    yes, if should have upgraded it. in any case, you can do the DB change manually.
    you just need to add a "tags" field into the albums DB table (also artists and songs), of type VARCHAR(255)
    The reply is currently minimized Show
Your Reply