Mysql problems..

[Nefs]

Hello, i got a problems on my ot serv... my console give me an error while saving a players, because dont have the table accounts_viplist... and when i go to create this table the mysql give me error...

#1005 - Can't create table 'mydatabase.account_viplist' (errno: 150)

why i cannot create that table?

 

[beautyisatalent]

This ain't the onliest problem, perhaps go look any tutorial "how to create mysql table" just google.. and then before you can enter data row into the table u need to define what kind of data etc.. but i guess that you know better than me, since i do not host any server and dont forget that the table needs to have a index on the referencing column

Ps > this < could be helpfull..

 

[Nefs]

dont understand :S

 

[beautyisatalent]

Google - translator?!..

 

[Nefs]

@i know english + o -, bu i dont understand the Ps > this < could be helpfull..
these things cannot help me, dont create the table

i attached an image of my problems

 

[Cykotitan]

Exec

DROP TABLE IF EXISTS `player_viplist`;

For TFS 0.2:

CREATE TABLE `player_viplist`
(
	`player_id` INT NOT NULL COMMENT 'id of player whose viplist entry it is',
	`vip_id` INT NOT NULL COMMENT 'id of target player of viplist entry',
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
	FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

TFS 0.3:

CREATE TABLE `player_viplist`
(
	`player_id` INT NOT NULL,
	`vip_id` INT NOT NULL,
	KEY (`player_id`), KEY (`vip_id`), UNIQUE (`player_id`, `vip_id`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
	FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Nefs]

the same problem with that

#1005 - Can't create table 'alzeria.player_viplist' (errno: 150)

CREATE TABLE `player_viplist` (
`player_id` INT NOT NULL ,
`vip_id` INT NOT NULL ,
KEY ( `player_id` ) ,
KEY ( `vip_id` ) ,
UNIQUE (
`player_id` ,
`vip_id` 
),
FOREIGN KEY ( `player_id` ) REFERENCES `players` ( `id` ) ON DELETE CASCADE ,
FOREIGN KEY ( `vip_id` ) REFERENCES `players` ( `id` ) ON DELETE CASCADE 
) ENGINE = InnoDB;

 

[beautyisatalent]

Like i said

""the table needs to have a index on the referencing column""

jsut read the upper post.. thats why i gave ya this link etc..

that's why your err 150 comes up..

#1005 - Can't create table 'alzeria.player_viplist'

Isnt it called account_viplist ??

 

[Nefs]

yes look the image, accounts_viplist doesn't exist.

any help?

 

[beautyisatalent]

Well I can't help you more i gave ya links to extern help etc.. perhaps change player viplist to Account viplist

 

[Nefs]

Buuuuuump help!

 

[beautyisatalent]

Why did ya bump? I already gave ya some possible solutions on what it could hang, if you really got no idea of what you are doing i wonder why you want to have it than *laugh*

 

[Nefs]

hello, i was added these tables but this give me another problem

look the attached image

 

[AchTung]

You have to modify your databse since there are missing querys, which the server need.

 

[Nefs]

what querys are missing? cause i dont know what it tell me :/

 

[Nefs]

Buuuuuump heeeeeeelp

 

[beautyisatalent]

I guess you only added the Table, eh? nothing else? lol what does a table brings you if you do not got any row etc in it.. you need to specify.. everything