vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Major Additions - psiStats 2009 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=203767)

twista46 10-01-2009 07:11 PM

I become this Error in ACP if i change Usegroup settings

Quote:

Datenbankfehler in vBulletin 3.8.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderatoren',
`description` = '',
`usertitle` = '',
`opentag` = '<span style=\"font-weight:bold; font-style:italic; color:#0066FF;\" title=\"Moderator\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`advanced_bbcode_usergroup_on` = '1',
`vbpt_permissions` = '6',
`userjaq` = '0',
`forumpermissions` = '12312063',
`genericpermissions` = '1609504463',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '13',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '75535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '70000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`sfmpermissions` = '0',
`advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_ color||1|||core||allow_bbcode_size||1|||core||allo w_bbcode_font||1|||core||allow_bbcode_align||1|||c ore||allow_bbcode_list||1|||core||allow_bbcode_url ||1|||core||allow_bbcode_code||1|||core||allow_bbc ode_php||0|||core||allow_bbcode_html||0|||non_core ||hide||1|||non_core||Spoiler||1|||non_core||nfo|| 1|||non_core||mod||1'
WHERE usergroupid=7;

MySQL-Fehler : Unknown column 'userjaq' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Thursday, 01.10.2009 @ 22:04:06
Datum : Thursday, 01.10.2009 @ 22:04:06
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny2

|Jordan| 10-03-2009 02:10 PM

This mod could really use a function in the AdminCP to easily clear the stats. Another great thing to have would be an archive feature where after each month or set period, the stats are archived and cleared for the next time period.

NTMID8 10-03-2009 06:09 PM

Quote:

Originally Posted by NTMID8 (Post 1872394)
Thanks. Its showing stats for Windows 7 now great. How do I had an icon for Win7 though?

Quote:

Originally Posted by NTMID8 (Post 1876592)
Any chance we can get the top search words or phrases that led to our site in the next release? I know my cpanel reports that along with most of the other stats you are currently reporting, so was hoping it would be possible.

Quote:

Originally Posted by NTMID8 (Post 1877550)
I'd like to submit a request to have Most Thanked Users and Most Thanked Posts added to the stats.

Any word on any of these?

lnxtr 10-05-2009 06:15 AM

where is demo?

twista46 10-05-2009 06:58 PM

No idea ??


Quote:

Datenbankfehler in vBulletin 3.8.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderatoren',
`description` = '',
`usertitle` = '',
`opentag` = '<span style=\"font-weight:bold; font-style:italic; color:#0066FF;\" title=\"Moderator\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`advanced_bbcode_usergroup_on` = '1',
`vbpt_permissions` = '6',
`userjaq` = '0',
`forumpermissions` = '12312063',
`genericpermissions` = '1609504463',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '13',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '75535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '70000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`sfmpermissions` = '0',
`advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_ color||1|||core||allow_bbcode_ size||1|||core||allow_bbcode_font||1|||core||allow _bbcode_align||1|||core||allow _bbcode_list||1|||core||allow_bbcode_url||1|||core ||allow_bbcode_code||1|||core| |allow_bbcode_php||0|||core||allow_bbcode_html||0| ||non_core||hide||1|||non_core ||Spoiler||1|||non_core||nfo||1|||non_core||mod||1 '
WHERE usergroupid=7;

MySQL-Fehler : Unknown column 'userjaq' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Thursday, 01.10.2009 @ 22:04:06
Datum : Thursday, 01.10.2009 @ 22:04:06
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny2

akanevsky 10-05-2009 07:24 PM

Quote:

Originally Posted by twista46 (Post 1895283)
No idea ??

The message says:

MySQL-Fehler : Unknown column 'userjaq' in 'field list'

Some other mod (not this one) failed to add column "userjaq" to the usergroup table, but it is trying to access that column. Hence, there is an error message. Please try to find out which hack causes this problem by disabling all your hacks one-by-one. Once you find the correct hack, you can uninstall it or ask the author of that hack to fix it.

BigDog56 10-06-2009 12:09 AM

Works like a charm! thank you!

realmr 10-15-2009 10:20 AM

can we limit referrer stats based on month or date ?? i.e user registered from 1Oct only should be visible instead of the entire list, the other referrer stats add-on isn't working as expected for 3.8 and as u mentioned the support will b given only here, can u help me

BucWiLd 10-15-2009 02:16 PM

Installed .. thank you.. look forward to some updates.


edit: i just went to enable the dempgraphics page and when i clicked it i got a database error. anyone know what i did wrong?
i have this hack for gender https://vborg.vbsupport.ru/showthread.php?t=196749..
i think i may be entering the demographics gender field wrong.

help.... thanks

Tanapangarap 10-18-2009 06:56 AM

Hi.

Is there a way to allow regular members to view the statistics?

Regards,

Kevin


All times are GMT. The time now is 03:04 AM.

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.01221 seconds
  • Memory Usage 1,752KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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