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

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

Post by blue9a » Tue Sep 25, 2018 3:53 am

hmm i tried everything based on what you posted yet im getting nowhere maybe i cant do it on windows 10 any other ideas
Attachments
Screenshot (38).png
Screenshot (37).png
Screenshot (36).png
Screenshot (35).png

User avatar
TeoTwawki
Developer
Posts: 527
Joined: Mon Jul 15, 2013 9:50 pm

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

Post by TeoTwawki » Sun Sep 30, 2018 5:50 pm

Probably on the newer mysql that by default does not ALLOW a default time of all zero's.

Strict mode affects whether the server permits '0000-00-00' as a valid date: If strict mode is not enabled, '0000-00-00' is permitted and inserts produce no warning. If strict mode is enabled, '0000-00-00' is not permitted and inserts produce an error, unless IGNORE is given as well. For INSERT IGNORE and UPDATE IGNORE, '0000-00-00' is permitted and inserts produce a warning.

tl;dr we still need to do away with those defaults and have the core code just use "now" for these timestamps/datestamps instead. Meanwhile, you can try

Code: Select all

`timecreate` datetime NOT NULL DEFAULT NOW(),
`timelastmodify` timestamp NOT NULL DEFAULT NOW(),
or disabling strict mode (see mysql reference manual on their website)
Hi, I run The Demiurge server.


Image
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. - Martin Golding
PLS USE [ code ] CODE TAGS [ /code ] WHEN POSTING CODE
DO NOT PRIVATE MESSAGE ME ABOUT BUGS

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 » Tue Oct 09, 2018 1:21 pm

Ok alfer so many trial and error to get the server setup i finally got it to work :) now how do i get the auction house to work because when i try to bid its greyed out

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 » Tue Oct 09, 2018 1:37 pm

Search server handles auction house browsing
-- 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 » Wed Oct 10, 2018 11:23 pm

so im guessing this is normal if it is how does everyone else make it so that when they visit their auction house they can bid on anything for 1 gil
Attachments
Untitled1.jpg

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 » Thu Oct 11, 2018 8:13 am

You have to load the auction house, by default there is nothing on it (no one's put anything up for sale yet!)
There are some 3rd party tools on the forums that will do it (there is a python script that will even scrape ffxiah.com and load items based on prices there).

Or you can roll your own
-- Whasf


Post Reply