Raised This Month: $51 Target: $400
 12% 

[REQ] War3Source database update


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
krikus62
Senior Member
Join Date: Jan 2015
Old 05-22-2016 , 08:04   [REQ] War3Source database update
Reply With Quote #1

Hello,

I would like to ask for some help with war3source database managment, as it seems to be broken atm.

Using sql database I get: SQL error: [T_CallbackUpdatePDataMain] disk I/O error QUERY:UPDATE

And if I am using mysql it seems that it cannot connect to the database and or create tables in it.

So I would like someone to help out and fix this issue, I am willing to pay for this request, already pmed franc1sko, but he seemed quite busy, so I am asking here, if someone else could come up with a paid fix ?

Added both database managment files as attachments.
Attached Files
File Type: sp Get Plugin or Get Source (Engine_DatabaseConnect.sp - 90 views - 2.3 KB)
File Type: sp Get Plugin or Get Source (War3Source_Addon_DatabaseReset.sp - 99 views - 5.3 KB)
File Type: sp Get Plugin or Get Source (War3Source_Engine_DatabaseSaveXP.sp - 97 views - 23.1 KB)
__________________
My plugins:
Spoiler

Last edited by krikus62; 05-25-2016 at 16:28. Reason: Included sp
krikus62 is offline
krikus62
Senior Member
Join Date: Jan 2015
Old 05-25-2016 , 08:47   Re: [REQ] War3Source database update
Reply With Quote #2

bump, I am really interested in this, atm trying to learn it myself but I am lacking the free time...
__________________
My plugins:
Spoiler
krikus62 is offline
Jakeey802
Senior Member
Join Date: Oct 2015
Old 05-25-2016 , 14:06   Re: [REQ] War3Source database update
Reply With Quote #3

No sp file?
Jakeey802 is offline
krikus62
Senior Member
Join Date: Jan 2015
Old 05-25-2016 , 16:28   Re: [REQ] War3Source database update
Reply With Quote #4

Quote:
Originally Posted by Jakeey802 View Post
No sp file?
So sorry did not notice I gave smx files, updated with sp...
__________________
My plugins:
Spoiler
krikus62 is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 05-27-2016 , 06:16   Re: [REQ] War3Source database update
Reply With Quote #5

Quote:
disk I/O error
Seems like your sqlite database is corrupted? Maybe the server crashed while it was writing to it? Or there are some permission problems? Google is more helpful here as it's a generic sqlite error.
__________________
Peace-Maker is offline
sdz
Senior Member
Join Date: Feb 2012
Old 05-27-2016 , 08:36   Re: [REQ] War3Source database update
Reply With Quote #6

It sounds like the user you're trying to use in the database doesn't have their permissions set. Try doing that or using root ONCE as a test.
sdz is offline
krikus62
Senior Member
Join Date: Jan 2015
Old 05-28-2016 , 11:52   Re: [REQ] War3Source database update
Reply With Quote #7

But in that case why wouldnt it create tables for mysql database?
__________________
My plugins:
Spoiler
krikus62 is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 05-28-2016 , 15:24   Re: [REQ] War3Source database update
Reply With Quote #8

Can you post the error message for that MySQL problem?
__________________
Peace-Maker is offline
krikus62
Senior Member
Join Date: Jan 2015
Old 05-28-2016 , 17:19   Re: [REQ] War3Source database update
Reply With Quote #9

That is the weird part there are none, and yet it doesn't save it. And I have set to save stats in cvar. Tomorrow I will be home and double check everything, but it should show some error, if it couldn't connect to db, and if it connects it should make the tables but it doesn't...
__________________
My plugins:
Spoiler
krikus62 is offline
El Diablo War3Evo
Veteran Member
Join Date: Jun 2013
Old 06-04-2016 , 09:34   Re: [REQ] War3Source database update
Reply With Quote #10

Have you gone to the War3Source.com website for help?
__________________
El Diablo War3Evo is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:10.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode