Status
Not open for further replies.

impaktZygo

Customer
Database Error vbactivity 3.1.4

We are running into an issues with the activity feed part of vbactivity, When a user clicks the activity feed we end up getting a database error so we recently disabled the activity feed and haven't gotten a database error since then. Any Idea's on what the issue could be
 
Last edited:
Please post the database error message.

When reporting an error message, please always include the actual error message as per the error report email you received :)
 
We have gotten over 900 of these messages in the last two days

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vb3gxboxlive SET

userid = '16368',
gold = '1',
gamertag = 'yeabooiiiiieeee',
avatar = 'http://avatar.xboxlive.com/avatar/yeabooiiiiieeee/avatarpic-l.png',
score = '4785',
reputation = '<div class="Star Full"></div><div class="Star Full"></div><div class="Star Full"></div><div class="Star Full"></div><div class="Star Full"></div>',
zone = '',
lastplayed = 'a:5:{i:0;a:4:{s:5:\"title\";s:18:\"Grand Theft Auto V\";s:4:\"link\";s:88:\"http://live.xbox.com/en-US/Activity/Details?titleId=1414793383&compareTo=yeabooiiiiieeee\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/72/Lk/02dsb2JhbA9ECgUMGgQfVg5UL2ljb24vMC84MDAwIAAAAAAAAPzLYvA=.jpg\";s:10:\"lastplayed\";s:9:\"4/27/2014\";}i:1;a:4:{s:5:\"title\";s:17:\"COD: Black Ops II\";s:4:\"link\";s:88:\"http://live.xbox.com/en-US/Activity/Details?titleId=1096157379&compareTo=yeabooiiiiieeee\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/NX/Oq/0mdsb2JhbA9ECgQJGgYfVgxQL2ljb24vMC84MDAwIAAAAAAAAP2Fcyo=.jpg\";s:10:\"lastplayed\";s:9:\"4/13/2014\";}i:2;a:4:{s:5:\"title\";s:22:\"Call of Duty®: Ghosts\";s:4:\"link\";s:88:\"http://live.xbox.com/en-US/Activity/Details?titleId=1096157436&compareTo=yeabooiiiiieeee\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/OM/7v/0mdsb2JhbA9ECgQJGgYfVgkAL2ljb24vMC84MDAwIAAAAAAAAP3Azic=.jpg\";s:10:\"lastplayed\";s:9:\"4/13/2014\";}i:3;a:4:{s:5:\"title\";s:13:\"Forza Horizon\";s:4:\"link\";s:88:\"http://live.xbox.com/en-US/Activity/Details?titleId=1297287625&compareTo=yeabooiiiiieeee\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/Hj/7h/12dsb2JhbA9ECgRcGgMfVwxaL2ljb24vMC84MDAwIAAAAAAAAPjOPgE=.jpg\";s:10:\"lastplayed\";s:9:\"4/13/2014\";}i:4;a:4:{s:5:\"title\";s:13:\"Battlefield 4\";s:4:\"link\";s:88:\"http://live.xbox.com/en-US/Activity/Details?titleId=1161890234&compareTo=yeabooiiiiieeee\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/8p/5P/1Wdsb2JhbA9ECgQNGwEfVw0CL2ljb24vMC84MDAwIAAAAAAAAPpgnu0=.jpg\";s:10:\"lastplayed\";s:9:\"3/22/2014\";}}',
updated = '1399923363'
,
strikes = '0',
error = '1',
firstseen = '1399923363';

MySQL Error : Duplicate entry '16368' for key 1
Error Number : 1062
Request Date : Monday, May 12th 2014 @ 11:36:03 PM
Error Date : Monday, May 12th 2014 @ 11:36:21 PM
Script : http://defcon-gaming.com/cron.php?rand=1399923362
Referrer : DefCon Gaming
IP Address : 75.189.253.233
Username : Unregistered
Classname : vB_Database
MySQL Version :


This is the database error that comes up after clicking the activity feed

