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
