Here is the old layout: http://web.archive.org/web/20080118150607/www.minibb.net/forums/12_4177_0.html. I'm not sure if that was easier to read and if clutter was less..

You're right. We could keep both versions and just provide an instruction of how to set up this and that. I'll think about it :-)

I recently completed an upgrade from 2.0 to 2.4a and overall things are fine. However I'm still having one small issue: on the main forums page, at the bottom in the list of "Recent Topics," the "Latest Reply" column shows a date and time but not the poster, just a "-". I know there's a new "topic_last_poster" field in the minibb_topics table but it is empty for all posts. Now, if a user posts a reply after the upgrade their username will show up in this field, but for any topics which haven't been replied to since the upgrade there is no name showing. Is there a solution for this problem available?

Thanks
Mark

Run Database upgrading tool. It will update new fields with their values.

Thanks. I had uploaded it and untared, but for whatever reason hadn't actually run it. Good to go now.

My side also Collation set to latin1_swedish_ci, how can I change them to utf8_unicode_ci? is there any command for doing that?

Search in Google for that term and you'll find tons of solutions.
You'll need to export/import the whole database for that, it's the most simple way.

Thanks for that. (I forgot to login by my user ID).

Changing the collation for all tables in a MySQL database

Just need to use the following PHP script for changing the collation for all tables at a time:

Make sure to substitute in the above script:

- DB_Name with your database name;

- DB_USER with your mysql username;

- User_Pass with your password for the mysql user;

- utf8-general_ci with your new collation if different;

Ok, if the solution might be just about running one query, I suppose it's about that:

and you can run it straight as the mySQL query, without any script :)

Thanks for that though.

Hello,

When I want to update sql history can't do that with sql command because I get this error whenever I try to do that:



Any Idea how to update history?

Regards,

You need to execute queries from !UPDATE_DB.sql following your current version number. You don't have to execute queries which are not for your version, as they may be applied already. It means you need to do a selection of queries, not to execute them blindly all at once. In your case, it seems you have a miniBB version higher than 1.x. This command is only for miniBB 1.x.

Following down the queries file, you will discover, that there are commands for 2.0 RC3, 2.0 RC5, 2.0.3 and 2.1. Comparing with your version, you need to execute only those queries which are necessary.

Thank you!

I did it from: #2.0 RC3 to #2.0.3 (it worked).

How about this one: convdb.php

Which one should I choose? My Old version is: 2.5
There is 3 Options:

1.7 series (this will update number of topics, posts, user messages number, topic latest post time)
2.0 RC2b and earlier 2.0 beta series (this will update number of user messages and topic latest post time)
2.0.x stable (this will update topic's latest poster username)

Thanks :)

You don't have to run it for this version. Not each miniBB version needs database updates.

Actually I'm not sure why you are not following the updating guide. It contains very precise instructions on each version's change. You should carefully follow such instructions, from top to bottom, collecting information about updated files and mySQL updates for your current version. For example, if you have version 2.5, you don't have to apply anything from the instruction, which is *above* this version .

How do I preserve certain files if I have to upgrade minibb in the future ?

I am starting to change certain template files and will change the stylesheet also...

How do I make changes to files and then preserve the changes during/after future upgrades ?

Templates and CSS stylesheet usually are not included in miniBB upgrades. Each version we release, has an updating history in update.txt file; if there's something mandatory to update in templates, we always mention it for the certain version. So you just need to apply miniBB's changes to your own templates, and NOT overwrite your templates with default ones and then restore your own customized changes.

The same about CSS file, which is upgraded truly rarely in the recent times.