[mrpaint]

Originally Posted by parseforum

I deleted the files and upload them again now I have this error:

Database error in vBulletin 3.7.2:

Invalid SQL:

        SELECT 
            userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
            
        ,kbank_granted.allow_count AS kbank_granted_count
        ,kbank_granted.allow_userid AS kbank_granted_userid
        ,kbank_granted.allow_username AS kbank_granted_username
        ,kbank_granted.allow_usergroupid AS kbank_granted_usergroupid
        ,kbank_granted.allow_membergroupids AS kbank_granted_membergroupids
        ,kbank_granted.allow_چوب AS kbank_granted_چوب
    
        FROM user AS user
        LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
        LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
        
        LEFT JOIN (
            SELECT
                kbank_granted.userid AS userid
                ,COUNT(*) AS allow_count
                ,GROUP_CONCAT(user.userid SEPARATOR '|') AS allow_userid
                ,GROUP_CONCAT(user.username SEPARATOR '|') AS allow_username
                ,GROUP_CONCAT(user.usergroupid SEPARATOR '|') AS allow_usergroupid
                ,GROUP_CONCAT(user.membergroupids SEPARATOR '|') AS allow_membergroupids
                ,GROUP_CONCAT(user.چوب SEPARATOR '|') AS allow_چوب
            FROM `kbank_granted_permission` AS kbank_granted
            INNER JOIN `user` AS user ON (user.userid = kbank_granted.allowid)
            WHERE kbank_granted.userid = 1
            GROUP BY kbank_granted.userid
        ) AS kbank_granted ON (kbank_granted.userid = user.userid)
    
        WHERE user.userid = 1;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '�وب AS kbank_granted_چوب
    
        FROM user AS user
        LEFT JOIN userfield AS us' at line 10
Error Number  : 1064
Request Date  : Wednesday, July 30th 2008 @ 09:52:41 AM
Error Date    : Wednesday, July 30th 2008 @ 09:52:41 AM
Script        : http://67.205.67.58/~parsefc/forum/login.php?do=login
Referrer      : http://67.205.67.58/~parsefc/forum/admincp/
IP Address    : 85.185.30.103
Username      : Arash
Classname     : vB_Database
MySQL Version : 5.0.51a-community

You have specified wrong field name for money row (please use "money", default value, if you don't really understand this setting)

As I tested, you can't edit setting because you can't login. You should create new file named "hook_fetch_userinfo_query.php", content:

PHP Code:

<?php
?>

Replace it with the old one inside ./kbank (don't forget to backup)
Go to AdminCP and edit settings
Restore the original "hook_fetch_userinfo_query.php"

Everything should be okie! Gud luck