{"id":4781,"date":"2010-01-01T13:14:11","date_gmt":"2010-01-01T19:14:11","guid":{"rendered":"http:\/\/www.conradaskland.com\/blog\/?p=4781"},"modified":"2010-01-01T13:16:16","modified_gmt":"2010-01-01T19:16:16","slug":"vbulletin-create-search-table","status":"publish","type":"post","link":"https:\/\/conradaskland.com\/blog\/vbulletin-create-search-table\/","title":{"rendered":"VBulletin Create Search Table"},"content":{"rendered":"

This took me quite a while to find. Here is the query to use in MySql to create the search table in VBulletin. To find the code to create other tables in VBulletin database go to your VB upload files to: install\/mysql-schema.php<\/p>\n

This was in response to an INVALID SQL error in VB 4.0 where “domainname” is the name of your website url:
\nMySQL Error \u00a0 : Table ‘domainname.search’ doesn’t exist
\nError Number \u00a0: 1146<\/p>\n

<\/p>\n

You may also visit this thread at VBulletin.com:<\/p>\n

http:\/\/www.vbulletin.com\/forum\/showthread.php?318389-Search-function-problem&highlight=CREATE+TABLE+search<\/a><\/p>\n

Here is the code to create the search table:<\/p>\n

CREATE\u00a0TABLE\u00a0search\u00a0(
\nsearchid INT UNSIGNED NOT NULL AUTO_INCREMENT,
\nuserid INT UNSIGNED NOT NULL DEFAULT ‘0’,
\nipaddress CHAR(15) NOT NULL DEFAULT ”,
\npersonal SMALLINT UNSIGNED NOT NULL DEFAULT ‘0’,
\nquery VARCHAR(200) NOT NULL DEFAULT ”,
\nsearchuser VARCHAR(200) NOT NULL DEFAULT ”,
\nforumchoice MEDIUMTEXT,
\nprefixchoice MEDIUMTEXT,
\nsortby VARCHAR(200) NOT NULL DEFAULT ”,
\nsortorder VARCHAR(4) NOT NULL DEFAULT ”,
\nsearchtime float NOT NULL DEFAULT ‘0’,
\nshowposts SMALLINT UNSIGNED NOT NULL DEFAULT ‘0’,
\norderedids MEDIUMTEXT,
\nannounceids MEDIUMTEXT,
\ndateline INT UNSIGNED NOT NULL DEFAULT ‘0’,
\nsearchterms MEDIUMTEXT,
\ndisplayterms MEDIUMTEXT,
\nsearchhash VARCHAR(32) NOT NULL DEFAULT ”,
\ntitleonly SMALLINT UNSIGNED NOT NULL DEFAULT ‘0’,
\ncompleted SMALLINT UNSIGNED NOT NULL DEFAULT ‘1’,
\nPRIMARY KEY (searchid),
\nUNIQUE KEY searchunique (searchhash, sortby, sortorder)
\n);<\/p>\n","protected":false},"excerpt":{"rendered":"

This took me quite a while to find. Here is the query to use in MySql to create the search table in VBulletin. To find the code to create other tables in VBulletin database go to your VB upload files to: install\/mysql-schema.php This was in response to an INVALID SQL error in VB 4.0 where […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[6],"tags":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3C0LX-1f7","_links":{"self":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/4781"}],"collection":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/comments?post=4781"}],"version-history":[{"count":3,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/4781\/revisions"}],"predecessor-version":[{"id":4783,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/4781\/revisions\/4783"}],"wp:attachment":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/media?parent=4781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/categories?post=4781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/tags?post=4781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}