Music Database [3.1]

[JayBachatero]

computerdummy the reason those are there because this mod had the ability to work with the filemanager but it wasn't working correctly so I took that out when i updated it to RC2.

tetsujin at the moment there is no way to do it unless you take the original 3.1 file and try to get it working with the file manager.  Mind you that it's still an alpha version.

[tetsujin]

Well my friend and i will see if we can do that then, or something to that extent.

Cameron

[tetsujin]

After some quick programming I threw in the ability to add a download link to the music if that helps anyone out.

Cameron

[peterstannard]

Glad to hear it working fine for you now.  If you come across any other issues just let me know.

Just installed for a client running 1.1 RC2. Appears fine. Thanks Jay.

[Joshsux]

im so confused theres SMF 1.0.7 and version 1.1R2..... what the heck is the new version ?! theres a mix of people using all sorts shouldnt we all be using the newest one?

I cant get the mod to work on my SMF 1.0.7 and i'm trying my hardest but i dont know much about code! soooo confused if someone can help me add me to msn? [email protected] thanks

[JayBachatero]

This mod is for 1.1 RC2.  1.1 is newer than 1.0 but 1.1 RC2 is not a FINAL product yet but it's very stable.
http://en.wikipedia.org/wiki/Software_version

[deadpoeticstar]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID_ALBUM = '1'' at line 1
File: /home/georgeli/public_html/smf/Sources/MusicAdmin.php
Line: 131

[JayBachatero]

What where you doing when you got the error?

[deadpoeticstar]

What where you doing when you got the error?

I think i was adding the same CD but i had just reinstalled it yesterday cause a while back  i ran into some other errors with it so i removed it

[JayBachatero]

I'll take a loo at it when I get home but if you are able to reproduce the error please let me know.

[deadpoeticstar]

Ok, I was going through the Music Admin, and clicking save and all of them worked fine (which they still do anyways) and then i went to albums and clicked on an album i had previously added and clicked save and then that is when i got that error

[JayBachatero]

I will take a look at this and see where it went wrong.

[deadpoeticstar]

and i changed nothing in it about that album, it was still in the original way that i had set it up

[JayBachatero]

Ok found the issue it was a comma in the wrong pace.  In MusicAdmin.php file

Code (find) Select Expand


db_query("UPDATE {$db_prefix}music_albums SET albumName = '$_REQUEST[albumName]', length = '$_REQUEST[length]', released = '$_REQUEST[releaseMonth] . $_REQUEST[releaseYear]',  WHERE ID_ALBUM = '$_REQUEST[ID_ALBUM]'", __FILE__,__LINE__);


Code (replace) Select Expand


db_query("UPDATE {$db_prefix}music_albums SET albumName = '$_REQUEST[albumName]', length = '$_REQUEST[length]', released = '$_REQUEST[releaseMonth] . $_REQUEST[releaseYear]' WHERE ID_ALBUM = '$_REQUEST[ID_ALBUM]'", __FILE__,__LINE__);


[deadpoeticstar]

works perfecto mate thanks

[Cccddd]

wow yeah so I wanted to come back and work on this. Guess what? I got assigned to a new position now which puts me in charge of 10 to 12 people across Kuwait, Qatar, and Djibouti. My free time is not minimal, but extremely broken up. Makes it hard to focus on any coding projects.

But lil_j and JayB seem to be taking this and running with it well. I'm happy this didn't die! Too bad my file manager never made it off the ground...

[JayBachatero]

Just a side note.  JayB and lil_j are the same person .  LIL_J is the old name .

[desertcities]

The install via PM is fine but tells me the Test Fails on just 1 file, the /Sources/ModSettings.php file.  It's chmoded fine.

Any suggestions?

Thank you.

Mark

[JayBachatero]

What other mods do you have installed?

[deadpoeticstar]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID_ALBUM = '1'' at line 1
File:public_html/smf/Sources/MusicAdmin.php
Line: 131

after i tried to modify the album release date...the above quote is what i got