Pagina 1 din 1

Problema mysql

Scris: Sâm Mar 16, 2024 5:22 pm
de Ionut14
Tipologie server pvm
Resursă folosită:sinners
ServerFiles utilizat:serverfile sinners
Syserr:SYSERR: Mar 16 16:13:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.event_table' doesn't exist
query: SELECT id, eventIndex+0, UNIX_TIMESTAMP(startTime), UNIX_TIMESTAMP(endTime), empireFlag, channelFlag, value0, value1, value2, value3 FROM player.event_table
SYSERR: Mar 16 16:13:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.rankings' doesn't exist
query: SELECT r.pid, r.monsters, r.metins, r.bosses, r.players, r.chests, p.name, pi.empire, g.name FROM rankings r LEFT JOIN player p on p.id = r.pid LEFT JOIN player_index pi on pi.id = p.account_id LEFT JOIN guild_member gm on gm.pid = r.pid LEFT JOIN guild g on g.id = gm.guild_id;
Poză:
Detalii suplimentare:

Re: Problema mysql

Scris: Sâm Mar 16, 2024 5:28 pm
de RazVan
Ionut14 scrie: Sâm Mar 16, 2024 5:22 pm Tipologie server pvm
Resursă folosită:sinners
ServerFiles utilizat:serverfile sinners
Syserr:SYSERR: Mar 16 16:13:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.event_table' doesn't exist
query: SELECT id, eventIndex+0, UNIX_TIMESTAMP(startTime), UNIX_TIMESTAMP(endTime), empireFlag, channelFlag, value0, value1, value2, value3 FROM player.event_table
SYSERR: Mar 16 16:13:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.rankings' doesn't exist
query: SELECT r.pid, r.monsters, r.metins, r.bosses, r.players, r.chests, p.name, pi.empire, g.name FROM rankings r LEFT JOIN player p on p.id = r.pid LEFT JOIN player_index pi on pi.id = p.account_id LEFT JOIN guild_member gm on gm.pid = r.pid LEFT JOIN guild g on g.id = gm.guild_id;
Poză:
Detalii suplimentare:
Salut, iti lipseste tabelu de player.rankings

Re: Problema mysql

Scris: Sâm Mar 16, 2024 5:41 pm
de Ionut14
Multumec mult, il pot luat din alt mysql nu ?

Re: Problema mysql

Scris: Sâm Mar 16, 2024 6:05 pm
de RazVan
Ionut14 scrie: Sâm Mar 16, 2024 5:41 pm Multumec mult, il pot luat din alt mysql nu ?
Da, sau sa reincarci mysql original (partea de tabel care iti lipseste)

Re: Problema mysql

Scris: Sâm Mar 16, 2024 6:52 pm
de Ionut14
Imagine o am dar nu il citeste credca rebuie mysql 5.7 https://postimg.cc/ZCfWKJ7W

Re: Problema mysql

Scris: Sâm Mar 16, 2024 7:36 pm
de RazVan

Re: Problema mysql

Scris: Sâm Mar 16, 2024 9:53 pm
de Ionut14
Multumesc mult bro, le-am inlocuit dar nu merge nici unu din tabele https://postimg.cc/hhKYVp5T/6884fe78

Re: Problema mysql

Scris: Dum Mar 17, 2024 7:46 am
de RazVan
Atunci incearca sa le iei dintr un alt mysql ca iti lipsesc cele 2 tabele de rankings si event_table

Re: Problema mysql

Scris: Mar Mar 19, 2024 5:54 pm
de RazVan
Autorul nu a mai dat nici un raspuns. T/c