I am evaluating Joomla 1.6.1, and am also evaluating Phoca Download.
When I went to install Phoca Download, it only half installed, and there was no 'settings', 'licenses', or other areas available.
Looking in MyPHPAdmin, I have found that there were only 2 tables installed instead of the several I presume should have been installed.
As per troubleshooting instructions on your website (and as this is a new dummy test install - it doesn't matter about overwriting existing tables as they have no data in them), I have attempted to import the install.bak file to create all tables again. I get this error message for jos_phocadownload_categories table, and similar messages for other tables.
only 2 tables originally installed correctly: jos_phocodownload_file_votes and jos_photodownload_file_votes_statistics.Error
SQL query:
CREATE TABLE `jos_phocadownload_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default 0, `section` int(11) NOT NULL default 0, `title` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `image` varchar(255) NOT NULL default '', `image_position` varchar(30) NOT NULL default '', `description` text, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `uploaduserid` text, `accessuserid` text, `deleteuserid` text, `date` datetime NOT NULL default '0000-00-00 00:00:00', `count` int(11) NOT NULL default '0', `hits` int(11) NOT NULL default '0', `params` text, `metakey` text, `metadesc[...]
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 32
Could you please advise. Thanks, Witchdoctor.
