Deprecated Darkstar fourms

hmm i tried everything based on what you posted yet im getting nowhere maybe i cant do it on windows 10 any other ideas

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 or disabling strict mode (see mysql reference manual on their website)

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

Search server handles auction house browsing

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

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

oh ok