954,180 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Error messages pls help

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= '
<?xml version="1.0" encoding="'.$this->charset.'"?>
<?xml-stylesheet href="#internalStyle" type="text/css"?>
';
break;
case 'xhtml_trans':
$headerStart= '
<?xml version="1.0" encoding="'.$this->charset.'"?>
<?xml-stylesheet href="#internalStyle" type="text/css"?>
';
break;
case 'xhtml_frames':
$headerStart= '
<?xml version="1.0" encoding="'.$this->charset.'"?>
';
break;
default:
$headerStart='';
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.

madhusuri
Newbie Poster
2 posts since Jul 2005
Reputation Points: 10
Solved Threads: 0
 

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
Posting Whiz
362 posts since Jun 2005
Reputation Points: 36
Solved Threads: 6
 

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

onewebsite
Newbie Poster
1 post since Jul 2005
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You