Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Installation Help
Author Message
SpaceMonkey
Worker
Worker


Joined: Apr 30, 2005
Posts: 170

PostPosted: Fri Sep 02, 2005 2:57 am Reply with quote

I'm trying to upload my MySQL stuff using phpmyadmin. I'm getting the following error:

Code:
SQL-query:


# phpMyAdmin MySQL-Dump
# version 2.3.1-rc1
# http://www.phpmyadmin.net/ (download page)
#
# servidor: localhost
# Tiempo de generación: 08-05-2005 a las 20:26:29
# Versión del servidor: 4.01.10
# Versión de PHP: 5.0.3
# Base de datos : `nuke`
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_authors`
#
CREATE TABLE nuke_authors(
aid varchar( 25 ) NOT NULL default  '',
name varchar( 50 ) default NULL ,
url varchar( 255 ) NOT NULL default  '',
email varchar( 255 ) NOT NULL default  '',
pwd varchar( 40 ) default NULL ,
counter int( 11 ) NOT NULL default  '0',
radminsuper tinyint( 1 ) NOT NULL default  '1',
admlanguage varchar( 30 ) NOT NULL default  '',
PRIMARY KEY ( aid ) ,
KEY aid( aid )
) ENGINE = MYISAM

MySQL said:

#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 27

This is especially odd considering I performed the same upload really recently without any problems.
 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Fri Sep 02, 2005 3:26 am Reply with quote

Try changing ENGINE = MYISAM to TYPE=MyISAM;
 
View user's profile Send private message
SpaceMonkey
PostPosted: Fri Sep 02, 2005 3:30 am Reply with quote

Well I'll be. It worked.. How come I've never had that problem before? I've uploaded the same stuff a million times.

Thanks Raven..
 
Raven
PostPosted: Fri Sep 02, 2005 3:33 am Reply with quote

Well, it was either Engine -> Type or the ; at the end. Try engine=myisam; (add the colon)
 
SpaceMonkey
PostPosted: Fri Sep 02, 2005 3:37 am Reply with quote

It's all fixed... Your first suggestion worked.. Another site is on the go.. Smile
 
Raven
PostPosted: Fri Sep 02, 2005 3:41 am Reply with quote

RavensScripts
 
SpaceMonkey
PostPosted: Fri Sep 02, 2005 3:42 am Reply with quote

hahaha.. You can say that again..
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Installation Help

View next topic
View previous topic
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 vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©