Monthly Archives: August 2009

Moving wordpress tables

By | Published: 2009/08/22

This also applies to renaming table prefixes within the same database.

Previously on my server, I had 3 databases that I used actively. One for this website, one for another, and one for my power/gas data. The two websites are both wordpress.

So, just a few moments ago, I consolidated those tables into one database. I had to change the table prefix for one of the sites so both sites tables could coexist within the same database (and not have collisions). After changing the wp-config.php to reflect this change, the site loaded up. The problem is, I tried to go into the admin page, and I get “You do not have sufficient permissions to access this page”.

A lot of the info on the wordpress site doesn’t really cover this issue. Luckly, this does. Basically, you need to go into the “usermeta” table, and change the “meta_key” values from the previous prefix_capabilities, and prefix_user_level, to the new prefix_capabilities and new prefix_user_level. Then go into the options table and change prefix_user_roles to the new prefix_user_roles.

Once that’s done, things should work. You can certainly use the SQL statements he has on his site, but I had a hard time following what he was saying. So, I did it by hand once I figured it out.

Thanks very much, and hopefully I’ll have more later tonight or tomorrow.

(p.s. Sorry about the quality of the camera image. I’m working on it…)

Tweet this
Posted in Coding | Comments closed

Cardstar

By | Published: 2009/08/18

CardstarMy boss told me about Cardstar today, an iPhone app that lets you input various membership numbers for things like REI, Costco, Safeway, etc and then have the barcode rendered on the screen.

I had very low hopes for this app since my previous experience with attempting to get a barcode to read off the iPhone screen was met with disappointment, as well as several articles online saying it’s not possible due to physics (at least when it comes to laser readers. “Imager” readers work fine).

But, given the fact that it’s an app, and him saying he got it to work at Blockbuster, I decided to give it a try.

I’ll say right now, it’s finicky. Laser readers will in fact work. It took reading the directions for the app to get it to work. Basically, distance matters. 5-7″ really is necessary for it to work. The other issue is the angle the phone is held at relative to the reader. While I’d like to say you hold it 5° off plane, it’s not quite that simple. Depending on the barcode symbology, the angle seemed to be different. This could be completely circumstantial, but it seemed that barcodes using EAN 128 had to be a bit differently angled than Code 39. =/

But, that all said, it does work. Since getting home, I added a bunch more cards, and hopefully I’ll be able to stop carrying all those silly cards. It’s just upsetting some cards are magstrip only.

At this point, can’t give a real rating. Once I’ve had the application for a week or two, I’ll come back.

Thanks!

Tweet this
Posted in Reviews | Comments closed

  • Weather

  • Current Power Usage

  • Prius Mileage

    Lifetime Average (Calc) : 44.6MPG
    Lifetime Average (MFD) : 45.43MPG
    Total Miles Driven : 70691.9
    Graphs: Price/Gal. || Mileage || Summary

  • Distance Walked

    Distance walked in last 7 days
    12 miles (26242 steps)
    Graphs: History || Summary