next »

[setman]

How do you execute this file? I am running this on server 2008

3. Execute the echelon.sql script inside the directory 'sql' on
the echelon database. This will create two tables and a few
records.

[Courgette]

you need a SQL administration tool such as PhpMyAdmin or MySQL Workbench

[setman]

I have xampp installed which runs my b3, it has phpadmin

[Courgette]

there are plenty of video tutorials on how to run sql script with phpmyadmin. Please refer to them

http://www.google.com/search?q=run+sql+script+with+phpmyadmin

[setman]

Thanks, ever heard of this when executing a file? Already posted on mysql fourms, still waiting for them to answer

Error Code: 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 'TYPE=MyISAM AUTO_INCREMENT=4' at line 26

It is saying something about the echelon.sql file

[setman]

Thanks, ever heard of this when executing a file? Already posted on mysql fourms, still waiting for them to answer

Error Code: 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 'TYPE=MyISAM AUTO_INCREMENT=4' at line 26

It is saying something about the echelon.sql file

Got it working. I guess in the echelon sql file it is showing TYPE when it should say ENGINE

[Courgette]

glad you got it working. This issue is a regression in MySQL v5.1.0 that is fixed in MySQL 5.1.7 if I'm not mistaken

[Strawhidy]

So how did you fix the problem?

[setman]

Just imported the echelon.sql into the echelon database , and it works fine.
To simple, i just didn't think of it. Same way all the b3 files get imported.

[Strawhidy]

I've been trying to import the echelon.sql in the same manner and I'm getting the following error:

SQL query:

# --------------------------------------------------------
#
# Table structure for table `users`
#
 CREATETABLE`users` (

 `id` int( 11)NOTNULLAUTO_INCREMENT ,
 `username` varchar( 25)NOTNULL default'',
 `password` varchar( 32)NOTNULL default'',
 `ech_level` int( 11)NOTNULL default'0',
 `b3cod` int( 11)default NULL ,
 `b3uo` int( 11)default NULL ,
 PRIMARYKEY (`id`)
) TYPE=MYISAMAUTO_INCREMENT=2;


MySQL said:
#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 'TYPE=MyISAM AUTO_INCREMENT=2' at line 15
 

[MordyT]

Edit the echelon.sql
find and replace TYPE with ENGINE.
Same and re-import.

[Strawhidy]

Thanks Mordy! That did the trick.