Thanks Simon,
Here I would like add one more thing which I have missed in my previous
posts (and I apologize for that) we had also upgraded our ZF to ZF-1.03 to
ZF-1.5.2
I think this is causing the problem but I don't know why? Do you have any
idea?
As a temporary fix, we have re-install ZF-1.03 on our server and the site is
now working again. Do you have any idea as why it was not working on ZF
1.5.2? Why it is showing errors in running queries also in actions?
Thank you very mush for your time.
Ashish
Simon Mundy wrote:
>
> Hi Ashish
>
> I don't think your SQL problems can be attributed to the Apache
> configuration - can you compare the final SQL query from the 'old'
> server with the new? Is the 'fetchCount' called from within a model
> that extends Zend_Db_Table? Have you also run the query from within
> the database on the same machine to ensure there's nothing incorrect
> about the new setup in PHP?
>
> One sure fire way would be to install PHPUnit on your newer server and
> run the unit tests to see if it's a ZF problem or perhaps more related
> to the way your code extends it.
>
>>
>> Thanks for your Steven.
>>
>> Could you please explain as what exactly needs to be checked in Apache
>> configuration. As far as the .htaccess file is concerned, it is same
>> as
>> ealier (no changes made in that).
>>
>> The most weird part which I am not getting is why the SQL query is not
>> working now? The function ..
>>
>> public function fetchCount($cols = '*', $where = null)
>> {
>> $rowset = $this->fetchCols(new
>> Zend_Db_Expr(sprintf('COUNT(%s) AS
>> total_records', $cols)), $where);
>> return (integer) $rowset->current()->total_records;
>>
>> }
>>
>> . .. is returning all the columns from the table and NOT the count
>> only.
>>
>>
>>
>>
>> Steven Brown-7 wrote:
>>>
>>> Check that your Apache configuration and .htaccess files are the
>>> same/correct
>>>
>>> -----Original Message-----
>>> From: ashish.sharma [mailto:[EMAIL PROTECTED]
>>> Sent: Tuesday, 10 June 2008 3:25 PM
>>> To: fw-general@lists.zend.com
>>> Subject: [fw-general] Zend Framework Stop Working after PHP upgrade
>>> to
>>> 5.2.6
>>> - URGENT
>>>
>>>
>>> Hello ALL,
>>>
>>> Yesterday we had upgraded our server to PHP 5.2.6 and after that our
>>> applications based on ZF1.0 are NOT WORKING. The sections which were
>>> working
>>> earlier are not working now and showing errors and warning. For
>>> example
>>> the
>>> count function to get the count of records from a table in showing an
>>> error
>>> saying "Specified column "total_records" is not in the row " here
>>> is the
>>> function code ...
>>>
>>> public function fetchCount($cols = '*', $where = null)
>>> {
>>> $rowset = $this->fetchCols(new
>>> Zend_Db_Expr(sprintf('COUNT(%s) AS
>>> total_records', $cols)), $where);
>>> return (integer) $rowset->current()->total_records;
>>>
>>> }
>>>
>>> The above code was working fine on LIVE server (running on LINUX)
>>> and it
>>> is
>>> still working fine on LOCAL systems (running on windows using
>>> XAMPP) but
>>> NOT
>>> on LIVE server now (after the upgrade).
>>>
>>> Also it starts showing errors like ...
>>>
>>> "Could not found the requested action.
>>> Action "getstates" does not exist and was not trapped in __call()"
>>>
>>> But this same code was working absolutely fine earlier (on LIVE
>>> server)
>>> and
>>> it is still working fine on our LOCAL systems (running on windows
>>> using
>>> XAMPP)
>>>
>>> FYI: Along with the PHP version upgrade we have recompiled PHP and
>>> Apache
>>> AND installed PEAR on our server.
>>>
>>> Kindly treat this as VERY URGENT and post your suggestion / reply
>>> ASAP.
>>>
>>> Thanks to all of you.
>>>
>>> Ashish
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Zend-Framework-Stop-Working-after-PHP-upgrade-to-5.2.6
>>> ---URGENT-tp17748031p17748031.html
>>> Sent from the Zend Framework mailing list archive at Nabble.com.
>>>
>>>
>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Zend-Framework-Stop-Working-after-PHP-upgrade-to-5.2.6---URGENT-tp17748031p17748361.html
>> Sent from the Zend Framework mailing list archive at Nabble.com.
>>
>
> --
>
> Simon Mundy | Director | PEPTOLAB
>
> """ " "" """""" "" "" """"""" " "" """"" " """"" " """""" "" "
>
> 202/258 Flinders Lane | Melbourne | Victoria | Australia | 3000
> Voice +61 (0) 3 9654 4324 | Mobile 0438 046 061 | Fax +61 (0) 3 9654
> 4124
> http://www.peptolab.com
>
>
>
--
View this message in context:
http://www.nabble.com/Zend-Framework-Stop-Working-after-PHP-upgrade-to-5.2.6---URGENT-tp17748031p17748777.html
Sent from the Zend Framework mailing list archive at Nabble.com.
