vb.org Archive
Page 70 of 94 « First 20606869 70 717280 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - [DBTech] vBActivity & Awards v3 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=236973)

ellinofatsa 02-13-2012 07:52 AM
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 02-13-2012 03:41 PM
Quote:
Originally Posted by Kat-2 (Post 2298629)
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?

Quote:
Originally Posted by ellinofatsa (Post 2299175)
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
Code:
ALTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0','1') DEFAULT '0'
For some reason, certain MySQL installations have problems creating ENUM columns. I've never been able to figure out why.


Fillip

ellinofatsa 02-13-2012 06:52 PM
Quote:
Originally Posted by DragonByte Tech (Post 2299290)
If the profile stats work then the leaderboard should work too, could you check that?


Code:
ALTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0','1') DEFAULT '0'
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 02-13-2012 07:43 PM
1 Attachment(s)
Quote:
Originally Posted by DragonByte Tech (Post 2299290)
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 02-16-2012 03:10 AM
Quote:
Originally Posted by ellinofatsa (Post 2299349)
thank you you!!
if you can sey were i found that code for edit.
Sorry, I don't understand what you're asking :(

Quote:
Originally Posted by Kat-2 (Post 2299367)
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 02-16-2012 11:56 AM
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 02-16-2012 03:19 PM
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 02-16-2012 09:46 PM
Quote:
Originally Posted by DragonByte Tech (Post 2300125)

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. :confused:

Kat-2 02-16-2012 10:47 PM
BTW, just recalculated again. Still only showing the two users who have joined since mod was installed.

https://vborg.vbsupport.ru/

DragonByte Tech 02-17-2012 04:49 AM
Quote:
Originally Posted by Kat-2 (Post 2300344)
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. :confused:
Quote:
Originally Posted by Kat-2 (Post 2300354)
BTW, just recalculated again. Still only showing the two users who have joined since mod was installed.

http://64.19.142.12/www.nme.com/boar...lies/dunno.gif
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


All times are GMT. The time now is 08:54 PM.
Page 70 of 94 « First 20606869 70 717280 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01994 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete