nuclearsilo583 / zephyrus-store-preview-new-syntax

My rewritten zephyrus store
61 stars 40 forks source link

Invalid database Handle 0 (error: 4) #141

Open Villads1 opened 1 year ago

Villads1 commented 1 year ago

Hello! Unfortunately my server hoster crashed & somehow corrupted all their files. The store plugin was working fine before but i am getting this error now? It doesnt happen all the the time & the plugin has made a connection many times.

L 02/07/2023 - 04:40:53: [store\store.smx] Database connection is lost or not yet initialized. L 02/07/2023 - 04:40:53: [store\store.smx] Database connection is lost or not yet initialized. L 02/07/2023 - 04:40:53: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 02/07/2023 - 04:40:53: [SM] Blaming: store\store.smx L 02/07/2023 - 04:40:53: [SM] Call stack trace: L 02/07/2023 - 04:40:53: [SM] [0] SQL_FormatQuery L 02/07/2023 - 04:40:53: [SM] [1] Line 540, store\store_functions.sp::Store_LogMessage L 02/07/2023 - 04:40:53: [SM] [2] Line 230, store\store_functions.sp::Store_DisconnectClient L 02/07/2023 - 04:40:53: [SM] [3] Line 443, C:\Users\villa\Desktop\servers\5v5\addons\sourcemod\scripting\store.sp::OnClientDisconnect

Thanks in advance & great plugin!

nuclearsilo583 commented 1 year ago

Check if you have setup the database entry/connection correctly. Check this entry here and check your addons/sourcemod/configs/database.cfg are matching.

Villads1 commented 1 year ago

My database.cfg entry is correct & so is the plugin.store.cfg configuration. I havent been able to figure out whether this actually makes an impact or not, But regardless this error shows up in error log once in a while & i'm really not interested in leaving it like that.

azalty commented 1 year ago

Seems like a problem with your database, code seems fine