Cannot view Records (accounts, contacts, portals, leads, etc.) Please help.

[gdetemple]

Hi,

Please help me. I just installed Sugar and after i save a new record on any page/module i cannot view it. Anotherwords it does not get listed or does it display under account list, or contact list or any item in input. The only place it is displayed and accessible is through the "last viewed" feature. I am completely stumped. For some reason the script is not pulling all of the records from the Database. Even when i search, it says 1 of 1 but it displays no records. Please help me.

Glenn.

[salesagility]

We need to know ...

1. what version of sugar
2. what you're running on (o/s, php & mysql versions and webserver)
3. what changes you have made

Currently there's not enough information to be able to advise

[gdetemple]

Ok...I figured it out but now i have a new problem...

The reason why this was happening is due to the fact that i commented out the following from /include/database/PearDatabase.php because of the myslq warnings below. by doing so it got rid of the errors but no lists are displayed.

if($this->dbType == "mysql"){
/*if($this->getRowCount($result) > $rowNum){

mysql_data_seek($result, $rowNum);
}*/
$this->lastmysqlrow = $rowNum;

/*$row = mysql_fetch_assoc($result);*/

if($encode && $this->encode && is_array($row))return array_map('to_html', $row);
return $row;

}

I uncommented those lines and i can now see my lists but on my home page i getting the following:

Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 491

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 495

Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 491

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hermes/web03/b467/as.gdetemple1/public_html/sugar/include/database/PearDatabase.php on line 495


Please help me.