Page 1 of 1

What gives? SFS2X Database Manager issues [SOLVED]

Posted: 16 Dec 2010, 06:25
by Fishypants
So I have decided I would give SFS2X a shot and see how well it behaves (I am currently using 1.6.x).

Maybe I am overlooking something, but it seems like SFS2X is 2X harder to get up and running then 1.6.x.

I am trying to configure the server to connect to a MySQL database. In ver 1.6.x, I followed the tutorial word for word, and I was up and running in no time. I for the life of me cannot figure out what is wrong with 2X, it just wont work. I'm running Window Vista 64bit. This is the error I am getting:
ERROR [main] db.SFSDBManager
Exception: java.lang.IllegalArgumentException
Message: SFSObject requires a non-null value! If you need to add a null use the putNull() method.
Description: The initialization of the DBManager has failed.
Possible Causes: if the database driver is not 'seen' int the server classpath the setup fails.
Make sure to deploy the driver .jar file in the extensions/__lib__/ folder and restart the Server.
I find it weird that the server recommends putting it in the __lib__ folder, while the documentation (http://docs2x.smartfoxserver.com/Gettin ... wtos#item2) recommends putting it in the {SFS2XRoot}/lib/ folder.

For giggles I tried putting it in both and no luck. Has anyone got this issue before? Know of any possible solutions?

Posted: 16 Dec 2010, 06:52
by Fishypants
Argh . . . ok I figured it out. Apparently SFS2X does not like having empty entries in your database. ( I had an old column that had nothing in it ) Now it's working . . .

Wonder why it's so touchy with that where as 1.6.x didn't care at all?