Newly setup local server, cannot create accounts

TeoTwawki · Post by **TeoTwawki** » Sun Jul 19, 2015 2:49 pm

kjLotus wrote:
teotwawki wrote:Its entirely possible some people had the issue and never actually reported it too. The project gets that a lot...

If you poke me on IRC I can usually remote in to assist via either anydesk or teamviewer, both of which have no-install portable exe's if desired. I won't be around much till after the 23rd though.
everyone's server assigns NULL into the timestamp (because MySQL automatically replaces it with the current time)

Apparently the WAMP package version of MySQL he used didn't do that.

kjLotus · Post by **kjLotus** » Sun Jul 19, 2015 3:02 pm

teotwawki wrote:Apparently the WAMP package version of MySQL he used didn't do that.

I guess that's why we have the link to mysql in the setup guide :p

TeoTwawki · Post by **TeoTwawki** » Sun Jul 19, 2015 4:01 pm

kjLotus wrote:
teotwawki wrote:Apparently the WAMP package version of MySQL he used didn't do that.
I guess that's why we have the link to mysql in the setup guide :p

I just figured it was because we don't need apache and php so why would we even try that :p

Delaide · Post by **Delaide** » Sun Jul 19, 2015 10:56 pm

I use WAMP, and have no issues. Could be because I set it up originally with just mySQL, and later rolled my existing stuff to WAMP, but I don't think so. It should work with no issue with a standard WAMP setup...

theRonLewis · Post by **theRonLewis** » Mon Jul 20, 2015 9:12 am

I did go through the Oracle/MySQL portion of the guide, got to that point and saw I already had a ton of MySQL stuff from Oracle, and assumed I was good to go initially (that's what happens when you do initial setup at 3am I guess!). Either way, I went and double checked and the actual MySQL package that would run standalone still needed to be installed. Everything I already had was a mysql utility and not the actual service. Got that going, and rebuilt the database in there without issues. Now it's creating accounts and changing that NULL param to the right time. It did seem like there were other people online having issues with the NULL insert on timestamp column (solved by creating your own custom triggers or using CURRENT_TIMESTAMP in the insert), but it's probably version related. Now I'm running 5.6.25, with no need for wamp, and it's working fine.

Thanks for your help guys.

Delaide wrote:I use WAMP, and have no issues.

Maybe OS/version related? I'm on Win7 Home Premium 64-bit. Not that it matters much (now that I'm properly setup, and you have no issues), but are you running WAMP server 64? I guess if you run into issues in the future its good to know that wamp might be the culprit if its something sql related.

TeoTwawki · Post by **TeoTwawki** » Mon Jul 20, 2015 9:42 am

Could be because I set it up originally with just mySQL, and later rolled my existing stuff to WAMP,

Prolly the reason.

theRonLewis · Post by **theRonLewis** » Mon Jul 20, 2015 11:42 am

Ah yep, that makes sense.

Deprecated Darkstar fourms

Go to LandSandBoat

Newly setup local server, cannot create accounts

Re: Newly setup local server, cannot create accounts

Re: Newly setup local server, cannot create accounts

Re: Newly setup local server, cannot create accounts

Re: Newly setup local server, cannot create accounts

Re: Newly setup local server, cannot create accounts

Re: Newly setup local server, cannot create accounts

Re: Newly setup local server, cannot create accounts