Announcement

Collapse
No announcement yet.

sigparsed Table missing

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

  • sigparsed Table missing

    I submitted a ticket Re: [SID-1412336-42ba33aa] Problem creating signature - vBulletin and receive this possible solution.


    And do you have a table named sigparsed in your database (you should)? I would suggest running repair/optimize on the table and see if it then works.

    I DO NOT have the sigparsed table and the repair/optimize did not fix the issue. Any additional ideas?

  • #2
    Support had to log in and create that table for me .. Just so you know ...

    they said this sql query was the solution

    run it on the DB

    CREATE TABLE sigparsed (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    languageid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    signatureparsed MEDIUMTEXT,
    hasimages SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (userid, styleid, languageid)
    ) ENGINE = InnoDB

    Comment

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