Where have my forum modifications gone?

[Fergal C]

Unfortunately my VB4 forum had some downtime over the weekend. I submitted a support ticket at VB.com and they got it back up by re-running the upgrade script. It appears that the forum went down because the templates suddenly disappeared from the database.

Now that the forum is up again, none of our forum mods are working. The mods still appear to be installed and active in ACP > Plugins & Products > Manage Products. However, they are not actually working on the forum.

How can I get the mods working again? Do I need to un-install and re-install them?

Thanks!

[Paul M]

Did they add a disable line to config.php ?

[HMBeaty]

Find and remove this line from your includes/config.php file

PHP Code:

define('DISABLE_HOOKS', true); 


I'm assuming they forgot to remove that line when they were finished, but that sounds like what the problem is

[Fergal C]

Thanks Paul and HMBeaty,

That line was in the config file but was commented out with "//".

Anyway I removed it and that seems to have brought the forum down again. http://www.businessadviceforum.com is currently showing a DB error on the home page. I've updated the support ticket at VB.com and hope that they can fix it soon.

[HMBeaty]

Then that means you have a faulty modification. Disable your modifications one by one until the error goes away and you should find out which modification is causing the problem

[Fergal C]

Originally Posted by HMBeaty

Then that means you have a faulty modification. Disable your modifications one by one until the error goes away and you should find out which modification is causing the problem

Thanks for the suggestion HMBeaty, I've disabled every modification on the forum, but unfortunately the DB error remains.

[Lynne]

That error is saying you are missing the field lastpost in your forum table. Do you see that field there? That field should not just suddenly go missing. What caused your initial downtime over the weekend? And do you have a database backup from before this problem?

Database error in vBulletin 4.1.5:  Invalid SQL:                  SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,                     user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible                                      FROM forum AS forum                                  LEFT JOIN user AS user ON (user.userid = forum.lastposterid)                 LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0);  
MySQL Error   : Unknown column 'forum.lastpost' in 'field list'

[Fergal C]

Thanks for the reply Lynne.

That error is saying you are missing the field lastpost in your forum table. Do you see that field there?

How would I check that, sorry but I would not know where to start with that.

That field should not just suddenly go missing. What caused your initial downtime over the weekend?

Unfortunately I wasn't able to figure that out, neither was Zachery, who fixed the ticket over at VB.com.

And do you have a database backup from before this problem?

Yes I do.

[Lynne]

Use phpMyadmin or whatever you normally use to look at your database. Take a look at your table "forum" and see if you see a field there called "lastpost".

Fields do not just disappear like that. When you site went down, did you contact your host? Did you look through you access_logs to see if anything fishy was going on?

[Fergal C]

Lynne, sorry but I'm not technical enough yet to look at databases.

I contacted my host and asked them to look at the logs and they also cannot figure out why the site went down.

Where can I view access-logs?