10-23-2014, 10:55 PM
Hi,
I just purchased and installed ezgallery pro, but it works almost all the page prinzipale http://apomtbforum.com/ezgallery.php tells me database errors as follows
MyBB Has experienced an internal SQL error and can not continue.
SQL Error:
1064 - You have an error in your SQL syntax; check the manual That Corresponds to your MariaDB server version for the right syntax to use near ') LEFT JOIN mybb_members AS m ON (m.uid = p.ID_MEMBER)' at line 4
query:
SELECT max (com.ID_COMMENT) AS lastcomment, p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.username, mg.namestyle, p.date, p.description, p.mature, c.view, v.ID_PICTURE as unread FROM mybb_gallery_pic as p, as mybb_gallery_comment com) mybb_members AS m LEFT JOIN ON (m.uid = p.ID_MEMBER) LEFT mybb_membergroups mg JOIN AS ON (m.usergroup = mg.gid) LEFT JOIN mybb_gallery_usersettings AS s ON (s.ID_MEMBER = m.uid) LEFT JOIN mybb_gallery_catperm AS c ON (c.ID_GROUP IN (4) AND c.ID_CAT = p. ID_Cat) LEFT JOIN mybb_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = 1 AND v.user_id_cat = p.USER_ID_CAT) WHERE com.ID_PICTURE p.ID_PICTURE = AND (((s.private = 0 || s.private IS NULL) AND (s.password = '' || s.password IS NULL) AND p.USER_ID_CAT! = 0 AND p.approved = 1) || (p.approved = 1 AND p.USER_ID_CAT = 0 AND (c.view IS NULL || c.view = 1))) GROUP by p.ID_PICTURE lastcomment
what is the problem.
Can u check if all is working right?
Thanks a lot
Arturo
I just purchased and installed ezgallery pro, but it works almost all the page prinzipale http://apomtbforum.com/ezgallery.php tells me database errors as follows
MyBB Has experienced an internal SQL error and can not continue.
SQL Error:
1064 - You have an error in your SQL syntax; check the manual That Corresponds to your MariaDB server version for the right syntax to use near ') LEFT JOIN mybb_members AS m ON (m.uid = p.ID_MEMBER)' at line 4
query:
SELECT max (com.ID_COMMENT) AS lastcomment, p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.username, mg.namestyle, p.date, p.description, p.mature, c.view, v.ID_PICTURE as unread FROM mybb_gallery_pic as p, as mybb_gallery_comment com) mybb_members AS m LEFT JOIN ON (m.uid = p.ID_MEMBER) LEFT mybb_membergroups mg JOIN AS ON (m.usergroup = mg.gid) LEFT JOIN mybb_gallery_usersettings AS s ON (s.ID_MEMBER = m.uid) LEFT JOIN mybb_gallery_catperm AS c ON (c.ID_GROUP IN (4) AND c.ID_CAT = p. ID_Cat) LEFT JOIN mybb_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = 1 AND v.user_id_cat = p.USER_ID_CAT) WHERE com.ID_PICTURE p.ID_PICTURE = AND (((s.private = 0 || s.private IS NULL) AND (s.password = '' || s.password IS NULL) AND p.USER_ID_CAT! = 0 AND p.approved = 1) || (p.approved = 1 AND p.USER_ID_CAT = 0 AND (c.view IS NULL || c.view = 1))) GROUP by p.ID_PICTURE lastcomment
what is the problem.
Can u check if all is working right?
Thanks a lot
Arturo