vb.org Archive - Add PhotoPost Pro to each forum.

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Add PhotoPost Pro to each forum. (https://vborg.vbsupport.ru/showthread.php?t=112105)

Ville

10-07-2007 07:23 AM

Same problem as yotsume. :(

It may have been PhotoPost 6.0 or vBulletin 3.6.8 that broke this add-on since both included substantial database changes.

Is this add-on still being maintained as is suggested by the header? I would also very much like to have this on my forum!

Thanks!

stuartn

11-09-2007 02:41 PM

Quote:

Originally Posted by yotsume (Post 1345181)

I have this installed on vbulletin 3.6.8 and Photopost 6. When the mod is enabled I can not edit forums and get this error: MySQL Error: Unknown column 'ppgcount' in 'field list'
Error Number : 1054

How can I fix this so it runs on my board? When I deactivate the mod I can edit forums again.

Love this mod and need it bad! Thanks!

I too have the same error message coming up - I would love to get it working sooner rather than later.

stuartn

11-09-2007 04:03 PM

Quote:

Originally Posted by Rik Brown (Post 1158438)

Re: Unknown column 'ppgcount' in 'field list'

I came back for a 2nd attempt at installing this very nice mod and found that the plugin xml file simply wasn't adding any of the 4 required columns to our "forums" table.

In our case, the problem was with the ... NOT NULL DEFAULT '' statement which created SQL syntax error messages by mySQL. By removing the DEFAULT '' and running the queries manually (didn't attempt to alter the XML file for which this change should also work) everything is now fine.

FYI, we are running mySQL 5.0.24-standard and vb 3.6.4.

Hope that helps others and thanks to Zachariah for a really neat mod!

Cheers! -- Rik

Thanks Rik,

Did your trick and hey bingo all working a treat.

VViper

11-11-2007 04:10 AM

I just updated to the latest version of Photopost and VB and this modification doesnt work any more.
Is anyone else having the same problem?

It shows the Category but doesnt display any photos. You click on collapse but it doesnt show any photos.

Zachariah

11-11-2007 01:13 PM

I'll need to get access to 6.x Pro's "inc_features.php" file.
- I'll ask Chuck @ photopost to shoot it to me in e-mail.

Majava

11-15-2007 03:49 PM

Would love to use this, downloaded it, tried to install it, but just cannot get rid of that error: 1054. Uninstalling until the bugs are worked out.

EDIT: I dont know enough about all this to go mucking around with SQL queries and the like. Anything that requires such things without step by step instructions an imbecile could understand, I would think constitutes an "incomplete" modification. Not all of us know the ins and outs.

yotsume

12-06-2007 02:59 AM

This was fixed for me by the creator but I just went to install it on my new site and I am back to square one with the same database error. Can anyone post real instructions on how to fix this! ASAP LIKE!

Thanks!

Quote:

Originally Posted by yotsume (Post 1345181)

yotsume

12-06-2007 03:31 AM

Quote:

Originally Posted by Rik Brown https://vborg.vbsupport.ru/external/2011/11/11.gif
Re: Unknown column 'ppgcount' in 'field list'

I came back for a 2nd attempt at installing this very nice mod and found that the plugin xml file simply wasn't adding any of the 4 required columns to our "forums" table.

In our case, the problem was with the ... NOT NULL DEFAULT '' statement which created SQL syntax error messages by mySQL. By removing the DEFAULT '' and running the queries manually (didn't attempt to alter the XML file for which this change should also work) everything is now fine.

FYI, we are running mySQL 5.0.24-standard and vb 3.6.4.

Hope that helps others and thanks to Zachariah for a really neat mod!

Cheers! -- Rik

So how do I alter the product file to get rid of this database error once and for all!!??

popmyzit

12-11-2007 10:56 AM

Quote:

Originally Posted by Zachariah (Post 1380319)

I'll need to get access to 6.x Pro's "inc_features.php" file.
- I'll ask Chuck @ photopost to shoot it to me in e-mail.

Hello Zachariah,
would love to get an update for this great mod.

Any update on this my friend?

thanks again :)

popmyzit

12-11-2007 10:59 AM

Quote:

Originally Posted by VViper (Post 1380144)

yeah have the same... hope Zach come back with the fix :D

yotsume

12-11-2007 05:18 PM

DATABASE ERROR PROBLEM SOLVED!!!

So Zach solved this and it is very easy to fix. The problem is a conflict using MySQL5x database. So all you have to do to fix the database error is on 4 lines add damn zeros!

Edit the product-pp_ppg_cat.xml file.

Change the four lines that have: NOT NULL DEFAULT ' ')");

to: NOT NULL DEFAULT '0')");

Save the file and import!

ALL FIXED!

THANKS ZACH!!!

I think the first post needs to be updated with MySQL5x instructions.

OnTheSideDesign

12-11-2007 06:20 PM

I have this hack and it works great on my forums. Is there a way to have this on the main forums page? Anyone able to get it to work on vBadvanced? Just curious. I really would love it on my main forums. Thanks so much.

yotsume

12-11-2007 11:19 PM

Adding Photopost Pro thumbs to vbadvanced.... There is a module released over at vbadvanced.com for that specifically. There is a separate hack for adding the thumbs to the forum index. It would be nice to have these options all in one mod:

1. thumbs on forum cmps index
2. thumbs on forum index
3. thumbs in any forum
4. thumbs in user profile

I have separate mods for all of these options. All work great. Might be nice to collect the links to each of these hacks which is actually all based on this one and post them in one convenient place.

TomC18

01-11-2008 07:47 PM

Install went okay. I edited the XML file to add 0 to the four NOT NULL DEFAULT ' ', reloaded and all went well. Dabatbase error gone. Edit a forum to display the film strip for one of the categories and not show other than a collapsable area. I tried the fix in post 67 but that did nothing.

Has there been any fix for this or understanding as to what is going on?

TomC18

01-14-2008 06:32 PM

Just checking back.

TomC18

01-18-2008 11:12 AM

Anyone?

TomC18

01-24-2008 06:08 PM

Guess I'll go ahead and uninstall:(

styleforum

01-31-2008 02:25 AM

I'm running Photopost 6.0 and vb 3.6.4 and just got this all working after some struggling.

I tried it by the instructions, and after putting values in to a forum's settings, I got the "ppgcount" database error msg.
I tried changing the NOT NULL DEFAULT '' to NOT NULL DEFAULT '0' and got the error message.
I added the tables manually in phpMyAdmin and it worked.

So I uninstalled it and edited the .xml file. I took out the 4 DEFAULT '0' statements entirely. Saved it, imported it, did the settings, and it showed up just like it was supposed to.

So, if you are having this problem, despite the DEFAULT '' solution, try DELETING all the DEFAULT '''s out of your xml file, and installing (with overwrite to yes).

Example: change

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (ppgcount smallint(6) NOT NULL DEFAULT '')");

to:

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (ppgcount smallint(6) NOT NULL)");

For all 4 lines that look like that. Then reimport.

BTW, those who are getting empty gallery areas, did you check the numbers you're putting in the category field? The number of the categories with stuff in them, despite the examples (1,10,20), is likely to start with 500 and up. my categories 1 and 2 have nothing in them, and then the next one is 500, 501, and so on. You may just be putting category numbers with nothing in them. You have to pull the category numbers not from the "sort order" numbers in the admin thing, but from the URL for the category view. It will be http://www.yoursite.com/yourPPinstal...llery.php/cat/515 or similar.

Try putting 500,501,502 into that category box and see if that fixes your blank thumb area problem.

Edit: I just tried putting 1,2,3,4 into my category box and I got an empty thumb gallery too.

styleforum

01-31-2008 03:55 AM

Another hack for this I added - it puts the image title in as ALT text for each pic (actually, for the overlay gif that makes the rounded border, but still, it will link that alt text to the actual showphoto page). Maybe good for SEO? Not sure. Anyway, I wanted it. The php already had the query for the image title, whether you are displaying it or not, so I don't think it adds any db overhead. But I'm not an expert.

In inc_vbcat.php:

find:

Code:

    if ( pp_is_image($photo) ) {        

        $temp_user = $puserid;

        

        if ( $height > $width )

            $sthumb = "<img src=\"{$url_path}/images/overlay-roundp.gif\" height=\"105\" width=\"81\" border=\"0\" alt=\"\" />";

        else

            $sthumb = "<img src=\"{$url_path}/images/overlay-round.gif\" height=\"81\" width=\"105\" border=\"0\" alt=\"\" />";

add what's in bold:

Code:

    if ( pp_is_image($photo) ) {        

        $temp_user = $puserid;

        

        if ( $height > $width )

            $sthumb = "<img src=\"{$url_path}/images/overlay-roundp.gif\" height=\"105\" width=\"81\" border=\"0\" alt=\"{$ptitle}\" />";

        else

            $sthumb = "<img src=\"{$url_path}/images/overlay-round.gif\" height=\"81\" width=\"105\" border=\"0\" alt=\"{$ptitle}\" />";

That's it.

I also changed the template so it reads "Random Images from the Gallery" instead of the name of the forum you're in. Just edit forumdisplay_ppgallery (under forum display templates) and change $foruminfo[title] to whatever you want.

TomC18

01-31-2008 10:33 AM

Quote:

Originally Posted by styleforum (Post 1432872)

BTW, those who are getting empty gallery areas, did you check the numbers you're putting in the category field? The number of the categories with stuff in them, despite the examples (1,10,20), is likely to start with 500 and up. my categories 1 and 2 have nothing in them, and then the next one is 500, 501, and so on. You may just be putting category numbers with nothing in them. You have to pull the category numbers not from the "sort order" numbers in the admin thing, but from the URL for the category view. It will be http://www.yoursite.com/yourPPinstal...llery.php/cat/515 or similar.

Try putting 500,501,502 into that category box and see if that fixes your blank thumb area problem.

Edit: I just tried putting 1,2,3,4 into my category box and I got an empty thumb gallery too.

Thanks styleforum, I do have the correct categories entered yet still have the problem.

styleforum

01-31-2008 03:13 PM

Hm, then I don't know if I can help you. I'm not much of an expert, just did some poking around. You might consider looking at your DB with phpMyAdmin and checking the forum table to see that the 4 fields are in there right, and then the pp_ tables to see that stuff looks right in there. It's all pretty logical if you look at the php for this mod for the field names and stuff.

TomC18

01-31-2008 03:48 PM

I got it. I uninstalled VBGallery, which was disabled as I now use photopost pro, and it started working.

styleforum

01-31-2008 09:54 PM

Great!

CallieJo

02-26-2008 10:36 PM

Got it working with vb3.7 beta 5 and the newest version of pp after a bit of tweaking from helpful info located in this thread.

The last thing that I had to do was to put my database name and pass on line 26 of the file instead of keeping the variables there.

As for getting blank nothings, I had put my url instead of the path to gallery in the main plugin. Putting the path solved the blank nothings.

Just wanted to note that it does work with the current vb beta and pp.

Thanks for this mod.

I'd love to get the stats (total number of photos) in the stats area on forumhome. I tried 2 hacks from photopost.com without any luck at all. If anyone comes up with this, please let me know as it's much needed. Also needed for classifieds & reviews as well...so please keep that in mind also. Just- stats: total# for each pp script on forumhome. Thanks.

CallieJo

03-21-2008 08:21 PM

I have this working perfectly for standard vb forums (on 3.7 beta 6).

However, when I try to enable it for GARS based forums it doesn't show.

I looked at forumdisplay and GARS_forumdisplay to see if I needed to add something to make it work in GARS templated forums but cannot find anything related to this Photopost product.

Is there something I can add to the GARS forumdisplay to make this work?

Thanks*

EDITED:

I found that if I add the forumdisplay_ppgallery template code in the gars forumdisplay below the navbar thingie that it will work. Is this wise?

stuartn

04-21-2008 12:09 AM

I have found that no matter which category I put in, unless its the top parent of 500 nothing will show. My category for my gallery is 520 but nothing shows at all under this. Is thier a fix at all or is it how its meant to work.

we_scooter

08-09-2008 07:44 AM

How to add spicific PICTURe from the gallery to the header or navbar to be the photo of the Day choosen by me .. admin ?

tommyxv

09-06-2008 06:29 PM

Running vb 3.7.1 and PP 6.11. I have the blank collaspable box with no photos in it. And fixes for this? Tried everything I seen posted here already.

tommyxv

09-06-2008 07:28 PM

FYI: when you put the full path to the inc_vbcat.php in the global start plugin, you get a blank page. If you put the full URL to it or just leave it blank, you'll get the the collapsable box with no pics. So putting the url in instead of the path is NOT correct. Have to fix the blank page using the full path. It is trying to work when doing it that way.

tommyxv

09-07-2008 08:23 AM

Any fix for this? Not working on vb 3.7.x and photopost 6.11. :(

tommyxv

09-08-2008 07:11 PM

Bump, any one?? I talk to Chuck over at PhotoPost and he said the inc_features.php hasn't changed since 5.x so it's vB 3.7x that is breaking this. Any help would be great!

Thanks

tommyxv

09-10-2008 02:20 AM

Bump....PLEASE help me to get this to work with vb 3.7 and pp 6.11. Thanks

tommyxv

09-12-2008 12:55 AM

bump...anyone?

tommyxv

09-14-2008 10:48 AM

bump....can someone get this to work with vb3.7 please. Thanks.

Zachariah

09-14-2008 12:37 PM

I do not have the time @ the moment or access to the software to work on an update.
I created this hack based on access to a clients system I had with PRO installed.

tommyxv

09-14-2008 06:19 PM

ok.

PimvanJ

07-18-2009 11:58 AM

Quote:

Originally Posted by tommyxv (Post 1616055)

Running vb 3.7.1 and PP 6.11. I have the blank collaspable box with no photos in it. And fixes for this? Tried everything I seen posted here already.

Have You set the correct $pp_db_prefix in config-int.php?
I run 3.7.3 and PP 6.1 without any problem.

CallieJo

01-09-2010 12:59 AM

Any update for 4.0 coming? Pretty please... - willing to pay Zachariah.

Ricsca

06-30-2012 09:27 AM

Upgrade for vb 4 plase ;)

All times are GMT. The time now is 07:14 PM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01490 seconds Memory Usage 1,832KB 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 (4)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (39)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
Messages: