6
Quote:
rowdie wrote:
You need to change the closesite config in the database. If you have PhpMyAdmin just go to the config table and change the value of "closesite" to 0.
If you need a sql query for it, try this:
UPDATE xoops_config SET conf_value=0 WHERE conf_name = 'closesite'
Change "xoops" to the prefix you use, if it's different.
I do have phpMyAdmin, and am trying to go about trying this, but when I try to run the query, I get this error:
"#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'xoops_config SET conf_value=0 WHERE conf_name = 'closesite'' at "
The prefix is the same, btw.
Could you be a little more specific as to how I can do this with phpMyAdmin? I am a total n00b to using it. I know the theory, but havn't really use it much. I am able to go to the xoops_config table, but all that it shows is a bunch of stuff like "conf_modid" and such. Am I missing something? Maybe I need to do it with a query, but the query you gave didn't work, so maybe I need to alter the query somehow?
This seems like such an easy fix, and I bet I'm gonna slap myself once I get it. Thanks for the help everyone.