Invision Power Board issues

[flarf]

I run a forum using Invision Power Board v1.2 that was installed via CPanel.

A few days ago, an odd thing happened. I noticed that every page such as a post or reply page was miles long. Long enough to make the bottom scroll bar in a browser really tiny. Along with this, the page locks up the browser for about 10 seconds and the CPU goes to 100 during this time.

I've tried installing a new instance of IPB in a different directory and then using a copy of the existing database, but it seems the version installed via CPanel is different. With this configuration (new IPB, old DB) I can still browse posts etc, but am unable to login with any usernames. When I do so, I get the following error:

mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.sub_end, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=1

mySQL error: Unknown column 'm.sub_end' in 'field list'
mySQL error code:
Date: Thursday 09th of September 2004 06:37:13 PM

I'm at my wits end. It's a semi-popular forum I run for my class in college with plenty of regular users. I'm posting this with the hopes that someone has encountered this problem before and can help me out.

I've tried posting at the IPB forums but was unable to. I'm assuming they don't offer free support.

Thanks in advance.

[-Oz-]

It seems like the tables are either gone or corrupted (or something upgraded the flat files but not the db). I don't use ipb or any cpanel installs so i'm not 100% sure, but definitely make sure you haven't changed your mysql user/pass or deleted/modified any tables.

[Klaassh]

To use your old database with a newer version you will first have to run the upgrade script. These are in the tools & Scripts directory contained in your downloaded IPB zip file. They modify your database to handle whatever has changed in the newer version.
Something else to try might be to run the error checking and optimization on your database. These are available through your IPB admin panel under MySQL tools, and also in PHPMyAdmin.

[flarf]

To use your old database with a newer version you will first have to run the upgrade script. These are in the tools & Scripts directory contained in your downloaded IPB zip file. They modify your database to handle whatever has changed in the newer version.
Something else to try might be to run the error checking and optimization on your database. These are available through your IPB admin panel under MySQL tools, and also in PHPMyAdmin.

Any idea where I can find the upgrade script? As I said, this version of IPB was installed by CPanel and I can't find the tools and scripts directory..

Ran the error checking and optimization with no luck.

[Klaassh]

Download the zip from here

[flarf]

Sweet zombie jesus, Klaassh. You saved the day! upgrade6.php was exactly what I was looking for.

Thanks!