logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Tested with MariaDB

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
12o



Joined: 27 Dec 2008
Posts: 35

PostPosted: Mon Jan 12, 2015 8:13    Post subject: Tested with MariaDB Reply with quote

About a year and a half ago, I posted a question (here) regarding whether MariaDB would work as it is now basically a community fork from MySQL. The two are pretty much exactly the same, as is the SQL syntax. However, I began running into a problem that didn't appear to throw an error. I was able to test the aps_demo.mod module using MariaDB and the git version of NWNX2. It doesn't work 'out of the box' as the line:
Code:

last TIMESTAMP(14) NOT NULL

will throw an error. According to NWNX2, everything works fine and no error is thrown in the logs (probably shouldn't anyway as the error is in MariaDB).

The error is:
Code:

ERROR 1426 (42000): Too big precision 14 specified for 'last'. Maximum is 6.

When I set the value to 6, the module created the table and stored the variable.

This setup is running a NWN server and MariaDB both in the same chroot in Arch Linux. I hope this information helps.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group