Database error in vBulletin 4.0.2:

Invalid SQL:
UPDATE forum SET
title_clean = 'thread',
title = 'thread',
description_clean = '',
description = '',
link = '',
displayorder = 1,
parentid = -1,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options, options + 16),
options = IF(options & 32, options - 32, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options - 8192, options),
options = IF(options & 4, options - 4, options),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options - 64, options),
options = IF(options & 128, options - 128, options),
options = IF(options & 512, options - 512, options),
options = IF(options & 1024, options - 1024, options),
options = IF(options & 2048, options - 2048, options),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
accessf_nb = 0,
accesst_nb = 0,
create_nb = 0,
reply_nb = 0,
linkview_nb = 0,
linkpost_nb = 0
WHERE forumid = 10;

i can't edit forum manager ... and got that eror .. after i disable this mods i can edit forum manager too ...

am i wrong ..

P.s
i use kbank product too and i dont get that eror ...

Try to Uninstall/Re-install/Re-set options.

Great tool. Installed. Thanks

Thanks for great mod which I really want. Installed.

is there a possibility to get options for the CMS - to read articles for example and something else ?! that would be great

Great

Is there a way to just disallow viewing images?

BUG REPORT FOR VB4.0.3:

When this addon is enabled it throws up a SQL DB error when you try to change yes/no to the following Forum option:

Forum is Open (Set this to 'No' to prevent any new posts being made in this forum)

It's definitely this addon as it works fine if you disable the addon!

I also found that any change to my forums through the Forum Manager resulted in the "Unknown column 'accessf_nb' in 'field list'" database error.

However, as suggested by Valter above, I uninstalled the mod - reinstalled it and redid my settings and all's well.

@Valter - just one suggestion/request.

I use your advanced forum permissions mod to restrict access to my classifieds sections (minimum post count of 10) and and your advanced forum rules mod to force people to be aware that they must use the templates provided when placing an ad.

Just now when testing the new install with a dummy user, I first had to read then agree to the classifieds rules - then after I'd agreed to them I was hit with with notice that I didn't have enough posts to use the classifieds.

If I were a standard user that would have irritated me (a lot) - is there any way to make the permissions mod execute before the rules mod?

Thanks for your work - very cool mods. :up:

Mike

Change plugin execution order.

Example:
- Advanced Permissions = 5
- Rules = 6

Any fix for the reported bug for the VB4.0.3?
This is a must have MOD for me, but I'm using VB4.0.3 and I'm not a tech-php guy. :-(

What bug?

zelnik,

what db error?

Ensure that you have no two instances of this product installed (vB4 one + old one for vB3 with 'Cyb' prefix).

new settings compared to 3.8 version are awesome!

is there any way to disable blog posting based on post count?

thanks ...

I have uninstalled the vb3 version before installing the vb4 version if that's what you mean?

The following is the SQL error:

Database error in vBulletin 4.0.3:

Invalid SQL:
UPDATE forum SET
title_clean = 'Latest News & Sport From Espana',
title = 'Latest News & Sport From Espana',
description_clean = 'The latest news headlines.',
description = 'The latest news headlines.',
link = '',
displayorder = 1,
parentid = 49,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options, options + 32),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options - 2, options),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options, options + 256),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
vbseo_moderatepingbacks = 1,
vbseo_moderatetrackbacks = 1,
vbseo_moderaterefbacks = 1,
accessf_nb = 0,
accesst_nb = 0,
create_nb = 0,
reply_nb = 0,
linkview_nb = 0,
linkpost_nb = 0,
enable_recipe = '0'
WHERE forumid = 33;

MySQL Error : Unknown column 'accessf_nb' in 'field list'
Error Number : 1054
Request Date : Wednesday, April 21st 2010 @ 07:47:25 PM
Error Date : Wednesday, April 21st 2010 @ 07:47:25 PM
Script : http://www.mysite.com/forum/admincp/forum.php?do=update
Referrer : http://www.mysite.com/forum/admincp/...o=edit&f=33&s=
IP Address : 7x.xx.xx.xx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.45-log

You may uninstalled old version AFTER installing new one for vB4, as you are missing database field required by this product to work properly.

If it's not big problem for you uninstall/re-install product to re-create required fields.

I had the same database error as the others in this thread, but I can confirm that uninstalling and reinstalling fixed this.

Valter, I need to add permissions described here:
https://vborg.vbsupport.ru/showthread.php?t=240124

Could you please tell me what you think?

v5.1 - May 02. 2010.
-Fixed: LPI hidden for excluded groups
-Fixed: Upgrade errors (vB3.x to vB4.x)
-Fixed: Some PHP errors, and minor bugs

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

Note:
-There are important changes in this version, please upgrade soon

wow. nice mod. thank you

Strange that? After installing this hack, the forum does not accept attachments larger than 3Mb up.

Someone had this problem?
I await news. Sincerely

After the new update, the option still doesn't work. halp.

Man, after the new update, the restriction not working. Please check it again. THANK yOU!

^ same for me too

tanxx for upgrade Valter

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO forum
(title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, imageprefix, password, vbseo_moderatepingbacks, vbseo_moderatetrackbacks, vbseo_moderaterefbacks, vsa_ap_viewforum, vsa_ap_viewthread, vsa_ap_postthread, vsa_ap_postreply, vsa_ap_viewlink, vsa_ap_postlink)
VALUES
('Medal of Honor', 'Medal of Honor', '', '', '', 8, 128, -1, 'lastpost', 'desc', 0, '', '', 97991, 0, '', '', 1, 1, 1, 0, 0, 0, 0, 0, 0);

MySQL Error : Unknown column 'vsa_ap_viewforum' in 'field list'
Error Number : 1054


What is wrong with this new version?

My forum table shows that these columns don't exist in the forum table. Why werent they made?

I will attempt to uninstall and reinstall. Hate redoing all the setting again though :(

Great mod. Thank you!

A suggestion for the next release: How about the ability to restrict the creation of blog entries by post count. I have found that many of my new members, incorrectly create a blog entry when a forun post was actually required. The simple solution would be to restrict blog creation to members with more than x number of posts.

Thanks again

yes. very true.

It works fine til updated to vBulletin 4.0.3

Same error as above
MySQL Error : Unknown column 'vsa_ap_viewforum' in 'field list'

tagged

im having some problems with it, everything works fine except users (with 32 post for example) can send messages privates even when i put that minimum is 50... using 4.0.3

I would like to use this mod to reduce SPAM. Spammers register manually and then post links. I can see that this mod could be used to prevent link posting for users with less that x posts. However, what I'd like to know is how the mod identifies a link. Does it use a regex to match elements in a string or will it just spot the link BBCode?

was waiting for this one, thanks.

are you planning to get it work in 4.0.4?

As I know it does work in 4.0.4.

What part you have problems with?

Installed ;) Thanx Valter.

I to can confirm that this is not working with 4.0.4 I've set it to where people need 75 posts to view a forum, however using a puppet account, I saw the forum without 75 posts, same issue with guests posting links. I can confirm that this did work before 4.0.4 as I do regular testing and I can assure you that it is no fault of my own but rather the fault of this addon.

confirm not working with 4.0.4

I have this mod enabled as well.. the PM option is set by default must have 15 posts before you can private message.. but i created test user with zero posts and i am able to send PM's still :( i am using version 4.0.4.

I've tested the pm system. It is working as it should (fresh install of product on a 4.0.5 board).

For those having trouble...make sure you click either the "For Individual Forums | For All Existing Forums" to set up the permissions properly.