Advertisement:

Author Topic: Board color and icons  (Read 19544 times)

Offline KEA

  • Jr. Member
  • **
  • Posts: 187
Re: Board color and icons
« Reply #40 on: January 04, 2018, 09:49:20 AM »
Getting This message after upgrading to 2.0.15 and cant add any categories to the forum because of it.

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 SaltedWeb

  • Sr. Member
  • ****
  • Posts: 854
  • Gender: Male
  • The Tired One
Re: Board color and icons
« Reply #41 on: January 05, 2018, 10:37:21 PM »
Not sure if it works for everyone but tested on a board.
This mod seems compatible with 2.0.15
http://custom.simplemachines.org/mods/index.php?mod=3023
and I had these mods tested ok for me.
1.   Board-color-and-icons 1.1   
2.   Moderator and Administrator Comment Tags 1.9   
3.   SimplePortal 2.3.7   
4.   Post Anonymously In Topic   2.7   
5.   Quick Ban on Account Delete 1.0.1   
6.   Ultimate Menu 1.0   
7.   Ohara YouTube Embed 1.2.9

Knowing your limitations makes you human, exceeding these limitations makes you worthy of being human.

Offline pepa

  • Jr. Member
  • **
  • Posts: 183
Re: Board color and icons
« Reply #42 on: February 11, 2018, 03:57:51 AM »
Getting This message after upgrading to 2.0.15 and cant add any categories to the forum because of it.

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.

Yes, similar problem here.  I only used this for the colour feature, not icons and it worked well.  However, I just recently need to create a new category and got the error message you mentioned.  Not sure if it's related to 2.0.15 upgrade, I didn't try to create a new category with this mod installed when I was on 2.0.14.

My error message is attached.

Offline pepa

  • Jr. Member
  • **
  • Posts: 183
Re: Board color and icons
« Reply #43 on: February 11, 2018, 05:35:41 AM »
This has just become worse.  I uninstalled the mod. Now I can create a new Category but can no longer create a new board.  I get this error message:

"Field 'img_name' doesn't have a default value
File: /home/psychol1/reformaps.net.au/forum/Sources/Subs-Boards.php
Line: 785

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.14. The above error might possibly go away if you execute the latest version of upgrade.php."

What do I do now .. any ideas?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 56,075
  • Gender: Male
    • Kindred-999 on GitHub
Re: Board color and icons
« Reply #44 on: February 11, 2018, 08:04:43 AM »
You either have to set a default value for those columns, delete the columns or Have your host upgrade MySQL...   this is actually an issue in several MySQL versions..
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 pepa

  • Jr. Member
  • **
  • Posts: 183
Re: Board color and icons
« Reply #45 on: February 11, 2018, 08:14:29 AM »
You either have to set a default value for those columns, delete the columns or Have your host upgrade MySQL...   this is actually an issue in several MySQL versions..

Hmmm, thanks for the advice, I can't seem to find those columns in PhpMyAdmin?

Offline pepa

  • Jr. Member
  • **
  • Posts: 183
Re: Board color and icons
« Reply #46 on: February 11, 2018, 08:41:08 AM »
You either have to set a default value for those columns, delete the columns or Have your host upgrade MySQL...   this is actually an issue in several MySQL versions..

Hmmm, thanks for the advice, I can't seem to find those columns in PhpMyAdmin?

OK, found it, dropped it and now the error message is:

"Unknown column 'b.color' in 'field list'
File: /home/psychol1/reformaps.net.au/forum/Sources/Subs-Boards.php
Line: 1064

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.14. The above error might possibly go away if you execute the latest version of upgrade.php."

What's the procedure now?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 56,075
  • Gender: Male
    • Kindred-999 on GitHub
Re: Board color and icons
« Reply #47 on: February 11, 2018, 08:45:19 AM »
Looks like the mod did not get fully uninstalled.

You will have to manually remove any leftover code
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 pepa

  • Jr. Member
  • **
  • Posts: 183
Re: Board color and icons
« Reply #48 on: February 11, 2018, 09:00:57 AM »
Looks like the mod did not get fully uninstalled.

You will have to manually remove any leftover code

How would I do that?  Haven't coded around for around 10 years.

Offline Rock Lee

  • SMF Hero
  • ******
  • Posts: 1,540
  • Gender: Male
  • Digitalizando un nuevo mundo :D
    • BomberCode.Oficial on Facebook
    • RockLee-BC on GitHub
    • @Bomber_Code on Twitter
    • Bomber Code ~ La nueva era del conocimiento
Re: Board color and icons
« Reply #49 on: February 12, 2018, 04:08:31 PM »
I'm using Zone99 theme and it doesn't work with me any help please?

And making the modification manually does not work either? I remember that theme gives certain problems with many mods.


Regards!
¡Regresando como cual Fenix! ~ Bomber Code © 2018
Ayudas - Aportes - Tutoriales - Y mucho mas!!!

Offline srafie

  • Newbie
  • *
  • Posts: 3
Re: Board color and icons
« Reply #50 on: Today at 02:04:15 AM »
Alright, do you need help fixing anything on this with your current forum?

When I finished doing some of my things I need to do, I will update this mod and have it parse for other themes.
I also wanna allow you to change the position of the icon, before or after the board text. On my old forums, I did actually have the icon before which I think looks better.

example!
hxxp:www.uniquez-home.com [nonactive]

Its old and being redesigning.

Please, how to change icons position before the board text mannually, before you update the mod to do it in the admin panel ?

Thnks

Offline Rock Lee

  • SMF Hero
  • ******
  • Posts: 1,540
  • Gender: Male
  • Digitalizando un nuevo mundo :D
    • BomberCode.Oficial on Facebook
    • RockLee-BC on GitHub
    • @Bomber_Code on Twitter
    • Bomber Code ~ La nueva era del conocimiento
Re: Board color and icons
« Reply #51 on: Today at 08:58:53 AM »
Ah read Manual Installation of Mods? ... I use a dzinerstudio theme and it is possible to adapt it (search for comments and locate it where you should go).


Regards!
¡Regresando como cual Fenix! ~ Bomber Code © 2018
Ayudas - Aportes - Tutoriales - Y mucho mas!!!