search

GameProgressive / GameSpyEmulator

Deprecated! Look at: https://github.com/GameProgressive/RetroSpyServer
6 stars 1 forks source link

No such function: Unix_Timestamp #5

Open xerxes-at opened 6 years ago

xerxes-at commented 6 years ago

I get this error from time to time, I'm using the latest version compiled with VS (2017) 15.7.5 I use SQLite as backend, my guess is that a query uses Unix_Timestamp which does not exist in SQLite.

[Query] [ERROR] >> Cannot execute query. Error: no such function: Unix_Timestamp

Games tested: BF2 Crysis:Wars

xiaojiuwo1993 commented 6 years ago

do not use sqlite it is not functional,use mariadb instead

发件人: xerxes-at notifications@github.com 发送时间: 2018年9月30日 20:12 收件人: GameProgressive/GameSpyEmulator 抄送: Subscribed 主题: [GameProgressive/GameSpyEmulator] No such function: Unix_Timestamp (#5)

I get this error from time to time, I'm using the latest version compiled with VS (2017) 15.7.5 I used BF2 as game with SQLite as backend. My guess is that a query uses Unix_Timestamp which does not exist in SQLite.

[Query] [ERROR] >> Cannot execute query. Error: no such function: Unix_Timestamp

― You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/GameProgressive/GameSpyEmulator/issues/5, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ATASvorsu5ITsGEAYjjLn2GD0GSwz0jGks5ugSWlgaJpZM4XBIlA.

arves100 commented 6 years ago

Thanks for reportig, I will fix it in the next commit, Sqlite support is currently experimental, if you want to launch the server without any possible sql error you should use mariadb.

Il lun 1 ott 2018, 02:29 xiaojiuwo notifications@github.com ha scritto:

do not use sqlite it is not functional,use mariadb instead

发件人: xerxes-at notifications@github.com 发送时间: 2018年9月30日 20:12 收件人: GameProgressive/GameSpyEmulator 抄送: Subscribed 主题: [GameProgressive/GameSpyEmulator] No such function: Unix_Timestamp (#5)

I get this error from time to time, I'm using the latest version compiled with VS (2017) 15.7.5 I used BF2 as game with SQLite as backend. My guess is that a query uses Unix_Timestamp which does not exist in SQLite.

[Query] [ERROR] >> Cannot execute query. Error: no such function: Unix_Timestamp

― You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub< https://github.com/GameProgressive/GameSpyEmulator/issues/5>, or mute the thread< https://github.com/notifications/unsubscribe-auth/ATASvorsu5ITsGEAYjjLn2GD0GSwz0jGks5ugSWlgaJpZM4XBIlA>.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/GameProgressive/GameSpyEmulator/issues/5#issuecomment-425763826, or mute the thread https://github.com/notifications/unsubscribe-auth/AEn4E_RwRlDVrehZZWqH485zcw_17VVWks5ugWHOgaJpZM4XBIlA .

arves100 commented 6 years ago

It should be fixed right now, however the database is not updated