Pomocy problem nast?pny

Yanke

User
Zarejestrowany
Dołączył
Czerwiec 15, 2009
Posty
31
Liczba reakcji
1
Witam ponownie problem z baz? danych rozwi?za?em. Teraz mam problem z silnikiem GanGrel V5.7 Udost?pnionym na forum.
Zmieni?em W config.lua ze sqlite na mysql baze danych utworzy?em z pliku schema.mysql wszystko pi?knie w??cza si? silnik:


[27/07/2009 15:32:48] The Forgotten Server, version 0.3.4 (Crying Damson)
[27/07/2009 15:32:48] Sever Criado Por Alissow e Comedinha.
[27/07/2009 15:32:48] Publicidade: S? Otserv <- <- <- Tudo sobre otserv.
[27/07/2009 15:32:48] Bom Jogo!!!

[27/07/2009 15:32:48] >> Debugging: nothing.
[27/07/2009 15:32:48] >> Checking software version... up to date!

[27/07/2009 15:32:48] >> Loading config (config.lua)
[27/07/2009 15:32:48] > Using plaintext passwords
[27/07/2009 15:32:48] >> Loading RSA key
[27/07/2009 15:32:48] >> Starting SQL connection
[27/07/2009 15:32:48] >> Running Database Manager
[27/07/2009 15:32:48] > Updating database to version: 9...
[27/07/2009 15:32:48] > Database has been updated to version: 9.
[27/07/2009 15:32:49] > Updating database to version: 10...
[27/07/2009 15:32:49] > Database has been updated to version: 10.
[27/07/2009 15:32:49] > Updating database to version: 11...
[27/07/2009 15:32:49] > Database has been updated to version: 11.
[27/07/2009 15:32:49] > Updating database to version: 12...
[27/07/2009 15:32:50] > Database has been updated to version: 12.
[27/07/2009 15:32:50] > Updating database to version: 13...
[27/07/2009 15:32:50] mysql_real_query(): ALTER TABLE `accounts` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\theforgottenserver\#sql-260_12a' to '.\theforgottenserver\accounts' (errno: 150) (1025)
[27/07/2009 15:32:50] mysql_real_query(): ALTER TABLE `players` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\theforgottenserver\#sql-260_12a' to '.\theforgottenserver\players' (errno: 150) (1025)
[27/07/2009 15:32:50] mysql_real_query(): DROP TABLE `groups`; - MYSQL ERROR: Cannot delete or update a parent row: a foreign key constraint fails (1217)
[27/07/2009 15:32:50] > Database has been updated to version: 13.
[27/07/2009 15:32:51] > Optimizing table: accounts
[27/07/2009 15:32:51] > Optimizing table: bans
[27/07/2009 15:32:51] > Optimizing table: global_storage
[27/07/2009 15:32:51] > Optimizing table: groups
[27/07/2009 15:32:51] > Optimizing table: guild_invites
[27/07/2009 15:32:52] > Optimizing table: guild_ranks
[27/07/2009 15:32:52] > Optimizing table: guilds
[27/07/2009 15:32:52] > Optimizing table: house_data
[27/07/2009 15:32:52] > Optimizing table: house_lists
[27/07/2009 15:32:52] > Optimizing table: houses
[27/07/2009 15:32:52] > Optimizing table: player_deaths
[27/07/2009 15:32:53] > Optimizing table: player_depotitems
[27/07/2009 15:32:53] > Optimizing table: player_items
[27/07/2009 15:32:53] > Optimizing table: player_skills
[27/07/2009 15:32:53] > Optimizing table: player_spells
[27/07/2009 15:32:53] > Optimizing table: player_storage
[27/07/2009 15:32:53] > Optimizing table: player_viplist
[27/07/2009 15:32:54] > Optimizing table: players
[27/07/2009 15:32:54] > Optimizing table: server_config
[27/07/2009 15:32:54] > Optimizing table: server_motd
[27/07/2009 15:32:54] > Optimizing table: server_record
[27/07/2009 15:32:54] > Optimizing table: server_reports
[27/07/2009 15:32:54] > Optimizing table: tile_items
[27/07/2009 15:32:55] > Optimizing table: tiles
[27/07/2009 15:32:55] >> Loading items
[27/07/2009 15:32:55] >> Loading groups
[27/07/2009 15:32:55] >> Loading vocations
[27/07/2009 15:32:55] >> Loading script systems
[27/07/2009 15:32:55] >> Loading chat channels
[27/07/2009 15:32:55] >> Loading outfits
[27/07/2009 15:32:56] >> Loading experience stages
[27/07/2009 15:32:56] >> Loading monsters
[27/07/2009 15:32:56] >> Loading map and spawns...
[27/07/2009 15:32:56] > Map size: 2433x2048.
[27/07/2009 15:32:56] > Map descriptions:
[27/07/2009 15:32:56] Saved with Remere's Map Editor 1.1.8
[27/07/2009 15:32:56] No map description available.
[27/07/2009 15:32:59] > Map loading time: 2.828 seconds.
[27/07/2009 15:32:59] > Data loading time: 0.281 seconds.
[27/07/2009 15:32:59] > Unserialization time for houses: 0 seconds.
[27/07/2009 15:32:59] > Unserialization time for map: 0.328 seconds.
[27/07/2009 15:32:59] >> Checking world type... PvP
[27/07/2009 15:32:59] >> Initializing game state modules and registering services...
[27/07/2009 15:32:59] Warning: [Monster::Monster]. Unknown event name - Pythius the rottenTeleport
[27/07/2009 15:33:00] > Global address: 127.0.01
[27/07/2009 15:33:00] > Local ports:
[27/07/2009 15:33:00] 7171 7172
[27/07/2009 15:33:00] >> All modules were loaded, server starting up...
[27/07/2009 15:33:00] >> GanGrel server Online!


A kiedy pr?buje zalogowa? si? na Acc managera 1/1 pisze Position wrong contact administrator
Wyskakuje mi :


[27/07/2009 15:33:05] mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'GanGrel 5.7 (8.50).'); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)


Pomocy! :(
 
Odp: Pomocy problem nast?pny

Mam to samo zmie? na sqlite i ju? b?dzie dzia?a? (ale nie b?dzie bazy danych)
 
Odp: Pomocy problem nast?pny

No Bardzo bym chcia? Gm'a Stworzy? moze jest jaka? inna mo?liwo?? utworzenia postaci?
Zalezy mi na GMie
 
Odp: Pomocy problem nast?pny

A patrzy?e? w bazie danych czy acc maker jest ustawiony w dobrym miejscu (X,Y,Z) ? Odpisz czy dzia?a
 
Odp: Pomocy problem nast?pny

Dzia?a.. Wszystko Dobrze ustawione na sqlite dzia?a na my sql nie wchodzi acc manager... ;(
 
Odp: Pomocy problem nast?pny

Wejd? w baz? danych otw?rz zak?adk? ACCOUNTS zr?b tam konto potem PLAYERS i zr?b posta? daj jej group id 6 i bedziesz mia? goda. Nie musisz robi? tej postaci przez acc managera.

A co do tego managera to jest z?a pozycja wejdz w baz? zak?adka PLAYERS i obok Account Manager we? edytuj i zmie? mu pozycj? na pozycje temple czyli X Y i Z.
________________________
http://vengrin.zapto.org
Tibia 8.42
IP: vengrin.zapto.org
 
Ostatnia edycja:
Odp: Pomocy problem nast?pny

Czerwony jest dla moderator?w !!!
 
Odp: Pomocy problem nast?pny

Okej dzieki Wielkie ju? mam :D
Zamkni?te...
 
Back
Do góry