ray_noel
Posts: 31
|
| Posted: 09/19/2006, 6:48 PM |
|
Pls help,
Everytime I published my page which is currently active and I did not change anything, I got this
eror "Fatal error: Call to undefined function: optimizesql() in /var/www/kainos/keap/mod_doctors/doc_report_1.php on line 921" I don't know what happen,
I haven't change yet I just republished it.
Anyone knows?
when i go to that file and line.... I have this code
Thanks. $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
but when I just publish the page without using database, just
simple "hello" it will display the text...
|
 |
 |
ray_noel
Posts: 31
|
| Posted: 09/20/2006, 6:40 PM |
|
hi,
Any help?
The line above which has the error is under the Open Method code.
//Open Method @2-19675CF8
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->CountSQL = "SELECT COUNT(*)\n\n" .
"FROM doctors";
$this->SQL = "SELECT * \n\n" .
"FROM doctors {SQL_Where} {SQL_OrderBy}";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
if ($this->CountSQL)
$this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
else
$this->RecordsCount = "CCS not counted";
$this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
}
//End Open Method
|
|
|
|
peterr
Posts: 5971
|
| Posted: 09/21/2006, 12:52 AM |
|
Please contact product support with technical issues.
Thanks.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
