Advertisement:

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

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,234
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #20 on: January 03, 2018, 10:34:44 PM »
Not seeing anything that would involve a board color.  Can you attach your Subs-Boards.php?

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Re: How to upgrade the database?
« Reply #21 on: January 03, 2018, 10:37:48 PM »
This message after upgrading to 2.0.15

Field 'board_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 #22 on: January 03, 2018, 10:40:51 PM »
File Attached
Not sure why it uploaded it twice but they are the same file.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,234
Re: Re: How to upgrade the database?
« Reply #23 on: January 03, 2018, 10:40:57 PM »
You're running two threads on same problem, makes it difficult to assist you.  The database version has nothing to do with your problem, there have been no db changes in 2.0 branch.  Upgrading from .14 to .15 doesn't touch the db.

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #24 on: January 03, 2018, 10:48:17 PM »
I gave the error to the server host and they say- "If you can tell us what the default should be (or they give you specific syntax to add it) we should be able to do that for you."

No clue what the default should be or what syntax to add it?

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,234
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #25 on: January 03, 2018, 11:08:50 PM »
Looks like it may be from Board color and icons mod.  The mod code is not in your Subs-Boards.php, but it also adds board_color to ManageBoards.template.php and ManageBoards.php.  The mod must have been installed, then uninstalled, and it didn't uninstall cleanly.  You can parse the code at the mod link and remove remnant code manually.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,124
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #26 on: January 04, 2018, 05:01:56 AM »
You can parse the code at the mod link and remove remnant code manually.


the issue is in the database, not in files. if the mod is not in use the column board_color has to be removed from the boards table.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,419
  • Gender: Male
    • Kindred-999 on GitHub
Re: How to upgrade the database?
« Reply #27 on: January 04, 2018, 08:29:28 AM »
Your error is due to a mod.... in combination with your MySQL version.

You either need to assign a default value for that column (and others) or get a newer version of MySQL...   MySQL introduced this error for several versions, requiring workarounds in code before they finally fixed it.
« Last Edit: January 04, 2018, 09:41:58 AM by Kindred »
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,419
  • Gender: Male
    • Kindred-999 on GitHub
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #28 on: January 04, 2018, 08:31:06 AM »
 Why do you have two thread open with this question?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #29 on: January 04, 2018, 09:36:51 AM »
Why do you have two thread open with this question?

The other one was marked resolved to negate the two thread issue.  I commented on another person thread with a similar issue then it got separated somehow, I am assuming by admin. 

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #30 on: January 04, 2018, 09:39:20 AM »
Looks like it may be from Board color and icons mod.  The mod code is not in your Subs-Boards.php, but it also adds board_color to ManageBoards.template.php and ManageBoards.php.  The mod must have been installed, then uninstalled, and it didn't uninstall cleanly.  You can parse the code at the mod link and remove remnant code manually.

Considering I am on old sawmiller, I am not following the foreign language on how to fix this LOL.  Can you be so kind to give me a beginners version of what I need to do to fix this problem? 

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #31 on: January 04, 2018, 09:41:51 AM »
Looks like it may be from Board color and icons mod.  The mod code is not in your Subs-Boards.php, but it also adds board_color to ManageBoards.template.php and ManageBoards.php.  The mod must have been installed, then uninstalled, and it didn't uninstall cleanly.  You can parse the code at the mod link and remove remnant code manually.

Not finding a Board_color mod installed at anytime when looking in Package Manager? 

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,419
  • Gender: Male
    • Kindred-999 on GitHub
Re: How to upgrade the database?
« Reply #32 on: January 04, 2018, 09:42:12 AM »
Your error is due to a mod.... in combination with your MySQL version.

You either need to assign a default value for that column (and others) or get a newer version of MySQL...   MySQL introduced this error for several versions, requiring workarounds in code before they finally fixed it.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #33 on: January 04, 2018, 10:07:16 AM »
OK guys, Im really trying to learn how to fix this but now am not sure what instruction to follow?

