Now I find I should have stayed with 2.2.

I upgraded to 2.6 and re-installed my original database.

Now I get

SELECT * FROM video WHERE active=1 AND approve=1 AND type='public' ORDER by VID DESC LIMIT

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

What is the problem?

(Yes, I uploaded everything in binary.)