Clearing all entries

[raylu]

I recently upgraded to the latest version of s9y (recently as in 30 minutes ago) and I was wondering if there was a way to completely reset my blog (clear entries, comments, and possibly users)?

I could delete all entries but the auto_increment for entries starts at whatever it was before. I could also go through the MySQL database but I'd rather not risk screwing anything up before I ask here first.

[garvinhicking]

Hi!

The best way to re-install s9y is to just delete all s9y DB tables. s9y will then recreate them again. It's not good to just empty all tables, because if they exist, s9y will not touch them during installation.

Best regards,
Garvin

[raylu]

Query failed:

SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email
, e.body, e.extended

FROM
s9y_entries AS e
LEFT JOIN s9y_authors a
ON e.authorid = a.authorid
LEFT JOIN s9y_entrycat ec
ON e.id = ec.entryid
LEFT JOIN s9y_category c
ON ec.categoryid = c.categoryid
LEFT JOIN s9y_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN s9y_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1146178302 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15

/ Table 'raymond_blog.s9y_entries' doesn't exist

I suppose I need to reinstall now, because you metioned something about "during installation."

So...how do I intiate the install process?

[garvinhicking]

Hi!

You can re-call the install process by deleting the file "sreendipity_config_local.inc.php"! Look at the FAQ on www.s9y.org if you cannot delete the file, look for the "fixperm.php" script.

HTH,
Garvin

[raylu]

Awesome, I saw the installation page. I clicked Expert Setup and I filled in everything. Then, upon pressing enter, I got this message:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, (email) and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

After a few more tries, I went to simple mode and filled in that information. Then, I logged in and went to Configuration. There, I got the same error.

The server logs just show me doing
"GET /serendipity_admin.php?serendipity[adminModule]=configuration HTTP/1.1"
and some serendipity_admin.css's.

[garvinhicking]

Hi!

When this error happens it seems you are enabling URL Rewriting, which creates a .htaccess file that makes that trouble. You may want to set URL Rewriting to "NONE" or just delete .htaccess file after installation?

Usually, s9y tries to autodetect a workable setting for URL Rewriting...
HTH,
Garvin

[raylu]

It doesn't seem to be working. I checked my config settings and URL Rewriting was off to begin with; I never remembered turning it on.

There was only one .htaccess file that I could find and it was in the root s9y directory. I renamed it to oldhta and the same error happened.

Also, I intsalled s9y on another server and the main blog page caused this error too. It was a fresh installation, though. I tried downgrading to 0.9.1 and it worked...

---

BTW, why does s9y require a table prefix? What if I gave it its own DB and I don't want a prefix? Can't it accept a null value?

[garvinhicking]

Hi!

Hhm, this internal error is strange. Please check your webservers error logfile for more errors, or contact your sysadmin. Many people are using 1.0 without this problem. Usually only the .htaccess file can cause this!

BTW, why does s9y require a table prefix? What if I gave it its own DB and I don't want a prefix? Can't it accept a null value?

No, this does not work, because s9y uses a "references" table which would be a reserved SQL command if not prefixed.Prefixing is always better as it avoids confusion.

Regards,
Garvin

[raylu]

Yeah, I didn't have this error before.

Anyway, I've downgraded my own blog to 0.9.1 and it's still causing the same error. I can't save the configuration options, but everything else works.

I can't seem to find the error logs; I suppose I'll ask my host.

[garvinhicking]

Hi!

Did you try to use a different browser to enter your config? To me it sounds as if somehow it is submitting the "URL Rewriting" option with a value other than "None"...?!

Regards,
Garvin

[raylu]

Still waiting on my reply from them.

I've tried FF and IE now; same result.

[garvinhicking]

Hi!

So your problem does not go away when you delete the .htaccess file, right? Then we really need some feedback from your provider...

Did you check the file permissions already? Maybe some files are not readable for the wegbserver?

Best regards,
Garvin

[raylu]

I changed the permissions on /include/admin/configuration.inc.php to 777 and tried again; still the 500 error.

Still waiting for a (meaningful) response from my host.

[raylu]

A security module that we have installed did not allow the saving of the configuration because it matched the pattern "/bin/" which is called in functions_installer.inc.php.

Since this is not a security issue I disabled our module for your blog directory to fix the problem. You admin configuration saved with no errors now.

W00t.

[garvinhicking]

Hi!

Wow. Strange problems that sometime occur

Best regards,
Garvin