Welcome to Geeklog, Anonymous Sunday, May 26 2024 @ 08:34 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.

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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
This has been fixed recently. Try updating.

bye, Dirk
 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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Confirmed. I've re-opened bug #454. Keep watching it.

bye, Dirk
 Quote

All times are EDT. The time is now 08:34 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