Look at the FROM clause--we alias the entries table to e, entrycat to ec, etc.
I don't see why that query (create index) would return a result.
Search found 88 matches
- Wed Oct 20, 2004 2:47 pm
- Forum: Bugs
- Topic: Search fails to function
- Replies: 17
- Views: 16136
- Wed Oct 20, 2004 2:44 pm
- Forum: General discussions
- Topic: Moving item footer
- Replies: 3
- Views: 3690
Okay inside the div.serendipity_entryFooter block, change to
Code: Select all
border-top: 1px solid #69C;
Code: Select all
border-bottom: 1px solid #69C;
- Wed Oct 20, 2004 4:36 am
- Forum: General discussions
- Topic: Moving item footer
- Replies: 3
- Views: 3690
- Wed Oct 20, 2004 4:32 am
- Forum: Bugs
- Topic: Search fails to function
- Replies: 17
- Views: 16136
What version of MySQL are you using? This query requires MySQL >= 3.23.23. I suppose that should be documented somewhere... and checked internally before we try to use it ;)
- Wed Oct 20, 2004 4:23 am
- Forum: General discussions
- Topic: Print This Post
- Replies: 1
- Views: 2834
Easy enough. First, let's create a stylesheet for print media. a:link, a:visited { color: black; text-decoration: none; } .serendipity_entryIcon, #serendipityRightSideBar, #serendipityLeftSideBar { display: none; } Should keep everything simple... Next, talk to Jannis and get him to send you his plu...
- Wed Oct 20, 2004 4:11 am
- Forum: General discussions
- Topic: Email This Post To A Friend
- Replies: 1
- Views: 2646
Yes.
- Wed Oct 20, 2004 4:09 am
- Forum: Installation
- Topic: A question about hosting someone else's blog
- Replies: 2
- Views: 3547
Okay first back up your database . Moving on, I have a second blog set up for development on my server, and the only thing is make sure you change your database prefix. It defaults to 'serendipity_'--my second blog is 's9y_'. If you do that, the two installations should keep to themselves. If you do...
- Wed Oct 20, 2004 4:03 am
- Forum: General discussions
- Topic: List of Authors
- Replies: 3
- Views: 3858
I can't think of a way currently, but I've just added it to my todo list for the next version (0.8). Thanks for the idea :)
- Wed Oct 20, 2004 3:58 am
- Forum: Themes
- Topic: Getting rough with CSS in the sidebar
- Replies: 5
- Views: 7780
The code is in plugins/serendipity_plugin_recententries/serendipity_plugin_recententries.php, but you don't need to change it . The CSS I posted gives the result you want, and if you add a div to the plugin you will have to edit the plugin every time you update your software. Please just try the cod...
- Wed Oct 20, 2004 3:51 am
- Forum: General discussions
- Topic: Length of entry (number of lines) limit setable?
- Replies: 5
- Views: 3810
There isn't really anything to do this automatically, but I think what you're really looking for is the extended entry part of the post. The textarea is hidden by default, but at the bottom of the new entry, you'll see some text that says 'Extended Body' (unless you aren't using English...) with a l...
- Tue Oct 19, 2004 9:19 pm
- Forum: Installation
- Topic: i just can't get past the chmod thing.
- Replies: 6
- Views: 5803
- Tue Oct 19, 2004 9:09 pm
- Forum: Bugs
- Topic: Search fails to function
- Replies: 17
- Views: 16136
Try running CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended); If that doesn't work try manually running the search query in phpMyAdmin and let me know if it gives you an error (and if so, what it is). The search query is... SELECT e.id, e.author, a.username, a.email, ec.c...
- Tue Oct 19, 2004 9:00 pm
- Forum: Themes
- Topic: Getting rough with CSS in the sidebar
- Replies: 5
- Views: 7780
Here's the CSS that will do what you want to the recent entries plugin: .sidebar_content_serendipity_plugin_recententries a { display: block; border: 1px black solid; border-bottom: 0; padding: 0.2em; padding-bottom: 0; } .sidebar_content_serendipity_plugin_recententries div.serendipitySideBarDate {...
- Tue Oct 19, 2004 6:21 am
- Forum: Installation
- Topic: i just can't get past the chmod thing.
- Replies: 6
- Views: 5803
- Tue Oct 19, 2004 6:02 am
- Forum: Development
- Topic: Migration from Wordpress (and others) to Serendipity
- Replies: 23
- Views: 99172
In its current incarnation it won't, but I have written a plugin that takes allows for MT-compatible archives. Take a look at it--it should be extremely easy to adapt to your archive format. If you don't know how let me know and I'll do it for you :)