Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Add PhotoPost Pro to each forum. Details »»
Add PhotoPost Pro to each forum.
Version: 1.00, by Zachariah Zachariah is offline
Developer Last Online: Jan 2020 Show Printable Version Email this Page

Version: 3.5.4 Rating:
Released: 04-03-2006 Last Update: Never Installs: 43
DB Changes Uses Plugins Template Edits
Additional Files Translations  
No support by the author.

/* ----------------- 4/03/2006 4:37PM -----------------
Add PhotoPost Pro to each forum.

This hack will allow you to fill-in catagories from Photopost Pro to display in a film strip format under the $navbar. This will show in every thread of the forum as well.

1 querry
  • 1 template
  • 4 Fields
  • 1 file upload
  • 3 plugins
  • 5 phrases

Tested on:
  • vBulletin 3.5.4
  • PhotoPost Pro 5.21


Each forum extra options:


- Image Count:
(How many images would you like to show ?)

- Image Order:
(Enter 1 for newest, 2 for most viewed, 3 for most comments, 4 for highest rated, 5 for random.)

- Select Catagory(s):
(Here you can list catagories you wish to show images from. EX: 1,10,20)

- Show Imagebit:
(Title, Description, Rating, Username, Views, Dimensions, and more.)

+-+-+-+-+-+-+-+-+-+-+-+-

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #82  
Old 10-07-2007, 07:23 AM
Ville's Avatar
Ville Ville is offline
 
Join Date: Sep 2003
Location: North Texas
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #83  
Old 11-09-2007, 02:41 PM
stuartn stuartn is offline
 
Join Date: Apr 2006
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by yotsume View Post
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.
Reply With Quote
  #84  
Old 11-09-2007, 04:03 PM
stuartn stuartn is offline
 
Join Date: Apr 2006
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Rik Brown View Post
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.
Reply With Quote
  #85  
Old 11-11-2007, 04:10 AM
VViper VViper is offline
 
Join Date: Dec 2002
Location: Down Under
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #86  
Old 11-11-2007, 01:13 PM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #87  
Old 11-15-2007, 03:49 PM
Majava Majava is offline
 
Join Date: Jun 2006
Location: East Sussex, England
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #88  
Old 12-06-2007, 02:59 AM
yotsume's Avatar
yotsume yotsume is offline
 
Join Date: Dec 2006
Posts: 844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 View Post
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!
Reply With Quote
  #89  
Old 12-06-2007, 03:31 AM
yotsume's Avatar
yotsume yotsume is offline
 
Join Date: Dec 2006
Posts: 844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Rik Brown
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!!??
Reply With Quote
  #90  
Old 12-11-2007, 10:56 AM
popmyzit popmyzit is offline
 
Join Date: Jun 2006
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Zachariah View Post
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
Reply With Quote
  #91  
Old 12-11-2007, 10:59 AM
popmyzit popmyzit is offline
 
Join Date: Jun 2006
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by VViper View Post
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.
yeah have the same... hope Zach come back with the fix
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:05 AM.


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.07024 seconds
  • Memory Usage 2,315KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete