Counting query problem
am 12.09.2007 07:37:16 von Cindy ChambersI have meeting minutes that need to be paged through via my website. I have
created a developer server on my local machine and when I run the PHP code
against the MySQL table that I imported from my ISP's website everything
works fine. However, when I upload the PHP pages to the ISP's server
everything connects but it doesn't page through anymore. It just sits on
the latest created page. I click the previous button and it shows it
reading but nothing happens.
So I know the code works from my local test so why does it not work when I
put it live? All this code worked prior to my ISP upgrading their MySQL and
phpMyAdmin software. Any ideas how to get everybody to talk again?
Here are some stats:
My ISP:
localhost
a.. Server version: 4.1.22-standard
b.. Protocol version: 10
c.. Server: Localhost via UNIX socket
d.. MySQL charset: UTF-8 Unicode (utf8)
e..
MySQL connection collation: utf8_unicode_ci
phpMyAdmin - 2.10.0.2
a.. MySQL client version: 4.1.22
b.. Used PHP extensions: mysql
My Developer Server:
Apache2Triad which includes Apache server, MySQL and PHP and is Windows
based.
Updates and versions for this Triad include:
fixed mod_perl 2.0.1 bug *
added apache SSL restart
optimised access.cgi to deal with huge logs
updated Apache to 2.2.0
updated OpenSSL to 0.9.8a
updated PHP to 5.1.2
updated Zend Optimizer to 2.6.2
updated Xdebug to 2.0.0 beta5
updated DBG to 2.18.5
updated SlimFTPd to 3.18
updated Xmail to 1.22
updated PostgreSQL to 8.1.2
updated pgAdmin to 1.4.1
updated phpPgAdmin to 4.0.1
updated MySQL to 5.0.18
updated MyODBC to 5.0.0
added MySQL Administrator 1.1.8
added MySQL Query Browser 1.1.20
updated PHPmyadmin to 2.7.0 pl2
updated UebiMiau to 2.7.9
updated AWStats to 6.5
security fix for CVE-2006-0144
added Apache2Triad Manager
reverted apache MaxRequestsPerChild to 0
INCLUDES filter removed issue adressed
added fix for VC80.CRT runtime libraries
updated mod_perl to 2.0.3
updated mod_ssl to 2.2.0
disabled mod_python 3.2.7 **