Sounds issue Update

OK everyone thanks to Anton_LV he discovered that the html5 player issue was due to a custom link i had done to try and get the files to upload directly to the demo album i.e:

http://voiceartistsunited.com/m/sounds/albums/my/add_objects

and this wasnt specifying an album.

i changed the deault public album to "Demos" so the link would be http://voiceartistsunited.com/m/sounds/albums/my/add_objects/Demos

however the issue is this appears to be used by all members as a conglomerated album of all files.

i then changed the album name back to standard :

http://voiceartistsunited.com/m/sounds/albums/my/add_objects/{nickname}'s sounds

displaying as (http://voiceartistsunited.com/m/sounds/albums/my/add_objects/%7Bnickname%7D's%20sounds)

and now im recieving this DB error.

Error
Database query error
Query:
SELECT COUNT(`RayMp3Files`.`ID`) FROM `RayMp3Files` LEFT JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayMp3Files`.`ID` LEFT JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` WHERE 1 AND `sys_albums`.`Type` = 'bx_sounds' AND `sys_albums`.`Uri` = '{nickname}'s sounds' AND `RayMp3Files`.`Status` IN('disapproved') AND `RayMp3Files`.`Owner` IN('1')
Mysql error:
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 's sounds' AND `RayMp3Files`.`Status` IN('disapproved') AND `RayMp3Files`.`Owner`' at line 2

 

All i want to do is have individual public folders that member's' demos upload to and be displayed on their profile in the player....is that so difficult?!

All for one and one for all....ah sod it who am i kidding!
Quote · 8 Jul 2013

Your issue is in the following bit of code:

 

Uri` = '{nickname}'s sounds'

 

As you can see there are three '

The 's is breaking the code and should be escaped properly for it to work

Dedicated servers for as little as $32 (28 euro) - See http://denre.com for more information
Quote · 8 Jul 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.