vb.org Archive
Page 238 of 270 « First 138188228236237 238 239240248 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)

pantasd 03-13-2012 07:30 PM
did someone try vbexperience with the new facebook app, i mean if someone post something over facebook does he get points etc ?

sweetpotato 03-14-2012 01:11 AM
The 4.1.1 Still has database error with Event Attendance Plugin.

Phalynx 03-14-2012 09:19 AM
It would be good to see that SQL Error, please post it here.

sweetpotato 03-14-2012 11:30 AM
Quote:
Originally Posted by Phalynx (Post 2309316)
It would be good to see that SQL Error, please post it here.
Bellow is the error:
Code:
Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT
                COUNT(response) AS countevents
                FROM eventattendance
                INNER JOIN event ON event.eventid = eventattendance.eventid
                WHERE response='Yes' AND userid=1
                AND event.dateline > 315532800;

MySQL Error  : Column 'userid' in where clause is ambiguous
Error Number  : 1052
Request Date  : Wednesday, March 14th 2012 @ 04:27:30 AM
Error Date    : Wednesday, March 14th 2012 @ 04:27:31 AM
Script        : /xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : /xperience_admin.php?do=recount
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.92-log

savraot 03-19-2012 08:10 AM
When I try to use "Ranking", I get the following MySQL Error.
vb 4.1.11 / vBExperience 4.1.1 Beta.

Code:
Datenbankfehler in vBulletin 4.1.11:

Invalid SQL:
SELECT
                u.userid,
                u.usergroupid,
                u.membergroupids,
                u.username,
                u.xperience_level,
                u.xperience,
                u.xperience_ppd,
                u.xperience_awardt,
                u.reputation,
                SUM(s.points_user) AS points_user,
                SUM(s.points_thread) AS points_thread,
                SUM(s.points_post) AS points_post,
                SUM(s.points_misc) AS points_misc
                FROM vb4xperience_stats AS s
                INNER JOIN vb4user AS u ON u.userid=s.userid
                WHERE 1=1
                GROUP BY S.userid
                ORDER BY u.xperience desc
                LIMIT 0,30;

MySQL-Fehler  : Unknown column 'S.userid' in 'group statement'
Fehler-Nr.    : 1054
Fehler-Zeit  : Monday, 19.03.2012 @ 09:05:56
Datum        : Monday, 19.03.2012 @ 09:05:57
Skript        : http://www.xxx/xperience.php?go=ranking
Referrer      : http://www.xxx/xperience.php?go=groups
IP-Adresse    : xxx
Benutzername  : xxx
Klassenname  : vB_Database
MySQL-Version : 5.1.43-nmm4-log

Phalynx 03-19-2012 12:18 PM
Quote:
Originally Posted by sweetpotato (Post 2309334)
Bellow is the error:
Code:
Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT
                COUNT(response) AS countevents
                FROM eventattendance
                INNER JOIN event ON event.eventid = eventattendance.eventid
                WHERE response='Yes' AND userid=1
                AND event.dateline > 315532800;

MySQL Error  : Column 'userid' in where clause is ambiguous
Error Number  : 1052
Request Date  : Wednesday, March 14th 2012 @ 04:27:30 AM
Error Date    : Wednesday, March 14th 2012 @ 04:27:31 AM
Script        : /xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : /xperience_admin.php?do=recount
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.92-log
Fixed in the final version.

Quote:
Originally Posted by savraot (Post 2310943)
When I try to use "Ranking", I get the following MySQL Error.
vb 4.1.11 / vBExperience 4.1.1 Beta.

Code:
Datenbankfehler in vBulletin 4.1.11:

Invalid SQL:
SELECT
                u.userid,
                u.usergroupid,
                u.membergroupids,
                u.username,
                u.xperience_level,
                u.xperience,
                u.xperience_ppd,
                u.xperience_awardt,
                u.reputation,
                SUM(s.points_user) AS points_user,
                SUM(s.points_thread) AS points_thread,
                SUM(s.points_post) AS points_post,
                SUM(s.points_misc) AS points_misc
                FROM vb4xperience_stats AS s
                INNER JOIN vb4user AS u ON u.userid=s.userid
                WHERE 1=1
                GROUP BY S.userid
                ORDER BY u.xperience desc
                LIMIT 0,30;

MySQL-Fehler  : Unknown column 'S.userid' in 'group statement'
Fehler-Nr.    : 1054
Fehler-Zeit  : Monday, 19.03.2012 @ 09:05:56
Datum        : Monday, 19.03.2012 @ 09:05:57
Skript        : http://www.xxx/xperience.php?go=ranking
Referrer      : http://www.xxx/xperience.php?go=groups
IP-Adresse    : xxx
Benutzername  : xxx
Klassenname  : vB_Database
MySQL-Version : 5.1.43-nmm4-log
This has been already addressed, please download the Beta again:
https://vborg.vbsupport.ru/attachmen...3&d=1331113788

savraot 03-19-2012 02:34 PM
Quote:
This has been already addressed, please download the Beta again:
I re-install the Beta and now it works fine for me without Errors.
Big THX @ Coder :D

vortodox 03-20-2012 12:05 PM
I have updated tu beta, and when I try to recalculate i receive this error message:

Code:
Database error in vBulletin 4.1.11:

Invalid SQL:
UPDATE xperience_stats
                SET
                points_xperience=18109,points_threads=46,points_thread_votes=0,points_thread_replycount=343,points_thread_views=1153,points_thread_stickies=50,points_posts=12848,points_post_avg=3,points_post_attachment=4,points_misc_events=0,points_threads_sg=0,points_posts_sg=0,points_post_attachment_views=0,points_user_profile=0,points_post_den=91,points_user_law=0,points_user_infractions=0,points_user_reputation=67,points_user_reputation_use=22,points_user_online=3523,points_user_referrals=0,points_misc_custom=0,points_user_socialgroup=0,points_thread_tags=0,points_thread_rate=0,points_user_friends=3,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=1592,points_post=12900,points_user=3615,points_xperience=18109,points_shop=0,points_post_thanks_used=22,points_post_thanks_got_post=16,points_post_thanks_got_total=10,points_user_activity=0,points_user_activity30=0,points_user_activity7=0,points_level=85,promoted=0,
        dateline=1332244959       
        WHERE userid=3;

MySQL Error  : Unknown column 'points_post_thanks_used' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, March 20th 2012 @ 01:02:39 PM
Error Date    : Tuesday, March 20th 2012 @ 01:02:40 PM
Script        : http://www.xxx.com/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : http://www.xxx.com/admincp/xperience_admin.php?do=recount
IP Address    : xxx
Username      : Vortodox
Classname    : vB_Database
MySQL Version : 5.1.56-log

Phalynx 03-20-2012 01:05 PM
Quote:
Originally Posted by vortodox (Post 2311330)
I have updated tu beta, and when I try to recalculate i receive this error message:
This is the plugin "Post_Thanks_Abe1.xml" - please reinstall it.

vortodox 03-20-2012 01:16 PM
Quote:
Originally Posted by Phalynx (Post 2311351)
This is the plugin "Post_Thanks_Abe1.xml" - please reinstall it.
It worked. Thanks! :D


All times are GMT. The time now is 02:39 AM.
Page 238 of 270 « First 138188228236237 238 239240248 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.02797 seconds
  • Memory Usage 1,764KB
  • 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
  • (5)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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