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

blue9a
Posts: 10
Joined: Sun Sep 23, 2018 3:06 pm

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

Post by blue9a » Sun Sep 23, 2018 3:22 pm

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.
Attachments
search-server.log
(870 Bytes) Downloaded 250 times
map-server.log
(10.2 KiB) Downloaded 259 times
login-server.log
(19.03 KiB) Downloaded 247 times

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

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

Post by whasf » Sun Sep 23, 2018 5:32 pm

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

blue9a
Posts: 10
Joined: Sun Sep 23, 2018 3:06 pm

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

Post by blue9a » Sun Sep 23, 2018 6:25 pm

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

blue9a
Posts: 10
Joined: Sun Sep 23, 2018 3:06 pm

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

Post by blue9a » Sun Sep 23, 2018 11:50 pm

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
Attachments
Screenshot (27).png

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

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

Post by whasf » Mon Sep 24, 2018 8:09 am

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

blue9a
Posts: 10
Joined: Sun Sep 23, 2018 3:06 pm

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

Post by blue9a » Mon Sep 24, 2018 5:09 pm

heres mine
Attachments
Screenshot (28).png

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

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

Post by whasf » Mon Sep 24, 2018 6:36 pm

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
-- Whasf

blue9a
Posts: 10
Joined: Sun Sep 23, 2018 3:06 pm

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

Post by blue9a » Mon Sep 24, 2018 9:45 pm

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...
Attachments
Screenshot (32).png
Screenshot (31).png
Screenshot (29).png

blue9a
Posts: 10
Joined: Sun Sep 23, 2018 3:06 pm

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

Post by blue9a » Mon Sep 24, 2018 10:13 pm

hmm even after that i still cant make any accounts
Attachments
Screenshot (33).png

jono659
Posts: 59
Joined: Sat Mar 24, 2018 1:01 pm

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

Post by jono659 » Tue Sep 25, 2018 1:05 am

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;
Last edited by jono659 on Tue Sep 25, 2018 8:16 am, edited 1 time in total.

Post Reply