vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - vBExperience (https://vborg.vbsupport.ru/showthread.php?t=171014)

SPARKS MAN 10-20-2008 11:48 AM

after install it when i run the cron job i got this DB error
and if i use the recount the xperience points via maintenance tools i got the same one ????? please any help

PHP Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT 
            thankedcount
            FROM user
            WHERE userid
=1;

MySQL Error   Unknown column 'thankedcount' in 'field list'
Error Number  1054
Request Date  
MondayOctober 20th 2008 07:42:16 AM
Error Date    
MondayOctober 20th 2008 07:42:18 AM
Script        
http://vb.ulkahf.net/ulkahfad/cronadmin.php?do=runcron&cronid=49
Referrer      http://vb.ulkahf.net/ulkahfad/index.php?loc=plugin.php%3Fdo%3Dproduct
IP Address    80.255.40.163
Username      
SPARKS MAN
Classname     
vB_Database
MySQL Version 
5.0.51a-community 


SPARKS MAN 10-20-2008 11:53 AM

sorry i find my fault
thats because i use a level product not suitable to my forum

regards
eng. ali

simunaqv 10-20-2008 02:45 PM

Hi Phalynx,
I have less that 2300 members on my board. I import the smalllest level (vbexperience_level_1_small.xml) but even then we start getting Internal Server Error 500 on the forum page. I always have to disable vbExperience to get rid of this error. Can you please guide me as how can I create a level that is suitable for our forum.
Thanks,

Phalynx 10-20-2008 03:07 PM

Quote:

Originally Posted by 4x4 Mecca (Post 1647078)
Hey there! I'm trying to make a conditional to insert something into the postbit or even forumdisplay using the activity field, here is my code
Code:

<if condition="$vbulletin->xperience_stats[points_user_activity] == 100">1</if>
<if condition="$xperience_stats[points_user_activity] == 100">2</if>

Neither one works, any ideas on how I would do it?

It's "$xperience[ppd]". To see all the code, go to XML and search for the hook "postbit_display_complete".

Quote:

Originally Posted by appsfinder (Post 1648205)
hi how do i get this to work with vbgallery 2.4.3:confused:

any help would be great.

You mean PhotoPost Gallery? Support for this is already included.

Quote:

Originally Posted by SPARKS MAN (Post 1648873)
after install it when i run the cron job i got this DB error
and if i use the recount the xperience points via maintenance tools i got the same one ????? please any help

PHP Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT 
            thankedcount
            FROM user
            WHERE userid
=1;

MySQL Error   Unknown column 'thankedcount' in 'field list'
Error Number  1054
Request Date  
MondayOctober 20th 2008 07:42:16 AM
Error Date    
MondayOctober 20th 2008 07:42:18 AM
Script        
http://vb.ulkahf.net/ulkahfad/cronadmin.php?do=runcron&cronid=49
Referrer      http://vb.ulkahf.net/ulkahfad/index.php?loc=plugin.php%3Fdo%3Dproduct
IP Address    80.255.40.163
Username      
SPARKS MAN
Classname     
vB_Database
MySQL Version 
5.0.51a-community 


Did you had post thanks installed and uninstalled it? If yes, you need to remove the post thanks tables also.


Quote:

Originally Posted by simunaqv (Post 1648962)
Hi Phalynx,
I have less that 2300 members on my board. I import the smalllest level (vbexperience_level_1_small.xml) but even then we start getting Internal Server Error 500 on the forum page. I always have to disable vbExperience to get rid of this error. Can you please guide me as how can I create a level that is suitable for our forum.
Thanks,

An error does not appear if you had a "wrong sized" level. I need detailed error message to track that down.

Dragonsys 10-20-2008 06:07 PM

Quote:

Originally Posted by MissKalunji (Post 1648324)
just choose "experience" as the point field it will use the WHOLE system. he just gave you the choice to choose between field

ahh ok, I missed that. Thank you!

simunaqv 10-20-2008 06:16 PM

Hi Phalynx,
Thanks for your reply. Actually the error is a general Internal Server Error 500, and it only occurs when vbExperience is enabled. I submitted a support request with our web hosting provider (DreamHost) and following is their answer:

Quote:

It appears some scripts on your site are being killed by our process
watcher program. This keeps the CPU/Memory load balanced for all users
on the server. Unfortunately, while we can't change the settings on
that, there are ways to reduce the CPU and Memory footprint of your site.
One is to make sure you've disabled hotlinking of your images.
Sometimes the culprit is robot "crawlers", such as googlebot, which like
to get caught in loops on some dynamic sites, causing the load to jump on
the server.
Can you guess what part of vbExperience could be causing a CPU load?

Phalynx 10-20-2008 07:29 PM

Quote:

Originally Posted by simunaqv (Post 1649102)
Hi Phalynx,
Thanks for your reply. Actually the error is a general Internal Server Error 500, and it only occurs when vbExperience is enabled. I submitted a support request with our web hosting provider (DreamHost) and following is their answer:



Can you guess what part of vbExperience could be causing a CPU load?

Uhm, every part? The whole thing is really database intensive. Worser if it's bad configured. I would suggest to uninstall vBExperience, as it is not intendet for low end and other limited servers.

robwestpdx 10-20-2008 10:22 PM

does this have a donation system or does it work with vbcredits?

MissKalunji 10-21-2008 12:07 AM

donation as in you can donate points to members manually? Yes

works with credits i don't think so...it has it's own point system

MyCTaK 10-22-2008 07:30 AM

Hello,
i got problem with level gaining.
I made new file with new points for level up after 60th lvl and upload it via Import another level product, then i Recount but nothing happened with users that must be affected. So i try to import it via Manage Products and then recount from Scheduled Task Manager but nothing happened again.
When i download the level product it is the new one, but in forum it continue to calculate it from old level points :eek:
I hope you understand what i mean and will help me :)


All times are GMT. The time now is 05:53 PM.

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.03453 seconds
  • Memory Usage 1,765KB
  • 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
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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