vb.org Archive
Page 207 of 270 « First 107157197205206 207 208209217257 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)

Megaboost 10-22-2011 12:37 AM
Just updated to 4.1.0 beta and everything works fine apart from the error below when I go to Recount/update experience points.

Quote:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
SUM(totaldownloads) as sum_downloads
FROM dl2_files
WHERE uploaderid=1
AND dl2_files.dateline > 315532800
GROUP BY uploaderid;

MySQL Error : Unknown column 'dl2_files.dateline' in 'where clause'
Error Number : 1054
Request Date : Friday, October 21st 2011 @ 08:34:15 PM
Error Date : Friday, October 21st 2011 @ 08:34:16 PM
Any Idea's on a fix?

ahobilam 10-22-2011 02:53 AM
Thanks for the VBExperience Upgrade info.
I downloaded and installed it. I like this product very much.
But, regarding levels, It always showing only Level 1 for any higher points:
Level completed: 99%,
Points required for next Level: 0
I think, that I have not made proper settings to work this?
Please guide me, can you send your reply through pm?
thanks in advance

ahobilam 10-22-2011 08:13 AM
Today I installed the update and tried to do recount
I am getting the following error:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
COUNT(*) AS count_threads,
SUM(votetotal/votenum) AS count_votes,
SUM(replycount) AS count_replycount,
SUM(views) AS count_views,
SUM(sticky) AS count_stickies
FROM brahmins_thread
WHERE visible=1 AND forumid NOT IN(4,5,8)
AND postuserid=1
AND thread.dateline > 315532800;

MySQL Error : Unknown column 'thread.dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 22nd 2011 @ 05:09:29 AM
Error Date : Saturday, October 22nd 2011 @ 05:09:29 AM
do=xperience_admin_recount_xp
do=recount
Classname : vB_Database
MySQL Version : 5.1.56

Phalynx 10-22-2011 11:23 AM
Quote:
Originally Posted by Sarab (Post 2259921)
Hello,

Thank you for all your great work =)

I was wondering what table & column should I use for vbshop?

Can you tell me please?

Best Regards
Sarab
That will not work, as vBShop does not support vBExperience. Only the Point Market System is currently supporting vBExperience.




Quote:
Originally Posted by ahobilam (Post 2260005)
Thanks for the VBExperience Upgrade info.
I downloaded and installed it. I like this product very much.
But, regarding levels, It always showing only Level 1 for any higher points:
Level completed: 99%,
Points required for next Level: 0
I think, that I have not made proper settings to work this?
Please guide me, can you send your reply through pm?
thanks in advance
You need to install a higher level xml


Quote:
Originally Posted by ahobilam (Post 2260069)
Today I installed the update and tried to do recount
I am getting the following error:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
COUNT(*) AS count_threads,
SUM(votetotal/votenum) AS count_votes,
SUM(replycount) AS count_replycount,
SUM(views) AS count_views,
SUM(sticky) AS count_stickies
FROM brahmins_thread
WHERE visible=1 AND forumid NOT IN(4,5,8)
AND postuserid=1
AND thread.dateline > 315532800;

MySQL Error : Unknown column 'thread.dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 22nd 2011 @ 05:09:29 AM
Error Date : Saturday, October 22nd 2011 @ 05:09:29 AM
do=xperience_admin_recount_xp
do=recount
Classname : vB_Database
MySQL Version : 5.1.56
Quote:
Originally Posted by Megaboost (Post 2259944)
Just updated to 4.1.0 beta and everything works fine apart from the error below when I go to Recount/update experience points.



Any Idea's on a fix?

Please update to Beta 2, just replace class_xperience.php

snowlion 10-22-2011 01:18 PM
I got this error (Beta 2) when update Experience points
Code:

Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT
  COUNT(*) AS count_events
  FROM sty_event
  WHERE visible=1
  AND userid=1
  AND event.dateline > 315532800;
MySQL Error  : Unknown column 'event.dateline' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 09:15:12 AM
Error Date    : Saturday, October 22nd 2011 @ 09:15:13 AM
Script        : admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : admincp/xperience_admin.php?do=recount
IP Address    : 113.170.3.155
Username      : kisibachda
Classname    : vB_Database
MySQL Version : 5.1.56
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 423
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 456
#2 vB_Database->query_read() called in [path]/includes/class_xperience.php on line 227
#3 xPerience->CalculateXP() called in [path]/admincp/xperience_admin.php on line 287

digicom 10-22-2011 03:27 PM
After updating to 4.1.0 beta 2 i recieve this error when i try to Update Experience Points.
Any help would be apprciated,Thanks
Code:
Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT
SUM(totaldownloads) as sum_downloads
FROM dl2_files
WHERE uploaderid=1
AND dl2_files.date > 315532800
GROUP BY uploaderid;

MySQL Error  : Unknown column 'dl2_files.date' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 04:18:29 PM
Error Date    : Saturday, October 22nd 2011 @ 04:18:32 PM
Script        : /admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : /admincp/xperience_admin.php?do=recount
Classname    : vB_Database
MySQL Version : 5.1.56

Phalynx 10-22-2011 05:58 PM
Please download Beta 3 and replace class_xperience.php
Also, if you have some vBExperience plugins installed, please install new version!

digicom 10-22-2011 06:37 PM
Hi Phalynx i updated to 4.1.0 beta 3 and still recieved a error when i tryed to Update Experience Points.
Code:
Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT
            SUM(totaldownloads) as sum_downloads
            FROM dl2_files
            WHERE uploaderid=1
            AND date > 315532800
            GROUP BY uploaderid;

MySQL Error  : Unknown column 'date' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 07:32:43 PM
Error Date    : Saturday, October 22nd 2011 @ 07:32:46 PM
Script        : admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      :admincp/xperience_admin.php?do=recount
Classname    : vB_Database
MySQL Version : 5.1.56

Phalynx 10-22-2011 06:59 PM
Ok, there were a change of that column from "date" to "dateadd". Still I was using v5 of DownloadsII. Please update the class_xperience.php of the new added ZIP.

digicom 10-22-2011 07:19 PM
Much apprciated Phalynx Experience Points now updating ok :up:

Quote:
Originally Posted by Phalynx (Post 2260264)
Ok, there were a change of that column from "date" to "dateadd". Still I was using v5 of DownloadsII. Please update the class_xperience.php of the new added ZIP.


All times are GMT. The time now is 09:16 PM.
Page 207 of 270 « First 107157197205206 207 208209217257 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.03335 seconds
  • Memory Usage 1,757KB
  • 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
  • (6)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