Hi,
I've recently installed this module in my site and while it says it's correctly installed when I press the node "Album Photos" I get the following errors:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "x_image" does not exist in /htdocs/temp/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT f.filepath, f.filemime, f.timestamp, f.filename, u.uid, u.name, p.* FROM files f INNER JOIN x_image p ON f.fid = p.fid INNER JOIN users u ON f.uid = u.uid WHERE f.uid = 4 ORDER BY f.fid DESC LIMIT 5 OFFSET 0 in /htdocs/temp/modules/photos/photos.module on line 772.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "x_image" does not exist in /htdocs/temp/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT f.filepath, f.filemime, f.timestamp, f.filename, u.uid, u.name, p.* FROM files f INNER JOIN x_image p ON f.fid = p.fid INNER JOIN users u ON f.uid = u.uid ORDER BY f.fid DESC LIMIT 5 OFFSET 0 in /htdocs/temp/modules/photos/photos.module on line 772.
and when I try to create an album:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "fid" violates not-null constraint in /htdocs/temp/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO x_album (pid, data) VALUES (7, 'a:13:{s:9:"viewpager";s:2:"10";s:10:"imageorder";s:14:"timestamp|desc";s:14:"list_imagesize";s:7:"240x180";s:14:"view_imagesize";s:7:"640x480";s:12:"page_display";s:1:"1";s:12:"page_viewnum";s:2:"10";s:14:"page_imagesize";s:5:"thumb";s:10:"page_slide";s:7:"640x480";s:3:"pid";N;s:14:"teaser_display";s:1:"1";s:14:"teaser_viewnum";s:1:"5";s:16:"teaser_imagesize";s:5:"thumb";s:12:"teaser_slide";s:7:"640x480";}') in /htdocs/temp/modules/photos/photos.module on line 428.
and the album says it's created but in fact it is not. Please enlighten me to what I have to so to sort this out. I am using the latest release (not dev) version of the software.
Thanks in advance!
Comments
Comment #1
nathaniel commented