Page 1 of 1
1064 - You have an error in your SQL syntax
Posted: Mon Jan 12, 2009 7:40 pm
by gardara
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?
Re: 1064 - You have an error in your SQL syntax
Posted: Sun Jan 18, 2009 8:19 pm
by gardara
Anyone?
Re: 1064 - You have an error in your SQL syntax
Posted: Sun Jan 18, 2009 8:57 pm
by dragonrider
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???
Re: 1064 - You have an error in your SQL syntax
Posted: Sun Jan 18, 2009 9:16 pm
by gardara
Oh that worked...
What a easy fix.
Thanks!
Re: 1064 - You have an error in your SQL syntax
Posted: Sat May 14, 2011 6:31 pm
by prashantbala
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
Re: 1064 - You have an error in your SQL syntax
Posted: Sat May 14, 2011 6:38 pm
by dragonrider
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.
Re: 1064 - You have an error in your SQL syntax
Posted: Tue Nov 12, 2013 6:09 pm
by tamim01
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