News:

Create A Forum Installed

Author Topic: I can't install ezGallery  (Read 912 times)

0 Members and 1 Guest are viewing this topic.

Offline Martijn

  • Newbie
  • *
  • Posts: 47
  • Karma: 0
  • Gender: Male
  • Location: The Netherlands
    • View Profile
    • OptimusRust

Badges: (View All)
Search Level 3 Signature
Re: I can't install ezGallery
« on: May 15, 2014, 08:56:38 pm »
Damn!

Everyting was looking good, till i clicked on the "Gallery" tab.
I did not changed any settings yet.
I recieved the following error:

Database Error

Table 'createaforum.optimusrust_gallery_usersettings' doesn't exist
File: C:\inetpub\createaforum\Themes\default\Gallery2.template.php
Line: 4487


SELECT
p.id_picture, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views,
p.thumbfilename, p.title, p.id_member, m.real_name, p.date, p.description,
p.mature, c.view, (p.rating / p.totalratings ) AS ratingaverage, v.ID_PICTURE as unread, mg.online_color
FROM optimusrust_gallery_pic as p
LEFT JOIN optimusrust_members AS m ON (m.id_member = p.id_member)
LEFT JOIN optimusrust_membergroups AS mg ON (mg.ID_GROUP = IF(m.ID_GROUP = 0, m.ID_POST_GROUP, m.ID_GROUP))
LEFT JOIN optimusrust_gallery_usersettings AS s ON (s.id_member = m.id_member)
LEFT JOIN optimusrust_gallery_catperm AS c ON (c.id_group IN (1,5) AND c.id_cat = p.id_cat)
LEFT JOIN optimusrust_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 ((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 ORDER BY p.id_picture DESC LIMIT 4

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
1685 Views
Last post August 03, 2010, 02:28:31 pm
by Fate
6 Replies
890 Views
Last post November 16, 2012, 01:08:17 am
by CreateAForum
1 Replies
714 Views
Last post March 02, 2014, 03:14:00 pm
by CreateAForum
1 Replies
412 Views
Last post April 27, 2015, 01:02:12 am
by CreateAForum
8 Replies
578 Views
Last post December 10, 2018, 08:31:45 pm
by thekreater