Core3 icon indicating copy to clipboard operation
Core3 copied to clipboard

session_id broken?

Open neozeed opened this issue 2 years ago • 1 comments

SO I setup a fun test server, and it bombed out with this:

REPLACE INTO sessions (account_id, session_id, ip, expires) VALUES (1, 'b9d621584366c80978056fabdeaba2cd6e4994bc6d94ee63d30ce3f0ed5936a9', '172.31.192.1' , ADDTIME(NOW(), '00:15'));

Looking at the table definition session_id its set to an int, but the data is a string... Is it a bug?

neozeed avatar Dec 06 '22 01:12 neozeed

I also noticed a bunch of tables have various TIMESTAMP NOT NULL, fields, but the program doesn't insert the time, rather I'm guessing it's expecting a "timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP" Or maybe Im loading the wrong sql?

neozeed avatar Dec 06 '22 14:12 neozeed