Announcement

Collapse
No announcement yet.

accidentally deleted announcements table, help!

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

  • 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!

  • #2
    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

    Comment


    • #3
      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

      Comment


      • #4
        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)
        )

        Comment


        • #5
          Thanks very very much, problems taken care of!

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X