Version: 1.00, by Zachariah
Developer Last Online: Jan 2020
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.
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.
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!
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.
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
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.
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!!??