Not sure where to post this so I sincerely apologize. I am a newbie here. I've tried getting help from my "agent" and it basically boiled down to upgrade to 7.0.3. I did that and all was well. Then I loaded my database of members back in and now the same issues are coming up again. I am getting emails from my site with 277 pages of code attached. (Don't worry... I'm not posting all that! Here is the message I am receiving:
Database error in "site"
Query:
SELECT `Text`, `Author` FROM `bx_quotes_units` ORDER BY RAND() LIMIT 1
Mysql error: Got error 28 from storage engine
Found error in the file '/home/jacktaxe/public_html/modules/boonex/quotes/classes/BxQuotesDb.php' at line 41.
Called 'getRow' function with erroneous argument #0.
I go to that file/line in Dreamweaver or cpanel and see the following:
require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolModuleDb.php' );
define('BX_QUOTES_TABLE', 'bx_quotes_units');
/*
* Quotes module Data
*/
class BxQuotesDb extends BxDolModuleDb {
var $_oConfig;
/*
* Constructor.
*/
function BxQuotesDb(&$oConfig) {
parent::BxDolModuleDb();
$this->_oConfig = $oConfig;
}
function getRandomQuote() {
line 41 return $this->getRow("SELECT `Text`, `Author` FROM `" . BX_QUOTES_TABLE . "` ORDER BY RAND() LIMIT 1");
}
function getQuote($iID) {
return $this->getRow("SELECT * FROM `" . BX_QUOTES_TABLE . "` WHERE `ID`='{$iID}' LIMIT 1");
}
function getAllQuotes() {
return $this->getAll("SELECT * FROM `" . BX_QUOTES_TABLE . "`");
}
function deleteUnit($iID) {
return $this->query("DELETE FROM `" . BX_QUOTES_TABLE . "` WHERE `ID`='{$iID}' LIMIT 1");
}
}
And I don't know if this is related or a separate item so I beg your forgiveness but I am receiving this email from my hosting company:
<div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
<div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
<div style="text-align:center;">Database connect failed</div>
</div>
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/jacktaxe/public_html/inc/classes/BxDolDb.php on line 453
Fatal error: Call to a member function getParam() on a non-object in /home/jacktaxe/public_html/inc/db.inc.php on line 83
In inc/classes/BxDolDb.php on line 453:
if( DB_DO_EMAIL_ERROR_REPORT )
{
$sMailBody = "Database error in <SiteName><br /><br /> \n";
if( strlen( $query ) )
$sMailBody .= "Query: <pre>" . htmlspecialchars_adv($query) . "</pre> ";
line 453: $sMailBody .= "Mysql error: " . mysql_error($this->link) . "<br /><br /> ";
$sMailBody .= $sFoundError. '<br /> ';
$sBackTrace = print_r($aBackTrace, true);
$sBackTrace = str_replace('[password] => ' . DATABASE_PASS, '[password] => *****', $sBackTrace);
$sBackTrace = str_replace('[user] => ' . DATABASE_USER, '[user] => *****', $sBackTrace);
$sMailBody .= "Debug backtrace:\n <pre>" . htmlspecialchars_adv($sBackTrace) . "</pre> ";
$sMailBody .= "Called script: " . $_SERVER['PHP_SELF'] . "<br /> ";
$sMailBody .= "Request parameters: <pre>" . print_r( $_REQUEST, true ) . " </pre>";
$sMailBody .= "--\nAuto-report system\n";
//$sMailBody = '<pre>' . htmlspecialchars_adv($sMailBody) . '</pre>';
sendMail( $site['bugReportMail'], "Database error in <SiteName>", $sMailBody, 0, array('SiteName' => $GLOBALS['site']['title']) );
}
exit;
In inc/db.inc.php on line 83:
function getParam( $param_name, $use_cache = true ) {
line 83 return $GLOBALS['MySQL']->getParam($param_name, $use_cache);
}
function getParamDesc( $param_name ) {
return $GLOBALS['MySQL']->getOne ("SELECT `desc` FROM `sys_options` WHERE `Name` = '$param_name'");
}
function setParam( $param_name, $param_val ) {
return $GLOBALS['MySQL']->setParam($param_name, $param_val);
}
I am using Vista and have a 64 bit system. I prefer Firefox over IE but use both to make sure my site works in both. I do not seem to find any errors popping up in my actual site or in the admin. Obviously I am not too familiar with PHP... I am more comfortable with html but am willing to learn. Right now though, I just don't understand the issues or why they keep emerging. The only thing I can think of is my member database...
Any help and patience would be enormously appreciated.
Best regards,
JPAres1
