vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - kBank 2.1 - Money System (https://vborg.vbsupport.ru/showthread.php?t=185318)

Marco van Herwaarden 07-30-2008 07:52 AM

Quote:

Originally Posted by parseforum (Post 1587238)
Hello

After install this hack and upload files and edit Templates when I`m going to my forum give this error and I can`t Restore my backup:(

https://vborg.vbsupport.ru/external/2008/07/3.jpg

Please help me

Seems you have not uploaded all the files for this modification. Check if you have uploaded all files and to the correct directory.

Marco van Herwaarden 07-30-2008 07:53 AM

Quote:

Originally Posted by RedeemedWarrior (Post 1587239)
i used a Testvb

and it trashed it also


database is ruined

thankfully it wasn't my live board

How do you think the coder, or anyone else, can help troubleshooting your issues without more information then you posted.

At least post what/how it ruined your database. If you get database errors, post the full error.

parseforum 07-30-2008 07:57 AM

Quote:

Originally Posted by Marco van Herwaarden (Post 1587266)
Seems you have not uploaded all the files for this modification. Check if you have uploaded all files and to the correct directory.

I uploaded all files again but I have that error :(

Marco van Herwaarden 07-30-2008 08:37 AM

I doubt that, a the error message indicates missing files.

RedeemedWarrior 07-30-2008 09:00 AM

Quote:

Originally Posted by Marco van Herwaarden (Post 1587268)
How do you think the coder, or anyone else, can help troubleshooting your issues without more information then you posted.

At least post what/how it ruined your database. If you get database errors, post the full error.

simply default Vb Database Error

I reverted shortly after to a fresh install, so more info i can't supply :)

As how it ruined, nothing was usable after the install, the Admincp was a useless, couldn't even access disable plugins

it began after I set my usergroup (admin) to KBank admin it froze up as soon as settings saved

i'll try again on my Testvb re install, i have a few idea's as to what may have triggered it

Edit : After following all install script/instructions nothing is functional

I'm uninstalling and moving on

had alot of promise

mrpaint 07-30-2008 10:51 AM

@parseforum: Have you uploaded all files/folders inside folder "upload"? If you only download kBank 2.0 Upgrade 2.0.1.zip, you have to download kBank 2.0.1 Installation.zip and re-upload to your forum root! kBank 2.0 Upgrade 2.0.1.zip is used for upgrading only!

@RedeemedWarrior: God bless you! But what is your error messages? If full error is not display, just view page source and you will see MySQL error messages (it has been hidden, just a trick) :D

PS: You have to set userid instead of usergroupid for kBank Admin. For more information about installing kBank, visit this page (english, no registration require): http://hskl.net/f/kbank.php?do=help&page=install

parseforum 07-30-2008 11:36 AM

Quote:

@parseforum: Have you uploaded all files/folders inside folder "upload"? If you only download kBank 2.0 Upgrade 2.0.1.zip, you have to download kBank 2.0.1 Installation.zip and re-upload to your forum root! kBank 2.0 Upgrade 2.0.1.zip is used for upgrading only!
I uploaded all files but I have the problem

mrpaint 07-30-2008 12:01 PM

Quote:

Originally Posted by parseforum (Post 1587358)
I uploaded all files but I have the problem

Can you screenshot your files/folder tree in you server?

parseforum 07-30-2008 12:57 PM

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

Code:

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


mrpaint 07-30-2008 01:19 PM

Quote:

Originally Posted by parseforum (Post 1587412)
I deleted the files and upload them again now I have this error:

Code:

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


All times are GMT. The time now is 10:48 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01471 seconds
  • Memory Usage 1,770KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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