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?

Digital Jedi 09-12-2011 10:10 PM

Generally hosts provide a phpMyAdmin installation so you can look through your databases. What did you use to create one during your initial installation, or did your host do it for you? They should also have a way to look at your access logs, like in cPanel. Who are you with? Maybe we can offer suggestions if we know who your host is and what tools they offer.

Fergal C 09-13-2011 05:45 AM

Thanks Digital Jedi, the forum is hosted on a VPS with Servint.net. I'll look at the suggestions you offer and see how far I can get with it.

HMBeaty 09-13-2011 06:14 AM

Quote:

Originally Posted by HostBidder.com (Post 2245164)
Thanks Digital Jedi, the forum is hosted on a VPS with Servint.net. I'll look at the suggestions you offer and see how far I can get with it.

I'm with the same hosting company, go to your cPanel and scroll down to the Database section and click on phpmyadmin to access your database

Boofo 09-13-2011 01:27 PM

ServInt? I *think* I have heard of them. ;)

Hang in there. The CS guys are great! They should be able to get you up and going soon.

Fergal C 09-13-2011 06:21 PM

Quote:

Originally Posted by HMBeaty (Post 2245175)
I'm with the same hosting company, go to your cPanel and scroll down to the Database section and click on phpmyadmin to access your database

Thanks HMBeaty, I'm currently working on improving my IT knowledge by learning some PHP and will hopefully soon move on to MySQL. I have had a look at phpmyadmin but unfortunately due to my lack of knowledge I don't really know what I'm looking at and I don't want to damage anything by playing around in there.

Quote:

Originally Posted by Boofo (Post 2245328)
ServInt? I *think* I have heard of them. ;)

Hang in there. The CS guys are great! They should be able to get you up and going soon.

Thanks Boofo, they are currently dealing with the issue and they have been very supportive up to now. Do you have an association with Servint?

Boofo 09-13-2011 06:34 PM

Quote:

Originally Posted by HostBidder.com (Post 2245486)
Thanks Boofo, they are currently dealing with the issue and they have been very supportive up to now. Do you have an association with Servint?

I have been with them for a while now. I have referred quite a few people to them, including the illustrious HMBeaty. ;)

Digital Jedi 09-13-2011 07:56 PM

Quote:

Originally Posted by HostBidder.com (Post 2245486)
Thanks HMBeaty, I'm currently working on improving my IT knowledge by learning some PHP and will hopefully soon move on to MySQL. I have had a look at phpmyadmin but unfortunately due to my lack of knowledge I don't really know what I'm looking at and I don't want to damage anything by playing around in there.

Basically all you have to do is scroll through your table names, find the one called forum (usually prefixed with vb_ or whatever you chose upon installation), look at it and see if one of the columns has the name lastpost. Right now your just looking to see if what should be there is still there.


All times are GMT. The time now is 05:49 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.01143 seconds
  • Memory Usage 1,759KB
  • 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
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (17)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete