1064 - You have an error in your SQL syntax

Need help installing Joomla!? For all Joomla! installation issues please use this forum.
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
gardara
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Sep 27, 2006 7:14 pm

1064 - You have an error in your SQL syntax

Postby gardara » Mon Jan 12, 2009 7:40 pm

I'm moving a joomla site and when I was importing the database using phpmyadmin I got a error that I've never gotten before (and I've moved quite a number of joomla sites before).

Code: Select all

Error

SQL query:

-- MySQL dump 8.23
--
-- Host: localhost Database: matis_joomla
------------------------------------------------------- --
-- Server version 4.1.22-standard-log
--
-- Table structure for table `jos_banner`
--
DROP TABLE IF EXISTS `jos_banner` ;

MySQL said: Documentation
#1064 - 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 '---------------------------------------------------------
-- Server version    4.1.' at line 1


Any ideas what could be wrong?

gardara
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Sep 27, 2006 7:14 pm

Re: 1064 - You have an error in your SQL syntax

Postby gardara » Sun Jan 18, 2009 8:19 pm

Anyone?

dragonrider
Joomla! Ace
Joomla! Ace
Posts: 1045
Joined: Mon Aug 22, 2005 7:53 pm
Location: Ilkley, West Yorkshire, UK
Contact:

Re: 1064 - You have an error in your SQL syntax

Postby dragonrider » Sun Jan 18, 2009 8:57 pm

Possibly.

Code: Select all

SQL query:

-- MySQL dump 8.23
--
-- Host: localhost Database: matis_joomla
------------------------------------------------------- --
-- Server version 4.1.22-standard-log
--
-- Table structure for table `jos_banner`
--
DROP TABLE IF EXISTS `jos_banner` ;

Drop all the comment code and just use

Code: Select all

DROP TABLE IF EXISTS `jos_banner` ;


You've possibly lost the first line of the comment???

gardara
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Sep 27, 2006 7:14 pm

Re: 1064 - You have an error in your SQL syntax

Postby gardara » Sun Jan 18, 2009 9:16 pm

Oh that worked...
What a easy fix.

Thanks!

prashantbala
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Tue Nov 24, 2009 11:31 pm

Re: 1064 - You have an error in your SQL syntax

Postby prashantbala » Sat May 14, 2011 6:31 pm

Could you please mention in which file you changed this... im not able to determine where this file is.. i have the same error when i am doing a fresh install

im using joomla 1.5.22

thanks in advance

dragonrider
Joomla! Ace
Joomla! Ace
Posts: 1045
Joined: Mon Aug 22, 2005 7:53 pm
Location: Ilkley, West Yorkshire, UK
Contact:

Re: 1064 - You have an error in your SQL syntax

Postby dragonrider » Sat May 14, 2011 6:38 pm

prashantbala wrote:Could you please mention in which file you changed this... im not able to determine where this file is.. i have the same error when i am doing a fresh install

im using joomla 1.5.22

thanks in advance


Hi, it's not a file, it's entered by using the SQL tab in your database via phpMyAdmin which should be available via your website/server control panel.

tamim01
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Nov 12, 2013 5:44 pm

Re: 1064 - You have an error in your SQL syntax

Postby tamim01 » Tue Nov 12, 2013 6:09 pm

plz help,can't install joomla on my site,it shows something like this


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 'TYPE=MyISAM CHARACTER SET `utf8`' .......

if i install earlier version would more earlier version would this solve this problem,,i am using 1.5.21


Return to “Installation - 1.0.x”

Who is online

Users browsing this forum: No registered users and 3 guests