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
- 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+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 1695
- Created
- Sunday 13 April, 2008 11:10:41 UTC
by Unknown - LastModif
- Sunday 13 April, 2008 13:36:44 UTC