Error to import the database

[Hazher]

Ok,when i want import my database (forgottenserver.sql)
to my sql (i'm using xampp 1.6.3a) appear this error:

Error

consulta SQL:

INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0 ) ;

MySQL says: Documentation
#1136 - Column count doesn't match value count at row 1

How i can to solve my problem.

Ty

 

[dekar]

in this forum already dale exists much information on this to look for

 

[Mokerhamer]

Update your PhpMyadmin to the latest one it should fix it

 

[Gesior.pl]

Reason + help

Change:

INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0 ) ;

to:

 INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0, 1 ) ;

Here is one more row with "1" (group_id) in database (in 0.2.5 ver. 100%, in 0.2.4 was 10 rows too (99%) - i dont have old .sql file)
So when u try to add 9 values to table with 10 rows u see error:
#1136 - Column count doesn't match value count at row 1

Good .sql file u can download here (0.2.5, but should work fine on 0.2.4):
http://tibicam.superhost.pl/kasi/pliki/forgottenserver.sql
(rehosted file from newest SVN)
I added this .sql by windows console "cmd" without any errors and 0.2.4 TFS work fine.

I am here to post a tutorial. The tutorial goes to decide the problem of importation of database of forgotten and of not the save of skills!
Go to phpmyadmin and create a database named theforgottenserver

later paste you database Ex: forgottenserver.sql
in C:/xampp/mysql/bin

later go to start>run and type cmd and click on ok

with the cmd window open type
cd C:\xampp\mysql\bin

later with cmd open,type in
mysql -u root theforgottenserver -p < forgottenserver.sql

it should ask for your password of the database, you type in your password and press enter and ready!

In this tutorial I based my database in XAMPP more others are existed packs with mysql, as easyphp and otstriad in the case if you to use one of these are enough you to change the directory of the folder of mysql.exe!

Credits: 100% Lithium //EDITED by Gesior - updated to 0.2.5 TFS datebase (without triggers.sql)

- from 0tfans.net forum
Sorry for my bad english. Im from Poland ^_^

 

[Hazher]

i,m followung all steps but when in the cdm
ask for the pasword appear a error ;/ how i can resolve .

 

[Denderia]

Update your PhpMyadmin to the latest one it should fix it

I get the same problem as hazher could you pm me and tell me how to update phpmyadmin?:S

 

[Pvls]

How? Simple way, download the latest version.

Google know

 

[darex11]

maybe u need the newest phpmyadmin ?