|
||||||
|
Views:
11,030,243 |
   
Main
| FAQ
| IRC chat
| Memberlist
| Active users
| Latest posts
| Stats
| Ranks
| Online users
| Search
|
11-21-24 08:43 AM |
||||
| Guest: Register | Login | ||||||
| 0 users currently in AcmlmBoard Developer Zone | 1 bot |
| Main - AcmlmBoard Developer Zone - displayname issue |
| yoshi |
| ||
|
Normal User
Newcomer Level: 4    
Posts: 1/2 EXP: 132 Next: 147 Since: 11-18-18 Last post: 2176 days Last view: 2176 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:
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 |
| ||
|
Site Administrator
The Sorceress. Boing~ Level: 237
Posts: 19431/20774 EXP: 205434305 Next: 2544629 Since: 01-01-12 From: UK Last post: 1051 days Last view: 8 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.
The world could always use more heroes! |
| yoshi |
| ||
|
Normal User
Newcomer Level: 4
Posts: 2/2 EXP: 132 Next: 147 Since: 11-18-18 Last post: 2176 days Last view: 2176 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 |
| ||
Site Administrator
 11 Hit Combo: Mother's Rosario Level: 109
Posts: 3300/3393 EXP: 13563275 Next: 396370 Since: 12-30-11 From: Akron, Ohio; USA Last post: 113 days Last view: 3 days |
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:
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 |
| ||
Banned
 Goomba See rosyilu Level: 12
Posts: 21/30 EXP: 7622 Next: 299 Since: 12-31-18 Last post: 2090 days Last view: 2090 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 |
| ||
|
Site Administrator
The Sorceress. Boing~ Level: 237
Posts: 19699/20774 EXP: 205434305 Next: 2544629 Since: 01-01-12 From: UK Last post: 1051 days Last view: 8 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 |
| ||
|
Site Administrator
11 Hit Combo: Mother's Rosario Level: 109
Posts: 3313/3393 EXP: 13563275 Next: 396370 Since: 12-30-11 From: Akron, Ohio; USA Last post: 113 days Last view: 3 days |
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 |
| ||
|
Banned
Goomba See Jamie Level: 10
Posts: 21/21 EXP: 4391 Next: 23 Since: 03-11-19 From: United Kingdom Last post: 2073 days Last view: 2072 days |
Forcing the MySQL mode to MYSQL40 with a hack will work.
Or don't use Oracle MySQL. Why support such a terrible company  |
| Main - AcmlmBoard Developer Zone - displayname issue |
 Acmlmboard v2.5.6 (06/11/2024) © 2005-2024 Acmlm, Emuz, et al. |
|
MySQL - queries: 111, rows: 549/582, time: 0.047 seconds. |
