Helpful Information

Category: vbBux / vbPlaza

Error (repost from thread that's no longer supported)

Stupid typo, its missing a comma, either add it yourself at

'" . $vbulletin->userinfo['userid'] . "',

Or wait for the next release.

This error is flooding my email box, will you please explain exactly where to search and replace? I see two instances of this and neither have a comma, is it supposed to be added to both? BTW, thanks for a great mod, the users on my site are really enjoying this. :)

This error is flooding my email box, will you please explain exactly where to search and replace? I see two instances of this and neither have a comma, is it supposed to be added to both? BTW, thanks for a great mod, the users on my site are really enjoying this. :)

Inside estore/action.changeusername.php

Find:

// log this change into estorenamechanges
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "estorenamechanges (changeid, dateline, changeuserid, oldusername, changedbyuserid)
VALUES
(
0,
" . TIMENOW . ",
'" . $vbulletin->userinfo['userid'] . "'
'" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "',
'" . $vbulletin->userinfo['userid'] . "'
)
");

Replace With:

// log this change into estorenamechanges
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "estorenamechanges (changeid, dateline, changeuserid, oldusername, changedbyuserid)
VALUES
(
0,
" . TIMENOW . ",
'" . $vbulletin->userinfo['userid'] . "',
'" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "',
'" . $vbulletin->userinfo['userid'] . "'
)
");

And its fixed.

-CMX

Inside estore/action.changeusername.php

Find:

// log this change into estorenamechanges
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "estorenamechanges (changeid, dateline, changeuserid, oldusername, changedbyuserid)
VALUES
(
0,
" . TIMENOW . ",
'" . $vbulletin->userinfo['userid'] . "'
'" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "',
'" . $vbulletin->userinfo['userid'] . "'
)
");

Replace With:

// log this change into estorenamechanges
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "estorenamechanges (changeid, dateline, changeuserid, oldusername, changedbyuserid)
VALUES
(
0,
" . TIMENOW . ",
'" . $vbulletin->userinfo['userid'] . "',
'" . $vbulletin->db->escape_string($vbulletin->userinfo['username']) . "',
'" . $vbulletin->userinfo['userid'] . "'
)
");

And its fixed.

-CMX

Excellent, thanks for the help :)

Np, thanx for supporting the product!

-CMX

This Post (http://www.vbulletin.org/forum/showpost.php?p=917117&postcount=2832)

after upgrading frm 1.2.5 to 1.2.6 am getting following database error.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT * FROM estoreribbons
WHERE touserid = '802'
ORDER BY ribbonid DESC;

MySQL Error : Table 'bforum_express.estoreribbons' doesn't exist
Error Number : 1146
Date : Saturday, March 4th 2006 @ 05:06:07 PM
Script : http://*************/member.php?action=getinfo&u=802
Referrer :
IP Address : 65.214.44.72
Username : Unregistered
Classname : vb_database

before upgrading to 1.2.6 i uninstalled the standalone Awareness Ribbons plugins then installed the 1.2.6, any solution ? i got almost 100 database error email, since then i turned off the estore...

Thanks...