vb.org Archive - Major Additions

Database error in vBulletin 4.1.7:



Invalid SQL:

SELECT

                                SUM(points) AS sum_points

                                FROM vb_infraction

                                WHERE action<>2 AND userid=1 

                                AND infraction.dateline > 315532800;



MySQL Error   : Unknown column 'infraction.dateline' in 'where clause'

Error Number  : 1054

Request Date  : Saturday, October 22nd 2011 @ 02:52:11 PM

Error Date    : Saturday, October 22nd 2011 @ 02:52:11 PM

Script        : http://xxx/admincp/xperience_admin.php?do=xperience_admin_recount_xp

Referrer      : http://xxx/admincp/xperience_admin.php?do=recount

IP Address    : 

Username      : silence

Classname     : vB_Database_MySQLi

MySQL Version : 5.1.56

Phalynx

10-22-2011 10:48 PM

Please update to Beta 4, just replace class_xperience.php

vanquish.securi

10-23-2011 12:51 AM

Uploaded the class_xperience.php like you said for beta 4. Went to recount for experience and got this:

Quote:

Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
SUM(yesno) AS sum_answers
FROM helpfulanswer as h
INNER JOIN post AS p ON p.postid=h.postid
WHERE p.userid=1
AND post.dateline > 315532800
GROUP BY p.userid;

MySQL Error : Unknown column 'post.dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 22nd 2011 @ 08:49:59 PM
Error Date : Saturday, October 22nd 2011 @ 08:49:59 PM
Script : http://www.vanquishcoding.com/commun...min_recount_xp
Referrer : http://www.vanquishcoding.com/commun...php?do=recount
IP Address :

hakkuo23

10-23-2011 12:54 AM

LOL Will the db errors every end xD

hakkuo23

10-23-2011 02:09 AM

Code:

Database error in vBulletin 4.1.7:



Invalid SQL:

SELECT *

                FROM vb_xperience_level

                WHERE xperience_points<8170

                ORDER BY xperience_points DESC LIMIT 0,1;



MySQL Error   : Table 'xxx.vb_xperience_level' doesn't exist

Error Number  : 1146

Request Date  : Saturday, October 22nd 2011 @ 08:08:25 PM

Error Date    : Saturday, October 22nd 2011 @ 08:08:26 PM

Script        : http://xenogamers.org/admincp/xperience_admin.php?do=xperience_admin_recount_xp

Referrer      : http://xenogamers.org/admincp/xperience_admin.php?do=recount

Username      : silence

Classname     : vB_Database_MySQLi

MySQL Version : 5.1.56

Phalynx

10-23-2011 05:16 PM

Quote:

Originally Posted by vanquish.securi (Post 2260373)

Uploaded the class_xperience.php like you said for beta 4. Went to recount for experience and got this:

Please install the plugin Helpful_Answers.xml from Beta 4 ZIP!

Quote:

Originally Posted by hakkuo23 (Post 2260401)

Code:

Database error in vBulletin 4.1.7:



Invalid SQL:

SELECT *

                FROM vb_xperience_level

                WHERE xperience_points<8170

                ORDER BY xperience_points DESC LIMIT 0,1;



MySQL Error   : Table 'xxx.vb_xperience_level' doesn't exist

Error Number  : 1146

Request Date  : Saturday, October 22nd 2011 @ 08:08:25 PM

Error Date    : Saturday, October 22nd 2011 @ 08:08:26 PM

Script        : http://xenogamers.org/admincp/xperience_admin.php?do=xperience_admin_recount_xp

Referrer      : http://xenogamers.org/admincp/xperience_admin.php?do=recount

Username      : silence

Classname     : vB_Database_MySQLi

MySQL Version : 5.1.56

Did you installed already a level file?

hakkuo23

10-23-2011 09:25 PM

oops lol. Seems disabling vbX removed the level plugin. Thanks!

vanquish.securi

10-24-2011 12:26 PM

Quote:

Originally Posted by Phalynx (Post 2260605)

Please install the plugin Helpful_Answers.xml from Beta 4 ZIP!

Ok installed the Helpful Answers and that fixed that issue. Atempted to do a recount again and now got this:

Quote:

Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
SUM(bet_amount_won) AS sumbets
FROM vbookie_bets_placed
WHERE bet_settled='Y' AND userid=1
AND dateline > 315532800
GROUP BY userid;

MySQL Error : Unknown column 'dateline' in 'where clause'
Error Number : 1054
Request Date : Monday, October 24th 2011 @ 08:23:00 AM
Error Date : Monday, October 24th 2011 @ 08:23:00 AM
Script : http://www.vanquishcoding.com/commun...min_recount_xp
Referrer : http://www.vanquishcoding.com/commun...php?do=recount
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.92-community

I saw that it was giving an error about vBookie, so I downloaded the beta 4 vbookie mod and checked over write thinking that would fix it, but it did not.

weexto

10-24-2011 06:32 PM

hello,
I seek the opportunity to change the start date of the contest .... is that possible?
best regards
w

StonePilot

10-26-2011 01:37 AM

My members have been asking about this, but I'm wait until I hear from more people that it's stable. I've got enough problems that are stealing all of my time.

All times are GMT. The time now is 08:31 PM.

Page 208 of 270

208

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05856 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 (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
Messages: