Can't install vbgallery 3.01 under mysql 5.5.9 with innodb
 

Hello! Just tried to install vbgallery 3.01 at vB 4.1.2 Suite under MySQL 5.5.9 (with default InnoDB engine) and get:

1. The first error:


2. Ok, I replaced with (remove TYPE=MyISAM everywere) and get a second error:

Of course, InnoDB doesn't support FULLTEXT indexes.
So, we need a new vbgallery_install.php script for vbgallery installing under mysql 5.5.x as InnoDB is default at the new mysql release. Please help!

Nope, you cant remove myisam, but you should have replaced with ENGINE=MyIsam


and, there is a new installer, (cant find the thread where it was posted) so i added it here also.

Main changes, type changed to engine and a couple of other minimal changes.

main thing, it will now install for versions of mysql > 5.5
BUT vbgallery still depends on MyIsam and you should not change to innodb.

(In mysql docs it says that both types can live side by side without problems)


But innodb is very very slow when count(*) is used. (and counts are used on main pages specially for pagination) so in very large galleries the pages could take more than 30 seconds loading.

To be able to get same results with innodb, the whole script would have to be rewritten.

But try the attached installer as is, it should work.

Luc

Yes, the script works! Tables have been installed correctly under MyISAM and work great. Thank you!

Looking forward to the innodb vbgallery version :)