12o
Joined: 27 Dec 2008
Posts: 35
|
 Posted: Mon Jan 12, 2015 8:13 Post subject: Tested with MariaDB |
 |
|
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. |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
