Help Please [Archive] - vb.org Archive

View Full Version : Help Please

King Fly

12-13-2008, 04:17 PM

please can someone help....i installed the kbank mod https://vborg.vbsupport.ru/showthread.php?t=185318&highlight=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">

</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 1229267855 at 1229267855 ---------------

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 1229270036 at 1229270036 ---------------

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.

King Fly

12-14-2008, 05:57 PM

i cant get into the product managment to remove the product...i get this database error on every page of my forum..so i cant enter the place to take it ou

--------------- Added 1229286561 at 1229286561 ---------------

even went and upgraded to 3.8 and still same database error....is there any back door to remove products??

--------------- Added 1229286592 at 1229286592 ---------------

site addy is www.undagroudutopia.com/forums

Lynne

12-14-2008, 06:34 PM

Did you remove all the files (via ftp) that you had uploaded for that product? That is VERY important. If you want to disable the product via phpMyAdmin, the table name is 'product' and the column is "active" - set to 0 for inactive.

King Fly

12-14-2008, 07:06 PM

ok i get the database error when the files for the product are in my sever.....when i remove the file via ftp then i get the code which i firt posted

where would i find the table for this product in myphpadmin?

--------------- Added 1229289366 at 1229289366 ---------------

i think i got it...im reuploading 3.8 just incase and files got written over....i did what you said and made the product inactive in my phpadmin....hopefully this works...if so i owe a huge thanks

--------------- Added 1229289862 at 1229289862 ---------------

this worked...thank you again so much.....