dsconnect_server account create issues in windows 10 also auction house files missing please help

[blue9a]

Hi everyone i have a problem when i created my private server i started up the dsconnect and dsgame servers they loaded fine but the trouble starts when i try to make a account i get a error saying this:

[22/Sep 21:31][1;32m[Status][0m The login-server-auth is [1;32mready[0m (Server is listening on the port 54231).

[22/Sep 21:31][1;32m[Status][0m The login-server-lobbydata is [1;32mready[0m (Server is listening on the port 54230).

[22/Sep 21:31][1;32m[Status][0m The login-server-lobbyview is [1;32mready[0m (Server is listening on the port 54001).

[22/Sep 21:31][1;32m[Status][0m The login-server is [1;32mready[0m to work...
[22/Sep 21:31][1;32m[Status][0m Console input thread is ready..

[22/Sep 21:33][1;33m[Warning][0m login_parse: unexisting user[1;37m<B142>[0m tried to connect
[22/Sep 21:33][1;37m[Info][0m [1;37mlogin_parse[0m:[1;37m127.0.0.1[0mshutdown socket...
[22/Sep 21:33][1;35m[SQL][0m DB error - Column 'timelastmodify' cannot be null
SQL: INSERT INTO accounts(id,login,password,timecreate,timelastmodify,status,priv) VALUES(1000,'B142',PASSWORD('5590'),'2018:09:22 21:33:16',NULL,1,1);
[22/Sep 21:33][1;37m[Info][0m [1;37mlogin_parse[0m:[1;37m127.0.0.1[0mshutdown socket...
[22/Sep 21:33][1;37m[Info][0m [1;37mlogin_parse[0m:[1;37m127.0.0.1[0mshutdown socket...

im not sure why maybe it doesnt work on windows 10 i guess btw i am using windower 4 to login also im missing the auction house files to.

if anyone knows how to solve this issue you have my thanks.

[whasf]

what backend database software are you running? (MySQL or MariaDB)
Re-run the accounts.sql file (re-import it into your database)

[blue9a]

I use mysql for my databases i do have mariadb installed but its on standby the server program is wampserver 3.1.3

[blue9a]

ok so after using the bat file it created the database yet i still cant create accounts i dont know what to do at this point

[whasf]

Something is wrong with your accounts table!
What does yours look like? (See my screenshot below)

[blue9a]

heres mine

[whasf]

Open accounts.sql in notepad, copy contents, paste it into "Query" tab in HeidiSQL, then press F9
Click back on the Table:Accounts tab and you should see stuff in the Default column


Then try to login and create an account again

[blue9a]

ok hopefully i did it right this time btw i noticed that expansions and features were checked for unassigned so i removed them hopefully i can create accounts also i left a 3rd screenshot idk if that was the part that i had to add but yeah...

[blue9a]

hmm even after that i still cant make any accounts

[jono659]

Ok, 1st redownload Darkstar source and recompile. Dont modify the database. I think this will cure the problem and you can keep your existing chars.

If you still get the error then your DB is corrupt and you will need to either manually fix or re-create the accounts
manual fix...
make sure timelastmodify column exists and default is 0000-00-00 00:00:00

Re-Create table...
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE IF NOT EXISTS `accounts` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`login` varchar(16) NOT NULL DEFAULT '',
`password` varchar(64) NOT NULL DEFAULT '',
`email` varchar(64) NOT NULL DEFAULT '',
`email2` varchar(64) NOT NULL DEFAULT '',
`timecreate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`timelastmodify` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`content_ids` tinyint(2) unsigned NOT NULL DEFAULT '16',
`expansions` smallint(4) UNSIGNED NOT NULL DEFAULT '4094',
`features` tinyint(2) UNSIGNED NOT NULL DEFAULT '13',
`status` tinyint(3) unsigned NOT NULL DEFAULT '1',
`priv` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;