+- MyBBHacks.com Plugins for MyBB (https://www.mybbhacks.com)
+-- Forum: ezGallery Pro for MyBB (https://www.mybbhacks.com/forumdisplay.php?fid=8)
+--- Forum: Support (https://www.mybbhacks.com/forumdisplay.php?fid=10)
+--- Thread: Problems with database? (/showthread.php?tid=2692)
Pages:
1
2
Problems with database? - apomtbforum - 10-23-2014
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
RE: Problems with database? - MyBBHacks - 10-24-2014
Posted an update to fix this issue
http://mybbhacks.com/showthread.php?tid=2656
5.0.12
!Fixed bug with the recent comments block
RE: Problems with database? - apomtbforum - 10-24-2014
(10-24-2014, 12:08 AM)MyBBHacks Wrote: Posted an update to fix this issue
http://mybbhacks.com/showthread.php?tid=2656
5.0.12
!Fixed bug with the recent comments block
thanks, i have problem with activation of my account, i don't receive the activeation mail, i request again but i don't receive
RE: Problems with database? - MyBBHacks - 10-24-2014
Try now.
RE: Problems with database? - apomtbforum - 10-24-2014
Thanks now it's ok...
Only one question again please.
I enabled bulk upload but when i upload i can do it one pic at time.... where i am wrong?
RE: Problems with database? - MyBBHacks - 10-24-2014
There should be a bulk upload link near add picture inside a gallery category. As long as you have permissions for it set in the gallery permissions area.
RE: Problems with database? - apomtbforum - 10-24-2014
(10-24-2014, 01:29 AM)MyBBHacks Wrote: There should be a bulk upload link near add picture inside a gallery category. As long as you have permissions for it set in the gallery permissions area.
the permission are ok i thnk (see the picture), but i don't see the link for bulk upload (or i am not able to see?)
RE: Problems with database? - MyBBHacks - 10-24-2014
You need to add a category first. Then inside the category is the link to do bulk upload
RE: Problems with database? - apomtbforum - 10-24-2014
(10-24-2014, 11:18 PM)MyBBHacks Wrote: You need to add a category first. Then inside the category is the link to do bulk upload
thanks, sorry but I'm a little stunned ehehe, I looked at the top instead of the bottom, found.
o all solved. You hav a MP
RE: Problems with database? - apomtbforum - 10-24-2014
sorry i am again here.
Look the pic, what kind of issue would be?
installing the plugin i changed the GALLERY folder in PHOTOGALLERY , would be thi the issue?
url, absolute url and path are all correct