Zone Flags

[Pirate123]

now when a new account is being created its saying

Error in createaccount query 'insert into account set name ='purcell2009', status=0, lsaccounts_id=152328;' #1364: field 'suspendeduntil' doesnt have a default value.

World_clientlist_ERR] error adding local account for LS login: 'pucell2009', diplicate name?

world_client_err] NOCLE: bad/expired session key '152328

i reverted to a backup db before i used the source to add in suspendeduntil and i was able to log in with new accounts just fine, but as soon i sourced in the .sql for suspendeduntil and it added that column to the account table it wouldnt allow any new accounts to be made.

[Derision]

Originally Posted by Pirate123

now when a new account is being created its saying

Error in createaccount query 'insert into account set name ='purcell2009', status=0, lsaccounts_id=152328;' #1364: field 'suspendeduntil' doesnt have a default value.

I think this is because you have MySQL running in 'strict' mode. (Not sure if the install guide still tells you to uncheck the strict mode box when installing MySQL on Windows).

I've updated utils/sql/svn/1195_account_suspendeduntil.sql to include a DEFAULT value for the suspendeduntil column, or you could do:

 ALTER TABLE `account` CHANGE `suspendeduntil` `suspendeduntil` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ;

[Pirate123]

Thanks man, that works now. Still having trouble with setting zone flags tho. still get zone.exe crashes when trying to zone into that zone with no flag.

[ghostriderdoom]

Originally Posted by Pirate123

Still having trouble with setting zone flags tho. still get zone.exe crashes when trying to zone into that zone with no flag.

Im getting the same exact problem, Tranq crashes when u try to zone any unflagged toon into any PoP zone. I looked on the forum for over 2 hours for any answers, any help greatly appreciated.

Originally Posted by joligario

Windows servers had a problem with setting zone flags. Use key checks and globals instead. There should be some posts about it somewhere.

Can't find anything on this at all......