Hi everyone!
I've upload new ZenPhoto release (1.1.4) to my blog www.drinkteam.tv and all the things work! I try to configure the Zenphoto Recent Comments extension (that worked with ZenPhoto 1.0.3 giving only a bad link error).
These the instructions for the extension:
1. Open zen-recent-comments.php in your favorite editor and supply the Configuration block(eg. $zen_db, $zen_username, etc...)
2. Copy and paste file zen-recent-comments.php into the wordpress plug-in directory.
3. Activate it from within the WordPress admin interface.
4. and put <?php zenphoto_recent_comments(); ?> in your template.
These my parameters in zen-recent-comments.php:
////////////////////////////////////////////////////////////////////
/*------------------- START OF CONFIGURATION ---------------------*/
/*MySQL Settings*/
$zen_db = 'Sql120667_3'; //The name of the database
$zen_username = 'username'; //Your MySQL username
$zen_password = 'password'; //...and password
$zen_host = 'iphost'; //99% chance you won't need to change this value
$mysql_prefix = 'zp_'; //Zen Database Tables prefix (if any)
/*More...*/
$num_of_comments = '10'; //Number of comments you want to show up.
$mods_rewrite = true; //If you have Apache mod_rewrite, put true here, and you'll get nice cruft-free URLs.
$gallery_folder = '
http://www.drinkteam.tv/dt-gallery'; //eg.
http://mysite.com/zenphoto/*--------------------- END OF CONFIGURATION ---------------------*/
////////////////////////////////////////////////////////////////////
and this the code added to my index.php template: <?php zenphoto_recent_comments(); ?>
it returns to me this error:
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: Table 'Sql120667_3.comments' doesn't exist
Can you help me?
Zenphoto
Comments
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: Table 'Sql120667_3.comments' doesn't exist