Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard
Chatting Places
Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 8,954,772
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
03-29-24 02:35 PM
Guest: Register | Login

0 users currently in AcmlmBoard Developer Zone | 3 bots

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


yoshi
Posted on 11-18-18 06:39 PM, in Link | ID: 144155
Normal User
Newcomer

Level: 3


Posts: 1/2
EXP: 125
Next: 3

Since: 11-18-18

Last post: 1939 days
Last view: 1939 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, in Link | ID: 144177
Site Administrator
The Sorceress.
Boing~

Level: 235


Posts: 19431/20774
EXP: 200201631
Next: 1724261

Since: 01-01-12
From: UK

Last post: 814 days
Last view: 1 hour
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, in Link | ID: 144930
Normal User
Newcomer

Level: 3


Posts: 2/2
EXP: 125
Next: 3

Since: 11-18-18

Last post: 1939 days
Last view: 1939 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, in Link | ID: 145688
Site Administrator

11 Hit Combo:
Mother's Rosario
Level: 108


Posts: 3300/3392
EXP: 13212113
Next: 308386

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

Last post: 116 days
Last view: 1 day
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, in Link | ID: 145836
Banned

Goomba
See rosyilu
Level: 12


Posts: 21/30
EXP: 7190
Next: 731

Since: 12-31-18

Last post: 1853 days
Last view: 1853 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, in Link | ID: 145854
Site Administrator
The Sorceress.
Boing~

Level: 235


Posts: 19699/20774
EXP: 200201631
Next: 1724261

Since: 01-01-12
From: UK

Last post: 814 days
Last view: 1 hour
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, in Link | ID: 146269
Site Administrator

11 Hit Combo:
Mother's Rosario
Level: 108


Posts: 3313/3392
EXP: 13212113
Next: 308386

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

Last post: 116 days
Last view: 1 day
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, in Link | ID: 146837
Banned

Goomba
See Jamie
Level: 10


Posts: 21/21
EXP: 4133
Next: 281

Since: 03-11-19
From: United Kingdom

Last post: 1836 days
Last view: 1836 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.5 (10/04/2020)
© 2005-2024 Acmlm, Emuz, et al.

Page rendered in 0.078 seconds. (803KB of memory used)
MySQL - queries: 115, rows: 554/586, time: 0.060 seconds.