Page 1 of 1
creating sql table phpbb_search_wordlist
Posted: Mon Sep 20, 2004 2:48 pm
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
ok i managed to insert the new table, but now i get this error
Code: Select all
Could not insert new word
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
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
http://www.phpbb.com/phpBB/viewtopic.ph ... rch#226805
Posted: Mon Sep 20, 2004 3:39 pm
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.
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