Please help

[dyob]

Query failed:
SELECT
mr.read_date,
mr.read_date,
mr.read_date,
mr.read_date,
multilingual_body.value AS multilingual_body,
multilingual_extended.value AS multilingual_extended,
multilingual_title.value AS multilingual_title,
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.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_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_entryproperties multilingual_body
ON (e.id = multilingual_body.entryid AND multilingual_body.property = 'multilingual_body_ro')LEFT OUTER JOIN serendipity_entryproperties multilingual_extended
ON (e.id = multilingual_extended.entryid AND multilingual_extended.property = 'multilingual_extended_ro')LEFT OUTER JOIN serendipity_entryproperties multilingual_title
ON (e.id = multilingual_title.entryid AND multilingual_title.property = 'multilingual_title_ro') 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 = 0
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 <= '1140043565' AND (ep_access.property IS NULL OR ep_access.value = 'public') AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true') AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 5
/ Not unique table/alias: 'mr'

Hello, i have a huge problem.
I cannot display my site anymore, i also cannot edit my posts, i can post them still....
I don't know what is de the problem, but when i open the website (url: www.uitgesproken.com) then the text above is displayed.
Who can help me whit this problem?

Greets

[judebert]

Frankly, it looks like this "markread" plugin is generating bad SQL. I don't think you're allowed to use multiple AS statements with the same name, even if they alias the same table.

Can you uninstall the "markread" plugin?

[dyob]

I thank you very much, there were several plugins installed several times.
I removed the extra's and now the site is open again.

Greatings from a greatful user of Serendipity

[dyob]

Nederland is er sinds de tweede wereld oorlog een stuk beter op geworden, industrieel gezien, evenals op economisch vlak.<br />
Wij wonen in een van de rijkste landen in de wereld, wij hebben vrijwel nooit een huizentekort, over het algemeen kan gezegd worden dat wij er financieel ook niet slecht voor staan.<br />



This is a little tekst from my site, and as you can see, de html-code is visible in my post, (<br />) how can i make the html-code work without showing html-codes by itself?

[garvinhicking]

This can depend on the markup plugins you installed. Which event plugins did you install, and in which order are they?

Regards,
Garvin

[dyob]

Onderwerp Toegangsrechten
Markup: Serendipity

Apply basic serendipity markup to entry text
versie: 1.1 Alle auteurs Dyob Steef White Revolution
Markup: Emoticate

Convert standard emoticons into graphic images
versie: 1.1 Alle auteurs Dyob Steef White Revolution
Markup: NL2BR

Convert newlines to BR tags
versie: 1.2 Alle auteurs Dyob Steef White Revolution
Browser Compatibility

Uses different (CSS) methods to enforce maximum browser compatibility
versie: 1.0 Alle auteurs Dyob Steef White Revolution
Spam Protector

A variety of methods to prevent comment spam
versie: 1.26 Alle auteurs Dyob Steef White Revolution
Spartacus

[S]erendipity [P]lugin [A]ccess [R]epository [T]ool [A]nd [C]ustomization/nification [S]ystem - Allows you to download plugins from our online repository
versie: 2.5 Alle auteurs Dyob Steef White Revolution
Spam Protector (RBL)

Will reject comments made from hosts which are listed in RBLs. Pay attention that this may affect proxy-users or dial-up users.
versie: 1.0 Alle auteurs Dyob Steef White Revolution
Spam Protector (SURBL)

Reject comments that contain blacklisted URLs
versie: 1.0 Alle auteurs Dyob Steef White Revolution
HTML Validator

Validates entries on their XML-conformity
versie: 1.0 Alle auteurs Dyob Steef White Revolution
User Self-Registration

Allows blog visitors to create their own author account. Together with the Event-plugin (index.php?serendipity[subpage]=adduser) you can choose whether only registered users may post comments.
versie: 2.13 Alle auteurs Dyob Steef White Revolution
Extended properties for entries

(cache, non-public articles, sticky posts)
versie: 1.6 Alle auteurs Dyob Steef White Revolution
Link List

