vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Major Additions - PhotoPlog: The Lite Gallery (https://vborg.vbsupport.ru/showthread.php?t=101368)

allstar55 12-14-2005 11:50 AM

Quote:

Originally Posted by calorie
Is it a timeout after 15 minutes?

everytime when i visit this url in browser or with an extern link,
i'm logged out http://www.nfs-center.de/showroom/

when i use than the vb navbar to the forum startpage and come back,
i'm logged in. Only after a visit from the forum startpage, i'm logged in.

I think it's a timeout in 15 min or faster, showroom sets no coockies, i don't know.

calorie 12-14-2005 12:26 PM

When visiting showroom directly as guest, I get the following cookies set (see attachment). Does this only happen to you as admin, or is it happening to everyone on your board?

wrang 12-14-2005 12:42 PM

Great now it works nearly
What is this error about?
Sorry, wrang: Bad Open

I haved set the permission to 100000Bytes and i test with a file witch is 80000Bytes
The file is a *.jpg file

calorie 12-14-2005 12:57 PM

See post three in this thread. It lists common onscreen errors.

wrang 12-14-2005 05:36 PM

Quote:

Originally Posted by calorie
See post three in this thread. It lists common onscreen errors.

Thanks i have the image map on 777 but it still came up

nitro 12-14-2005 06:20 PM

Hi Just wondering on the update what to follow.

Currently on 1.0.2.3

Should I follow the 1.0.2.3 to 1.0.3 instructions for a 1.0.2.3 -> 1.0.3.1 or run through both 1.0.2.3 -> 1.0.3 and 1.0.3 -> 1.0.3.1 ?

The Ottoman 12-14-2005 06:53 PM

I like the idea behind this mod and have just one question.

When I install PhotoPlog, can I configure it so that the actual images are hosted on a different server? If so, is the connection done via FTP or HTTP?

allstar55 12-14-2005 08:48 PM

Quote:

Originally Posted by calorie
When visiting showroom directly as guest, I get the following cookies set (see attachment). Does this only happen to you as admin, or is it happening to everyone on your board?

Same problem with registered users. I've test it with an new useraccount, click showroom 2x after 30min.

calorie 12-14-2005 09:23 PM

@wrang: the 'bad open' message happens when the PHP fopen() call fails. It's either a permission or ownership issue. Are you running PHP in safe mode by chance?

@nitro: in the v.1.0.4 zip, look about 2/3 the way down the README.txt file to find general upgrade instructions, so you don't have to do all the steps to upgrade.

@The Ottoman: to view, upload, etcetera a user needs permission, which is embedded in bitfields, so while the call is HTTP, PhotoPlog is 'same server' written.

@allstar55: not sure why the issue; what happens if you stick the showroom link directly into your vB navbar, using format like in the second post of this thread?

FYI: PhotoPlog updated to v.1.0.4, guess some new screens are in order. :dead: ;)

allstar55 12-14-2005 09:53 PM

I use this:
Quote:

<a href="http://www.nfs-center.de/showroom/index.php$session[sessionurl_q]" class="alt1Active">Showroom</a>
I have no idea why i'm logged out from showroom after 15-30min.

calorie 12-14-2005 11:20 PM

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 12-15-2005 12:11 AM

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

Code:

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 12-15-2005 12:35 AM

What version of MySQL are you using?

mikelbeck 12-15-2005 12:45 AM

Quote:

Originally Posted by calorie
What version of MySQL are you using?

4.0.25 Standard.

calorie 12-15-2005 12:52 AM

Are you able to upgrade to >= MySQL 4.1?

mikelbeck 12-15-2005 01:03 AM

Quote:

Originally Posted by calorie
Are you able to upgrade to >= MySQL 4.1?

No, not at this time.

nitro 12-15-2005 01:40 AM

@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 12-15-2005 03:30 AM

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 12-15-2005 03:47 AM

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 12-15-2005 04:13 AM

@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... ;)

nitro 12-15-2005 05:51 AM

K a final update Q is the vb 3.5.2 a more specific requirement now or was it allways like that but should be ok in 3.5.0 upwards.

And as I am sure others are wondering aswell as myself but is this product leading upto a final as is supported Lite product, where by there will be also a pro version that isnt freely available ? I ask because at the rate it is currently going its awsome and I am thinking of discussing with my site a donation, wont be huge as we are just a hobby site with not a lot of action really, but it would be a little something towards the inspiration, but if theres an impending pro at a reasonable price then more would need looking @ before making a funds decision.

StarBuG 12-15-2005 06:50 AM

Any chance that you will add a changelog to the file and/or to the thread?

Bugs/Problems:

1) the # is missing in the letter bar
2) If you click on a letter which contains no data you get "Not Available" but the colspan is missing 2 tables

Questions:
1) Would it be possible to rate pictures without writing a comment?

allstar55 12-15-2005 09:08 AM

I must change the cat_bit on the top:

<td class="alt1" width="100%">
to:
<td class="alt1" width="50%">

It was to wide. Please change the code in the next version.

And please set max. types in upload title an comment.
When useres type a lot of, file list information looks bad.

utw-Mephisto 12-15-2005 09:10 AM

What is the big difference between 1.0.3 and 1.0.4 ?

