I installed the FAQ plugin (not FAQman) and everything looked like it was working. I tried to go to the site tonight and I get this error:
Warning: require_once(../lib-common.php) [function.require-once]: failed to open stream: No such file or directory in /home/content/p/h/i/phillibe/html/geeklog/public_html/index.php on line 39
Fatal error: require_once() [function.require]: Failed opening required '../lib-common.php' (include_path='.:/usr/local/php5/lib/php' in /home/content/p/h/i/phillibe/html/geeklog/public_html/index.php on line 39
I found it looking for lib-common.php in the wrong directory, so I resolved that by putting lib-common.php in the correct directory. After doing so, I get a SQL error. The error was:
Tue 22 Jan 2008 20:31:34 MST - 1146: Table 'res0801910054219.gl_faq_categories' doesn't exist. SQL in question: SELECT * FROM gl_faq_categories ORDER BY name
MySQL showed the database table as gl_faq_category, so I renamed it to categories per what it was reporting. Now I get this error:
Tue 22 Jan 2008 20:41:44 MST - 1054: Unknown column 'name' in 'order clause'. SQL in question: SELECT * FROM gl_faq_categories ORDER BY name
I can't figure out where this is coming from. Unfortunately, I don't know much about SQL and I'm not sure how to back out the plugin or correct the SQL error. Any suggestions?
You shouldn't have moved lib-common.php. Does the rest of your site work? I'm guessing you copied the public_html files into public_html and not a directory until public_html (named faq). If you did that, that would be messy.