[ellinofatsa]

Database error in vBulletin 4.1.10:

Invalid SQL:

UPDATE user
SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
OR FIND_IN_SET(6, membergroupids) OR FIND_IN_SET(23, membergroupids)
OR usergroupid IN(6,23), '1', '0');

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

[DragonByte Tech]

Originally Posted by Kat-2

Can't seem to get the leaderboard to populate. Any ideas, what am I missing? Everything else seems to work just fine. Love the mod.

If the profile stats work then the leaderboard should work too, could you check that?

Originally Posted by ellinofatsa

Database error in vBulletin 4.1.10:

Invalid SQL:

UPDATE user
SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
OR FIND_IN_SET(6, membergroupids) OR FIND_IN_SET(23, membergroupids)
OR usergroupid IN(6,23), '1', '0');

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

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

For some reason, certain MySQL installations have problems creating ENUM columns. I've never been able to figure out why.


Fillip

[ellinofatsa]

Originally Posted by DragonByte Tech

If the profile stats work then the leaderboard should work too, could you check that?

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

For some reason, certain MySQL installations have problems creating ENUM columns. I've never been able to figure out why.


Fillip

thank you you!!
if you can sey were i found that code for edit.

[Kat-2]

Originally Posted by DragonByte Tech

If the profile stats work then the leaderboard should work too, could you check that?




Fillip

The only user showing up is the only user who has joined since installing the mod. He received 2 visitor messages and fleshed out his profile, which is how he earned the points. Here are some screenshots. One is of the leaderboard, the other is for the activity info inside of my profile.

What have I done wrong?

[DragonByte Tech]

Originally Posted by ellinofatsa

thank you you!!
if you can sey were i found that code for edit.

Sorry, I don't understand what you're asking

Originally Posted by Kat-2

The only user showing up is the only user who has joined since installing the mod. He received 2 visitor messages and fleshed out his profile, which is how he earned the points. Here are some screenshots. One is of the leaderboard, the other is for the activity info inside of my profile.

What have I done wrong?

Try running the Recalculate Points maintenance option in the vBActivity AdminCP maintenance menu


Fillip

[MarceloS]

Hello Fillip. Your mod looks pretty good.

Any way to import awards from "Yet Another Awards System" ?

Also, do you have a link-free option?

[DragonByte Tech]

As per the first post, the Pro version comes with a YAAS importer

There is a "Branding Free" option on our website - vb.org rules prevent us from direct linking to it, however. It should be easily available from the product list on the front page


Fillip

[Kat-2]

Originally Posted by DragonByte Tech

Try running the Recalculate Points maintenance option in the vBActivity AdminCP maintenance menu


Fillip

Done that quite a few times. The screenshots were taken....2 days? Something like that, after I had run it for the third or fourth time.

I'm at a loss.

[Kat-2]

BTW, just recalculated again. Still only showing the two users who have joined since mod was installed.

[DragonByte Tech]

Originally Posted by Kat-2

Done that quite a few times. The screenshots were taken....2 days? Something like that, after I had run it for the third or fourth time.

I'm at a loss.

Originally Posted by Kat-2

BTW, just recalculated again. Still only showing the two users who have joined since mod was installed.

Do you have any cache systems on your server? Under normal circumstances what you describe is impossible - there have been no reports of the recalculate failing to populate stats if it has completed successfully with no errors.


Fillip

[Kat-2]

Originally Posted by DragonByte Tech

Do you have any cache systems on your server? Under normal circumstances what you describe is impossible - there have been no reports of the recalculate failing to populate stats if it has completed successfully with no errors.


Fillip

Honestly I don't know, nor do I know how to find out. Any suggestions?

[DragonByte Tech]

Try checking PHP Info for any references to XCache, Memcached or APC.


Fillip

[spencerp]

I'd like something like this, but does it suck up database space? I don't want to install something that takes up almost another half of database size worth ..

[DragonByte Tech]

It does not.


Fillip

[Kat-2]

Originally Posted by DragonByte Tech

Try checking PHP Info for any references to XCache, Memcached or APC.


Fillip

There is no caching. The mod works perfectly, other than the Leaderboard...which only works if someone new joins the forum. Makes no sense to me, and I do not know what to do to fix it.
Do not know what would pull in posters to the Leaderboard.
Seems like the SQL query is not parsed correctly.