sat4all
08-02-2010, 00:34
witam zainstalowalem Phoca Gallery i wywal mi taki komunikat , moze ktos jest wstanie mnie naprowadzic co i jak , dzieki
Phoca Gallery not successfully installed:
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 37 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, `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `zoom` int(3) NOT NULL default '0', `geotitle` varchar(255) NOT NULL default '', `videocode` text, `vmproductid` int(11) NOT NULL default '0', `imgorigsize` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `approved` 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, `metakey` text, `metadesc` text, `extlink1` text, `extlink2` text, `extid` varchar(255) NOT NULL default '', `extl` varchar(255) NOT NULL default '', `extm` varchar(255) NOT NULL default '', `exts` varchar(255) NOT NULL default '', `exto` varchar(255) NOT NULL default '', `extw` varchar(255) NOT NULL default '', `exth` varchar(255) NOT NULL default '', 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 40 SQL=CREATE TABLE `jos_phocagallery_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default 0, `owner_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, `date` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `approved` 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', `accessuserid` text, `uploaduserid` text, `deleteuserid` text, `userfolder` text, `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `zoom` int(3) NOT NULL default '0', `geotitle` varchar(255) NOT NULL default '', `extid` varchar(255) NOT NULL default '', `exta` varchar(255) NOT NULL default '', `extu` varchar(255) NOT NULL default '', `params` text, `metakey` text, `metadesc` text, 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, 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, `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, 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 13 SQL=CREATE TABLE `jos_phocagallery_img_votes` ( `id` int(11) NOT NULL auto_increment, `imgid` 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, 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_img_votes_statistics` ( `id` int(11) NOT NULL auto_increment, `imgid` 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 13 SQL=CREATE TABLE `jos_phocagallery_user` ( `id` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL default 0, `avatar` varchar(40) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `approved` 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, PRIMARY KEY (`id`), KEY `userid` (`userid`) ) 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_img_comments` ( `id` int(11) NOT NULL auto_increment, `imgid` 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, `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, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
Phoca Gallery not successfully installed:
DB function failed with error number 1064
Something is wrong in your syntax obok 'CHARACTER SET `utf8`' w linii 37 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, `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `zoom` int(3) NOT NULL default '0', `geotitle` varchar(255) NOT NULL default '', `videocode` text, `vmproductid` int(11) NOT NULL default '0', `imgorigsize` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `approved` 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, `metakey` text, `metadesc` text, `extlink1` text, `extlink2` text, `extid` varchar(255) NOT NULL default '', `extl` varchar(255) NOT NULL default '', `extm` varchar(255) NOT NULL default '', `exts` varchar(255) NOT NULL default '', `exto` varchar(255) NOT NULL default '', `extw` varchar(255) NOT NULL default '', `exth` varchar(255) NOT NULL default '', 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 40 SQL=CREATE TABLE `jos_phocagallery_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default 0, `owner_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, `date` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `approved` 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', `accessuserid` text, `uploaduserid` text, `deleteuserid` text, `userfolder` text, `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `zoom` int(3) NOT NULL default '0', `geotitle` varchar(255) NOT NULL default '', `extid` varchar(255) NOT NULL default '', `exta` varchar(255) NOT NULL default '', `extu` varchar(255) NOT NULL default '', `params` text, `metakey` text, `metadesc` text, 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, 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, `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, 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 13 SQL=CREATE TABLE `jos_phocagallery_img_votes` ( `id` int(11) NOT NULL auto_increment, `imgid` 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, 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_img_votes_statistics` ( `id` int(11) NOT NULL auto_increment, `imgid` 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 13 SQL=CREATE TABLE `jos_phocagallery_user` ( `id` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL default 0, `avatar` varchar(40) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `approved` 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, PRIMARY KEY (`id`), KEY `userid` (`userid`) ) 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_img_comments` ( `id` int(11) NOT NULL auto_increment, `imgid` 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, `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, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;