The Arcive of Official vBulletin Modifications Site.

King Fly · #1 12-13-2008, 04:17 PM

please can someone help....i installed the kbank mod https://vborg.vbsupport.ru/showthrea...ighlight=kbank

and i got a database error...didnt tell me what just database error on any page i went too

so i removed all the stuff from my server and now get this

Warning: include_once([path]/kbank/init.php) [function.include-once]: failed to open stream: No such file or directory in [path]/includes/init.php(294) : eval()'d code on line 2

Warning: include_once() [function.include]: Failed opening '[path]/kbank/init.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in [path]/includes/init.php(294) : eval()'d code on line 2

Warning: include([path]/kbank/hook_fetch_userinfo_query.php) [function.include]: failed to open stream: No such file or directory in [path]/includes/functions.php(1316) : eval()'d code on line 2

Warning: include() [function.include]: Failed opening '[path]/kbank/hook_fetch_userinfo_query.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in [path]/includes/functions.php(1316) : eval()'d code on line 2

Warning: include([path]/kbank/hook_fetch_musername.php) [function.include]: failed to open stream: No such file or directory in [path]/includes/functions.php(1090) : eval()'d code on line 2

Warning: include() [function.include]: Failed opening '[path]/kbank/hook_fetch_musername.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in [path]/includes/functions.php(1090) : eval()'d code on line 2

Warning: include([path]/kbank/hook_fetch_userinfo.php) [function.include]: failed to open stream: No such file or directory in [path]/includes/functions.php(1394) : eval()'d code on line 2

Warning: include() [function.include]: Failed opening '[path]/kbank/hook_fetch_userinfo.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in [path]/includes/functions.php(1394) : eval()'d code on line 2

how do i fix it....i cannot get to my forum...

i even reinstalled VBulletin an still nothing works....i cant get to my product management to remove the kbank product which i think is the problem

Lynne · #2 12-13-2008, 05:21 PM

Did you Uninstall the Product in the Product Manager? And then remove any files you uploaded? Or undo any file edits?

King Fly · #3 12-13-2008, 05:24 PM

i couldnt get to product managemnet after installing....got page with database error....and not the kind inside the admincp if you know what i mean...a sperate page with the vb logo and database error...try and refresh...or go back...hit go back just refreshes...so i kinda figure its the product but i dont know how to go in and remove it now

Lynne · #4 12-13-2008, 05:34 PM

Post the database error.

King Fly · #5 12-13-2008, 11:08 PM

again.....it idnt give a specific database error...once in imported it it redirected to a webpage with a vb logo awhich said...you have encountered a database error...refresh or go back.....no identified error...now i just get the code above

Lynne · #6 12-13-2008, 11:21 PM

Yeah, on the "you have encountered an error" page, there is a database error. You can view it in the page source. Post that.

King Fly · #7 12-13-2008, 11:37 PM

i dont have that pag anymore nor can i get it.....that was as soon as i installed the product..i have since deleted any files associated with the kbank hack and are now leftwith the above code i have mentioned

thats all i have or all i can access is the code in my original post

Lynne · #8 12-14-2008, 02:34 AM

Well, you need to somehow uninstall it cuz you never did that and now you are getting errors because it is looking for the necessary files which you deleted. I'd suggest adding back all the files, then finding the database error, fixing that, then uninstalling the modification properly.

King Fly · #9 12-14-2008, 01:16 PM

ok i did what you suggested and got this as the veiw source code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Da UndaGround Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">

</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://undagroudutopia.com/forums/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 Da UndaGround 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="/">undagroudutopia.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 undagroudutopia.com forum technical staff have been notified of the error, though you may <a href="mailto:kingfly@kingflyent.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td>
</tr>
</table>

<!--
Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

,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_Cash AS kbank_granted_Cash

FROM vbuser AS user
LEFT JOIN vbuserfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

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.Cash SEPARATOR '|') AS allow_Cash
FROM `vbkbank_granted_permission` AS kbank_granted
INNER JOIN `vbuser` 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 : Table 'letstrythisagain.vbkbank_granted_permission' doesn't exist
Error Number : 1146
Request Date : Sunday, December 14th 2008 @ 08:13:38 AM
Error Date : Sunday, December 14th 2008 @ 08:13:39 AM
Script : http://undagroudutopia.com/forum/

--------------- Added [DATE]1229267855[/DATE] at [TIME]1229267855[/TIME] ---------------

it keeps teeling me i am using 3.8 as well.....i had upgraed to that but found somethings didnt work and went back to 3.7

--------------- Added [DATE]1229270036[/DATE] at [TIME]1229270036[/TIME] ---------------

is there any backdoor way to get in and remove the product?

Lynne · #10 12-14-2008, 04:39 PM

You cannot go back to 3.7 after you upgraded to 3.8. The database gets changed when you upgrade and unless you somehow undid all of the database changes, then it isn't possible to go back. You WILL get errors if you try to use 3.7 files on a 3.8 database.

Did you install that using an install script? The install script should have added the new database table, but it seems to be missing. That is what the error is about. Try doing an uninstall now on that product and make sure you remove any files you were supposed to add with the install.

Even after you do the uninstall, as I said above, you WILL still get errors on your site if you are using a database that has been upgraded to 3.8 and you are using the 3.7 files. And please use the html/php/code tags when posting code.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04126 seconds Memory Usage 2,269KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!