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