My hosting company server was down yesterday and I lost all work that I havent backed up. Now, I am trying to install vortex again but I receive my error message. Any one knows what to do?
SQL=Table \'jos_banner\' already exists SQL=# $Id: joomla.sql 6070 2006-12-20 02:09:09Z robs $\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=MyISAM AUTO_INCREMENT=1:
- - - - - - - - - -
# $Id: joomla.sql 6070 2006-12-20 02:09:09Z robs $
# 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:
- - - - - - - - - -
h
Have you tried repairing the database? Failing that, it may be time to use the backups. :'(
The member formerly known as Roland Deschain After your question is solved, please Edit your original post and choose the Solved message icon, thank you!
That really sucks. It appears that it may be time to find a reliable web host.
Best of luck to you.
The member formerly known as Roland Deschain After your question is solved, please Edit your original post and choose the Solved message icon, thank you!