Try the changes I needed... (they are posted)

I am curious if this code is on the correct hook?

This looks like a lot of work to be attached to Global start!

I moved mine to ForumHome_start and it works fine and this code is not getting executed with every page view on the site anymore!

Thanks for the suggestion Quarterbore, but that didn't work. I'll just uninstall it for now and watch the thread for future releases, ot other solutions.

Thanks again!

Yes it's not working in 3.6.2

I get the same error.

Ok, I've done some major troubleshooting tonight folks.

It seems as though by making the changes that jgommel & I have come up with, it does solve ALL issues. I actually did a series of tests.

• Installed 3.6.2 vbulletin WITH NO TABLE PREFIXES (Fresh Install), then installed the hack. Worked flawlessly.
  
• Installed 3.6.2 vbulletin WITH TABLE PREFIXES (Fresh Install), then installed the hack, and got database errors.

So the issue lies with all you guys who have table prefixes configured in your database, via the config.php file.

I then made the above changes to my XML product, reimported and it worked fine. This hack WILL work on 3.6.1 & 3.6.2. If it's not, you have some sort of special case, which I can examine further via PM.

Thanks again! ;)

I'll ask again... Why do you have this hooked off Global Start? This is only used on ForumHome, right? It seems crazy to run this on every page users visit when it is only needed on that one page!

It works fine on my site relocated to ForumHome_start!

seems as though that might be a small bug. If it works on forumhome_start then that should be the preferred method. I'll have to update the zip file

I had the same problem with everybody, but changing it as per the post fixes it

Since it's at global, I can use it on a vbadvanced page right, providing I put the variable in the vba globals?

Ok everyone,

I've updated the XML file with the SQL bug fixes, and put it a more suitable hook location.

Please download the above zip file ( latest paid subscribers 1.1 update.zip )

how would I go to make message appears on vbadvanced?

Now I've never created a vbadvanced module before, so bare with me. However, below is the module I created. I've tested and it seems to work on my forums. Just follow the directions and hopefully it will work for you too. ;)