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]

I tried that too, but I still get an error adding this: 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';

 

[Arty]

Sorry, I've messed up. Forgot to add "ADD" for last 2 fields. Correct query:

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

 

[Divinum Fiat]

it's not workings somehow, now it says it's a duplicate.

 

[borbole]

That means that that field already exists.

You should also rebuild the forums after you run the query.

 

[Divinum Fiat]

how do I do that, Borbole?

 

[borbole]

how do I do that, Borbole?

You can do that by going to your Admin Panel->Tools->Rebuild Caches and run this option: Rebuild Forum Information.

 

[Arty]

Strange. I don't see discussion_count field in screenshot. Oh well, just remove that field from sql query to add other 2:

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

 

[Divinum Fiat]

tried that but still getting this error. How does this even happen?

 

[Divinum Fiat]

Strange. I don't see discussion_count field in screenshot. Oh well, just remove that field from sql query to add other 2:

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

Still getting a duplicate entry.

 

[borbole]

tried that but still getting this error. How does this even happen?
View attachment 34273

Now it looks like you are missing the node_id field. This is not good at all.

 

[Divinum Fiat]

 

[Arty]

Now it looks like you are missing the node_id field. This is not good at all.

Indeed. And it exists on screenshot! That doesn't make any sense.

 

[Divinum Fiat]

 

[borbole]

Indeed. And it exists on screenshot! That doesn't make any sense.

Yes, I agree. It is very weird.

 

[borbole]

Update. The issue has been solved. After taking a look at the table I saw that the node_id was present in the table in spite of being reported as missing at the error screenshot. However another field was missing which was not shown in the error log. A very strange issue. But the most important thing is that the issue has been dealt with and Blueprint4Love 's forum is back up and running again.

 

[Divinum Fiat]

Wow, Borbole, you never cease to amaze me. You've come to my rescue several times since my life with XF. Can't thank you enough! Totally trust you with my login info, always have, cause you're just a great guy.

Arty, you've been wonderful too! Thank you for your giving and caring!

 

[borbole]

You are very welcome. Happy to have been of help