<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE"/>
<script type="text/javascript">
//<![CDATA[
try{if (!window.CloudFlare) {var CloudFlare=[{verbose:0,p:1399768786,byc:0,owlid:"cf",bag2:1,mirage2:0,oracle:0,paths:{cloudflare:"/cdn-cgi/nexp/dok9v=02fcfa4f56/"},atok:"ea9ddf3180892f508217d6fd57b61683",petok:"492f14d9bd22dba034420e1476c7377e7fdb89fe-1399769858-1800",zone:"defcon-gaming.com",rocket:"0",apps:{}}];CloudFlare.push({"apps":{"ape":"91442dfa1e0620590074cdd391198405"}});!function(a,b){a=document.createElement("script"),b=document.getElementsByTagName("script")[0],a.async=!0,a.src="//ajax.cloudflare.com/cdn-cgi/nexp/dok9v=97fb4d042e/cloudflare.min.js",b.parentNode.insertBefore(a,b)}()}}catch(e){};
//]]>
</script>
<style type="text/css"><!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC ; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e ; }
--></style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48"/></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr/></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">defcon-gaming.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The defcon-gaming.com forum technical staff have been notified of the error, though you may <a href="http://www.cloudflare.com/email-protection#c6afa5a9a8afade8a1a7aba3b4bc86a1aba7afaae8a5a9ab">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br/>We apologise for any inconvenience.</td>
</tr>
</table>
<script type="text/javascript">
/* <![CDATA[ */
(function(){try{var s,a,i,j,r,c,l=document.getElementsByTagName("a"),t=document.createElement("textarea");for(i=0;l.length-i;i++){try{a=l.getAttribute("href");if(a&&"www.cloudflare.com/email-protection"==a.substr(7 ,35)){s='';j=43;r=parseInt(a.substr(j,2),16);for(j+=2;a.length-j&&a.substr(j,1)!='X';j+=2){c=parseInt(a.substr(j,2),16)^r;s+=String.fromCharCode(c);}j+=1;s+=a.substr(j,a.length-j);t.innerHTML=s.replace(/</g,"<").replace(/>/g,">");l.setAttribute("href","mailto:"+t.value);}}catch(e){}}}catch(e){}})();
/* ]]> */
</script>
</body>
</html>
 
Last edited:
That is a bug with your gXboxLive mod, please disable it in order to stop these error messages.
 
I have just disabled that mod and the e-mails haven't stopped and when enabling activity again the site has crashed. Below are the db error source and e-mail

DB Source:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE"/>
<script type="text/javascript">
//<![CDATA[
try{if (!window.CloudFlare) {var CloudFlare=[{verbose:0,p:1400007325,byc:0,owlid:"cf",bag2:1,mirage2:0,oracle:0,paths:{cloudflare:"/cdn-cgi/nexp/dok9v=2d3f118356/"},atok:"35ed1ee3b463b363703cdcd448f6a7d8",petok:"ba65d1e0b62968381b864517dd519cf04064bc3c-1400007426-1800",zone:"defcon-gaming.com",rocket:"0",apps:{}}];CloudFlare.push({"apps":{"ape":"2f24c22432383b7018e2eb8f4f3e69a8"}});!function(a,b){a=document.createElement("script"),b=document.getElementsByTagName("script")[0],a.async=!0,a.src="//ajax.cloudflare.com/cdn-cgi/nexp/dok9v=97fb4d042e/cloudflare.min.js",b.parentNode.insertBefore(a,b)}()}}catch(e){};
//]]>
</script>
<style type="text/css"><!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC ; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e ; }
--></style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48"/></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr/></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">defcon-gaming.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The defcon-gaming.com forum technical staff have been notified of the error, though you may <a href="http://www.cloudflare.com/email-protection#a6c295c0c5c9c8c1c7cbcfc8c1e6c1cbc7cfca88c5c9cb">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br/>We apologise for any inconvenience.</td>
</tr>
</table>
<script type="text/javascript">
/* <![CDATA[ */
(function(){try{var s,a,i,j,r,c,l=document.getElementsByTagName("a"),t=document.createElement("textarea");for(i=0;l.length-i;i++){try{a=l.getAttribute("href");if(a&&"www.cloudflare.com/email-protection"==a.substr(7 ,35)){s='';j=43;r=parseInt(a.substr(j,2),16);for(j+=2;a.length-j&&a.substr(j,1)!='X';j+=2){c=parseInt(a.substr(j,2),16)^r;s+=String.fromCharCode(c);}j+=1;s+=a.substr(j,a.length-j);t.innerHTML=s.replace(/</g,"<").replace(/>/g,">");l.setAttribute("href","mailto:"+t.value);}}catch(e){}}}catch(e){}})();
/* ]]> */
</script>
</body>
</html>

DB Email:

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT *
FROM vb3session
WHERE userid = 0
AND host = '31.41.218.136'
AND idhash = 'b17231f54526ff95a967e6276c86e8d4'
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, May 13th 2014 @ 10:56:56 PM
Error Date : Tuesday, May 13th 2014 @ 10:57:03 PM
Script : http://defcon-gaming.com/register.php
Referrer : http://defcon-gaming.com/register.php
IP Address : 31.41.218.136
Username :
Classname : vB_Database
MySQL Version :
 
Last edited:
Update= We uninstalled the xbox leaderbored plugin and updated vbactivity to current version, we are still having issues with the activity feed ie, every time the activity feed tries to load our site crashes and we get a Database error
 
That may happen if your forum is very large. You should disable that feature via the vBulletin Options for this mod.
 
Status
Not open for further replies.

Legacy vBActivity & Awards

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,726
Customer rating
0.00 star(s) 0 ratings
Back
Top