Undefined index: last_post_username (?)

[Divinum Fiat]

In a bit of a panic. Logged off and logged back on to find this server error when clicking on the forum tab. All other tabs work fine:
Server Error

Undefined index: last_post_username

http://www.corefreedom.com/forum/

Any ideas?

 

[Divinum Fiat]

Got a screenshot of the server error log. Any ideas anyone?

 

[Arty]

Try running this query in phpMyAdmin:

repair table xf_forum;

 

[Divinum Fiat]

Thank you Arty, but I have no idea what you're saying.

 

[Arty]

You most likely have cPanel or similar control panel for your website. Usually such control panels include phpMyAdmin tool, it is an excellent tool to administrate your databases. Find it, open it in browser.

On left side select database where your forum tables are located. On right side it will show you list of tables. Click "SQL" tab on right side, paste that query, click "Go" button.

 

[borbole]

Running a repair of the table it will not help because this is not a crashed table case. That being said, from the error message you posted it looks like you have a missing field in the forum table (last_post_username). Can you go to the phpmyadmin, select the db that your forum is installed at and check the structure for the forum table and see if the field in question is in there or is indeed missing. Hope it helps.

 

[Arty]

Its not just one field. If you'll look at screenshot, field find_new is also missing. Most likely other fields are missing too.

 

[borbole]

Indeed, I noticed a message about the find_new field too after taking a closer look.

 

[Divinum Fiat]

Thank you, I would never have found that. I did as you suggested but it didn't work. See screen shot.

 

[borbole]

Thank you, I would never have found that. I did as you suggested but it didn't work. See screen shot.

Try to view the structure of the forum table and post here a screenshot of it.

 

[Arty]

Select xf_forum table on left, click Structure tab (if it will not be selected automatically) on right and post screenshot please.

edit: a little bit too late

 

[Divinum Fiat]

did I do this right?

 

[Arty]

Wrong table
Click xf_forum on left side, not xf_link_forum

 

[Divinum Fiat]

didn't even see that, sorry 'bout that. This screenshot is too big, has way too many lines...

 

[borbole]

didn't even see that, sorry 'bout that. This screenshot is too big, has way too many lines...

View attachment 34265

Yes, it is the right table but click the Structure button.

 

[Divinum Fiat]

I promise I'm not blonde...

 

[Arty]

3 fields are missing: discussion_count, last_post_username and find_new.

Run this query (click "SQL" tab on right, paste code, click "Go"):

ALTER TABLE xf_forum ADD discussion_count INT UNSIGNED NOT NULL DEFAULT 0, last_post_username VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Username of most recently-posting user', find_new TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Include posts from this forum when running /find-new/threads';

 

[borbole]

I promise I'm not blonde... View attachment 34266

lol

It looks like you have several fields missing Blueprint4Love. You can try to re-add them manually or if you have a recent backup then restore that. But this means that you will loose all the users, posts, threads and all the other stuff that were acquired from the time of the back up until now.

 

[Divinum Fiat]

Oh no, Borbole, I don't have a backup. How does this even happen. Logged on this morning, logged off for 30 minutes and when I logged back in it was 'gone.'

Tried running the inquiry, Arty, but not sure I did it right. When I click on SQL there is a first line already type in. I tried running your query with that line in tact and get an error, I tried removing that first line and adding what you said and it gives me an error too.

 

[borbole]

Oh no, Borbole, I don't have a backup. How does this even happen. Logged on this morning, logged off for 30 minutes and when I logged back in it was 'gone.'

Tried running the inquiry, Arty, but not sure I did it right. When I click on SQL there is a first line already type in. I tried running your query with that line in tact and get an error, I tried removing that first line and adding what you said and it gives me an error too.
View attachment 34268

You should remove that first line from your sql box, that starts with SELECT *....

When you click the sql button to run the query, that box should be empty. There should be no other code in there besides the query that you will run.