Thanks Jordan.
Can you refer some URL from where I can checkout the changes done in
ZF-1.5.2 as you have mentioned that "Zend_Db_Table_Abstract had major
changes in the 1.5 release". Also, could you please let me know the correct
procedure to upgrade the system. This is what I am not getting.
I agree that the SQL issue can be related to the changes in
"Zend_Db_Table_Abstract" class BUT why it is also showing errors in
"ACTIONS" .. any idea?
Thanks
Ashish
Jordan Moore wrote:
>
> Also... I'd highly recommend against upgrading so many components at
> once. It's almost always a bad idea.
>
> On Mon, Jun 9, 2008 at 11:43 PM, ashish.sharma
> <[EMAIL PROTECTED]> wrote:
>>
>> 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.
>>
>>
>
>
>
> --
> Jordan Ryan Moore
>
>
--
View this message in context:
http://www.nabble.com/Zend-Framework-Stop-Working-after-PHP-upgrade-to-5.2.6---URGENT-tp17748031p17749445.html
Sent from the Zend Framework mailing list archive at Nabble.com.
