vb.org Archive
Page 95 of 270 « First 45859394 95 9697105145195 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 - vBExperience 4 (https://vborg.vbsupport.ru/showthread.php?t=245023)

WhiskeyOSS 08-20-2010 12:51 AM
When we click on ranking we get this error ?

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
COUNT(*) AS users
FROM xperience_stats AS x
INNER JOIN user AS u
ON u.userid=x.userid
WHERE 1=1 AND u.userid NOT IN(Bullie44, Whitey);

MySQL Error : Unknown column 'Bullie44' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 19th 2010 @ 06:48:44 PM
Error Date : Thursday, August 19th 2010 @ 06:48:44 PM
Script : http://www.teamsrgaming.com/forums/x...php?go=ranking
Referrer : http://www.teamsrgaming.com/forums/xperience.php
IP Address : 76.11.220.172
Username : WhiskeySR
Classname : vB_Database
MySQL Version : 5.0.91-log

Veer 08-20-2010 01:23 AM
Phalynx, Promotion system still need to be updated, promotion / demotion both not working plus getting database error when remove all promotions.

Any idea when it will be updated?

Phalynx 08-20-2010 06:58 AM
Quote:
Originally Posted by pedroenf (Post 2086583)
But i do not have no ' in any tittle. My forum is portuguese and we use ? and ? and ?. But none of this show in mysql errors.
The ' is reserved for use in SQL statements. It's just missing an addslash command to avoid this. Fixed in final 4.0.2

Quote:
Originally Posted by WhiskeyOSS (Post 2086625)
When we click on ranking we get this error ?

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
COUNT(*) AS users
FROM xperience_stats AS x
INNER JOIN user AS u
ON u.userid=x.userid
WHERE 1=1 AND u.userid NOT IN(Bullie44, Whitey);

MySQL Error : Unknown column 'Bullie44' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 19th 2010 @ 06:48:44 PM
Error Date : Thursday, August 19th 2010 @ 06:48:44 PM
Script : http://www.teamsrgaming.com/forums/x...php?go=ranking
Referrer : http://www.teamsrgaming.com/forums/xperience.php
IP Address : 76.11.220.172
Username : WhiskeySR
Classname : vB_Database
MySQL Version : 5.0.91-log
Don't enter the username for the users beeing ignored. You will have to enter the UserID!


Quote:
Originally Posted by Veer (Post 2086638)
Phalynx, Promotion system still need to be updated, promotion / demotion both not working plus getting database error when remove all promotions.

Any idea when it will be updated?
Fixed in final.
Also, promotions are working - what are you missing here? Demotions need a workaroung by doing it with an extra thing.

Phalynx 08-20-2010 07:36 AM
This has been fixed for final 4.0.2:
- Improved: Speed improvements on Insight
- Improved: Speed improvements on Activities
- Fixed: Error while clearing all promotions
- Fixed: Achievements/Awards now without space between
- Fixed: Uncached template 'xperience_gap_memberaction'

I'm also waiting for a confirmation about the member profile tabs. Does it happen again?

Please take also a look if you have templates that need to be reverted.

KURTZ 08-20-2010 08:56 AM
Code:
Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
                a.awardid AS id,
                a.awardtitle AS title,
                a.awardurl AS small,
                a.awardbigurl AS big
                FROM xperience_award_issues AS i
                INNER JOIN xperience_awards AS a ON a.awardid=i.awardid
                WHERE i.userid=2
                ORDER BY i.dateline
                LIMIT 0,;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10
got this.

Phalynx 08-20-2010 09:20 AM
Quote:
Originally Posted by KURTZ (Post 2086763)
Code:
Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
                a.awardid AS id,
                a.awardtitle AS title,
                a.awardurl AS small,
                a.awardbigurl AS big
                FROM xperience_award_issues AS i
                INNER JOIN xperience_awards AS a ON a.awardid=i.awardid
                WHERE i.userid=2
                ORDER BY i.dateline
                LIMIT 0,;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10
got this.
Please check if the setting "Limit Awards" is empty. If yes, put a 1 to it.

Phalynx 08-20-2010 09:57 AM
I've updated Inside SupCom to the newest build. You can now see the new replace achievement feature in action:
http://www.insidesupcom.de/member.php?1-Phalynx

KURTZ 08-20-2010 11:53 AM
Quote:
Originally Posted by Phalynx (Post 2086769)
Please check if the setting "Limit Awards" is empty. If yes, put a 1 to it.
thanks, seems to be fixed ... :)

MiNeM 08-20-2010 12:03 PM
Hi Guys,

I keep getting the following error when i run Update Experience points

it goes to User 130 everytime and the give me this DB error

Code:
Database error in vBulletin 4.0.6:

Invalid SQL:
UPDATE xperience_stats
                SET
                points_xperience=-4744,points_threads=0,points_thread_votes=0,points_thread_replycount=0,points_thread_views=6,points_thread_stickies=0,points_posts=0,points_post_avg=0,points_post_attachment=0,points_misc_events=0,points_threads_sg=0,points_posts_sg=0,points_post_attachment_views=0,points_user_profile=0,points_post_den=56,points_user_law=0,points_user_infractions=0,points_user_reputation=0,points_user_reputation_use=0,points_user_online=160,points_user_referrals=0,points_misc_custom=0,points_user_socialgroup=0,points_thread_tags=0,points_thread_rate=0,points_user_friends=0,points_user_visitormessages=0,points_user_albumpictures=0,points_misc_ldm=0,points_misc_dl2=0,points_misc_vbblog=0,points_misc_vbcms=0,points_misc_ppd=0,points_misc=0,points_thread=6,points_post=0,points_user=160,points_xperience=-4744,points_shop=0,points_post_scp=-12,points_post_thanks_used=-3,points_post_thanks_got_post=-1,points_post_thanks_got_total=-1,points_misc_ibparcadechamps=-5,points_user_activity=0,points_user_activity30=0,points_user_activity7=0,points_level=1,promoted=0,
        dateline=1282309080       
        WHERE userid=130;

MySQL Error  : Unknown column 'points_post_scp' in 'field list'
Error Number  : 1054
Request Date  : Friday, August 20th 2010 @ 02:56:37 PM
Error Date    : Friday, August 20th 2010 @ 02:58:25 PM
Script        : http://www.xbox-360.co.za/forum/admi...min_recount_xp
Referrer      : http://www.xbox-360.co.za/forum/admi...php?do=recount
IP Address    : 198.54.202.174
Username      : MiNeM
Classname    : vB_Database
MySQL Version : 5.0.91-community
Thanks in advance...

Phalynx 08-20-2010 12:08 PM
Please click "Mark as Installed" to get further support!

Uninstall the old vBExperience 3.8 plugin "vBExperience Scrupulous Poster".


All times are GMT. The time now is 09:15 PM.
Page 95 of 270 « First 45859394 95 9697105145195 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.05791 seconds
  • Memory Usage 1,758KB
  • 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
  • (3)bbcode_code_printable
  • (5)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