Serendipity Forums

I tried to install the plugin: Extended properties for Entries and look what happened:
http://www.dougmotel.com/personalgrowthblog/

I get this instead of my blog:

Query failed:

SELECT
ep_sticky.value AS orderkey,

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.username AS loginname,
a.email
, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN serendipity_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN serendipity_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN serendipity_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_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 <= 1180472400 AND (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1)) AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true') AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 5

/ Can't open file: 'serendipity_entryproperties.MYD'. (errno: 145)

Please help me get my blog back online.

I wanted this plugin because I want some welcome text at the top of the first entry to "stick".

Thanks

That "can't open file" bit looks like you're using MySQL. A Google for

"can't find" .MYD

shows that you may be able to fix this by executing an SQL query like "REPAIR TABLE serendipity_entryproperties;" (this would be done either through the shell or through phpMyAdmin). This would be my highest-priority solution.

Can you access the admin interface (serendipity_admin.php)? Can you remove the plugin? If not, can you delete the plugin directory, and does it bring your blog back?

Garvin is much better at this, but it looks to me like your Serendipity user was not allowed to create a database table when the plugin was installed. Did you get any error messages?

Thanks Jude. I was able to uninstall the plugin so I am back up.
Any suggestions on how I can get a post to "stick" at the top of my blog as a welcome greeting?

A post, or just some static text?

One of the easiest ways is to edit your index.tpl. It's mostly HTML, with some Smarty mixed in. The Smarty is all looping and jumping stuff; you can mostly ignore it.

Just insert your HTML where you want it to appear, upload the modified file, and refresh your browser cache. Your "sticky" should appear.