sql error?

[oddis]

got 1 error whan i load my server

error. sqlite3_step (): SQLITE ERROR: columns id, world_id are not unique

 

[ExibeR]

You have to add a primary key to those columns.

 

[oddis]

You have to add a primary key to those columns.

how? im cinda noob at this atm

 

[kokoxx]

i have the same problem ! plz help

 

[BardockTornado]

I've got the same problem, please somebody help!

 

[ExibeR]

I've got the same problem, please somebody help!

Log into database and set it a primary key on those tables.

 

[alfGago]

where? I can't find an option for that

 

[Lhuntuck]

Same error. Can someone explain how to set this primary key? Also, is it possible for Sqlite?

 

[Onizuka]

go into your database like Exiber said, choose Global Storage, then you'll see world_id, press the key button far on the right >> that's a primary key

hope this is what Exiber meant.. :S

 

[Lhuntuck]

Could you explain better with a pic?



I tried to unmark some boxes but still... the same error came up.

 

[ogor123]

Po polsku mogę udzielić pomocy

 

[Onizuka]

use this sql query/ on top of page press big button SQL then insert this and press go.

ALTER TABLE `global_storage` ADD PRIMARY KEY ( `world_id` )

 

[Lhuntuck]

Didn't work.

 

[crimzzon]

gow to you servers config and change the SQLite to MYSQL thet wood work.
good luck!

check out my new ot server trailer:
YouTube - Realistic OT Official trailer

 

[den4is]

clear the tabs

 

[Poppopwe]

well i have this error now and none of this is working for me, i keep getting error no mater what i do :S

 

[oshrigames]

Could you explain better with a pic?



I tried to unmark some boxes but still... the same error came up.

what softwere did you use to get there?