guestbook not creating any tables on install

cybersalt · Post by **cybersalt** » 07 Jul 2011, 01:27

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.

cybersalt · Post by **cybersalt** » 07 Jul 2011, 02:57

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

cybersalt · Post by **cybersalt** » 08 Jul 2011, 03:39

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.

Post by **Jan** » 08 Jul 2011, 23:04

Hi, yes, it is done for latest versions and every new version get this change.

Jan

Phoca Forum