PDA

Zobacz pełną wersję : Phoca Gallery - problem z instalacją



wampir666
17-12-2008, 20:35
Phoca Gallery not successfully installed:
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 18 SQL=CREATE TABLE `jos_phocagallery`( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `filename` varchar(250) NOT NULL default '', `description` text NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`) ) TYPE=MyISAM CHARACTER SET `utf8`;
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 24 SQL=CREATE TABLE `jos_phocagallery_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` 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 '', `section` varchar(50) NOT NULL default '', `image_position` varchar(30) NOT NULL default '', `description` text NOT NULL, `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', `count` int(11) NOT NULL default '0', `hits` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `cat_idx` (`section`,`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) TYPE=MyISAM CHARACTER SET `utf8`;
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 13 SQL=CREATE TABLE `jos_phocagallery_votes` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, `date` datetime NOT NULL default '0000-00-00 00:00:00', `rating` tinyint(1) NOT NULL default '0', `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', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 14 SQL=CREATE TABLE `jos_phocagallery_comments` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(255) NOT NULL default '', `comment` text NOT NULL, `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', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 7 SQL=CREATE TABLE `jos_phocagallery_votes_statistics` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `count` tinyint(11) NOT NULL default '0', `average` float(8,6) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 7 SQL=CREATE TABLE `jos_phocagallery_user_category` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, PRIMARY KEY (`id`), KEY `catid` (`catid`,`userid`) ) TYPE=MyISAM CHARACTER SET `utf8`;

mam najnowszą joomla, próbowałem z phoca gallery:
com_phocagallery_v2.0.2.zip
com_phocagallery_v2.1.0_RC.zip

i gdy wybieram instal (jak już się wczyta) pojawia się błąd widoczny u góry, ktoś wie o co chodzi ?

crazyluki
17-12-2008, 21:30
ja wiem
masz pewnie starą wersję serwera MYSQL. ale ciężko zgadywać;-)

wampir666
17-12-2008, 22:20
Dziękuje za pomoc :)
Faktycznie to było tego winą.