miloandrew

Slow getting 41 rows? This has nothing to do with WordPress, but rather the MySQL Server. Yes, WordPress will indeed slow down with a DB that is that slow.

How to fix the slowness? Get a better hosting provider or move to a dedicated MySQL server. They are cheap money these days.

They say that WordPress needs a query optimization – tell them to take a hike!

Here’s a response on the same query from my WordPress DB:

SELECT *
FROM wp_posts

(314 total, Query took 0.0650 sec)

My 314 posts took .065 seconds. Your 41 took 6.85 seconds.

They say:

the wp_posts; takes a while to read, but this is also based on how much data is in it.

Yes, that’s true, but 41 posts isn’t big at all. My 300+ isn’t even big. Some people have literally thousands of posts in WordPress. A properly optimized server should do MUCH, MUCH better than the 6.85 seconds.

Sorry to say it, but I think your hosting provider is stinky and pointing the finger elsewhere when they should be working on optimizing their own setup. 🙂

OK, maybe that isn’t fair. Maybe it is the level of service you are paying for? I can’t slam a provider who is providing low cost service. Anyway, I’d fix the database response time before I’d ever start worrying about optimizing WordPress queries.

Just my opinion though.

Best of luck!

Cheers,
A

When you say “it showed up fine” – you mean that you were/are able to upload a picture and insert it into the post with the default theme, but with the wp-andreas01 theme, you can’t?

Sorry to harp on it – but if you change the theme back to the default, are you able to do everything fine? This is just such an unlikely thing to have happen with a theme change, so I’m wondering if it is a problem that simply cropped up at the same time.

If it IS a theme problem, the theme must be using a variable or overwriting a value that is messing up the upload.

What version of WP are you using, and what version is wp-andreas01 certified for? Does the theme provider have a forum or comment list where you can ask for help there?

If you can’t resolve it, I’d consider changing the theme – from looking at the URL, its a fairly basic layout. Beautiful to be sure, but a lot of that is your great banner.

Maybe something like vSlider would work for you? Just trying to think out of the box a bit.

Good luck!

Cheers,
A

OK, let us know how it works!

One question though – where are you putting the original <span style="color: #9c9d97;"></span> code? If I understand what you are saying, you have users on your blog with an Author role, and when they make a new post to the blog, this code is messed up.

Where is the code being messed up?

I don’t understand where you have put the code originally, and then subsequently, WHERE the code is getting messed up (is it in the post itself), is it in the theme, etc?

Sorry, just hard to visualize what is going on… 🙂

@banago – did you try setting the overall post number to 15 in the Reading settings? Just curious if that worked at all for the first page – problems with the second page notwithstanding…

Cheers,
A

You mean, now categories are working, but posts are not?

That is strange.

Looking at my blog, in my “Common Settings” I have the following in Custom Structure:

/%year%/%monthnum%/%postname%.html

You don’t need the .html, but I had migrated from blogger, so I threw it in there.

Under the optional settings for categories and tags, I have nothing – both fields are blank.

I can access my posts from the url:

http://myblog.com/2008/8/mypost.html

and, I can access a category this way:

http://myblog.com/category/mycategory

Give that a try and see if it helps!

Best of luck,
A

Did you change the actual blog URL back to where it should be?

If you can’t do this with the admin screen, try doing it in the database directly.

http://www.tamba2.org.uk/wordpress/site-url/

Be careful though, as it involves messing with the database directly.

Also, you should consider updating! Lots of security fixes from 2.3.3 to the current 2.6.1… But, I digress… 🙂

Cheers,
A

I’m assuming that you are using standard HTML for most of your site, but are using WordPress for the /blog portion?

If so, the short answer is NO, you can’t use the Plugin outside of wordpress.

The much longer “maybe you already knew this, so I should stop giving advice that wasn’t asked for” answer is:

I’ve been making sites for years, and I’ve never found an easier way to keep a website up to date than with WordPress. I’d consider using it to manage your entire site, not just your blog. Why? For reasons exactly like this – there are lots of awesome plugins and community submissions for WordPress. Stuff that would take hours to recreate for your own site. Why bother when WordPress can do all the heavy lifting for you?

There are lots of ways to manage your whole site with WordPress – Mostly it is done with the “pages” function and using Page templates to handle any custom HTML pages that you’d like to use that fall outside of your standard template type stuff.

Check out: http://codex.wordpress.org/User:Lastnode/Wordpress_CMS

or just google “wordpress CMS” and check out some of the pages that come up.

CMS stands for content management system and WordPress is actually well suited for it!

🙂

Best of luck,
A