This will go some way to explaining your actions problem...
http://framework.zend.com/manual/en/zend.controller.migration.html
Besides the usual array of minor fixes and enhancements, the big
change to Zend_Db_Table was the way the WHERE, ORDER and LIMIT clauses
were added via the API. The new Zend_Db_Table_Select component is now
the preferred way to assemble queries for all fetch/find methods.
However, you didn't mention how the query you're specifically having
trouble with was created, nor the final SQL, nor whether your database
still supported the same call. Can you confirm these - it makes it
harder to provide specific advice without knowing what you're trying
to achieve or how you've approached the issue.
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.
--
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