allstar55 12-15-2005 09:13 AM

Quote:

Originally Posted by utw-Mephisto
What is the big difference between 1.0.3 and 1.0.4 ?

See the news Screenshots

mikelbeck 12-15-2005 12:47 PM

Quote:

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

Ok, I guess I'll just have to wait until you "divide up the queries"...

Thanks for the effort!

While I'm waiting, is there someplace where I can download the 1.0.3 version?

calorie 12-15-2005 03:31 PM

@nitro: continued development is based on having vB 3.5.2. vB 3.5.1 and 3.5.0 may be okay too, but not personally tested. Regrading pro versus lite, I've been pondering the question but don't have a good answer. My short term goal, time permitting, is to get the remaining features in PhotoPlog for which there are ACP options. My long term goal is not well-defined, though I understand the donation dilemma. Maybe a way to handle that is to offset price based on donation amount, should a pro version be released, though that might be trouble if donation amount is more than price.

@StarBuG: a small changelog has been added to the release post. Next release should get the Bugs/Problems you list. Right now rate/comment are one, maybe they should be two, will think more on this.

@allstar55: lol, wide box. In PhotoPlog's functions.php file look for $max_len = 5000; and set to a lower number to truncate descriptions on file list.

@mikelbeck: 1.0.3 is out, 1.0.4 is in, but sorry for the wait, it shouldn't be too much longer.

mikelbeck 12-15-2005 04:48 PM

Quote:

Originally Posted by calorie
@mikelbeck: 1.0.3 is out, 1.0.4 is in, but sorry for the wait, it shouldn't be too much longer.

Ok, I'll wait then. Thanks!

nitro 12-15-2005 07:26 PM

Well updated to 1.0.4 in vb 3.5.0 and seems like all is good :)

I still cannot get vbportal left column and the quick link switcher for the portal left column to display. Iv tried adding the extra globals in both places now and nothing, the Quick links doesnt even get the slightly visible empty table at the bottom that would normally have the on/off link like it did in the arcade.

Any other ideas on this ?

Aside from that as usual great stuff, ratings and comments work, tho I agree with what someone else I think said earlier, users should be able to rate without commenting.

StarBuG 12-15-2005 07:47 PM

Do you plan to add the WOL?
Would be cool

lordnex 12-15-2005 08:15 PM

Gah .. i seem to have the database problem others have.

vBulletin 3.5.1:

Invalid SQL:
SELECT *,
(SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 1) 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 = 1) AS ave
FROM photoplog_ratecomment
WHERE fileid = 1
AND moderate = 0
ORDER BY dateline DESC
LIMIT 1;

MySQL Error : You have an error in your SQL syntax near 'SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 1) AS num,
' at line 2
Error Number : 1064
Date : Thursday, December 15th 2005 @ 02:05:53 PM



I checked the "view PHP info" in the admin CP to check on what version of mysql and it's 3.23.58 according to the print out. It's a unix system from what I understand and my webhosts seem to be twits at times. I fear asking them to upgrade the version ... :D
It worked up to the categories before, just installed the 1.0.4 patch and got this error. Yay for outdated computers!

lordnex 12-15-2005 08:17 PM

Oh.. also, will we be able to, in the future, restrict categories based on usergroups? So we can make a category that specifically is forbidden to everyone but one or two groups of users?

calorie 12-16-2005 10:23 AM

@nitro: you need to do the globals thing, plus use the variable in a PhotoPlog template if said variable is not part of your vB header, navbar, or footer already.

FYI: PhotoPlog 1.0.4.1 released: divided queries, template changes, pound in letter bar, who's online, not sure what the future holds. See the README.txt in the new ZIP archive for upgrade instructions.

StarBuG 12-16-2005 10:47 AM

Thank you.

Works great

descriptions for the tcat bars would be cool.
For memberinfo and the 5 random pics in the photoplog index ;)

allstar55 12-16-2005 10:53 AM

Quote:

Originally Posted by calorie
@nitro: you need to do the globals thing, plus use the variable in a PhotoPlog template if said variable is not part of your vB header, navbar, or footer already.

FYI: PhotoPlog 1.0.4.1 released: divided queries, template changes, pound in letter bar, who's online, not sure what the future holds. See the README.txt in the new ZIP archive for upgrade instructions.

Updatet:
http://www.nfs-center.de/showroom/index.php

Please make in next version in File List Information only ~30 characters, rest with ....
In Upload Area, max kb filesize specify for users.

Bugs:
I can't see not all stars full.


otherwise nice work :)

mikelbeck 12-16-2005 10:54 AM

Works great! Thanks!

calorie 12-16-2005 01:00 PM

@allstar55: what browser are you using (see attachment)?

Sinistra 12-16-2005 01:21 PM

I am having a problem with the admin CP adding catagories. my Vb version is 3.5.2

lordnex 12-16-2005 02:55 PM

Works fantastic now except any comments that I place say "Not Available" .. any ideas on that one?

calorie 12-16-2005 03:00 PM

@Lord Katsuhito: what type of problem, or perhaps a screenshot might help?

@lordnex: check category and user permissions for allowing/viewing comments.


All times are GMT. The time now is 10:47 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02483 seconds
  • Memory Usage 1,831KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete