Joomla Templates Club 406,261 posts

[jjara Friend jjaraJoin date: April 2006Posts: 1Downloads:0Uploads:0]

#119876

I have tried to install the JA_TELINE QUICKSTAR but it is impossible, i have the next error:

SQL=You have an error in your SQL syntax near ‘ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8’ at line 19 SQL=CREATE 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) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8:
– – – – – – – – – –
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`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_banner’ doesn’t exist SQL=LOCK TABLES `jos_banner` WRITE:
– – – – – – – – – –
LOCK TABLES `#__banner` WRITE
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_banner’ doesn’t exist SQL=INSERT INTO `jos_banner` VALUES (1,1,’banner’,’OSM 1′,0,1787,9,’osmbanner1.png’,’http://www.opensourcematters.org’,’2004-07-07 15:31:29′,1,0,’0000-00-00 00:00:00′,NULL,NULL),(2,1,’banner’,’OSM 2′,0,1664,13,’osmbanner2.png’,’http://www.opensourcematters.org’,’2004-07-07 15:31:29′,1,0,’0000-00-00 00:00:00′,NULL,NULL):
– – – – – – – – – –
INSERT INTO `#__banner` VALUES (1,1,’banner’,’OSM 1′,0,1787,9,’osmbanner1.png’,’http://www.opensourcematters.org’,’2004-07-07 15:31:29′,1,0,’0000-00-00 00:00:00′,NULL,NULL),(2,1,’banner’,’OSM 2′,0,1664,13,’osmbanner2.png’,’http://www.opensourcematters.org’,’2004-07-07 15:31:29′,1,0,’0000-00-00 00:00:00′,NULL,NULL)
= = = = = = = = = =

SQL=You have an error in your SQL syntax near ‘ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8’ at line 11 SQL=CREATE 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) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8:
– – – – – – – – – –
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`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_bannerclient’ doesn’t exist SQL=LOCK TABLES `jos_bannerclient` WRITE:
– – – – – – – – – –
LOCK TABLES `#__bannerclient` WRITE
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_bannerclient’ doesn’t exist SQL=INSERT INTO `jos_bannerclient` VALUES (1,’Open Source Matters’,’Administrator’,’admin@opensourcematters.org’,”,0,’00:00:00′,NULL):
– – – – – – – – – –
INSERT INTO `#__bannerclient` VALUES (1,’Open Source Matters’,’Administrator’,’admin@opensourcematters.org’,”,0,’00:00:00′,NULL)
= = = = = = = = = =

SQL=You have an error in your SQL syntax near ‘ENGINE=MyISAM DEFAULT CHARSET=utf8’ at line 12 SQL=CREATE 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) ENGINE=MyISAM DEFAULT CHARSET=utf8:
– – – – – – – – – –
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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_bannerfinish’ doesn’t exist SQL=LOCK TABLES `jos_bannerfinish` WRITE:
– – – – – – – – – –
LOCK TABLES `#__bannerfinish` WRITE
= = = = = = = = = =

