vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Help Please (https://vborg.vbsupport.ru/showthread.php?t=198792)

King Fly 12-13-2008 04:17 PM

Help Please
 
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 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 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 12-13-2008 05:34 PM

Post the database error.

King Fly 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 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 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 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 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">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</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">&nbsp;<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 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.


All times are GMT. The time now is 09:12 PM.

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.01058 seconds
  • Memory Usage 1,771KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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