Hi Everyone,<br /><br />I hope I am in the correct forum for this topic. I am trying to install phpbb album (<a href="http://www.phpbbhacks.com/download/1060" target="_blank">http://www.phpbbhacks.com/download/1060</a>) for my forums. I have no experience with SQL and very little with anything else really. I followed the install directions carefully and double-checked everything. I am not sure how to make the SQL modifications.<br /><br />I went into the "MySQL Databases" area in cPanel and manually added the tables mentioned in the instructions, but I'm not sure I did it correctly. I don't know how to access the entire database without going through the interface in cPanel. I was also unable to add additional values to the phpbb_album_config table because I simply don't know how. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="
" border="0" alt="sad.gif" /> <br /><br />Anyway, everything looks fairly good in the admin control panel for my forum, but when I actually click on the Album link on my forum page (<a href="http://www.historique.net//cheval/album.php" target="_blank">http://www.historique.net//cheval/album.php</a>) I get this error message:<br /> <br /><div align="center">Could not query recent pics information<br /><br />DEBUG MODE<br /><br />SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10<br /><br />SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN phpbb_album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN phpbb_album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (1,2) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY p.pic_time DESC LIMIT <br /><br />Line : 259<br />File : /home/cheval/public_html/cheval/album.php<!--content-->
The database should have your username_ on the front of it.<br /><br />Try creating;<br /><br />cpanelusername_phpbb_album<br /><br />And then putting the data into that, and using the full database name in the config file.<!--content-->
Thank you for your suggestions. phpbb_album is acutally just a table in my existing database that does in fact have my username in front of it.<br /><br />Is there a way to go into the database and edit the code without using the cPanel MySQL database interface?<!--content-->
Hello,<br /><br />Can i please suggest something different?<br /><br />The album you are about to load, is Smartors album, which can actually be found here:<br /><br /><a href="http://smartor.is-root.com/" target="_blank">http://smartor.is-root.com/</a><br /><br />However, there are many upgrades and new bits added to it, and for some while, Smartor has not really done much to it (to be honest, it doesnt really need anything doing to it)<br /><br />However, some guy has taken this further, and with Smartors permission, added everything together, as well as updating a few things which are now hard to get hold of (the important super service pack for one).<br /><br />The original post was here:<br /><br /><a href="http://smartor.is-root.com/viewtopic.php?t=15886" target="_blank">http://smartor.is-root.com/viewtopic.php?t=15886</a><br /><br />And the website for this Full Album pack (FAP) is here:<br /><br /><a href="http://www.area69.phphost.info/" target="_blank">http://www.area69.phphost.info/</a><br /><br />I suggest you download that and use that instead, its much easier, and is continously updated. It used to be my album of choice before I moved away from phpBB about 6 weeks ago.<br /><br />Let me know how it goes<br /><br />JimE<!--content-->
Wow! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /> Thanks for the suggestion! I installed everything and it's working...so far. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sweatdrop.gif" style="vertical-align:middle" emoid=":sweatdrop:" border="0" alt="sweatdrop.gif" /> I'll post an update after I work with it for a while. I have one error so far, but I don't know how bad it is.<br /><br />One part in the instructions was not clear to me. I don't know where this "Admin CP" file is.<br /><br />#-----[ DIY INSTRUCTIONS ]------------------------------------<br />#<br />CHMOD these directories for Full Album Pack to work correctly.<br />.<br />CHMOD 777 album_mod/upload<br />CHMOD 777 album_mod/upload/cache<br />CHMOD 777 album_mod/upload/med_cache<br />CHMOD 777 album_mod/upload/otf<br />CHMOD 777 album_mod/upload/wm_cache<br />.<br /><!--coloro:#CC0000--><span style="color:#CC0000"><!--/coloro--><b>Change "Path to cgi-in" in Admin CP to a relative path from phpBB root to your cgi-bin</b><!--colorc--></span><!--/colorc--><br />Create folder: cgi-bin/tmp/<br />CHMOD 777 cgi-bin/tmp/<br />CHMOD 755 cgi-bin/nuffload.cgi<!--content-->
Hello,<br /><br />Your Admin CP is also know as "Administrator Control Panel". The area where you go when you click "Administrator" at the bottom or top of the forum (depending on where that link is).<br /><br />Now if you scroll down the side until you reach the album area. Then in one of the sub menus off this, will be the nuffload area which you can change the path to the CGI script.<br /><br />Glad its working well!<br /><br />JimE<!--content-->
Thanks! I found it and the path is already correct! YAY!!!! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/clapping.gif" style="vertical-align:middle" emoid=":clapping:" border="0" alt="clapping.gif" /> <br />The album looks GREAT! I cannot thank you enough. <br /><br /><a href="http://www.historique.net/cheval/" target="_blank">http://www.historique.net/cheval/</a><!--content-->
" border="0" alt="sad.gif" /> <br /><br />Anyway, everything looks fairly good in the admin control panel for my forum, but when I actually click on the Album link on my forum page (<a href="http://www.historique.net//cheval/album.php" target="_blank">http://www.historique.net//cheval/album.php</a>) I get this error message:<br /> <br /><div align="center">Could not query recent pics information<br /><br />DEBUG MODE<br /><br />SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10<br /><br />SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN phpbb_album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN phpbb_album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (1,2) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY p.pic_time DESC LIMIT <br /><br />Line : 259<br />File : /home/cheval/public_html/cheval/album.php<!--content-->The database should have your username_ on the front of it.<br /><br />Try creating;<br /><br />cpanelusername_phpbb_album<br /><br />And then putting the data into that, and using the full database name in the config file.<!--content-->
Thank you for your suggestions. phpbb_album is acutally just a table in my existing database that does in fact have my username in front of it.<br /><br />Is there a way to go into the database and edit the code without using the cPanel MySQL database interface?<!--content-->
Hello,<br /><br />Can i please suggest something different?<br /><br />The album you are about to load, is Smartors album, which can actually be found here:<br /><br /><a href="http://smartor.is-root.com/" target="_blank">http://smartor.is-root.com/</a><br /><br />However, there are many upgrades and new bits added to it, and for some while, Smartor has not really done much to it (to be honest, it doesnt really need anything doing to it)<br /><br />However, some guy has taken this further, and with Smartors permission, added everything together, as well as updating a few things which are now hard to get hold of (the important super service pack for one).<br /><br />The original post was here:<br /><br /><a href="http://smartor.is-root.com/viewtopic.php?t=15886" target="_blank">http://smartor.is-root.com/viewtopic.php?t=15886</a><br /><br />And the website for this Full Album pack (FAP) is here:<br /><br /><a href="http://www.area69.phphost.info/" target="_blank">http://www.area69.phphost.info/</a><br /><br />I suggest you download that and use that instead, its much easier, and is continously updated. It used to be my album of choice before I moved away from phpBB about 6 weeks ago.<br /><br />Let me know how it goes<br /><br />JimE<!--content-->
Wow! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /> Thanks for the suggestion! I installed everything and it's working...so far. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sweatdrop.gif" style="vertical-align:middle" emoid=":sweatdrop:" border="0" alt="sweatdrop.gif" /> I'll post an update after I work with it for a while. I have one error so far, but I don't know how bad it is.<br /><br />One part in the instructions was not clear to me. I don't know where this "Admin CP" file is.<br /><br />#-----[ DIY INSTRUCTIONS ]------------------------------------<br />#<br />CHMOD these directories for Full Album Pack to work correctly.<br />.<br />CHMOD 777 album_mod/upload<br />CHMOD 777 album_mod/upload/cache<br />CHMOD 777 album_mod/upload/med_cache<br />CHMOD 777 album_mod/upload/otf<br />CHMOD 777 album_mod/upload/wm_cache<br />.<br /><!--coloro:#CC0000--><span style="color:#CC0000"><!--/coloro--><b>Change "Path to cgi-in" in Admin CP to a relative path from phpBB root to your cgi-bin</b><!--colorc--></span><!--/colorc--><br />Create folder: cgi-bin/tmp/<br />CHMOD 777 cgi-bin/tmp/<br />CHMOD 755 cgi-bin/nuffload.cgi<!--content-->Hello,<br /><br />Your Admin CP is also know as "Administrator Control Panel". The area where you go when you click "Administrator" at the bottom or top of the forum (depending on where that link is).<br /><br />Now if you scroll down the side until you reach the album area. Then in one of the sub menus off this, will be the nuffload area which you can change the path to the CGI script.<br /><br />Glad its working well!<br /><br />JimE<!--content-->
Thanks! I found it and the path is already correct! YAY!!!! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/clapping.gif" style="vertical-align:middle" emoid=":clapping:" border="0" alt="clapping.gif" /> <br />The album looks GREAT! I cannot thank you enough. <br /><br /><a href="http://www.historique.net/cheval/" target="_blank">http://www.historique.net/cheval/</a><!--content-->