Board color and icons

[KEA]

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.

[SaltedWeb]

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

[pepa]

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.

[pepa]

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?

[Kindred]

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..

[pepa]

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?

[pepa]

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?

[Kindred]

Looks like the mod did not get fully uninstalled.

You will have to manually remove any leftover code

[pepa]

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.

[-Rock Lee-]

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!

[srafie]

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!
http://www.uniquez-home.com [nofollow]

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

[-Rock Lee-]

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!

[srafie]

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!

Any more tips or links please? i didn't find anythink about dzinerstudio, but i think "oOo--STAR--oOo" has the right way to do that if he reads this

[-Rock Lee-]

Any more tips or links please? i didn't find anythink about dzinerstudio, but i think "oOo--STAR--oOo" has the right way to do that if he reads this

I do not have any link since I was deducting everything by using a theme by the same author and going through several that with many modifications gave me errors ... it is a matter of putting a hand and adapting it!


Regards!

[mcdconcepts]

I'm using SMF 2.1.4. Theme Curve2 with MOD Curve2 Color Changer.

When I try to modify my boards, it only has the option to upload icons, nothing for changing the board colours.
Does this mean it won't work with Theme and MOD?
Thanks
Chris