Links manager - Shows your favorite links in the sidebar.
versie: 1.4 Alle auteurs Dyob Steef White Revolution
HTML Validator

Validates entries on their XML-conformity
versie: 1.0 Alle auteurs Dyob Steef White Revolution
Statistics

Adds a link to interesting statistics in your entries panel, including a visitors counter
versie: 1.23 Alle auteurs Dyob Steef White Revolution
Discussion forum (forum)

Provides a complete discussion forum to your users.
versie: 0.10 Alle auteurs Dyob Steef White Revolution
Export blog as PDF

Allows visitors to download your blog in the PDF format
versie: 1.3 Alle auteurs Dyob Steef White Revolution
Polls

Maintains your votings / polls
versie: 2.09 Alle auteurs Dyob Steef White Revolution
Show read/unread state of entries for visitors

Show read/unread state of entries for visitors
versie: 1.1 Alle auteurs Dyob Steef White Revolution
Karma

Let visitors rate the quality of your entries
versie: 1.6 Alle auteurs Dyob Steef White Revolution
MimeTex TeX Interpreter

Create Gifs from TeX expressions using MimeTex
versie: 0.5 Alle auteurs Dyob Steef White Revolution
Custom Permalinks for Entries

Defines custom permalinks that can be used to access a specific entry. It can only use URL patterns which are NOT YET in use - using custom permalinks within the /archives/ structure is thus not possible. But any (virtual) other directory is.
versie: 1.03 Alle auteurs Dyob Steef White Revolution
Markup: Wiki

Markup text using Text_Wiki
versie: 1.1 Alle auteurs Dyob Steef White Revolution
Markup: BBCode

Markup text using BBCode
versie: 2.0 Alle auteurs Dyob Steef White Revolution
Backup Interface ()

Provides the ability to automatically make backups from your s9y, the database-tables, the whole database and the files.
versie: 0.7 Alle auteurs Dyob Steef White Revolution
Sample!

Allows you to insert HTML-Code into the HEAD-area of your blog. You can use this for meta-tags or JavaScript inclusion.
versie: 1.2 Alle auteurs Dyob Steef White Revolution
Contact Form

Shows a email contactform on your blog as a static page. It can be accessed by either the custom permalink or by index.php?serendipity[subpage]=contactform. You can customize the look of the contact form by putting the plugin_contactform.tpl file into your template directory and modify it there. Captchas from the Spamblock plugin (if enabled) will be applied.
versie: 1.7 Alle auteurs Dyob Steef White Revolution
Contact Form

Shows a email contactform on your blog as a static page. It can be accessed by either the custom permalink or by index.php?serendipity[subpage]=contactform. You can customize the look of the contact form by putting the plugin_contactform.tpl file into your template directory and modify it there. Captchas from the Spamblock plugin (if enabled) will be applied.
versie: 1.7 Alle auteurs Dyob Steef White Revolution
Contact Form

Shows a email contactform on your blog as a static page. It can be accessed by either the custom permalink or by index.php?serendipity[subpage]=contactform. You can customize the look of the contact form by putting the plugin_contactform.tpl file into your template directory and modify it there. Captchas from the Spamblock plugin (if enabled) will be applied.
versie: 1.7 Alle auteurs Dyob Steef White Revolution
User Profiles

Shows simple user profiles and allows to embed author pictures.
versie: 0.14 Alle auteurs Dyob Steef White Revolution
Guestbook (gastenboek)

Shows a guestbook inside your blogs with your normal blog design.



These are the things in my list, they are in the right order.
I also notice my pdf-files are displayed bij name, and they cannot be downloaded because you only see the title of the file, but not the file by itself.

[garvinhicking]

First off: You have several event plugins duplicated. Please delete the duplicates.

Then you are using several markup plugins at once, and several plugins interfere. The "Text_Wiki" markup plugin is one that is repsonsible for your behaviour. It should not be used if you are using HTML markup!

About your PDF problem, can you give me an example on your webpage? I don't kjnow what you mean...

Regards,
Garvin