+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Mysql problems with comments (/thread-653.html)
Mysql problems with comments - teigas - 2006-07-07
Got this error in my comment section. ANybody got any tips?
"MySQL Query ( SELECT c.id, i.title, i.filename, a.folder, a.title AS albumtitle, c.name, c.website, (c.date + 0) AS date, c.comment, c.email FROM comments AS c, images AS i, albums AS a WHERE c.imageid = i.id AND i.albumid = a.id ORDER BY c.id DESC LIMIT 20 ) Failed. Error: Unknown column 'c.website' in 'field list'"
Mysql problems with comments - Chilifrei64 - 2006-07-07
fresh install?
upgrade?
what version?
have you tried re-running setup.php or upgrade.php?
Mysql problems with comments - zucye - 2007-08-28
Same problem:
"MySQL Query ( SELECT c.id, i.title, i.filename, a.folder, a.title AS albumtitle, c.name, c.website, c.date, c.comment FROM comments AS c, images AS i, albums AS a WHERE c.imageid = i.id AND i.albumid = a.id ORDER BY c.id DESC LIMIT 10 ) Failed. Error: Unknown column 'c.website' in 'field list "
With previous version (fresh install) and
New Version Verion 1.0.8.2 (Upgrade)
Add I did re-runned setup.php or upgrade.php!!