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
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.
Yes, the script works! Tables have been installed correctly under MyISAM and work great. Thank you!
Looking forward to the innodb vbgallery version :)
|All times are GMT -5. The time now is 08:45 PM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0