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

Affiliates
Super Mario Bros. X | Kuribo64
Views: 5,949,843
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
04-24-19 02:10 PM
Guest: Register | Login

0 users currently in AcmlmBoard Developer Zone | 8 bots

Main - AcmlmBoard Developer Zone - displayname issue
Next newer thread | Next older thread


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

Level: 2


Posts: 1/2
EXP: 35
Next: 11

Since: 11-18-18

Last post: 138 days
Last view: 138 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.
Boing~

Level: 215


Posts: 19431/20010
EXP: 146251339
Next: 1859938

Since: 01-01-12
From: UK

Last post: 14 hours
Last view: 3 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: 35
Next: 11

Since: 11-18-18

Last post: 138 days
Last view: 138 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: 99


Posts: 3300/3325
EXP: 9910281
Next: 89719

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

Last post: 1 day
Last view: 36 min.
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
Banned

Goomba
See rosyilu
Level: 8


Posts: 21/30
EXP: 1755
Next: 432

Since: 12-31-18

Last post: 52 days
Last view: 52 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.
Boing~

Level: 215


Posts: 19699/20010
EXP: 146251339
Next: 1859938

Since: 01-01-12
From: UK

Last post: 14 hours
Last view: 3 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!

Emuz
Posted on 02-12-19 02:18 PM Link | ID: 146269
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 99


Posts: 3313/3325
EXP: 9910281
Next: 89719

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

Last post: 1 day
Last view: 36 min.
Assumptions.. make asses out of us.. but when they work we often rely on them.

We're in a code consolidation and improvement mode. The goal is to try to make it so it will run in PHP7. It should work as is but with the possible little hiccups here and there. ( Schezo did all his work on it in a PHP 7 install. He cleaned up a few of the big snags already. Epele has fixed many of the other issues with the warnings and errors this board is known for.)

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

rosyilu
Posted on 03-19-19 05:31 PM Link | ID: 146837
Banned

Goomba
See Jamie
Level: 6


Posts: 21/21
EXP: 640
Next: 267

Since: 03-11-19
From: United Kingdom

Last post: 35 days
Last view: 35 days
Forcing the MySQL mode to MYSQL40 with a hack will work.
Or don't use Oracle MySQL. Why support such a terrible company :P

Next newer thread | Next older thread
Main - AcmlmBoard Developer Zone - displayname issue


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

Page rendered in 0.063 seconds. (637KB of memory used)
MySQL - queries: 117, rows: 553/586, time: 0.030 seconds.