Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 06-23-2005, 06:50 PM
[Stryder] [Stryder] is offline
 
Join Date: Dec 2004
Location: Detroit, Michigan
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Removing Column In Fields

]Ok, what i was installing told me to do this:

Quote:
Run this SQL query on your database. Don't forget to add a prefix to table's name if you use one in your config.php:

ALTER TABLE `forum` ADD `hide_hack` INT(1) DEFAULT '0' NOT NULL;

I did that than began to recieve this message when going to edit forums.

Code:
Database error in vBulletin 3.0.7:
Invalid SQL: UPDATE jelsoft_forum SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Site News & Announcements',
description = 'All updates and news regarding Thrash City will be posted here.',
link = '',
displayorder = '2',
daysprune = '-1',
parentid = '1',
newpostemail = '',
newthreademail = '',
styleid = '0',
password = '',
hide_hack = '0',
uttpoints_perthread = '1',
uttpoints_perreply = '1',
uttpoints_perview = '1',
options = '89799',
parentlist = '3,1,-1'
WHERE forumid=3
mysql error: Unknown column 'hide_hack' in 'field list'
mysql error number: 1054
Date: Thursday 23rd of June 2005 12:20:50 PM
Script: ********************
Referer: ***************
Username: Stryder
IP Address: **********
Now i don't know how to fix it, but need it to be fix in order to use the forum.
Reply With Quote
  #2  
Old 06-23-2005, 06:59 PM
calorie calorie is offline
 
Join Date: May 2003
Posts: 2,804
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That error says that the hide_hack column is not in the forum table, so you'd need to run that query you posted to add the hide_hack column to the forum table.
Reply With Quote
  #3  
Old 06-23-2005, 07:13 PM
[Stryder] [Stryder] is offline
 
Join Date: Dec 2004
Location: Detroit, Michigan
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

could you please explain that in more detail if possible, i didn't fully understand that..
Reply With Quote
  #4  
Old 06-24-2005, 01:29 AM
calorie calorie is offline
 
Join Date: May 2003
Posts: 2,804
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You said that you ran the query but the error says that you did not.
Reply With Quote
  #5  
Old 06-24-2005, 06:41 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To get better support i suggest you post your problem in teh thread about that hack, and not in the general section.
Reply With Quote
  #6  
Old 06-24-2005, 08:16 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looking again at this, you should have been getting an error on that first query, unless you have installed 2 Boards into the same database, 1 using a prefix and the other not using a prefix.

You can run the following query to fix your problem:
[sql]ALTER TABLE `jelsoft_forum` ADD `hide_hack` INT(1) DEFAULT '0' NOT NULL; [/sql]
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:14 AM.


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.04019 seconds
  • Memory Usage 2,195KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete