There was an error while processing a database query

[melban]

I've turned on debug mode and been unable to really pin down my article.  I've asked me host if he's done anything and they say they haven't.  The closest thing I've found on the boards that relates to my problem is something dealing with an upgrade in Zend optimizer but I don't know.

Any reason why it is not giving a value for the category WHERE value?  Thanks for any help.

Debug Code:

Code Select Expand


While executing query "SELECT aid FROM album_cp_albums WHERE category = " on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


[Tranz]

Go to admin tools / phpinfo. What versions of php and zend optimizer are running?

[melban]

Sorry did forget to post that it still allows me to login and things but just gives that error when doing anything else.

Link I found in reference to this.  Looks like I might need to have my host upgrade zend or php ?
http://forum.coppermine-gallery.net/index.php?topic=12711.0


PHP Version 4.3.10
Zend Engine v1.3.0

[Tranz]

You have the latest php version but zend optimiser is outdated. Latest is v2.5.7.

Actually, I can't tell what you have since you gave the version for Zend engine. The key thing to look at is the optimizer.

Contact your host.

[melban]

Sorry did see the different zend versions and names.

Zend Optimizer v2.5.5

[isloera]

I had the same problem with CPG 1.3.2. It just went crazy after PHP was upgraded from 4.3.9 to 4.3.10.

I contacted my host and suggested to upgrade to the latest version of the Zend Optimizer which is v2.5.7.
Today, they upgraded the Zend Optimizer and CPG is working perfectly.

I just don't understand why the hosts don't install the latest Optimizer when they install PHP 4.3.10,
because  it's clearly written on  the download page for PHP that  there are incompatibility issues with PHP 4.3.10 and earlier versions of the Zend Optimizer :http://www.php.net/downloads.php

[Casper]

I just don't understand why the hosts don't install the latest Optimizer when they install PHP 4.3.10,
because  it's clearly written on  the download page for PHP that  there are incompatibility issues with PHP 4.3.10 and earlier versions of the Zend Optimizer :http://www.php.net/downloads.php

That's just human nature.  We have clearly written docs and faq, but still have very many questions on these boards that reading the docs would solve.  I suppose they just forget to do one part of the upgrade.