Loading...
 
Skip to main content

search "Editorial Board Meeting" at doc.tw.o admin category EBM returns Column 'name' ambiguous

Status
Closed
Subject
search "Editorial Board Meeting" at doc.tw.o admin category EBM returns Column 'name' ambiguous
Version
2.x
Category
  • Error
  • Dogfood on a *.tiki.org site
Feature
Administration
Category
Submitted by
Xavier de Pedro
Lastmod by
Xavier de Pedro
Rating
(0)
Description

At doc.tw.o (upgraded to 1.10svn April 12th), I went to admin categories.
Selected "Editorial Board Meeting" (already existed), to add pages to it.
At the filter box I set "Editorial Board Meeting" and a mysql error is returned:

~pp~
An error occured in a database query! Context: File tiki-admin_categories.php Url tiki-admin_categories.php?find_objects=Editorial+Board+Meeting&parentId=10&search_objects=Filter&sort_mode=name_asc&offset=0&find= Query: SELECT tab.*, tfgp.`name` as `parentName` FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) WHERE (upper(`name`) LIKE upper(?) OR upper(`description`) LIKE upper(?) OR upper(`filename`) LIKE upper(?)) ORDER BY `isgal` desc, tab.`name` desc Values: 0 %Editorial Board Meeting% 1 %Editorial Board Meeting% 2 %Editorial Board Meeting% Message: Column 'name' in where clause is ambiguous Built query was probably: SELECT tab.*, tfgp.`name` as `parentName` FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) WHERE (upper(`name`) LIKE upper('%Editorial Board Meeting%') OR upper(`description`) LIKE upper('%Editorial Board Meeting%') OR upper(`filename`) LIKE upper('%Editorial Board Meeting%')) ORDER BY `isgal` desc, tab.`name` desc
~pp~


Nothing was added to that category. I had to add them selecting them from the multiple select box showing all pages in doc.tw.o (at least nowadays all pages are listed 😊 - thanks to the coders who improved that )

Solution
fixed
Importance
6
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1695
Created
Sunday 13 April, 2008 11:10:41 UTC
by Unknown
LastModif
Sunday 13 April, 2008 13:36:44 UTC


Show PHP error messages