1064 - You have an error in your SQL syntax

[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?

[gardara]

Anyone?

[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???

[gardara]

Oh that worked...
What a easy fix.

Thanks!

[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

[dragonrider]

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]

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