MySQL

Error messages pls help

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2005

Posts: 2

Reputation: madhusuri is an unknown quantity at this point

Solved Threads: 0

madhusuri

Offline

Newbie Poster

Error messages pls help

Jul 6th, 2005

Hi,
Iam a MySQL user and Iam currently having some error messages in my code.I use TYPO3 as the frontend.
I get these 2 warning messages
Warning: Supplied argument is not a valid MySQL result resource in /var/www/typo3/lib/t3lib/class.t3lib_db.php on line 677

Warning: Cannot add header information - headers already sent by (output started at /var/www/typo3/lib/t3lib/class.t3lib_db.php:677) in /var/www/typo3/lib/typo3/template.php on line 596

And the code in the 2 files r like this

[PHP]/**
* Returns the number of selected rows.
* mysql_num_rows() wrapper function
* Usage count/core: 85
*
* @param pointer MySQL result pointer (of SELECT query) / DBAL object
* @return integer Number of resulting rows.
*/
function sql_num_rows($res) {
return mysql_num_rows($res);
}[/PHP]

and for the secon warning its like this

[PHP] function startPage($title) {
// Get META tag containing the currently selected charset for backend output. The function sets $this->charSet.
$charSet = $this->initCharset();
$generator = $this->generator();

// For debugging: If this outputs "QuirksMode"/"BackCompat" (IE) the browser runs in quirks-mode. Otherwise the value is "CSS1Compat"
// $this->JScodeArray[]='alert(document.compatMode);';

// Send HTTP header for selected charset. Added by Robert Lemke 23.10.2003
header ('Content-Type:text/html;charset='.$this->charset);
switch($this->docType) {
case 'xhtml_strict':
$headerStart= '<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<?xml version="1.0" encoding="'.$this->charset.'"?>
<?xml-stylesheet href="#internalStyle" type="text/css"?>
';
break;
case 'xhtml_trans':
$headerStart= '<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?xml version="1.0" encoding="'.$this->charset.'"?>
<?xml-stylesheet href="#internalStyle" type="text/css"?>
';
break;
case 'xhtml_frames':
$headerStart= '<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
<?xml version="1.0" encoding="'.$this->charset.'"?>
';
break;
default:
$headerStart='<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">';
break;
}

// Construct page header.

$str = $headerStart.'[/PHP]

the main code that iam using is a real big one and also the problem is this is a live server running and so i cant give the full code.
Can you please help me with this.
I tried a lot of stuffs like checking for any blank spaces which might be put in by the editor, and for case sensitiveness but i dont seem to find any of those.Is there any other way to solve this problem.Please help me.
Thank you.

•

Join Date: Jun 2005

Posts: 354

Reputation: Troy is an unknown quantity at this point

Solved Threads: 5

Troy

Offline

Posting Whiz

Re: Error messages pls help

Jul 6th, 2005

Do not worry about the second error. The first error is causing the second. Fix the first, and the second goes away.

"Warning: Supplied argument is not a valid MySQL result" is exactly that--an invalid MySQL result. This is usually because the query you executed was invalid. So find the code where the SQL statement is actually executed (mysql_query()) and echo out the sql statement so you can physically see what is being sent to the database. Most likely, you'll find your problem.

Troy Wolf is the author of SnippetEdit. "Website editing as easy as it gets." IX Web Hosting

•

Join Date: Jul 2005

Posts: 1

Reputation: onewebsite is an unknown quantity at this point

Solved Threads: 0

onewebsite onewebsite is offline

Offline

Newbie Poster

Re: Error messages pls help

Jul 20th, 2005

Hi IM not sure if you still have the error in TYPO3 to rectify the error you will need to IMPORT the database, go to the backend and click on "Install", then goto database analyser, next to "Update required tables" click on compare and start updating the tables.
THen click on IMPORT next to Dump static data and import the records,
and that should hopefully have fixed your problem.

Tell me if that has rectified the problem?

Thanks
Ali