View Single Post
  #342  
Old 07-09-2008, 05:48 PM
J98680Bxxxxx J98680Bxxxxx is offline
 
Join Date: Jan 2008
Location: Bridge - Enterprise
Posts: 325
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TsirhCitna View Post
Just upgraded to 1.3:

Code:
Database error in vBulletin 3.7.2:

Invalid SQL:
DELETE FROM postparsed WHERE `postid` = '386649';

MySQL Error   : Table 'tenstone_vbforum2.postparsed' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, July 9th 2008 @ 08:51:59 AM
Error Date    : Wednesday, July 9th 2008 @ 08:51:59 AM
Script        : http://www.tenstones.net/forums/admincp/nominate_topic_admin.php?do=refreshpollthread
Referrer      : http://www.tenstones.net/forums/admincp/index.php?do=nav
IP Address    : 70.61.229.27
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.45-log
Quote:
Originally Posted by crkgb View Post
Updated to 1.3. Thank you for the great mod once again.

Deleted the old Poll-topic and changed the settings to the current month to be displayed.

tried to do "Refresh Poll Thread" and got the following.

Running the cron did not help either.

No Nomination topic at the moment. Any ideas?
Check your database (using PhPMyAdmin from your site CPanel) and see if you have a table entry called "post_parsed" instead of "postparsed"

1. If you have a table entry called "post_parsed"
Open the file "admin/nominate_topic_admin.php" and scroll down to the bottom of the file.
Replace:
Code:
	$vbulletin->db->query_write("DELETE FROM postparsed WHERE `postid` = '$nominationthread_postid'");
by:
Code:
	$vbulletin->db->query_write("DELETE FROM post_parsed WHERE `postid` = '$nominationthread_postid'");
2. If you don't have a table entry called "post_parsed" do the following:

Open the file "admin/nominate_topic_admin.php". Scroll down to the bottom of the file and replace:
Code:
	$vbulletin->db->query_write("DELETE FROM postparsed WHERE `postid` = '$nominationthread_postid'");
by:
Code:
	$vbulletin->db->hide_errors();
	$vbulletin->db->query_write("DELETE FROM postparsed WHERE `postid` = '$nominationthread_postid'");
	$vbulletin->db->show_errors();
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01162 seconds
  • Memory Usage 1,776KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete