forums.smartfoxserver.com

executeQuery returns 'None' when the select * operation is performed on a table with the following configuration:

account_id int(10) unsigned not null,
username char(32) not null,
session_id char(32) not null,
entered_game tinyint(1) unsigned not null,
session_started datetime not null,
last_chat datetime not null,
primary key(account_id)

With much testing I found that it works perfectly when the last field has been dropped, or replaced by anything else. I don't remember all of the configurations that I tried, but it seems like the problem revolves around datetime.

David

Excuse me for the stupid question but does you try to execute the same query that returns 'None' outside the SFS(for example if you use MySQL with the client that goes with it or even better with JDBC). In simple words are you sure the problem is in SFS?

Also all fields look the same - why removing one of them will make this work? Can you give also the query you try to execute and row from the table as an example?

I'll see if I can get around to creating a more thorough example that can be replicated step by step sometime this week.

My knowledge level cannot quickly figure out how to run a test directly with the JDBC so I may need to lean more on your expertise for that test.

David