Welcome to Geeklog, Anonymous Friday, July 26 2024 @ 10:10 pm EDT
Geeklog Forums
GL 1.3.12CVS SQL Error on Comments
Status: offline
ByteEnable
Forum User
Full Member
Registered: 10/20/03
Posts: 138
Hi,
I'm getting an SQL error when clicking to view a reply to a comment.
An SQL error has occurred. Please see error.log for details.
Sun 18 Sep 2005 12:49:43 AM CDT - 1052: Column 'type' in where clause is ambiguo
us. SQL in question: SELECT c.*, u.username, u.fullname, u.photo, c2.indent + 1
as pindent, unix_timestamp(c.date) AS nice_date FROM gl_comments as c, gl_commen
ts as c2, gl_users as u WHERE c.sid = '20050214165132702' AND (c.lft > c2.lft AN
D c.lft < c2.rht) AND c2.cid = 864 AND c.uid = u.uid AND type='article'ORDER BY
c.lft ASC LIMIT 0, 100
Apache 2.0.54
php 4.4.0
MySQL 4.1
Byte
LinuxElectrons™
I'm getting an SQL error when clicking to view a reply to a comment.
An SQL error has occurred. Please see error.log for details.
Text Formatted Code
Sun 18 Sep 2005 12:49:43 AM CDT - 1052: Column 'type' in where clause is ambiguo
us. SQL in question: SELECT c.*, u.username, u.fullname, u.photo, c2.indent + 1
as pindent, unix_timestamp(c.date) AS nice_date FROM gl_comments as c, gl_commen
ts as c2, gl_users as u WHERE c.sid = '20050214165132702' AND (c.lft > c2.lft AN
D c.lft < c2.rht) AND c2.cid = 864 AND c.uid = u.uid AND type='article'ORDER BY
c.lft ASC LIMIT 0, 100
Apache 2.0.54
php 4.4.0
MySQL 4.1
Byte
LinuxElectrons™
3
1
Quote
Status: offline
ByteEnable
Forum User
Full Member
Registered: 10/20/03
Posts: 138
I'm already using that version:
// $Id: lib-comment.php,v 1.19 2005/09/02 19:06:32 vinny Exp $
I just did a CVS update on the 16th.
Byte
LinuxElectrons™
5
2
Quote
All times are EDT. The time is now 10:10 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content