Major Additions - PhotoPlog: The Lite Gallery

PhotoPlog: The Lite Gallery

PhotoPlog Lite is a gallery script for GIF, JPG, and PNG images. PhotoPlog Lite comes with categories, permissions, comments, search, moderation. The installation takes care of phrases, templates, tables, etcetera. Just follow the README.txt file for installation.

There is a license agreement that I request that you abide. Thanks!

This thread is organized as follows:

• Post1 contains this here release.
• Post2 contains current add-ons.
• Post3 contains onscreen errors.

Fine Print: see license agreement, no redistribution, copyright retained in full, right reserved to uncheck support box.

Requirements: vB 3.5.0+ (development initially based on having vB 3.5.4 though vB 3.6.0+ and vB 3.7.0+ should be okay, but not every version was personally tested) and MySQL 4.1+ (development based on having MySQL 4.1+ though MySQL 3+ may be okay, but not every version was personally tested) and PHP with GD2 and Safe Mode off

Does it work on vB 3.5 and vB 3.6 and vB 3.7? Yes, it should. See the requirements. Also, there are two product XML files, one for vB 3.5 and one for vB 3.6/3.7, so import the one that matches your vB version.

Live Demo and Official Support: http://www.photoplog.com/

Note on Official Support: With 70 some pages, assuming 15 posts per page, and over 1000 posts, all in one thread, official support for this mod is now held off-site. Apologies in advance for possibly having to register at yet another forum, but IMHO support would be better served elsewhere at this point.

All support requests, except perhaps for proven bugs, may be ignored if posted in this thread.

Comments, suggestions, etcetera are welcome, but please note that further modifications are not being planned, as this is intended as the final release of the lite series.

Fun Fact: PhotoPlog Lite v.2.0.6 had 4330 downloads plus 2262 downloads prior to CSRF protection plus 3031 downloads as of 06 Nov 2010!

[calorie]

See the 900 in this attachment? Is 900 seconds (15 minutes) the issue?

FYI: screenies in post1 have been updated to reflect PhotoPlog v.1.0.4.

[mikelbeck]

I just installed 1.0.4 over 1.0.3, I got this error message:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT *,
(SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 14) AS num,
(SELECT IF(SUM(photoplog_ratecomment.rating) > 0, SUM(photoplog_ratecomment.rating) / SUM(IF(photoplog_ratecomment.rating > 0, 1, 0)), 0) FROM photoplog_ratecomment WHERE fileid = 14) AS ave
FROM photoplog_ratecomment
WHERE fileid = 14
AND moderate = 0
ORDER BY dateline DESC
LIMIT 1;

MySQL Error  : 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 'SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 14) A
Error Number : 1064

[calorie]

What version of MySQL are you using?

[mikelbeck]

Originally Posted by calorie

What version of MySQL are you using?

4.0.25 Standard.

[calorie]

Are you able to upgrade to >= MySQL 4.1?

[mikelbeck]

Originally Posted by calorie

Are you able to upgrade to >= MySQL 4.1?

No, not at this time.

[nitro]

@Calorie oooww 1.0.4 allready we didnt even get chance to try 1.0.3x

I take it you mean the general update instructions ? and by revert any changed photoplog templates you mean any we have customised, which if we havnt done that that step is skipable ?

I should probably not need to ask but the prefered way is to get it right first time and not risk losing current data, even if at this early stage it wouldnt matter to much. Check check and check again can save so much hassle.

[Rhoads]

Dam, I can't upgrade now because i have a lower MySQL, my host will not upgrade at the moment because they say the MySQL that we have is stable.

[Seyfullah]

same error

(SELECT IF(SUM(photoplog_ratecomment.rating) > 0, SUM(photoplog_ratecomment.rating) / SUM(IF(photoplog_ratecomment.rating > 0, 1, 0)), 0) FROM photoplog_ratecomment WHERE fileid = 2) AS ave
FROM photoplog_ratecomment
WHERE moderate = 0
AND fileid = 2;

MySQL-Fehler : 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 'SELECT IF(SUM(photoplog_ratecomment.rating) > 0, SUM(photoplog_
Fehler-Nr. : 1064
Datum : Thursday, December 15th 2005 @ 06:44:53 AM
Skript : http://yansima.org/forum/photoplog/index.php?n=2
Referrer : http://yansima.org/forum/admincp/pho....php?do=modify

[calorie]

@nitro: yep, general upgrade where no 'x to y only' is listed, and if you haven't made any PhotoPlog template edits, there's nothing to revert. No problem is asking, good to check.

@mikelbeck, drl2005, Seyfullah, and anyone else having 4.0 versus 4.1 MySQL query issues: the requirements here have been updated. Versions, versions, everywhere...