I plan to update this hack when I have the time, until than I suggest using the only other Affiliate type hack here: https://vborg.vbsupport.ru/showthread.php?t=98646

Hi everyboby hoping someone can help me using 3.5.4 install went fine setup went fine having permisson issues when trying to access the affiliates page.......please help

Just installed on my board and having the same issue.

maybe we should just try a different plugin for affiliates. No blame going out but maybe if we make plugins or mods we should maybe beta test several times on our own machines before releaseing it out with so many problems. Just my 2 cents. i amsure no one cares.

Any Plans for Upgrading this modification?
Can you release version 2?
I would really like to use this modification, but I don't want to mess up my forum.

I tired to uninstall, it left behind the blank tables in the usergroup permissions page along with this error when I try to update any permissions:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '782591',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '49',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '2799583',
`genericoptions` = '30',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '25000',
`arcadepermissions` = '15',
`vbppermissions` = '30097',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '1.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`vbspacecomments` = '0'
WHERE usergroupid=2;

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

Anyone know how to fix this?

I'm on 3.5.4 also and after following all steps I don't get anything in usergroups. Is there a way to fix this yet? If not does anyone know where I could put code in the .php to enable usergroups. I don't mind going in and adding the IDs by hand.

i installed this while ago, then uninstalled. So when trying to re-installed, it errored. So i had to drop tables through CPanel in order to re-install. But now there's no permisissions in Usergroup manager. Ideas?

Now installed on vb 3.6.1, however the same issues appeared on 3.5.4.

Issue 1. In the affiliates admin only the first page of affiliates is showing there should be 22 pages of affiliates.

Issue 2. Similar only the first page of affiliates in decending alphabetical order shows in the forum.

suggestions and help request :D

Seems like a lot of people are getting this error without a fix:

you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.