Joomla Templates Club 406,261 posts

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#119785

Hi Guys,

Trying to install Teline as a new site, with a fresh install.

Joomla installs upto the point it tries to populate the db.

Then I get:-

Looks like there have been some errors with inserting data into your database!
You cannot continue

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` (

etc. etc.

Any ideas how to fix this?

Many thanks

Matthew

[ShannonN Friend ShannonNJoin date: July 2006Posts: 1947Downloads:0Uploads:9 Thanks: 16 Thanked: 172 times in 49 posts]

#218503

mrh;13358Hi Guys,

Trying to install Teline as a new site, with a fresh install.

Joomla installs upto the point it tries to populate the db.

Then I get:-

Looks like there have been some errors with inserting data into your database!
You cannot continue

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` (

etc. etc.

Any ideas how to fix this?

Many thanks

Matthew

try installing with the drop tables box ticked ?

Cheers ShannonN

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#218510

<em>@ShannonN 13382 wrote:</em><blockquote>try installing with the drop tables box ticked ?

Cheers ShannonN</blockquote>
Cheers for the suggestion, but it still behaves the same!

Thanks

Matthew

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#218608

Anyone else got any ideas?

Thanks

Matthew

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

#218628

Hi Matthew,

could you please elaborate, what you are trying to install. Is it the quickstart package? If yes, did you try a normal Joomla already?

Bernhard

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#218634

Cheers Bernhard for the the reply,

I’m trying to install the quickstart package for this template.

The server on which I’m trying also hosts about 11 joomla sites which all installed ok. I’ve just tried a fresh plain joomla install and it works ok.

I upload the quickstart, uncompress the files when go to the site url and follow the setup procedures.

I enter the hosts, db names (I’d already created it), user, password etc.

Then I get the error detailed above,

I’ve tried to see if a get the same error by changing the user password or username, and I get an error telling me the database can’t be accessed/ the password is incorrect etc.

So, from what I can see, the credentials I am supplying are ok, its just the error occurs when the installer tries to populate the database.

Hope this gives you enough information.

Many thanks

Matthew

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

#218636

There are several possible reasons. From the message you get I would guess that it is a problem of
1. the SQL-file of the Qucikstart package
or
2. your MYSQL version.
But this could only be verified by having a closer look. Can you give the system info or do you have a info.php to view?

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#218637

Not at the system to give you access at the moment …

Have paste info.php to http://pastebin.ca/452808

Many thanks again,

Matthew

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

#218645

There are only two reasons I can think of.
1. Maybe the Quickstart package needs a more recent version of MySQL?!
2. Your packages sql-file is broken.

Have you tried to do a sql query and insert the sql-files of the package into a blank database without trying to install joomla or the whole package. If this works, we could exclude some possible reasons for the problem.

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#218647

Cheers for the suggestion – will try that in the morning

Thanks

Matthew

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#218761

Just tried to import the sql file direct via webmin.

Still gave errors, and only imported 3 tables jos_sessions, jos_stats and jos_users.

Also tried via phpadmin
Database austreynet running on localhost
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
—-BEGIN CUT—-
eNptjt1KwzAARu/zFJ+wq9GmSX+2LiC0xLAVsrYmdYI3ZcOBhVFry2Q+2y58JF9h0WtvD9/HOcqY
yghIDhlCq1KAI8SSEds4fCVE7qzArHgVmD5Ow36cjiM9dQc6vA3eJzhdMoSMRQFbBMxdI8FWIl5g
3B/OE9RlwIxsv+yjFohoGNEkJU/WoLIe8rUqGw875UTPXY9t9VJonSOhjNTbXCCkCeWk3tS/G69y
HTHl1GV2/flCdF6uBY69303vfpomK5+TP8/P9dv3STC/ixl3SVY1yCr90MpNbnLZKNM61EpdOP19
lv2HMQ9uyQ9JkQ==
—-END CUT—-
—-BEGIN RAW—-

ERROR: C1 C2 LEN: 1 2 70
STR: »

CVS: $Id: sqlparser.lib.php,v 1.70 2003/06/01 23:09:46 rabus Exp $
MySQL: 3.23.58
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.5.1
PHP VER,OS: 4.1.2 Linux
LANG: en-iso-8859-1
SQL: –
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */

—-END RAW—-

Error

SQL-query :

–
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */

MySQL said:

You have an error in your SQL syntax near ‘–

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */’ at line 1

Back

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#218763

Ok.

Just D/l the quickstart again!

This time myphpadmin gives,,,

SQL-query :

CREATE TABLE `teline_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 = 3DEFAULT CHARSET = utf8

MySQL said:

You have an error in your SQL syntax near ‘ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8’ at line 19

Hope we are making progress!

[ErikThorsen Friend ErikThorsenJoin date: December 2005Posts: 1098Downloads:0Uploads:7 Thanks: 22 Thanked: 10 times in 1 posts]

#218785

Which charset is your sql db set to take? As it is trying to import utf8

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

#218788

As the messages point to a charset problem, I would conclude that the quickstart package is incompatible with your (very old) version of MySQL. The package is trying to insert tables with utf-8 as default charset but this seems to be impossible. Maybe the joomlart team should tell us the minimum requirements to use this package.

[mrh Friend mrhJoin date: February 2006Posts: 12Downloads:0Uploads:0 Thanks: 2]

#219037

I agree – if someone can tell me the minimum requirements I can look to upgrading etc.

[Author]

Posts