vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Where have my forum modifications gone? (https://vborg.vbsupport.ru/showthread.php?t=270123)

Fergal C 09-12-2011 02:45 PM

Where have my forum modifications gone?
 
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 09-12-2011 03:04 PM

Did they add a disable line to config.php ?

HMBeaty 09-12-2011 03:08 PM

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 09-12-2011 03:24 PM

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 09-12-2011 03:38 PM

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 09-12-2011 04:28 PM

Quote:

Originally Posted by HMBeaty (Post 2244919)
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 09-12-2011 04:40 PM

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?
Code:

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 09-12-2011 05:00 PM

Thanks for the reply Lynne.

Quote:

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.

Quote:

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.

Quote:

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

Lynne 09-12-2011 05:03 PM

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 09-12-2011 05:31 PM

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?


All times are GMT. The time now is 07:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01125 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete