Ho provato a installare joomla su altervista ma mi da un errore...non capisco a cosa sia dovuto...eccolo:
[code]SQL=Table \'jos_banner\' already exists SQL=# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $\n\n# Table structure for table `jos_banner`\n\nCREATE TABLE `jos_banner` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'banner\',\n `name` varchar(50) NOT NULL default \'\',\n `imptotal` int(11) NOT NULL default \'0\',\n `impmade` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(100) NOT NULL default \'\',\n `clickurl` varchar(200) NOT NULL default \'\',\n `date` datetime default NULL,\n `showBanner` tinyint(1) NOT NULL default \'0\',\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `custombannercode` text,\n PRIMARY KEY (`bid`),\n KEY `viewbanner` (`showBanner`)\n) TYPE=InnoDB AUTO_INCREMENT=1:
- - - - - - - - - -
# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $
# Table structure for table `#__banner`
CREATE TABLE `#__banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) TYPE=MyISAM AUTO_INCREMENT=1
= = = = = = = = = =
SQL=Table \'jos_bannerclient\' already exists SQL=# Table structure for table `jos_bannerclient`\n\nCREATE TABLE `jos_bannerclient` (\n `cid` int(11) NOT NULL auto_increment,\n `name` varchar(60) NOT NULL default \'\',\n `contact` varchar(60) NOT NULL default \'\',\n `email` varchar(60) NOT NULL default \'\',\n `extrainfo` text NOT NULL,\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` time default NULL,\n `editor` varchar(50) default NULL,\n PRIMARY KEY (`cid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerclient`
CREATE TABLE `#__bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_bannerfinish\' already exists SQL=# Table structure for table `jos_bannerfinish`\n\nCREATE TABLE `jos_bannerfinish` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'\',\n `name` varchar(50) NOT NULL default \'\',\n `impressions` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(50) NOT NULL default \'\',\n `datestart` datetime default NULL,\n `dateend` datetime default NULL,\n PRIMARY KEY (`bid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerfinish`
CREATE TABLE `#__bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_categories\' already exists SQL=# Table structure for table `jos_categories`\n\nCREATE TABLE `jos_categories` (\n `id` int(11) NOT NULL auto_increment,\n `parent_id` int(11) NOT NULL default 0,\n `title` varchar(50) NOT NULL default \'\',\n `name` varchar(255) NOT NULL default \'\',\n `image` varchar(100) NOT NULL default \'\',\n `section` varchar(50) NOT NULL default \'\',\n `image_position` varchar(10) NOT NULL default \'\',\n `description` text NOT NULL,\n `published` tinyint(1) NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `ordering` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `count` int(11) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `cat_idx` (`section`,`published`,`access`),\n KEY `idx_section` (`section`),\n KEY `idx_access` (`access`),\n KEY `idx_checkout` (`checked_out`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__categories`
CREATE TABLE `#__categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) 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',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_components\' already exists SQL=# Table structure for table `jos_components`\n\nCREATE TABLE `jos_components` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(50) NOT NULL default \'\',\n `link` varchar(255) NOT NULL default \'\',\n `menuid` int(11) unsigned NOT NULL default \'0\',\n `parent` int(11) unsigned NOT NULL default \'0\',\n `admin_menu_link` varchar(255) NOT NULL default \'\',\n `admin_menu_alt` varchar(255) NOT NULL default \'\',\n `option` varchar(50) NOT NULL default \'\',\n `ordering` int(11) NOT NULL default \'0\',\n `admin_menu_img` varchar(255) NOT NULL default \'\',\n `iscore` tinyint(4) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__components`
CREATE TABLE `#__components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) NOT NULL default '',
`admin_menu_alt` varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=# Dumping data for table `jos_components`\n\nINSERT INTO `jos_components` VALUES (1, \'Banner\', \'\', 0, 0, \'\', \'Gestione banner\', \'com_banners\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
# Dumping data for table `#__components`
INSERT INTO `#__components` VALUES (1, 'Banner', '', 0, 0, '', 'Gestione banner', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (2, \'Gestione banner\', \'\', 0, 1, \'option=com_banners\', \'Banner attivi\', \'com_banners\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (2, 'Gestione banner', '', 0, 1, 'option=com_banners', 'Banner attivi', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (3, \'Gestione clienti\', \'\', 0, 1, \'option=com_banners&task=listclients\', \'Gestione clienti\', \'com_banners\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (3, 'Gestione clienti', '', 0, 1, 'option=com_banners&task=listclients', 'Gestione clienti', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (4, \'Collegamenti web\', \'option=com_weblinks\', 0, 0, \'\', \'Gestione collegamenti web\', \'com_weblinks\', 0, \'js/ThemeOffice/globe2.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (4, 'Collegamenti web', 'option=com_weblinks', 0, 0, '', 'Gestione collegamenti web', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (5, \'Gestione collegamenti web\', \'\', 0, 4, \'option=com_weblinks\', \'Vedi collegamenti web esistenti\', \'com_weblinks\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (5, 'Gestione collegamenti web', '', 0, 4, 'option=com_weblinks', 'Vedi collegamenti web esistenti', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (6, \'Categorie collegamenti web\', \'\', 0, 4, \'option=categories§ion=com_weblinks\', \'Gestione categorie collegamenti web\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (6, 'Categorie collegamenti web', '', 0, 4, 'option=categories§ion=com_weblinks', 'Gestione categorie collegamenti web', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (7, \'Contatti\', \'option=com_contact\', 0, 0, \'\', \'Modifica dettagli contatti\', \'com_contact\', 0, \'js/ThemeOffice/user.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (7, 'Contatti', 'option=com_contact', 0, 0, '', 'Modifica dettagli contatti', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (8, \'Gestione Contatti\', \'\', 0, 7, \'option=com_contact\', \'Modifica dettagli contatti\', \'com_contact\', 0, \'js/ThemeOffice/edit.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (8, 'Gestione Contatti', '', 0, 7, 'option=com_contact', 'Modifica dettagli contatti', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (9, \'Categorie contatti\', \'\', 0, 7, \'option=categories§ion=com_contact_details\', \'Gestione categorie contatti\', \'\', 2, \'js/ThemeOffice/categories.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (9, 'Categorie contatti', '', 0, 7, 'option=categories§ion=com_contact_details', 'Gestione categorie contatti', '', 2, 'js/ThemeOffice/categories.png', 1, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (10, \'Prima pagina\', \'option=com_frontpage\', 0, 0, \'\', \'Gestione prima pagina\', \'com_frontpage\', 0, \'js/ThemeOffice/component.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (10, 'Prima pagina', 'option=com_frontpage', 0, 0, '', 'Gestione prima pagina', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (11, \'Sondaggi\', \'option=com_poll\', 0, 0, \'option=com_poll\', \'Gestione sondaggi\', \'com_poll\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (11, 'Sondaggi', 'option=com_poll', 0, 0, 'option=com_poll', 'Gestione sondaggi', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (12, \'News feed\', \'option=com_newsfeeds\', 0, 0, \'\', \'Gestione news feed\', \'com_newsfeeds\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (12, 'News feed', 'option=com_newsfeeds', 0, 0, '', 'Gestione news feed', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (13, \'Gestione News feed\', \'\', 0, 12, \'option=com_newsfeeds\', \'Gestione news feed\', \'com_newsfeeds\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (13, 'Gestione News feed', '', 0, 12, 'option=com_newsfeeds', 'Gestione news feed', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (14, \'Gestione categorie\', \'\', 0, 12, \'option=com_categories§ion=com_newsfeeds\', \'Gestione categorie\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (14, 'Gestione categorie', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Gestione categorie', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (15, \'Login\', \'option=com_login\', 0, 0, \'\', \'\', \'com_login\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (16, \'Cerca\', \'option=com_search\', 0, 0, \'\', \'\', \'com_search\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (16, 'Cerca', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (17, \'Syndicate\',\'\',0,0,\'option=com_syndicate&hidemainmenu=1\',\'Configurazione syndication\',\'com_syndicate\',0,\'js/ThemeOffice/component.png\',0,\'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (17, 'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Configurazione syndication','com_syndicate',0,'js/ThemeOffice/component.png',0,'')
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_components` VALUES (18, \'Mass Mail\', \'\', 0, 0, \'option=com_massmail&hidemainmenu=1\', \'Invia Mass Mail\', \'com_massmail\', 0, \'js/ThemeOffice/mass_email.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (18, 'Mass Mail', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Invia Mass Mail', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, '')
= = = = = = = = = =
SQL=Table \'jos_contact_details\' already exists SQL=# Table structure for table `jos_contact_details`\n\nCREATE TABLE `jos_contact_details` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(100) NOT NULL default \'\',\n `con_position` varchar(50) default NULL,\n `address` text,\n `suburb` varchar(50) default NULL,\n `state` varchar(20) default NULL,\n `country` varchar(50) default NULL,\n `postcode` varchar(10) default NULL,\n `telephone` varchar(25) default NULL,\n `fax` varchar(25) default NULL,\n `misc` mediumtext,\n `image` varchar(100) default NULL,\n `imagepos` varchar(20) default NULL,\n `email_to` varchar(100) default NULL,\n `default_con` tinyint(1) unsigned NOT NULL default \'0\',\n `published` tinyint(1) unsigned NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `ordering` int(11) NOT NULL default \'0\',\n `params` text NOT NULL,\n `user_id` int(11) NOT NULL default \'0\',\n `catid` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__contact_details`
CREATE TABLE `#__contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`con_position` varchar(50) default NULL,
`address` text,
`suburb` varchar(50) default NULL,
`state` varchar(20) default NULL,
`country` varchar(50) default NULL,
`postcode` varchar(10) default NULL,
`telephone` varchar(25) default NULL,
`fax` varchar(25) default NULL,
`misc` mediumtext,
`image` varchar(100) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(100) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned 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,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content\' already exists SQL=# Table structure for table `jos_content`\n\nCREATE TABLE `jos_content` (\n `id` int(11) unsigned NOT NULL auto_increment,\n `title` varchar(100) NOT NULL default \'\',\n `title_alias` varchar(100) NOT NULL default \'\',\n `introtext` mediumtext NOT NULL,\n `fulltext` mediumtext NOT NULL,\n `state` tinyint(3) NOT NULL default \'0\',\n `sectionid` int(11) unsigned NOT NULL default \'0\',\n `mask` int(11) unsigned NOT NULL default \'0\',\n `catid` int(11) unsigned NOT NULL default \'0\',\n `created` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `created_by` int(11) unsigned NOT NULL default \'0\',\n `created_by_alias` varchar(100) NOT NULL default \'\',\n `modified` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `modified_by` int(11) unsigned NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `publish_up` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `publish_down` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `images` text NOT NULL,\n `urls` text NOT NULL,\n `attribs` text NOT NULL,\n `version` int(11) unsigned NOT NULL default \'1\',\n `parentid` int(11) unsigned NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n `metakey` text NOT NULL,\n `metadesc` text NOT NULL,\n `access` int(11) unsigned NOT NULL default \'0\',\n `hits` int(11) unsigned NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `idx_section` (`sectionid`),\n KEY `idx_access` (`access`),\n KEY `idx_checkout` (`checked_out`),\n KEY `idx_state` (`state`),\n KEY `idx_catid` (`catid`),\n KEY `idx_mask` (`mask`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content`
CREATE TABLE `#__content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`title_alias` varchar(100) NOT NULL default '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned 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',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content_frontpage\' already exists SQL=# Table structure for table `jos_content_frontpage`\n\nCREATE TABLE `jos_content_frontpage` (\n `content_id` int(11) NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`content_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_frontpage`
CREATE TABLE `#__content_frontpage` (
`content_id` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content_rating\' already exists SQL=# Table structure for table `jos_content_rating`\n\nCREATE TABLE `jos_content_rating` (\n `content_id` int(11) NOT NULL default \'0\',\n `rating_sum` int(11) unsigned NOT NULL default \'0\',\n `rating_count` int(11) unsigned NOT NULL default \'0\',\n `lastip` varchar(50) NOT NULL default \'\',\n PRIMARY KEY (`content_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_rating`
CREATE TABLE `#__content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '0',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_core_log_items\' already exists SQL=# Table structure for table `jos_core_log_items`\n# To be implemented\n\nCREATE TABLE `jos_core_log_items` (\n `time_stamp` date NOT NULL default \'0000-00-00\',\n `item_table` varchar(50) NOT NULL default \'\',\n `item_id` int(11) unsigned NOT NULL default \'0\',\n `hits` int(11) unsigned NOT NULL default \'0\'\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_items`
# To be implemented
CREATE TABLE `#__core_log_items` (
`time_stamp` date NOT NULL default '0000-00-00',
`item_table` varchar(50) NOT NULL default '',
`item_id` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_core_log_searches\' already exists SQL=# Table structure for table `jos_core_log_searches`\n# To be implemented\n\nCREATE TABLE `jos_core_log_searches` (\n `search_term` varchar(128) NOT NULL default \'\',\n `hits` int(11) unsigned NOT NULL default \'0\'\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_searches`
# To be implemented
CREATE TABLE `#__core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_groups\' already exists SQL=# Table structure for table `jos_groups`\n\nCREATE TABLE `jos_groups` (\n `id` tinyint(3) unsigned NOT NULL default \'0\',\n `name` varchar(50) NOT NULL default \'\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__groups`
CREATE TABLE `#__groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'0\' for key 1 SQL=# Dumping data for table `jos_groups`\n\nINSERT INTO `jos_groups` VALUES (0, \'Public\'):
- - - - - - - - - -
# Dumping data for table `#__groups`
INSERT INTO `#__groups` VALUES (0, 'Public')
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (1, \'Registered\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (1, 'Registered')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (2, \'Special\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (2, 'Special')
= = = = = = = = = =
SQL=Table \'jos_mambots\' already exists SQL=# Table structure for table `jos_mambots`\n\nCREATE TABLE `jos_mambots` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(100) NOT NULL default \'\',\n `element` varchar(100) NOT NULL default \'\',\n `folder` varchar(100) NOT NULL default \'\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n `published` tinyint(3) NOT NULL default \'0\',\n `iscore` tinyint(3) NOT NULL default \'0\',\n `client_id` tinyint(3) NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__mambots`
CREATE TABLE `#__mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`folder` varchar(100) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`iscore` tinyint(3) NOT NULL default '0',
`client_id` tinyint(3) 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',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (1,\'MOS Image\',\'mosimage\',\'content\',0,-10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (2,\'MOS Pagination\',\'mospaging\',\'content\',0,10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (3,\'Legacy Mambot Includer\',\'legacybots\',\'content\',0,1,0,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (4,\'SEF\',\'mossef\',\'content\',0,3,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (5,\'MOS Rating\',\'mosvote\',\'content\',0,4,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (6,\'Ricerca nei contenuti\',\'content.searchbot\',\'search\',0,1,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (6,'Ricerca nei contenuti','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (7,\'Ricerca nei collegamenti web\',\'weblinks.searchbot\',\'search\',0,2,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (7,'Ricerca nei collegamenti web','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (8,\'Supporto codice\',\'moscode\',\'content\',0,2,0,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (8,'Supporto codice','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (9,\'Nessun editor WYSIWYG\',\'none\',\'editors\',0,0,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (9,'Nessun editor WYSIWYG','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'10\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (10,\'Editor TinyMCE WYSIWYG\',\'tinymce\',\'editors\',0,0,1,1,0,0,\'0000-00-00 00:00:00\',\'theme=advanced\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (10,'Editor TinyMCE WYSIWYG','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced')
= = = = = = = = = =
SQL=Duplicate entry \'11\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (11,\'Bottone editor MOS Image\',\'mosimage.btn\',\'editors-xtd\',0,0,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (11,'Bottone editor MOS Image','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'12\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (12,\'Bottone editor MOS Pagebreak\',\'mospage.btn\',\'editors-xtd\',0,0,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (12,'Bottone editor MOS Pagebreak','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'13\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (13,\'Ricerca nei contati\',\'contacts.searchbot\',\'search\',0,3,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (13,'Ricerca nei contati','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'14\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (14, \'Ricerca nelle categorie\', \'categories.searchbot\', \'search\', 0, 4, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (14, 'Ricerca nelle categorie', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'15\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (15, \'Ricerca nelle sezioni\', \'sections.searchbot\', \'search\', 0, 5, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (15, 'Ricerca nelle sezioni', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'16\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (16, \'Email Cloaking\', \'mosemailcloak\', \'content\', 0, 5, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'17\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (17, \'GeSHi\', \'geshi\', \'content\', 0, 5, 0, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (17, 'GeSHi', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'18\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (18, \'Ricerca nei newsfeeds\', \'newsfeeds.searchbot\', \'search\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (18, 'Ricerca nei newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'19\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (19, \'Carica posizione moduli\', \'mosloadposition\', \'content\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (19, 'Carica posizione moduli', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Table \'jos_menu\' already exists SQL=# Table structure for table `jos_menu`\n\nCREATE TABLE `jos_menu` (\n `id` int(11) NOT NULL auto_increment,\n `menutype` varchar(25) default NULL,\n `name` varchar(100) default NULL,\n `link` text,\n `type` varchar(50) NOT NULL default \'\',\n `published` tinyint(1) NOT NULL default \'0\',\n `parent` int(11) unsigned NOT NULL default \'0\',\n `componentid` int(11) unsigned NOT NULL default \'0\',\n `sublevel` int(11) default \'0\',\n `ordering` int(11) default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `pollid` int(11) NOT NULL default \'0\',\n `browserNav` tinyint(4) default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `utaccess` tinyint(3) unsigned NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `componentid` (`componentid`,`menutype`,`published`,`access`),\n KEY `menutype` (`menutype`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__menu`
CREATE TABLE `#__menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) default NULL,
`name` varchar(100) default NULL,
`link` text,
`type` varchar(50) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`componentid` int(11) unsigned NOT NULL default '0',
`sublevel` int(11) default '0',
`ordering` int(11) default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`pollid` int(11) NOT NULL default '0',
`browserNav` tinyint(4) default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`utaccess` tinyint(3) unsigned NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_menu` VALUES (1, \'mainmenu\', \'Home\', \'index.php?option=com_frontpage\', \'components\', 1, 0, 10, 0, 1, 0, \'0000-00-00 00:00:00\', 0, 0, 0, 3, \'leading=1\r\nintro=2\r\ncolumns=1\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Benvenuto in prima pagina\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0\'):
- - - - - - - - - -
INSERT INTO `#__menu` VALUES (1, 'mainmenu', 'Home', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'leading=1\r\nintro=2\r\ncolumns=1\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Benvenuto in prima pagina\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0')
= = = = = = = = = =
SQL=Table \'jos_messages\' already exists SQL=# Table structure for table `jos_messages`\n\nCREATE TABLE `jos_messages` (\n `message_id` int(10) unsigned NOT NULL auto_increment,\n `user_id_from` int(10) unsigned NOT NULL default \'0\',\n `user_id_to` int(10) unsigned NOT NULL default \'0\',\n `folder_id` int(10) unsigned NOT NULL default \'0\',\n `date_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `state` int(11) NOT NULL default \'0\',\n `priority` int(1) unsigned NOT NULL default \'0\',\n `subject` varchar(230) NOT NULL default \'\',\n `message` text NOT NULL,\n PRIMARY KEY (`message_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__messages`
CREATE TABLE `#__messages` (
`message_id` int(10) unsigned NOT NULL auto_increment,
`user_id_from` int(10) unsigned NOT NULL default '0',
`user_id_to` int(10) unsigned NOT NULL default '0',
`folder_id` int(10) unsigned NOT NULL default '0',
`date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`state` int(11) NOT NULL default '0',
`priority` int(1) unsigned NOT NULL default '0',
`subject` varchar(230) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`message_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_messages_cfg\' already exists SQL=# Table structure for table `jos_messages_cfg`\n\nCREATE TABLE `jos_messages_cfg` (\n `user_id` int(10) unsigned NOT NULL default \'0\',\n `cfg_name` varchar(100) NOT NULL default \'\',\n `cfg_value` varchar(255) NOT NULL default \'\',\n UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__messages_cfg`
CREATE TABLE `#__messages_cfg` (
`user_id` int(10) unsigned NOT NULL default '0',
`cfg_name` varchar(100) NOT NULL default '',
`cfg_value` varchar(255) NOT NULL default '',
UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_modules\' already exists SQL=# Table structure for table `jos_modules`\n\nCREATE TABLE `jos_modules` (\n `id` int(11) NOT NULL auto_increment,\n `title` text NOT NULL,\n `content` text NOT NULL,\n `ordering` int(11) NOT NULL default \'0\',\n `position` varchar(10) default NULL,\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `published` tinyint(1) NOT NULL default \'0\',\n `module` varchar(50) default NULL,\n `numnews` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `showtitle` tinyint(3) unsigned NOT NULL default \'1\',\n `params` text NOT NULL,\n `iscore` tinyint(4) NOT NULL default \'0\',\n `client_id` tinyint(4) NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `published` (`published`,`access`),\n KEY `newsfeeds` (`module`,`published`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__modules`
CREATE TABLE `#__modules` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
`position` varchar(10) default NULL,
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`module` varchar(50) default NULL,
`numnews` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`showtitle` tinyint(3) unsigned NOT NULL default '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=# Dumping data for table `jos_modules`\n\nINSERT INTO `jos_modules` VALUES (0, \'Sondaggi\', \'\', 1, \'right\', 0, \'0000-00-00 00:00:00\', 1, \'mod_poll\', 0, 0, 1, \'\', 0, 0):
- - - - - - - - - -
# Dumping data for table `#__modules`
INSERT INTO `#__modules` VALUES (0, 'Sondaggi', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_poll', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Menu utente\', \'\', 2, \'left\', 0, \'0000-00-00 00:00:00\', 1, \'mod_mainmenu\', 0, 1, 1, \'menutype=usermenu\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Menu utente', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Menu principale\', \'\', 1, \'left\', 0, \'0000-00-00 00:00:00\', 1, \'mod_mainmenu\', 0, 0, 1, \'menutype=mainmenu\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Menu principale', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Login Form\', \'\', 3, \'left\', 0, \'0000-00-00 00:00:00\', 1, \'mod_login\', 0, 0, 1, \'\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Login Form', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Syndication\', \'\', 4, \'left\', 0, \'0000-00-00 00:00:00\', 1, \'mod_rssfeed\', 0, 0, 1, \'\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Syndication', '', 4, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_rssfeed', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Ultime notizie\', \'\', 4, \'user1\', 0, \'0000-00-00 00:00:00\', 1, \'mod_latestnews\', 0, 0, 1, \'\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Ultime notizie', '', 4, 'user1', 0, '0000-00-00 00:00:00', 1, 'mod_latestnews', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Statistiche\', \'\', 4, \'left\', 0, \'0000-00-00 00:00:00\', 0, \'mod_stats\', 0, 0, 1, \'serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Statistiche', '', 4, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_stats', 0, 0, 1, 'serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Chi e\'\' online\', \'\', 1, \'right\', 0, \'0000-00-00 00:00:00\', 1, \'mod_whosonline\', 0, 0, 1, \'online=1\nusers=1\nmoduleclass_sfx=\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Chi e'' online', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'I piu\'\' letti\', \'\', 6, \'user2\', 0, \'0000-00-00 00:00:00\', 1, \'mod_mostread\', 0, 0, 1, \'\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'I piu'' letti', '', 6, 'user2', 0, '0000-00-00 00:00:00', 1, 'mod_mostread', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Scelta template\',\'\',6,\'left\',0,\'0000-00-00 00:00:00\',0,\'mod_templatechooser\', 0, 0, 1, \'show_preview=1\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Scelta template','',6,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser', 0, 0, 1, 'show_preview=1', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Archivio\', \'\', 7, \'left\', 0, \'0000-00-00 00:00:00\', 0, \'mod_archive\', 0, 0, 1, \'\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Archivio', '', 7, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Sezioni\', \'\', 8, \'left\', 0, \'0000-00-00 00:00:00\', 0, \'mod_sections\', 0, 0, 1, \'\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Sezioni', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Annunci\', \'\', 1, \'top\', 0, \'0000-00-00 00:00:00\', 1, \'mod_newsflash\', 0, 0, 1, \'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Annunci', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_newsflash', 0, 0, 1, 'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Articoli correlati\', \'\', 9, \'left\', 0, \'0000-00-00 00:00:00\', 0, \'mod_related_items\', 0, 0, 1, \'\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Articoli correlati', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Cerca\', \'\', 1, \'user4\', 0, \'0000-00-00 00:00:00\', 1, \'mod_search\', 0, 0, 0, \'\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Cerca', '', 1, 'user4', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 0, '', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Immagine casuale\', \'\', 9, \'right\', 0, \'0000-00-00 00:00:00\', 1, \'mod_random_image\', 0, 0, 1, \'\', 0, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Immagine casuale', '', 9, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Top Menu\', \'\', 1, \'user3\', 0, \'0000-00-00 00:00:00\', 1, \'mod_mainmenu\', 0, 0, 0, \'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Top Menu', '', 1, 'user3', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Banner\', \'\', 1, \'banner\', 0, \'0000-00-00 00:00:00\', 1, \'mod_banners\', 0, 0, 0, \'banner_cids=\nmoduleclass_sfx=\n\', 1, 0):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Banner', '', 1, 'banner', 0, '0000-00-00 00:00:00', 1, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Componenti\',\'\',2,\'cpanel\',0,\'0000-00-00 00:00:00\',1,\'mod_components\',0,99,1,\'\',1, 1):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Componenti','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',1, 1)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'I piu\'\' letti\',\'\',3,\'cpanel\',0,\'0000-00-00 00:00:00\',1,\'mod_popular\',0,99,1,\'\',0, 1):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'I piu'' letti','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',0, 1)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Articoli recenti\',\'\',4,\'cpanel\',0,\'0000-00-00 00:00:00\',1,\'mod_latest\',0,99,1,\'\',0, 1):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Articoli recenti','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',0, 1)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Stato menu\',\'\',5,\'cpanel\',0,\'0000-00-00 00:00:00\',1,\'mod_stats\',0,99,1,\'\',0, 1):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Stato menu','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',0, 1)
= = = = = = = = = =
SQL=Column count doesn\'t match value count at row 1 SQL=INSERT INTO `jos_modules` VALUES (0, \'Messaggi non letti\',\'\',1,\'header\',0,\'0000-00-00 00:00:00\',1,\'mod_unread\',0,99,1,\'\',1, 1):
- - - - - - - - - -
INSERT INTO `#__modules` VALUES (0, 'Messaggi non letti','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',1, 1)
= = = = = = = = = =
SQL=Col
