Page 1 of 1
guestbook not creating any tables on install
Posted: 07 Jul 2011, 01:27
by cybersalt
I am trying to download the version of Phoca Guestbook that is at:
http://joomlacode.org/gf/download/frsre ... v1.4.4.zip
It installs fine except that it creates nothing in the database.
Thanks.
guestbook not creating any tables on install
Posted: 07 Jul 2011, 02:57
by cybersalt
After looking further into this I did find a .bak file with sql commands in them - and they had TYPE=MYISAM on some lines - which does not work on mysql5.5, which I am running.
Mysql5.5 requires ENGINE=MYISAM - so I am guessing that perhaps my install problems are due to my using mysql5.5 in some way.
Have you converted other phoca components for mysql5.5 and just missed this one?
Tim
Re: guestbook not creating any tables on install
Posted: 08 Jul 2011, 03:39
by cybersalt
Crickets sound while I talk to myself, lol.
I can confirm that this is a mysql5.5 issue.
In the file "phocaguestbookinstall.php" I replaced 4 occurrences of "TYPE=MyISAM" with "ENGINE=MyISAM" and all installed just fine to my mysql5.5 database
This change needs to be done for all install scripts for Joomla extensions.
Re: guestbook not creating any tables on install
Posted: 08 Jul 2011, 23:04
by Jan
Hi, yes, it is done for latest versions and every new version get this change.
Jan