Joomla Templates Club 406,261 posts

[webbiegirl Friend webbiegirlJoin date: October 2007Posts: 6Downloads:0Uploads:0]

#123344

I have been trying to install Ja Teline as a quickstart package… but I am having a lot of problems during installation. I have tried installing it 7 times now and I continue getting the same errors. I have installed other quickstart packages and never had any problems. (Using 1and1 for hosting and mysql databases).

During installation, I put in my MySQL database information and it takes me to the next step of installation where i’m supposed to define my site. It allows me to go to the next tab (so my MySQL info is correct) but on the next tab it says that there are errors in lines of the mysql database. If I try installing it without including sample data (dropping old tables) it will install fine… but I want the sample data within the site! (that’s the point of the quickstart!)

I watched the video demo when it was still up on quickstart with teline, but I don’t have cpanel with the installation.

After 7 attempts at installing this quickstart, I’m getting incredibly frustrated. I have the teline template up, is there a way to manually insert the info in mysql?

I’m just lost, any idea what’s going on?

[dejh Friend dejhJoin date: May 2007Posts: 8Downloads:0Uploads:1]

#231992

This what I found:

1. Delete the .htaccess file
2. Run http://localhost/teline/installation/

[xraydevil Friend xraydevilJoin date: June 2007Posts: 33Downloads:0Uploads:6 Thanks: 8 Thanked: 2 times in 1 posts]

#236527

hi,
i have the same problem.
this is my error log:
[PHP]SQL=You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘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 ‘maam_v2db.jos_banner’ doesn’t exist SQL=–
n– Dumping data for table `jos_banner`
n–
n
n
n/*!40000 ALTER TABLE `jos_banner` DISABLE KEYS */:
– – – – – – – – – –
—
— Dumping data for table `#__banner`
—

/*!40000 ALTER TABLE `#__banner` DISABLE KEYS */
= = = = = = = = = =

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

SQL=Table ‘maam_v2db.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=Table ‘maam_v2db.jos_banner’ doesn’t exist SQL=/*!40000 ALTER TABLE `jos_banner` ENABLE KEYS */:
– – – – – – – – – –
/*!40000 ALTER TABLE `#__banner` ENABLE KEYS */
= = = = = = = = = =

SQL=You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘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 ‘maam_v2db.jos_bannerclient’ doesn’t exist SQL=–
n– Dumping data for table `jos_bannerclient`
n–
n
n
n/*!40000 ALTER TABLE `jos_bannerclient` DISABLE KEYS */:
– – – – – – – – – –
—
— Dumping data for table `#__bannerclient`
—

/*!40000 ALTER TABLE `#__bannerclient` DISABLE KEYS */
= = = = = = = = = =

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

SQL=Table ‘maam_v2db.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=Table ‘maam_v2db.jos_bannerclient’ doesn’t exist SQL=/*!40000 ALTER TABLE `jos_bannerclient` ENABLE KEYS */:
– – – – – – – – – –
/*!40000 ALTER TABLE `#__bannerclient` ENABLE KEYS */
= = = = = = = = = =

SQL=You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘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 ‘maam_v2db.jos_bannerfinish’ doesn’t exist SQL=–
n– Dumping data for table `jos_bannerfinish`
n–
n
n
n/*!40000 ALTER TABLE `jos_bannerfinish` DISABLE KEYS */:
– – – – – – – – – -[/PHP]
and so on and so on ….

I deleteted the .htaccess file. is there no possibilty to install the routine with the quickstart teline template?
regards
frank

[xraydevil Friend xraydevilJoin date: June 2007Posts: 33Downloads:0Uploads:6 Thanks: 8 Thanked: 2 times in 1 posts]

#236530

solved.
i found this thread.

[Author]

Posts