upgrade database

[Omebolle]

When trying to add a board to the forum, I get this message:
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.9. The above error might possibly go away if you execute the latest version of upgrade.php.
I cannot figure out how to do that

[Bigguy]

This may help.

Upgrading SMF

EDIT: Is this in the wrong board. ??

[Omebolle]

Why doesn't the database automatically upgrade along with the installed version? I have 2.0.15 installed, database stayed back at 2.0.9?

I saw that page, but I'm not an expert and hesitated to just paste files into a working forum (except for the database it seems).

Ah, I see, wrong board

[Doug Heffernan]

Well, they say that there are not any database changes and therefore running the upgrader is not needed. But the question is why the error message says otherwise. If I were you I would either run the upgrader anyway, or change the smf version manually in the smf_settings to reflect that of the files. i.e. 2.0.15.

[Omebolle]

the smf version manually in the smf_settings to reflect that of the files. i.e. 2.0.15

No idea where to do that, sorry.

[SychO]

Check your error log, past all of the error message

[Omebolle]

This?    
Reverse chronological order of list Today at 01:27:42 PM
Apply Filter: Only show the error messages of this session d848b8ec01af5307213e3b950512d00c
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URL
http://xxx.xxx.php?action=admin;area=manageboards;sa=board2
Apply Filter: Only show the errors with the same message
Database Error: Field 'passwd' doesn't have a default value
Apply Filter: Only show the errors from this file
File: /customers/1/f/5/xxx.xxx/Sources/Subs-Boards.php
Line: 778

[SychO]

Are you using or used some kind of board password mod ?

You need to go into the database using phpMyAdmin and then to the smf_boards table and then you need to give the "passwd" column a default value, or you can delete the column if you're no longer using the mod (be careful though)

[Omebolle]

Not sure what a password board is, didn't install a mod like that.
But now I see it in the files of the forum, not in the package manager.

[Omebolle]

btw that error log has more than 330.000 errors logged... Should I delete?

[SychO]

You need to go into the database using phpMyAdmin and then to the smf_boards table and then you need to give the "passwd" column a default value, or you can delete the column if you're no longer using the mod (be careful though)

^

[Doug Heffernan]

btw that error log has more than 330.000 errors logged... Should I delete?

If you are not using that mod anymore, then you can delete that field altogether from the smf_boards table.

[Omebolle]

You need to go into the database using phpMyAdmin and then to the smf_boards table and then you need to give the "passwd" column a default value, or you can delete the column if you're no longer using the mod (be careful though)

I'm a rookie, not even sure what you mean here, "you need to go into the database using phpMyAdmin"
How?

[SychO]

Well you should be able to access it from your cpanel,

You can also ask your host to disable mysql strict mode

[Sir Osis of Liver]

Did you put html in any of your board names or descriptions?

[Omebolle]

html... don't think so...

Is this the passwordboard you mentioned? where do I change that "default value"
As I said, this is all new to me
I just contacted the host and asked to disable the mysql strict mode

[Illori]

it is in the database not in the files. you would need to get into your database. if you don't know how ask your host if they can help you out.

[Kindred]

first... the "database version" error message is a red herring and is incorrect. Ignore it.

second... the ACTUAL issue is (as pointed out) with a mod that you have installed -- whether it's in the package manager or not, that mod WAS installed and the database column was added.

So, you have two choices.
If you are CERTAIN that the mod has been uninstalled, then you can remove the database column "passwd" from the smf_boards table.

If not, you can go into phpmyadmin (it's a function of the host, usually in the hosting cpanel which allows you to view and edit the database)
and give the "passwd" column a default value of NULL.

[Omebolle]

As I said before, I'm just an amateur when it comes to this kind of stuff. I never installed a password board mod.
It isn't in my "package manager"
Tried to find what you suggested through my CP, and this is what I could find, this is what you meant? Can't find a passwd column

below that is a mention of my SQL server only being active since yesterday? No idea what that means, the forum has been running for several years now

[Kindred]

well then... what are lines 770-780 of Subs-Boards.php



File: /customers/1/f/5/xxx.xxx/Sources/Subs-Boards.php
Line: 778