Announcement

Collapse
No announcement yet.

accidentally deleted announcements table, help!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • t0ecutter
    replied
    Thanks very very much, problems taken care of!

    Leave a comment:


  • Michael König
    replied
    Ah

    Run this Query as well:
    Code:
    CREATE TABLE attachment (
       attachmentid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
       userid int(10) unsigned DEFAULT '0' NOT NULL,
       dateline int(10) unsigned DEFAULT '0' NOT NULL,
       filename varchar(100) NOT NULL,
       filedata mediumtext NOT NULL,
       visible smallint(5) unsigned DEFAULT '0' NOT NULL,
       counter smallint(5) unsigned DEFAULT '0' NOT NULL,
       PRIMARY KEY (attachmentid)
    )

    Leave a comment:


  • t0ecutter
    replied
    Thanks a ton, it created successfully, however the same error message is coming up. This is the full text of the error:

    Code:
    Database error in vBulletin 2.2.6:
    
    Invalid SQL: 
    SELECT
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    
    FROM post
    
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    WHERE post.postid IN (0,375352,375359,375360,375372,375406,375521,375631,375689,375730,385030,385246,385328,385337,385495,385535)
    ORDER BY dateline 
    
    mysql error: Table 'hpiracin_rcforum.attachment' doesn't exist
    
    mysql error number: 1146
    
    Date: Monday 24th of June 2002 01:19:24 PM
    Script: http://www.hpiracing.com/rcforum/rcf...threadid=38795
    Referer: http://www.hpiracing.com/rcforum/for...p?s=&forumid=7

    Leave a comment:


  • Michael König
    replied
    Execute this Query with phpMyAdmin:
    Code:
    CREATE TABLE announcement (
       announcementid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
       title varchar(250) NOT NULL,
       userid int(10) unsigned DEFAULT '0' NOT NULL,
       startdate int(10) unsigned DEFAULT '0' NOT NULL,
       enddate int(10) unsigned DEFAULT '0' NOT NULL,
       pagetext mediumtext NOT NULL,
       forumid smallint(6) DEFAULT '0' NOT NULL,
       PRIMARY KEY (announcementid),
       KEY (forumid)
    )
    Mystics

    Leave a comment:


  • t0ecutter
    started a topic accidentally deleted announcements table, help!

    accidentally deleted announcements table, help!

    Location:
    Posts: 33
    repair.php script brings up admin login screen
    URL of your forums: http://www.hpiracing.com/rcforum/index.php

    PHP version 4.0.6

    MySQL version 3.23.45

    Apache/webserver version: 1.3.20

    Server operating system: Linux

    Any error message you are getting: none

    Whether or not you have edited any files*: no hacked files, some templates modified but they've been going for months with no problems

    -------------------------------------

    While deleting the .attachments table from our forum, I accidentally dropped the announcements table also, can someone please tell me how to add a new (blank) table so the forum can run properly? When we try to view a thread or forum I get error #1149, which has something to do with the announcements table apparently. Can be corrected with a simple upload again of the 2.2.6 files?

    Any help would be appreciated!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X