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

[ericgtr]

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. :)

[CMX_CMGSCCC]

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

[ericgtr]

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 :)

[CMX_CMGSCCC]

Np, thanx for supporting the product!

-CMX

[soulface]

This Post (https://vborg.vbsupport.ru/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...