gt112

sorry,

forgive my last post. I have just spotted the text “There is a new version of Akismet available. Download version 2.1.8 here or upgrade automatically.”

I get it now, sorry for being such a dufus

Hi

I had the same problem. I upgraded from 2.6 to 2.6.1. I followed the upgrade instructions exactly. When I had finished the upgrade, I logged onto my site where I was presented witha button to upgrade my database. Upon clicking this I get the following

Upgrade Complete
Your WordPress database has been successfully upgraded!

Continue
WordPress database error Out of memory (Needed 20550240 bytes) for query SHOW INDEX FROM wp_postmeta; made by dbDelta WordPress database error Multiple primary key defined for query ALTER TABLE wp_postmeta ADD PRIMARY KEY (meta_id) made by dbDelta WordPress database error Duplicate key name ‘post_id’ for query ALTER TABLE wp_postmeta ADD KEY post_id (post_id) made by dbDelta WordPress database error Duplicate key name ‘meta_key’ for query ALTER TABLE wp_postmeta ADD KEY meta_key (meta_key) made by dbDelta

This is really worrying and I would dearly love someone to explain to me what it means and if I am in trouble. Th eblog seems to be running fine but after that horrendous message, I am terrified.

Ah it seems to be back now

I also have the same problem. Is this a bug ? is ther a fix ?

A further refinement (for some reason the edit link has dissapeared so I have to submit a new post)

Point 5 above should now be read as follows

5. Edit the cosmetic navigation page links from “Previous Posts” to “Further Posts” as follows. Change the lines

<div class="alignleft"><?php next_posts_link('&laquo; Previous Entries') ?></div>
<div class="alignright"><?php previous_posts_link('Next Entries &raquo;') ?></div>

To

<div class="alignright"><?php next_posts_link('Further Entries &raquo;') ?></div>
<div class="alignleft"><?php previous_posts_link('&laquo; Previous Entries ') ?></div>

I have had a go at solving thi smyself and it seems to work.

Here’s what I did

1. Go to the template folder for the active wp templete

2. Copy index.php to a file called category-n.php (where n is the number of the category you wish to sort in). You can find this number by looking at the terms table in phpMyAdmin. In my case the category was 9 so I created a file called category-9.php

3. Edit category-n.php

4. just before the loop <?php while (have_posts()) : the_post(); ?>)
place this line of code
<?php query_posts($query_string."&orderby=date&order=ASC"); ?>

5. Edit the cosmetic navigation page links from “Previous Posts” to “Further Posts” as follows. Change the line
<div class="alignleft"><?php next_posts_link('&laquo; Previous Entries') ?></div>
To
<div class="alignright"><?php next_posts_link('Further Entries &raquo;') ?></div>
`
6. Save the file and upload it to the template folder on your server.

Hi Handy

Can I pm you the address? how do I do that.
Secondly, I am using no plugins, it’s all straight out of the box. I am testing by runnign teh blog in both ie6 and firefox3. I am clearing cache clocally etc.