Looks like it may be from Board color and icons mod.  The mod code is not in your Subs-Boards.php, but it also adds board_color to ManageBoards.template.php and ManageBoards.php.  The mod must have been installed, then uninstalled, and it didn't uninstall cleanly.  You can parse the code at the mod link and remove remnant code manually.


So when I find the parse code for my version 2.0.15 I look for the "find" code and just remove it, or do I then replace it with the suggested new code? 

For example, I found the code in the /Themes/default/BoardIndex.template.php -
                  <a class="subject" href="', $board['href'], '" name="b', $board['id'], '">', $board['name'], '</a>';
Instructions tell me to replace it with -
                                    <a class="subject" href="', $board['href'], '" name="b', $board['id'], '"', !empty($board['color']) ? ' style="color: ' . $board['color'] . ';">' : '>', $board['name'];
                  if (!empty($board['icon']))
                  echo ' <img src="',  $board['icon'], '" style="width: 18px; height: 18px;" alt="" />';
                  echo '</a>';

Although there are more to find and replace, is this the process to follow for this fix?  Remove, or Remove and Replace?

Additionally, how do I remove and install the new code?  I can view the code but not sure how to actually perform the edit? 

OR, is this the problem?
You either need to assign a default value for that column (and others) or get a newer version of MySQL...   MySQL introduced this error for several versions, requiring workarounds in code before they finally fixed it.

I am not what version of MysQl I have as when I selected it on the server it doesnt tell me what version it is.?

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #34 on: January 04, 2018, 10:10:40 AM »
Your error is due to a mod.... in combination with your MySQL version.

You either need to assign a default value for that column (and others) or get a newer version of MySQL...   MySQL introduced this error for several versions, requiring workarounds in code before they finally fixed it.
This is the info I Could find on MySqQL

MySQL Databases
Created by Documentation, last modified on Nov 30, 2017
For cPanel & WHM version 68
(cPanel >> Home >> Databases >> MySQL Databases)

How do I go about applying the fix you suggest?

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #35 on: January 04, 2018, 10:25:38 AM »
So what direction do I follow guys?

1. Sir Osis of Liver - Looks like it may be from Board color and icons mod.  The mod code is not in your Subs-Boards.php, but it also adds board_color to ManageBoards.template.php and ManageBoards.php.  The mod must have been installed, then uninstalled, and it didn't uninstall cleanly.  You can parse the code at the mod link and remove remnant code manually.

2. Illori - the issue is in the database, not in files. if the mod is not in use the column board_color has to be removed from the boards table.

3. Kindred - Your error is due to a mod.... in combination with your MySQL version.
You either need to assign a default value for that column (and others) or get a newer version of MySQL...   MySQL introduced this error for several versions, requiring workarounds in code before they finally fixed it.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,535
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #36 on: January 04, 2018, 10:45:34 AM »
It would seem to me that all those are just a little differently approaching the same problem. A mod install or uninstall gone wrong.
What mods do you have installed, and are you sure you haven't had the "Board color and icons mod" installed?
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline KEA

  • Jr. Member
  • **
  • Posts: 190
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #37 on: January 04, 2018, 11:06:16 AM »
It would seem to me that all those are just a little differently approaching the same problem. A mod install or uninstall gone wrong.
What mods do you have installed, and are you sure you haven't had the "Board color and icons mod" installed?

Mods installed was included earlier in the thread.  Have not found any Board color and icons mod installed?

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,124
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #38 on: January 04, 2018, 11:07:05 AM »
have you always been admin? if not possible someone in the past had installed the mod.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,234
Re: Error after 2.014 install - blocked from site - Error 500
« Reply #39 on: January 04, 2018, 04:00:39 PM »
You can parse the code at the mod link and remove remnant code manually.

the issue is in the database, not in files. if the mod is not in use the column board_color has to be removed from the boards table.

If the mod was completely removed, wouldn't the column be ignored?  It's not used by anything else, if the remnant code wasn't calling it, SMF shouldn't see board_color, and even if mysql sees it, field should have last value from before mod was uninstalled.

@KEA - Assuming there isn't another mod that adds board_color, you only have to remove the mod code from  ManageBoards.template.php and ManageBoards.php, it's already gone from Subs-Boards.php.