Page 1 of 1

creating sql table phpbb_search_wordlist

Posted: Mon Sep 20, 2004 2:48 pm
by tOnk3r
i accidently dropped the sql table for phpbb_search_wordlist and now when i go to post i get the error

SQL Error : 1146 Table 'mx1_db.phpbb_search_wordlist' doesn't exist



When i try to go into phpmyadmin to create the table phpbb_search_wordlist i get an error saying the synax is wrong

could someone give me a step by step of creating a table please.

Posted: Mon Sep 20, 2004 3:05 pm
by tOnk3r
ok i managed to insert the new table, but now i get this error

Code: Select all

Could not insert new word

DEBUG MODE

SQL Error : 1054 Unknown column 'word_text' in 'field list'

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('post', 0), ('subject', 0)

Line : 234
File : /home/www/mx1.thefreebizhost.com/forum/includes/functions_search.php

Posted: Mon Sep 20, 2004 3:13 pm
by primedomain
how did you create the missing table? Did you use the respective query from /install/schemas/mysql_schema.sql?

You might also want to take a look at:
http://www.phpbb.com/phpBB/viewtopic.ph ... tables+mod
or
http://www.phpbb.com/phpBB/viewtopic.ph ... rch#226805

Posted: Mon Sep 20, 2004 3:39 pm
by tOnk3r
to create the table i went to phpmyadmin and clicked structure.
when it lists all of the tables there is some text saying
"Create new table on database mx1_db :"
and 2 box's to enter info.
Name :
fields :

as the name i entered "phpbb_search_wordlist" and as the "fields" value i entered 1.

it creates the table and gives the new error. i dont think i created the new table correctly.

i think i may of bolloxed it for good :(

i only done it cos i have limeted space for sql and the search function took up nearly all of it