sigparsed Table missing

[judsonian]

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?

[judsonian]

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