Loading...
 
Skip to main content

Image Gallery fails with Unknown column 'g.parentgallery' in 'on clause'

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Image Gallery fails with Unknown column 'g.parentgallery' in 'on clause'
Version
1.9.x
Category
  • Error
  • Usability
Feature
Database MySQL (MyISAM)
Image Gallery
Submitted by
Mike
Volunteered to solve
mlaporte
Rating
(0)
Description

I am running Tiki 1.9.7 with MySQL on Linux.

I have gone through the tiki_mysql.sql file and have found no reference to the column listed in the error message:

Context:
File tiki-galleries.php
Url tiki-galleries.php
Query:
select g.*, a.`name` as parentgalleryName from `tiki_galleries` g left join `tiki_galleries` a on g.`parentgallery` = a.`galleryId` order by `name` desc
Values:
Message:
Error Message Unknown column 'g.parentgallery' in 'on clause'


This appears as soon as I click on "Image Galleries" folder from the Menu module, or "Galleries".

I also get the same error message when I try and click on "Upload Image":

Context:
File tiki-upload_image.php
Url tiki-upload_image.php
Query:
select g.*, a.`name` as parentgalleryName from `tiki_galleries` g left join `tiki_galleries` a on g.`parentgallery` = a.`galleryId` order by `lastModif` desc
Values:
Message:
Error Message Unknown column 'g.parentgallery' in 'on clause'


Apparently this column needs to exist, but I have no idea what the column settings should be. This is preventing me from even using the image gallery feature.

Importance
8
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1068
Created
Tuesday 17 April, 2007 20:18:27 UTC
by Unknown
LastModif
Thursday 05 July, 2007 13:16:24 UTC


Show PHP error messages