12
Posts: 0
Posted:
4.May 2006 - 21:07
First of all, great work, I like Mediashare! :-)
My fist try was not error free, I had an SQL error after selecting the "Access" menu:
Quote
/home/httpd/docs/pn/modules/mediashare/pneditapi.php(1101): "getAccessSettings" failed: You have an error in your SQL syntax near 'UNION SELECT -1, 'Everybody', CASE ' at line 11 while executing: SELECT pn_group_membership.pn_gid, pn_groups.pn_name, CASE WHEN ISNULL(msa_access) THEN 0 ELSE msa_access END FROM pn_group_membership INNER JOIN pn_groups ON pn_groups.pn_gid = pn_group_membership.pn_gid LEFT JOIN pn_mediashare_access ON msa_groupid = pn_group_membership.pn_gid AND msa_albumid = 2 UNION SELECT -1, 'Everybody', CASE WHEN ISNULL(msa_access) THEN 0 ELSE msa_access END FROM pn_mediashare_access WHERE msa_groupid = -1 AND msa_albumid = 2
I figured out, that my MySQL version was the reason for this; I had MySQL 3.x.
After updating MySQL to version 4.x mediashare works as expected.
The problem now is, that my provider has MySQL 3.x and I don't think he would update...
Is there a workaround for this query that works also on MySQL 3.x? (I am not so fit in SQL like this... :-))
Regards
Gouli
edited by: Gouli, May 04, 2006 - 10:48 PM
12
Posts: 0
Posted:
5.May 2006 - 22:43
Quote
Is there a workaround for this query
Sorry, cannot help you.
12
Posts: 0
Posted:
6.May 2006 - 00:33
I think, I will change my hosting provider soon...
But maybe a note for the requirements of Mediashare: It needs MySQL 4.x and newer!
edited by: Gouli, May 06, 2006 - 01:34 AM