It is currently Thu Mar 28, 2024 9:09 am


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: MySQL problem
PostPosted: Sun Feb 12, 2006 11:29 am 
Noobie
Noobie

Joined: Sun Feb 12, 2006 11:25 am
Posts: 2
I am trying to execute a file on mysql database and I get this message:


Code:
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 15 Nov, 2005 at 09:13 PM
-- Versione MySQL: 4.1.14
-- Versione PHP: 4.4.0
--
-- Database: `hypercube`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `torrent_bans`
--
CREATE TABLE `torrent_bans` (
`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`ipstart` int( 10 ) unsigned NOT NULL default '0',
`ipend` int( 10 ) unsigned NOT NULL default '0',
`reason` varchar( 255 ) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `ip_unique` ( `ipstart` , `ipend` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

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 'DEFAULT CHARSET=latin1' at line 27


Top
 Profile  
 
 Post subject:
PostPosted: Sun Feb 12, 2006 2:04 pm 
Moderator
Moderator

Joined: Thu Dec 15, 2005 2:59 pm
Posts: 681
Location: England
Your SQL that you are executing has a mistake in it, check over it and see if you can find it :P

_________________
Mountain biking forum ;)
Ponds and fishkeeping :D


Top
 Profile  
 
 Post subject:
PostPosted: Sun Feb 12, 2006 3:44 pm 
Noobie
Noobie

Joined: Sun Feb 12, 2006 11:25 am
Posts: 2
the problem is in:
Code:
ENGINE = MYISAM DEFAULT CHARSET = latin1

and i don't know the solution[/code]


Top
 Profile  
 
 Post subject:
PostPosted: Sun Feb 12, 2006 6:02 pm 
Moderator
Moderator

Joined: Thu Dec 15, 2005 2:59 pm
Posts: 681
Location: England
What is Latin1..Is that your database or something ?

_________________
Mountain biking forum ;)
Ponds and fishkeeping :D


Top
 Profile  
 
 Post subject:
PostPosted: Sun Feb 12, 2006 8:14 pm 
Posts like crazy!
Posts like crazy!

Joined: Mon Sep 26, 2005 5:03 pm
Posts: 204
Location: The Netherlands
Just remove the "DEFAULT CHARSET = latin1" part and i bet it will work.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ]  Moderators: fhmagic, KJ, Moderators, Support Team

All times are UTC


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

Search for:
Jump to:  
100WebSpace © 2011