Permalinks mess

Thanks, Skippy. I typed in your code and came up with this message from SQL:
#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 ‘-options SET option_value = ‘ ‘ WHERE option_name = ‘permalink_

I must have put in too many spaces or something else incorrect. This is what my line looks like:
UPDATE wp-options SET option_value = ‘ ‘ WHERE option_name = ‘permalink_structure’ LIMIT 1

Can you see what I might have done wrong? Thanks, again.

Thanks again! After the correction I was able to get to the permalinks page in WP-Admin, but when I tried to view my site again I got the 404 again. I deleted the .htaccess file, but it came back as soon as I accessed the permalinks page. I hesitate to include the code in the file because it’s so long, but here it is:

RewriteEngine On
RewriteBase /monk/
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^.*$ – [S=43]
RewriteRule ^(personal-profile)/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?pagename=$1&feed=$2 [QSA,L]
RewriteRule ^(personal-profile)/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?pagename=$1&feed=$2 [QSA,L]
RewriteRule ^(personal-profile)/page/?([0-9]{1,})/?$ /monk/index.php?pagename=$1&paged=$2 [QSA,L]
RewriteRule ^(personal-profile)(/[0-9]+)?/?$ /monk/index.php?pagename=$1&page=$2 [QSA,L]
RewriteRule ^(personal-profile)/trackback/?$ /monk/index.php?pagename=$1&tb=1 [QSA,L]
RewriteRule ^(contact-me)/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?pagename=$1&feed=$2 [QSA,L]
RewriteRule ^(contact-me)/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?pagename=$1&feed=$2 [QSA,L]
RewriteRule ^(contact-me)/page/?([0-9]{1,})/?$ /monk/index.php?pagename=$1&paged=$2 [QSA,L]
RewriteRule ^(contact-me)(/[0-9]+)?/?$ /monk/index.php?pagename=$1&page=$2 [QSA,L]
RewriteRule ^(contact-me)/trackback/?$ /monk/index.php?pagename=$1&tb=1 [QSA,L]
RewriteRule ^feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?&feed=$1 [QSA,L]
RewriteRule ^(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?&feed=$1 [QSA,L]
RewriteRule ^page/?([0-9]{1,})/?$ /monk/index.php?&paged=$1 [QSA,L]
RewriteRule ^comments/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?&feed=$1&withcomments=1 [QSA,L]
RewriteRule ^comments/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?&feed=$1&withcomments=1 [QSA,L]
RewriteRule ^comments/page/?([0-9]{1,})/?$ /monk/index.php?&paged=$1 [QSA,L]
RewriteRule ^search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?s=$1&feed=$2 [QSA,L]
RewriteRule ^search/(.+)/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?s=$1&feed=$2 [QSA,L]
RewriteRule ^search/(.+)/page/?([0-9]{1,})/?$ /monk/index.php?s=$1&paged=$2 [QSA,L]
RewriteRule ^search/(.+)/?$ /monk/index.php?s=$1 [QSA,L]
RewriteRule ^category/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?category_name=$1&feed=$2 [QSA,L]
RewriteRule ^category/(.+)/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?category_name=$1&feed=$2 [QSA,L]
RewriteRule ^category/(.+)/page/?([0-9]{1,})/?$ /monk/index.php?category_name=$1&paged=$2 [QSA,L]
RewriteRule ^category/(.+)/?$ /monk/index.php?category_name=$1 [QSA,L]
RewriteRule ^author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?author_name=$1&feed=$2 [QSA,L]
RewriteRule ^author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?author_name=$1&feed=$2 [QSA,L]
RewriteRule ^author/([^/]+)/page/?([0-9]{1,})/?$ /monk/index.php?author_name=$1&paged=$2 [QSA,L]
RewriteRule ^author/([^/]+)/?$ /monk/index.php?author_name=$1 [QSA,L]
RewriteRule ^([0-9]{4})/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?year=$1&feed=$2 [QSA,L]
RewriteRule ^([0-9]{4})/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?year=$1&feed=$2 [QSA,L]
RewriteRule ^([0-9]{4})/page/?([0-9]{1,})/?$ /monk/index.php?year=$1&paged=$2 [QSA,L]
RewriteRule ^([0-9]{4})/?$ /monk/index.php?year=$1 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?year=$1&monthnum=$2&feed=$3 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?year=$1&monthnum=$2&feed=$3 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$ /monk/index.php?year=$1&monthnum=$2&paged=$3 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/?$ /monk/index.php?year=$1&monthnum=$2 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?year=$1&monthnum=$2&day=$3&feed=$4 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?year=$1&monthnum=$2&day=$3&feed=$4 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$ /monk/index.php?year=$1&monthnum=$2&day=$3&paged=$4 [QSA,L]
RewriteRule ^([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$ /monk/index.php?year=$1&monthnum=$2&day=$3 [QSA,L]
RewriteRule ^ /feed/(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?&feed=$1 [QSA,L]
RewriteRule ^ /(feed|rdf|rss|rss2|atom)/?$ /monk/index.php?&feed=$1 [QSA,L]
RewriteRule ^ /page/?([0-9]{1,})/?$ /monk/index.php?&paged=$1 [QSA,L]

# END WordPress

I deleted the .htaccess file again, but my category links are disabled due to this mess. But at least I have my blog back! Thanks again Skippy.

The permalink structure is gone, but I still get the odd looking permalinks admin page. And even if I delete the .htaccess file it automatically generates itself when I access the permalinks admin page. It’s a circle I can’t get out of. Yikes!!!!

That did it! Now, is there a way to recover the ability to have my page and category links work again? When I try and use these links I get this:

Not Found
The requested URL /monkcategory/welcome/ was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/1.3.33 Server at http://www.monasticism.org Port 80

You’ve been a great help. Thanks.