• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Laravel ORM with Arcturus' enum fields in database

Newbie Spellweaver
Joined
May 13, 2017
Messages
31
Reaction score
1
Has anyone had any issues with querying the Arcturus DB with most of the boolean fields if not all being set as enumerable instead of tinyint or similar? Is it safe to change these values to tinyint instead of enum?

I'm trying to create a Permission model so that I can manage user ranks via Eloquent but I just noticed that all of the permissions are set to enum, we previously had an issue counting online users because of that but switched to using a raw query instead.
 
Experienced Elementalist
Joined
Jul 14, 2012
Messages
244
Reaction score
147
I've been using Laravel for a while now, also using enums for most 0/1 stuff, but I honestly have no idea what you're talking about.

Enums are fine and should work properly.

Code:
$usersOnline = User::where('online', '=', '1')->count();
 
Upvote 0
Newbie Spellweaver
Joined
May 13, 2017
Messages
31
Reaction score
1
I've been using Laravel for a while now, also using enums for most 0/1 stuff, but I honestly have no idea what you're talking about.

Enums are fine and should work properly.

Code:
$usersOnline = User::where('online', '=', '1')->count();


yeah, idk, i tried it again today and it worked fine. i have no idea why we weren't getting the right results last time.
 
Upvote 0
Back
Top