I'm having major issues with mysql and php. I'm running WAMP with PHP 5.3.5, mySQL 5.5.8, apache 2.2.17 AND piwigo 2.1.6
My problem is that i cannot get piwigo to utilize the new database structure in php 5.3.5, InnoDB. I've read that in PHP 5.3.5 InnoDB is the default handler(or whatever you call that) versus myISAM. During the piwigo install, it cannot automatically create the database tables. SO i tried to use the sql files to manually do it and it errors at the myISAM command and stops. Is there someway I can get Piwigo to use the new mySQL database??? I installed an earlier version of mySQL but non of my other scripts worked so i cant really downgrade that. Thank you for your help!
Last edited by donahuge (2011-01-26 23:03:02)
6 months ago, I gave a reply to a similar issue on [Forum, post 113909 by plg in topic 16034] MySQL Database Import Error
Unfortunately and as far as I'm concerned, I have not performed any test on MySQL 5.5.
Which Linux/BSD distribution are you using?
I found that article and followed through with it. I successfully installed a version of mySQL that uses the myISAM approach and all my other scripts stopped working. So i can't really downgrade mySQL. I'm running WAMP which runs on Windows. I'm currently running Windows XP. I know that a terrible OS to use but i still want to use it. I'm familiar with LAMP running on Ubuntu, but this server isn't mine so i cannot change the OS.
I feel like this switch this from myISAM to InnoDB in mySQL 5.5 is here to stay so my question would be, will piwigo support it? I am a noob to this stuff so just let me know if that is ridiculous :) Thanks again!!!
Last edited by donahuge (2011-01-26 23:18:20)
I feel like this switch this from myISAM to InnoDB in mySQL 5.5 is here to stay so my question would be, will piwigo support it?
If MySQL doesn't support MyISAM in its future version, of course Piwigo will switch to InnoDB or any table engine compliant with the future version of MySQL.
As far as my benchmarks went in the past, InnoDB takes much more memory and is slower than MyISAM :-/ OK, we have a better database integrity, but I fear the downgrade of performances.
(it's perfectly OK to use Windows, I was wondering which Linux distribution was propositin MySQL 5.5 so soon)
Apparently Oracle purchased the company that makes innodb and has made it faster and will now be implementing it. I really just stepped in to the world of dynamic content and databases so I might be jumping the gun. I'm now realizing that its not too important to have the most up-to-date php and sql software because it not always supported for awhile. This stuff is a lot of work!! Thanks for your help!!
MySql 5.5 supports MyISAM engine. The problem is located on Sql syntax: "TYPE=MyISAM" have to be replaced by "ENGINE=MyISAM".
Already notified in [Bugtracker, bug 2155, fixed] MySql error on gallery installation with MySql 5.5 and above ;-)