Some "errors" occured on gameserver.

[InTheEndॐ]

http://prntscr.com/1lvbrf

 

Check here.

[Stewie]

I never said that, now you put words in my mouth? (my point was that many people are just fine with primary keys)

 

OP, try that one.

 

ALTER TABLE spawnlist MODIFY id INT NOT NULL;
ALTER TABLE spawnlist DROP PRIMARY KEY;

 

Or just exchange

PRIMARY KEY

to

PRIMARY KEY AUTOINCREMENT

[MikeJ]

Or just exchange

PRIMARY KEY

to

PRIMARY KEY AUTOINCREMENT

So you're saying it would be like that?

ALTER TABLE spawnlist DROP PRIMARY KEY AUTOINCREMENT;

 

It doesn't even work but nice try.

[dEvilKinG]

Or just exchange

PRIMARY KEY

to

PRIMARY KEY AUTOINCREMENT

 

It's already autoincrement..

[xdem]

For fack's sake, dont listen to stewie, his l2j knowledge is bellow 0, edit sqls? really ?

[Stewie]

So you're saying it would be like that?

ALTER TABLE spawnlist DROP PRIMARY KEY AUTOINCREMENT;

 

It doesn't even work but nice try.

@dEvilKinG

Actualy i've checked SQL syntax using in L2J Frozen lastest version.

 

@MikeJ

 

No i doesn't mean anything about your line. Was talking generaly in SQL.

 

[InTheEndॐ]

I never said that, now you put words in my mouth? (my point was that many people are just fine with primary keys)

 

OP, try that one.

 

ALTER TABLE spawnlist MODIFY id INT NOT NULL;
ALTER TABLE spawnlist DROP PRIMARY KEY;

 

mysql> ALTER TABLE spawnlist MODIFY id INT NOT NULL;

ALTER TABLE spawnlist DROP PRIMARY KEY;

Query OK, 36895 rows affected

Records: 36895  Duplicates: 0  Warnings: 0

 

Query OK, 36895 rows affected

Records: 36895  Duplicates: 0  Warnings: 0

 

mysql>

 

that's good? must i restart now or what? :P

[MikeJ]

mysql> ALTER TABLE spawnlist MODIFY id INT NOT NULL;

ALTER TABLE spawnlist DROP PRIMARY KEY;

Query OK, 36895 rows affected

Records: 36895  Duplicates: 0  Warnings: 0

 

Query OK, 36895 rows affected

Records: 36895  Duplicates: 0  Warnings: 0

 

mysql>

 

that's good? must i restart now or what? :P

Yeah, now primary key is gone buddy.

 

Try restarting and see if it's ok now.

[Stewie]

It's already autoincrement..

 

Okey true, didn't check above  ;D

[MikeJ]

No i doesn't mean anything about your line. Was talking generaly in SQL.

Alright then.

 

By the way, I didn't want to offend you in any way. (just saying)

[Stewie]

Alright then.

 

By the way, I didn't want to offend you in any way. (just saying)

 

in a dispute is born the real truth

[MikeJ]

in a dispute is born the real truth

What are you talking about?

 

Didn't quite get your point.

[InTheEndॐ]

Alright then.

 

By the way, I didn't want to offend you in any way. (just saying)

Worked fine,thanks. :D

[Stewie]

What are you talking about?

 

Didn't quite get your point.

 

Two minds are better than one. Better solution can be easily found if two people discuss it. I'm also learning while helping others, we are always learning forever and ever and noone knows everything.

 

@xdem

If he thinks he does then he is stupid.