I fear this is becoming a database version issue. We will have to raise the minimum database version required. 4.0 simply does not select the queries required to run the workload and SEO optimization. It is about sub queries that were not supported in 4.0 and that would cause us to write additional queries and transfer the result sets back and forth form the database. We will have to update the minimum MySQL version requirement.

Sorry about that. I fear there wont be an easy work around other than upgrading the mysql version you are running.

As I said in the other thread, this is now confirmed a version issue with MySQL. The version you are running 4.0 is lacking support for the most basic derived table SQL statements. Something we have used to severely reduce the number of SQL calls. I recommend you upgrade your MySQL environment to a more up to date version and this issue will go away.

PLEASE READ:

www.bestofjoomla.com/component/option,co...d,77/id,57822/#57822

Hi,
My sql version is 5.0.32 Debian and have the same fb_debug.php error..
Piet

Once I moved my site to another host that I verified was using mysql 5 or above, all the errors I was having stopped. I posted about my errors on that link provided by fxstein and will post again to alert others that it really was exactly as stated. MySql at the old host was not high enough to run FB 1.0.5rc2.

So All I can say is double check that sql and make sure because I thought my sql was above as my host told me it was, but this is what I found out.

Client API library version 4.1.22
Client API version again at 5.0.45 <-- my host said this was mysql version. It was NOT, it was the above 4.1.22 and each time I tried to verify it they would never answer my direct questions. I moved my site and I no longer have DB errors, 503 errors, etc...

Good luck!