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

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)

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.

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.

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.

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?

Guess I'll go ahead and uninstall:(

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.

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.

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.

X vBulletin 3.8.12 by vBS Debug 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 (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01115 seconds Memory Usage 1,750KB 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 (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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: