So, can we use without InnoDB?
Submitted by yonation on Wed, 10/03/2007 - 21:04.
I've seen questions around the forums about using without InnoDB, but no replies - is it possible to have a workaround for this? I know the kids at activecollab have gotten around it, but is there a workaroudn for ProjectPier?
It seems there's no workaround so far .. I had no problems with aC on my hosting account, but ProjectPier just won't install because of the InnoDB issue. Is there really no way, maybe to skip the InnoDB check during installation and install ProjectPier anyway?
Please provide more details about your hosting situation. Also, can you include what workarounds you have already tried?
All the workarounds I found regarded the my.conf file - which I can not access as I'm not using a local webserver but a 'real' hosting account. I already asked my provider if I could get the InnoDB support for MySQL - I can't.
I have a 'normal' hosting account from a huge german webspace provider, supporting MySQL 5 and PHP 5. I also installed various web-software before (blogs, CMS, etc.) and never had any problems - of course, I never heard of InnoDB before.. ;)
I really think you should get rid of this InnoDB feature or at least make it optional, if MySQL alone also works. It seems I'm not the only one having problems with the ProjectPier installation, and it's a little frustrating if you just can't do a quick install if you'd like to test this software on your own account.
Read This
http://www.activecollab.com/forums/topic/783/
Then Try this
http://www.activecollab.com/forums/topic/1302/
Please note that this is not currently supported and you do so at your own risk.
Thanks! After reading the first of the two forum entries I was finally able to install ProjectPier on my hosting account without InnoDB support. Just open the public/install/installation/acInstallation.class.php file an put two slashes at the beginning of line 113:
// return $this->breakExecution('InnoDB storage engine is not supported');
... because a lot of hosting providers offer only MYISAM support
This hack is not officially supported by ProjectPier, hence why it is not in the manual. Removing the requirement for InnoDB is one of the priorities for development, but if you read some of the other information from those posts you will realize why this isn't a good solution.
Thanks for the workaround info - and I will apply this on my personal web space which has the same problem (hosted at one.com).
What worries me more is that I couldn't find any info if applying that "fix" will be risky for our user's data, which would be a showstopper IMHO and we should officially announce that.
I used aC 0.6 and up before without any data loss, so I think this should be fine ... but maybe one of you DB gurus has a correct answer for us.
Best
Roland
http://en.wikipedia.org/wiki/InnoDB
I already posted this link, but please see this regarding why the original aC code uses InnoDB and why its not particularly stable without it. http://www.activecollab.com/forums/topic/783/ It might work just fine, but that doesn't mean it is a solid solution. For example, I wouldn't bet my company's infrastructure on it - but for a community group collaboration site, its probably fine and isn't the end of the world if something gets corrupted. All I suggest is caution until a proper solution is provided in the code for removing the requirement.
We shouldn't build software just by making hacks and hoping they work.
> We shouldn’t build software just by making hacks and hoping they work.
I totally agree :-)