Announcement

Collapse
No announcement yet.

me again - this time a more scary error

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

  • me again - this time a more scary error

    On trying to submit new posts, I get the dreaded white screen of doom telling me there's been an error and an email has been dispatched. here's what the email says:

    Database error in vBulletin: Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1010,155,0)
    mysql error: Unknown column 'intitle' in 'field list'
    mysql error number: 1054
    Date: Monday 28th of May 2001 03:58:40 PM
    Script: /newreply.php
    Referer: http://www.kdpublish.com/newreply.ph...ly&threadid=85

    It's funny though sometimes if i refresh the page the post will go through. that's only happened once though.

    TIA,
    J

    KALLISTI - currently
    under extreme construction

    www.kdpublish.com

  • #2
    When you were upgrading did you run upgrade4.php?

    Comment


    • #3
      i thought i did

      should i re-run it?

      KALLISTI - currently
      under extreme construction

      www.kdpublish.com

      Comment


      • #4
        Well if you think you did, no.

        You can just run this query to fix the problem:
        ALTER TABLE searchindex ADD intitle smallint(5) unsigned DEFAULT '0' NOT NULL;

        It is not required, but I would *highly* recommend you empty your searchindex table BEFORE running that query:
        DELETE FROM searchindex;

        You'll then want to re-index your board.

        Comment


        • #5
          MOST excellent

          that worked like a charm

          you *are* a good man, Charlie Brown!

          KALLISTI - currently
          under extreme construction

          www.kdpublish.com

          Comment

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