SQL=You have an error in your SQL syntax near ‘ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8’ at line 23 SQL=CREATE 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) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8:
– – – – – – – – – –
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`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_categories’ doesn’t exist SQL=LOCK TABLES `jos_categories` WRITE:
– – – – – – – – – –
LOCK TABLES `#__categories` WRITE
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_categories’ doesn’t exist SQL=INSERT INTO `jos_categories` VALUES (1,0,’Latest’,’Latest News’,’taking_notes.jpg’,’1′,’left’,’The latest news from the Joomla! Team’,1,0,’0000-00-00 00:00:00′,”,12,0,1,”),(2,0,’Joomla!’,’Joomla!’,’clock.jpg’,’com_weblinks’,’left’,’A selection of links that are all related to the Joomla! Project.’,1,0,’0000-00-00 00:00:00′,NULL,0,0,0,”),(3,0,’Newsflash’,’Newsflash’,”,’2′,’left’,”,1,0,’0000-00-00 00:00:00′,”,0,0,0,”),(4,0,’Joomla!’,’Joomla!’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,2,0,0,”),(5,0,’Business: general’,’Business: general’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,1,0,0,”),(7,0,’Examples’,’Example FAQs’,”,’3′,’left’,’Here you will find an example set of FAQs.’,1,0,’0000-00-00 00:00:00′,NULL,1,0,2,’imagefolders=*2*’),(9,0,’Finance’,’Finance’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,5,0,0,”),(10,0,’Linux’,’Linux’,”,’com_newsfeeds’,’left’,'<br />rn’,1,0,’0000-00-00 00:00:00′,NULL,6,0,0,”),(11,0,’Internet’,’Internet’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,7,0,0,”),(12,0,’Contacts’,’Contacts’,”,’com_contact_details’,’left’,’Contact Details for this website’,1,0,’0000-00-00 00:00:00′,NULL,0,0,0,”),(13,0,’Example Category’,’Example Category’,”,’4′,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,10,0,0,’imagefolders=*2*’),(29,0,’Travel’,’Travel’,”,’1′,’left’,’Travel’,1,0,’0000-00-00 00:00:00′,NULL,6,0,0,’imagefolders=*2*’),(28,0,’Science & Space’,’Science & Space’,”,’1′,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,7,0,0,’imagefolders=*2*’),(27,0,’Health’,’Health’,”,’1′,’left’,’Health’,1,0,’0000-00-00 00:00:00′,NULL,8,0,0,’imagefolders=*2*’),(26,0,’Law’,’Law’,”,’1′,’left’,’Law’,1,0,’0000-00-00 00:00:00′,NULL,9,0,0,’imagefolders=*2*’),(25,0,’Technology’,’Technology’,”,’1′,’left’,’Technology’,1,0,’0000-00-00 00:00:00′,NULL,10,0,0,’imagefolders=*2*’),(24,0,’World’,’World’,”,’1′,’left’,’World’,1,0,’0000-00-00 00:00:00′,NULL,11,0,0,’imagefolders=*2*’),(23,0,’Asia-Pacific’,’Asia-Pacific’,”,’1′,’left’,’U.S’,1,0,’0000-00-00 00:00:00′,NULL,13,0,0,’imagefolders=*2*’),(30,0,’Education’,’Education’,”,’1′,’left’,’Education’,1,0,’0000-00-00 00:00:00′,NULL,5,0,0,’imagefolders=*2*’),(31,0,’Sports’,’Sports’,”,’1′,’left’,’Sports’,1,0,’0000-00-00 00:00:00′,NULL,4,0,0,’imagefolders=*2*’),(32,0,’Business’,’Business’,”,’1′,’left’,’Business’,1,0,’0000-00-00 00:00:00′,NULL,3,0,0,’imagefolders=*2*’),(33,0,’Entertaiment’,’Entertaiment’,”,’1′,’left’,’Entertaiment’,1,0,’0000-00-00 00:00:00′,NULL,2,0,0,’imagefolders=*2*’),(34,0,’Politics’,’Politics’,”,’1′,’left’,’Politics’,1,0,’0000-00-00 00:00:00′,NULL,1,0,0,’imagefolders=*2*’):
– – – – – – – – – –
INSERT INTO `#__categories` VALUES (1,0,’Latest’,’Latest News’,’taking_notes.jpg’,’1′,’left’,’The latest news from the Joomla! Team’,1,0,’0000-00-00 00:00:00′,”,12,0,1,”),(2,0,’Joomla!’,’Joomla!’,’clock.jpg’,’com_weblinks’,’left’,’A selection of links that are all related to the Joomla! Project.’,1,0,’0000-00-00 00:00:00′,NULL,0,0,0,”),(3,0,’Newsflash’,’Newsflash’,”,’2′,’left’,”,1,0,’0000-00-00 00:00:00′,”,0,0,0,”),(4,0,’Joomla!’,’Joomla!’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,2,0,0,”),(5,0,’Business: general’,’Business: general’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,1,0,0,”),(7,0,’Examples’,’Example FAQs’,”,’3′,’left’,’Here you will find an example set of FAQs.’,1,0,’0000-00-00 00:00:00′,NULL,1,0,2,’imagefolders=*2*’),(9,0,’Finance’,’Finance’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,5,0,0,”),(10,0,’Linux’,’Linux’,”,’com_newsfeeds’,’left’,'<br />rn’,1,0,’0000-00-00 00:00:00′,NULL,6,0,0,”),(11,0,’Internet’,’Internet’,”,’com_newsfeeds’,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,7,0,0,”),(12,0,’Contacts’,’Contacts’,”,’com_contact_details’,’left’,’Contact Details for this website’,1,0,’0000-00-00 00:00:00′,NULL,0,0,0,”),(13,0,’Example Category’,’Example Category’,”,’4′,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,10,0,0,’imagefolders=*2*’),(29,0,’Travel’,’Travel’,”,’1′,’left’,’Travel’,1,0,’0000-00-00 00:00:00′,NULL,6,0,0,’imagefolders=*2*’),(28,0,’Science & Space’,’Science & Space’,”,’1′,’left’,”,1,0,’0000-00-00 00:00:00′,NULL,7,0,0,’imagefolders=*2*’),(27,0,’Health’,’Health’,”,’1′,’left’,’Health’,1,0,’0000-00-00 00:00:00′,NULL,8,0,0,’imagefolders=*2*’),(26,0,’Law’,’Law’,”,’1′,’left’,’Law’,1,0,’0000-00-00 00:00:00′,NULL,9,0,0,’imagefolders=*2*’),(25,0,’Technology’,’Technology’,”,’1′,’left’,’Technology’,1,0,’0000-00-00 00:00:00′,NULL,10,0,0,’imagefolders=*2*’),(24,0,’World’,’World’,”,’1′,’left’,’World’,1,0,’0000-00-00 00:00:00′,NULL,11,0,0,’imagefolders=*2*’),(23,0,’Asia-Pacific’,’Asia-Pacific’,”,’1′,’left’,’U.S’,1,0,’0000-00-00 00:00:00′,NULL,13,0,0,’imagefolders=*2*’),(30,0,’Education’,’Education’,”,’1′,’left’,’Education’,1,0,’0000-00-00 00:00:00′,NULL,5,0,0,’imagefolders=*2*’),(31,0,’Sports’,’Sports’,”,’1′,’left’,’Sports’,1,0,’0000-00-00 00:00:00′,NULL,4,0,0,’imagefolders=*2*’),(32,0,’Business’,’Business’,”,’1′,’left’,’Business’,1,0,’0000-00-00 00:00:00′,NULL,3,0,0,’imagefolders=*2*’),(33,0,’Entertaiment’,’Entertaiment’,”,’1′,’left’,’Entertaiment’,1,0,’0000-00-00 00:00:00′,NULL,2,0,0,’imagefolders=*2*’),(34,0,’Politics’,’Politics’,”,’1′,’left’,’Politics’,1,0,’0000-00-00 00:00:00′,NULL,1,0,0,’imagefolders=*2*’)
= = = = = = = = = =

SQL=You have an error in your SQL syntax near ‘ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8’ at line 15 SQL=CREATE 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) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8:
– – – – – – – – – –
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`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_components’ doesn’t exist SQL=LOCK TABLES `jos_components` WRITE:
– – – – – – – – – –
LOCK TABLES `#__components` WRITE
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_components’ doesn’t exist SQL=INSERT INTO `jos_components` VALUES (1,’Banners’,”,0,0,”,’Banner Management’,’com_banners’,0,’js/ThemeOffice/component.png’,0,”),(2,’Manage Banners’,”,0,1,’option=com_banners’,’Active Banners’,’com_banners’,1,’js/ThemeOffice/edit.png’,0,”),(3,’Manage Clients’,”,0,1,’option=com_banners&task=listclients’,’Manage Clients’,’com_banners’,2,’js/ThemeOffice/categories.png’,0,”),(4,’Web Links’,’option=com_weblinks’,0,0,”,’Manage Weblinks’,’com_weblinks’,0,’js/ThemeOffice/globe2.png’,0,”),(5,’Web Link Items’,”,0,4,’option=com_weblinks’,’View existing weblinks’,’com_weblinks’,1,’js/ThemeOffice/edit.png’,0,”),(6,’Web Link Categories’,”,0,4,’option=categories&section=com_weblinks’,’Manage weblink categories’,”,2,’js/ThemeOffice/categories.png’,0,”),(7,’Contacts’,’option=com_contact’,0,0,”,’Edit contact details’,’com_contact’,0,’js/ThemeOffice/user.png’,1,”),(8,’Manage Contacts’,”,0,7,’option=com_contact’,’Edit contact details’,’com_contact’,0,’js/ThemeOffice/edit.png’,1,”),(9,’Contact Categories’,”,0,7,’option=categories&section=com_contact_details’,’Manage contact categories’,”,2,’js/ThemeOffice/categories.png’,1,”),(10,’Front Page’,’option=com_frontpage’,0,0,”,’Manage Front Page Items’,’com_frontpage’,0,’js/ThemeOffice/component.png’,1,”),(11,’Polls’,’option=com_poll’,0,0,’option=com_poll’,’Manage Polls’,’com_poll’,0,’js/ThemeOffice/component.png’,0,”),(12,’News Feeds’,’option=com_newsfeeds’,0,0,”,’News Feeds Management’,’com_newsfeeds’,0,’js/ThemeOffice/component.png’,0,”),(13,’Manage News Feeds’,”,0,12,’option=com_newsfeeds’,’Manage News Feeds’,’com_newsfeeds’,1,’js/ThemeOffice/edit.png’,0,”),(14,’Manage Categories’,”,0,12,’option=com_categories&section=com_newsfeeds’,’Manage Categories’,”,2,’js/ThemeOffice/categories.png’,0,”),(15,’Login’,’option=com_login’,0,0,”,”,’com_login’,0,”,1,”),(16,’Search’,’option=com_search’,0,0,”,”,’com_search’,0,”,1,”),(17,’Syndicate’,”,0,0,’option=com_syndicate&hidemainmenu=1′,’Manage Syndication Settings’,’com_syndicate’,0,’js/ThemeOffice/component.png’,0,”),(18,’Mass Mail’,”,0,0,’option=com_massmail&hidemainmenu=1′,’Send Mass Mail’,’com_massmail’,0,’js/ThemeOffice/mass_email.png’,0,”):
– – – – – – – – – –
INSERT INTO `#__components` VALUES (1,’Banners’,”,0,0,”,’Banner Management’,’com_banners’,0,’js/ThemeOffice/component.png’,0,”),(2,’Manage Banners’,”,0,1,’option=com_banners’,’Active Banners’,’com_banners’,1,’js/ThemeOffice/edit.png’,0,”),(3,’Manage Clients’,”,0,1,’option=com_banners&task=listclients’,’Manage Clients’,’com_banners’,2,’js/ThemeOffice/categories.png’,0,”),(4,’Web Links’,’option=com_weblinks’,0,0,”,’Manage Weblinks’,’com_weblinks’,0,’js/ThemeOffice/globe2.png’,0,”),(5,’Web Link Items’,”,0,4,’option=com_weblinks’,’View existing weblinks’,’com_weblinks’,1,’js/ThemeOffice/edit.png’,0,”),(6,’Web Link Categories’,”,0,4,’option=categories&section=com_weblinks’,’Manage weblink categories’,”,2,’js/ThemeOffice/categories.png’,0,”),(7,’Contacts’,’option=com_contact’,0,0,”,’Edit contact details’,’com_contact’,0,’js/ThemeOffice/user.png’,1,”),(8,’Manage Contacts’,”,0,7,’option=com_contact’,’Edit contact details’,’com_contact’,0,’js/ThemeOffice/edit.png’,1,”),(9,’Contact Categories’,”,0,7,’option=categories&section=com_contact_details’,’Manage contact categories’,”,2,’js/ThemeOffice/categories.png’,1,”),(10,’Front Page’,’option=com_frontpage’,0,0,”,’Manage Front Page Items’,’com_frontpage’,0,’js/ThemeOffice/component.png’,1,”),(11,’Polls’,’option=com_poll’,0,0,’option=com_poll’,’Manage Polls’,’com_poll’,0,’js/ThemeOffice/component.png’,0,”),(12,’News Feeds’,’option=com_newsfeeds’,0,0,”,’News Feeds Management’,’com_newsfeeds’,0,’js/ThemeOffice/component.png’,0,”),(13,’Manage News Feeds’,”,0,12,’option=com_newsfeeds’,’Manage News Feeds’,’com_newsfeeds’,1,’js/ThemeOffice/edit.png’,0,”),(14,’Manage Categories’,”,0,12,’option=com_categories&section=com_newsfeeds’,’Manage Categories’,”,2,’js/ThemeOffice/categories.png’,0,”),(15,’Login’,’option=com_login’,0,0,”,”,’com_login’,0,”,1,”),(16,’Search’,’option=com_search’,0,0,”,”,’com_search’,0,”,1,”),(17,’Syndicate’,”,0,0,’option=com_syndicate&hidemainmenu=1′,’Manage Syndication Settings’,’com_syndicate’,0,’js/ThemeOffice/component.png’,0,”),(18,’Mass Mail’,”,0,0,’option=com_massmail&hidemainmenu=1′,’Send Mass Mail’,’com_massmail’,0,’js/ThemeOffice/mass_email.png’,0,”)
= = = = = = = = = =

SQL=You have an error in your SQL syntax near ‘ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8’ at line 26 SQL=CREATE 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) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8:
– – – – – – – – – –
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`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_contact_details’ doesn’t exist SQL=LOCK TABLES `jos_contact_details` WRITE:
– – – – – – – – – –
LOCK TABLES `#__contact_details` WRITE
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_contact_details’ doesn’t exist SQL=INSERT INTO `jos_contact_details` VALUES (1,’Name’,’Position’,’Street’,’Suburb’,’State’,’Country’,’Zip Code’,’Telephone’,’Fax’,’Miscellanous info’,”,’top’,’email@email.com’,0,1,0,’0000-00-00 00:00:00′,1,’menu_image=-1npageclass_sfx=nprint=nback_button=nname=1nposition=1nemail=0nstreet_address=1nsuburb=1nstate=1ncountry=1npostcode=1ntelephone=1nfax=1nmisc=1nimage=0nvcard=0nemail_description=1nemail_description_text=nemail_form=1nemail_copy=0ndrop_down=0ncontact_icons=0nicon_address=nicon_email=nicon_telephone=nicon_fax=nicon_misc=’,0,12,0):
– – – – – – – – – –
INSERT INTO `#__contact_details` VALUES (1,’Name’,’Position’,’Street’,’Suburb’,’State’,’Country’,’Zip Code’,’Telephone’,’Fax’,’Miscellanous info’,”,’top’,’email@email.com’,0,1,0,’0000-00-00 00:00:00′,1,’menu_image=-1npageclass_sfx=nprint=nback_button=nname=1nposition=1nemail=0nstreet_address=1nsuburb=1nstate=1ncountry=1npostcode=1ntelephone=1nfax=1nmisc=1nimage=0nvcard=0nemail_description=1nemail_description_text=nemail_form=1nemail_copy=0ndrop_down=0ncontact_icons=0nicon_address=nicon_email=nicon_telephone=nicon_fax=nicon_misc=’,0,12,0)
= = = = = = = = = =

SQL=You have an error in your SQL syntax near ‘ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8’ at line 37 SQL=CREATE 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) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8:
– – – – – – – – – –
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`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8
= = = = = = = = = =

SQL=Table ‘ja_teline.jos_content’ doesn’t exist SQL=LOCK TABLES `jos_content` WRITE:
….. etc.

I have installed a lot of Joomla sites but i have this problem with this installation.

These are the config of the server:

[root@server conf]# rpm -q mysql
mysql-3.23.58-1
[root@server conf]# rpm -q php
php-4.3.2-8.ent
[root@server conf]# rpm -q httpd
httpd-2.0.46-25.ent
[root@server conf]#

i am trying to use a dabatase named “arco”.

Please i need your help!!

[bernhar Friend bernharJoin date: July 2006Posts: 214Downloads:0Uploads:1 Thanks: 3 Thanked: 3 times in 1 posts]

#218789

There is another thread here discussing the same problem. http://www.joomlart.com/forums/topic/where-is-the-psd-source/

[Author]

Posts