Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard | IRC: #abdev
Chatting Places
IRC: #kafuka | Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 5,885,642
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Calendar | Stats | Ranks | Online users | Search
01-24-19 07:27 AM
Guest: Register | Login

0 users currently in AcmlmBoard Developer Zone | 1 guest

Main - AcmlmBoard Developer Zone - displayname issue
Next older thread


yoshi
Posted on 11-18-18 06:39 PM Link | ID: 144155
Newcomer

Level: 2


Posts: 1/2
EXP: 23
Next: 23

Since: 11-18-18

Last post: 48 days
Last view: 48 days
now, i don't know if this is the right forum to post this thread on, but if it isn't, please move it.

i've set up a instance of acmlmboard 2 on my server and i did import the main.sql file into the database + some other optional files successfully.

so i tried to register my account but i had this error after i registered:


Registration failed: Field 'displayname' doesn't have a default value


i do not know what is causing this. i tried to google for the error but no result. it gave me some results about sql being in strict mode or something but i am not sure if that's the reason why it's giving me this error.

any tips or help will be greatly appreciated.

Epele
Posted on 11-19-18 01:25 AM Link | ID: 144177
Acmlmistrator
The Sorceress.
OwO

Level: 212


Posts: 19431/19707
EXP: 140504331
Next: 531224

Since: 01-01-12
From: UK

Last post: 5 hours
Last view: 5 hours
I've done some testing. Yes, the issue is the sql engine being in strict mode.

Due to the structure of the how the database is, a lot of work would be needed to get it up and running on a strict mode db as strict mode requires every single field to have a non-blank default value or the code specify it as a not-null blank data value. As such, any part of the board which does a sql insertion would need to be modified to ensure full compatibility.

If you have the ability to modify the sql mode on your server, the following sql query can be used to turn off strict mode. Exercise Caution though.
set global sql_mode='NO_ENGINE_SUBSTITUTION'



The world could always use more heroes!

yoshi
Posted on 12-06-18 04:31 PM Link | ID: 144930
Newcomer

Level: 2


Posts: 2/2
EXP: 23
Next: 23

Since: 11-18-18

Last post: 48 days
Last view: 48 days
ok so i switched to a non-sql strict mode host
and i was able to succesfully install acmlmboard 2 and register my account
however i can't log in for some reason

Emuz
Posted on 01-11-19 01:43 PM Link | ID: 145688
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 98


Posts: 3300/3304
EXP: 9649264
Next: 5089

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 6 days
Last view: 5 hours
The most common reason is ckey isn't properly defined in the configuration. The default value is invalid to require you to enter your own. Make sure that you change this:
$config['ckey'] = "Change this key!"; // Must be exactly 16, 24 or 32 characters, otherwise logging in won't work


to a letter-number string that is 32 chars. (as said in the comment 16 or 24 also work but it's best to use 32).

Also make sure you are running PHP 5.6 as well.

The Dynamic Profile Administratorâ„¢


"Never Knows Best"
Note: if you can see this my layout broke. ALL THE CREDITS WILL BE REVEALED!!
'Victory Noriko' by @thatsheepagain.
'Chibi Dance Noriko' by @Haru__Kitsu.
'Deity's Night Out (Featuring Gabbie)'
by @thatsheepagain
Noriko Emotes by @Haru__Kitsu.
Side Bar Noriko by @thatsheepagain
'Noriko's Nature Walk' by @projectTiGER_
Emotive Noriko by @thatsheepagain.
"Space Candy Noriko" by BerryVerrine.
"Super Sharp Noriko" by Xionfes.
A gift illustration from the wonderful EverKinzPony!
"Magical Girl Noriko" by @cute_hospital!
"Patient Chibi Noriko" by @Ruii_ki!
'Dapper '60s Noriko' by @thatsheepagain.
'Shiny Chibi Noriko' by @inioli.
'Flower Veil Noriko' by @Sushiee_.
'Noriko in Realism' by @_Sarybuu.
'Noriko's Midnight Adventure' by @projectTiGER_
'Yukata Noriko' by @yunyunmaru_
'Birthday Wishes Noriko' by @thatsheepagain

Iris
Posted on 01-20-19 09:56 AM Link | ID: 145836

Goomba

Level: 6


Posts: 21/23
EXP: 538
Next: 369

Since: 12-31-18

Last post: 3 days
Last view: 3 days
PHP 5.6 is EOL'd since late last year, could anything be done to improve support with PHP 7 (like using PDO)?

Epele
Posted on 01-20-19 08:02 PM Link | ID: 145854
Acmlmistrator
The Sorceress.
OwO

Level: 212


Posts: 19699/19707
EXP: 140504331
Next: 531224

Since: 01-01-12
From: UK

Last post: 5 hours
Last view: 5 hours
PHP 5.6 is the minimum, not the requirement.

One of the main, current, goals is to clean up the sheer amount of notices that the board code spits out. That alone should help later versions out, as a lot of code relied on assumption-based-coding.. which, somehow worked?


The world could always use more heroes!

Next older thread
Main - AcmlmBoard Developer Zone - displayname issue


Acmlmboard v2.5.4 (01/20/2019)
© 2005-2019 Acmlm, Emuz, et al.

Page rendered in 0.052 seconds. (619KB of memory used)
MySQL - queries: 86, rows: 490/524, time: 0.024 seconds.