The Joomla! 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.



Post new topic Reply to topic  [ 7 posts ] 
Author Message
PostPosted: Mon Jan 12, 2009 7:40 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Sep 27, 2006 7:14 pm
Posts: 5
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:
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?


Top
 Profile  
 
PostPosted: Sun Jan 18, 2009 8:19 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Sep 27, 2006 7:14 pm
Posts: 5
Anyone?


Top
 Profile  
 
PostPosted: Sun Jan 18, 2009 8:57 pm 
Joomla! Ace
Joomla! Ace

Joined: Mon Aug 22, 2005 7:53 pm
Posts: 1045
Location: Ilkley, West Yorkshire, UK
Possibly.
Code:
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:
DROP TABLE IF EXISTS `jos_banner` ;


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

_________________
My sites: http://ilkleygardeners.org.uk Gardeners, http://wharfedalefestival.co.uk Music Festival


Top
 Profile  
 
PostPosted: Sun Jan 18, 2009 9:16 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Sep 27, 2006 7:14 pm
Posts: 5
Oh that worked...
What a easy fix.

Thanks!


Top
 Profile  
 
PostPosted: Sat May 14, 2011 6:31 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Nov 24, 2009 11:31 pm
Posts: 9
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


Top
 Profile  
 
PostPosted: Sat May 14, 2011 6:38 pm 
Joomla! Ace
Joomla! Ace

Joined: Mon Aug 22, 2005 7:53 pm
Posts: 1045
Location: Ilkley, West Yorkshire, UK
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.

_________________
My sites: http://ilkleygardeners.org.uk Gardeners, http://wharfedalefestival.co.uk Music Festival


Top
 Profile  
 
PostPosted: Tue Nov 12, 2013 6:09 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Nov 12, 2013 5:44 pm
Posts: 1
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 



Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group