A WordPress/Host Plea for Help

I keep coming to my blog seeing the following error (I changed the username myself):

WordPress database error: [User ‘username’ has exceeded the ‘max_questions’ resource (current value: 50000)]

I know my host, StartLogic restricts the number of MySQL calls in an hour to 50,000 … can I actually be hitting that limit or are there other causes? The other blogs and tools I have installed here at the camplesegroup.com domain continue to run even when this blog goes down. My host tells me I need to go to a dedicated server package, but I really don’t get that much traffic — during the last 8 months, according google analytics, my highest traffic month was November with around 5,000 unique visits … that is when this problem started BTW. Can anyone help me with decoding this? If I do need to change plans/hosts does anyone have a recommendation? If it doesn’t seem like I should need to, does anyone have any advice for me?

New Look

I spent the better part of today working on a couple of things … the first was my garage. I can now not only get a car in there, but we can still make it to the fridge, Madeline’s bike, my bike, the tools, the winter supply of fire wood, and everything else we need.

The other thing is a new look and feel. I started with the idea that I was going to switch to MovableType, but I couldn’t get it to work on my host. After fighting with their tech support people via their live chat service I simply gave up — there is a blog post about that interaction for the future. You see the blog has blown up with MySQL errors twice this week so I was hoping to try out something else. After wasting too much time on that project I switched gears trying to get my database and my WP up to date and stable. It pushed me to make a bunch of changes under the hood. I also decided it was time to make a move away from the K2 world.

I’d love to know what you all think of the new theme … there are still a few issues to work out, but it is time to spend some time with the family. Please let me know what you think!

Local WordPress on Mac OSX with MAMP

After years of foolishly working on my live blog for all types of changes I decided to take a leap of faith and install WordPress 2.x on my G5 at home to use as a development environment. I will probably do the same thing on my work MacBook Pro and abandon my local copy of MovableType since I am a WP guy. When I did the MT thing on my MBP I found some directions and ended up in the Terminal doing all sorts of things … made me uncomfortable.

I have to give a tip of the hat to my friend and colleague, Chris Millet for introducing me to MAMP … MAMP is this nice little app that gets MySQL, Apache, PHP, and the associated admin apps you need running on your Mac in no time — as a matter of fact at the click of a mouse. Just download the thing, drop it in your Applications folder, double click the MAMP app (or fire up the included widget for use under 10.4) and you are but a click away from having Apache and MySQL Server fully installed and running on your machine. From there, installing WP was a dream. Here are the basic steps I used to get it running:

  1. Download MAMP
  2. Install MAMP by dropping the whole folder into my Applications directory
  3. Double click the widget in the MAMP directory (under 10.4.x) and it auto installed
  4. Flipped the widget over and set the radio button to PHP 4 — this is done by running the mouse over the bottom of the widget to expose the little i button. Clicked Done and it flipped back over.
  5. Clicked “Start Servers” and the little lights glowed green.
  6. I then tried to click the “Open Start Page” button on the widget, but nothing happened … if this happens go to the next step.
  7. Back in my Applications/MAMP directory, I double clicked the MAMP application and it opened.
  8. In there, I clicked the “Open Start Page” button and it opened a web page for me.

At this point MAMP is running and you are ready to install WordPress. To get WordPress running you do the following:

  1. Download WordPress
  2. While WordPress is downloading, go back to the start page MAMP opened for you and click the link at the top for phpMyAdmin.
  3. This is where you will set up a mySQL database to run WP on.
  4. In the phpMyAdmin page, under the Create new database box, type in a database name … for this you can call it anything you want … I named mine local_wp … again, it can be anything.
  5. Make DB

  6. Take your WordPress files and place them inside the Applications/MAMP/htdocs directory.
  7. Open the wp-config-sample.php file and update it with the following (given you named your database local_wp) … the thing that threw me for the first 20 minutes or so was adding that :8889 to the DB_HOST section.

    Config
  8. Rename the wp-config-sample.php to just wp-config.php and save it back in your Applications/MAMP/htdocs directory.

At this point you just need to point your browser to http://localhost:8888/wp-admin/install.php and finish out the process … from here it is as easy as can be.  So this should get you going in a few minutes with your own development environment on your machine.  Talk about a killer personal content management system! At this point, you could install all sorts of other open source PHP based stuff in the MAMP directory to try out and tweak.  I hope this helps!

Subscribe to Comments

I know, I know … its so 2003, but I added a subscribe to comments feature.  If you can call clicking “Activate” in the plugin admin panel.  At any rate, it should make it easier to stay up to date on comments.

Taking Another Look at WP …

No, I haven’t switched … yet … I have been playing around with some of my plugins and features the last day or two here at my blog … really just becasue I have been watching D’Arcy make the big switch. It is interesting to watch his move and see what he has been using to make his blogging experiences so good (other than his killer content). Today I started using the photo-album plugin to give me a Flickr post space in my WP write panel. Works nicely. Just to test it out, I clicked on a thumbnail of the picture below in the Write section and it autoinserted it … it is a picture of my little lady in the shadows …

Maddie's Shadow

Either way, things will be a little crazy around here for a couple of days as I work up a new design with some new features.

WordPress Lightbox Plugin

Maybe you’ve seen the lightbox effect that has been in use around the web lately … I started exploring and was actually thinking of writing some code — but in the end, I decided to spare the world of my abilities. Who would guess it, but I came across the WordPress Lightbox effect plugin. Sort of cool, what do you think?
Just testing it out here … a while back I posted an image of the building number for my new job … click on the image below to see inside.