Jørn Wildt
Dealing with Zikula and other interesting stuff
SQL-Error on getAccessSettings
-
- rank:
- 12
- registered:
- March 2009
- Status:
- offline
- last visit:
- Posts:
- 0
Hello!
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