Advertisement:

Author Topic: Error after 2.014 install - blocked from site - Error 500  (Read 2281 times)

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,987
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #40 on: January 04, 2018, 04:20:35 PM »
no the column would not be ignored as it still has to be filled with something, hence the error that there is no default value to fill it with.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,216
    • StoryBB/StoryBB on GitHub
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #41 on: January 04, 2018, 04:22:24 PM »
It doesn't matter whether SMF sees it or not - the database does. And the database doesn't have a default value for it - and because SMF doesn't know about it, it can't supply one either.

Recommended solution: give MySQL a default value for the column:

Code: (fix the missing default) [Select]
ALTER TABLE smf_boards ALTER board_color SET DEFAULT '';
No amount of changing the code, short of reinstalling the mod or manually altering the query to add a value, is going to fix this.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,138
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #42 on: January 04, 2018, 04:27:07 PM »
If the mod had installed correctly, wouldn't it have left a default value after it was uninstalled?

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,987
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #43 on: January 04, 2018, 04:28:34 PM »
If the mod had installed correctly, wouldn't it have left a default value after it was uninstalled?


not if the mod never defined one to start with.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,138
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #44 on: January 04, 2018, 04:34:43 PM »
Why not just remove the column?

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,987
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #45 on: January 04, 2018, 04:37:41 PM »
it has been suggested already in this topic. that will work as well or to run the query arantor provided will fix it as well.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,138
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #46 on: January 04, 2018, 04:42:32 PM »
not if the mod never defined one to start with.

Would this be considered a bug in the mod?

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,987
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #47 on: January 04, 2018, 04:49:03 PM »
i dont think so, as it has been said in this topic it is mysql changes that are making this show up or not depending on version.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,138
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #48 on: January 04, 2018, 05:05:17 PM »
Ok, thanks.

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #49 on: January 04, 2018, 08:33:29 PM »
Server host tried this and still no fix:
"We could not add a default (the data type will not allow a default) so we just changed the column to not be required."

Tried to add a board and still get the same exact error message.
Field 'desc_color' doesn't have a default value
File: /home/kallen/public_html/Sources/Subs-Boards.php
Line: 790

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.11. The above error might possibly go away if you execute the latest version of upgrade.php.

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #50 on: January 04, 2018, 08:34:39 PM »
I have been the Admin for this site from day one and I can't find the mod in question ever getting installed?

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,138
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #51 on: January 04, 2018, 11:09:25 PM »
Doesn't matter, that field is not required by core code, just delete the column from the table (backup the db first).

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #52 on: January 05, 2018, 09:50:18 AM »
The server host sent this message.  Problem fixed.

"The two _color columns where defined as text data type. The problem is that text data types can't have defaults, so the only option was to change it to be not required."

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,216
    • StoryBB/StoryBB on GitHub
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #53 on: January 05, 2018, 09:53:38 AM »
Well,they could also have made it a varchar(100) field and given it a default, that would have worked too... but there's no way they could have known that.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.