-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of erwin
Sent: Tuesday, July 22, 2003 5:22 PM
To: [EMAIL PROTECTED]
Subject: [drupal-devel] bug #2330 : query error in image module
Project: Contributions
Area: modules
Version: cvs
Pstatus: Active
Priority: Normal
Assigned: [EMAIL PROTECTED]
22/07/2003 - 23:22 : erwin
Running v1.53 now and get the same error messages. I see some
difference in the select statement.
Let me know if I can do some more tests.
------------------------------------------------------------------------
22/07/2003 - 21:12 : [EMAIL PROTECTED]
I tried to fix these issues. Please try version 1.53.
------------------------------------------------------------------------
22/07/2003 - 20:43 : erwin
I installed the latest image.module $Id: image.module,v 1.52 2003/07/22
15:11:12 killes Exp $ and get some errors when I go to the image
module. I'm using postgres as database and checked the fields that are
used in the query, they all exist in the table.
Is there anybody who can give me a hint where to look at?
warning: pg_exec() query failed: ERROR: Relation "n" does not exist
in /usr/local/lib/php/DB/pgsql.php on line 171.
user error: DB Error: unknown error
query:
SELECT created, thumb_path
FROM node n, image i
LEFT JOIN term_node t ON n.nid = t.nid
WHERE n.nid = i.nid
AND t.tid IN (92)
AND type = 'image'
AND personal = 0
ORDER BY created DESC
LIMIT 1
in /usr/local/apache/drupal/includes/database.pear.inc on line
89.
warning: pg_exec() query failed: ERROR: Relation "n" does not exist
in /usr/local/lib/php/DB/pgsql.php on line 171.
user error: DB Error: unknown error
query:
SELECT thumb_path
FROM node n, image i
LEFT JOIN term_node t ON n.nid = t.nid
WHERE n.nid = i.nid
AND t.tid IN (92)
AND type = 'image'
AND personal = 0
ORDER BY RAND()
LIMIT 1
in /usr/local/apache/drupal/includes/database.pear.inc on line
89.
warning: pg_exec() query failed: ERROR: Relation "n" does not exist
in /usr/local/lib/php/DB/pgsql.php on line 171.
user error: DB Error: unknown error
query:
SELECT created, thumb_path
FROM node n, image i
LEFT JOIN term_node t ON n.nid = t.nid
WHERE n.nid = i.nid
AND t.tid IN (91)
AND type = 'image'
AND personal = 0
ORDER BY created DESC
LIMIT 1
in /usr/local/apache/drupal/includes/database.pear.inc on line
89.
warning: pg_exec() query failed: ERROR: Relation "n" does not exist
in /usr/local/lib/php/DB/pgsql.php on line 171.
user error: DB Error: unknown error
query:
SELECT thumb_path
FROM node n, image i
LEFT JOIN term_node t ON n.nid = t.nid
WHERE n.nid = i.nid
AND t.tid IN (91)
AND type = 'image'
AND personal = 0
ORDER BY RAND()
LIMIT 1
in /usr/local/apache/drupal/includes/database.pear.inc on line
89.
------------------------------------------------------------------------
Update-by-www: http://drupal.org/project/update/2330#content
Update-by-mail: mailto:[EMAIL PROTECTED]/update/2330
Update-by-mail help: http://drupal.org/project/mail_help
--
[ Drupal development list | http://list.drupal.org/ ]
[ http://lists.drupal.org/options/drupal-devel/jsloan%40enkapsis.com ]
