Usershare VB stats dissapear

[Cleenee]

Gday, I just installed the VB usershare and it works terrific, the stats on the forum index have a problem though...the forum members and active members read 0 after the mod..any ideas?

[Cleenee]

When I make a new vbulletin user the stats return to normal, then dissapear again when a new classifieds user registers

[Eric Barnes]

I had a look in the mod_user file and it is supposed to inserting the new user in the datastore table.

However maybe their system uses something else to pull that data or maybe has some type of caching. I will have to research it.

[philoo]

I personnaly use vBuserhare, but I choose that vBulletin registering system is master.

In fact, my 68C customers can login 68C only if they are active members on vBulletin portal. I disabled registering system of 68C ...

In this situation, the module never write anything in vBulletin database. So I do not meet the problem described by Cleenee

[Cleenee]

Yeah this seems to of started a number of issues, people are now reporting database problems..cannot access User CP and private messages etc, this is the error

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT COUNT(*) AS total, folderid
FROM pm AS pm
WHERE userid = 2
GROUP BY folderid;

MySQL Error : Unknown column 'folderid' in 'field list'
Error Number : 1054
Request Date : Saturday, October 25th 2008 @ 01:35:26 AM
Error Date : Saturday, October 25th 2008 @ 01:35:26 AM
Script : http://www.#########.com/forum/private.php
Referrer : http://www.##########.com/forum/prof...=editsignature
IP Address : ###.###.###.#
Username : #######
Classname : vB_Database
MySQL Version : 5.0.51a-community

[Eric Barnes]

The vb mod from us does not edit any tables in vb. It only selects data from them and inserts when a user joins.

[Cleenee]

Thanks for the info...somehow somehting changed somewhere though I hired a MySQL expert through scirptlance to fix the problem...which he did in about 30 minutes, I asked him what the issue was and his reply was

cheers
Colleen

[philoo]

It seems you use the same database for vBulletin and 68Classifieds.
Personnaly, I use two separated databases