Jul/097
“You do not have sufficient permissions to access this page” after Wordpress upgrade
(2 votes, average: 4.50 out of 5)
Loading ...If you’ve done a wordpress upgrade which included either copying another wp database or changing the current one’s table prefix (as well as changing the $table_prefix PHP variable in your config file,) you will most likely be met with this warning when you try to log in:
You do not have sufficient permissions to access this page.
The reason for this is that everything in wordpress that accesses info in the db does so from PHP using the $table_prefix variable, and when you first installed your blog, a couple of options are set in the database that include that value, which makes it not really so dynamic! ;)
After rooting through my db, I found 5 or 6 values that still had the old table prefix in – mostly in the `usermeta` table, but also one in the `options` table. To make sure I got them all, I ran these simple SQL statements in phpMyAdmin to update all the values:
UPDATE `wp2_usermeta` SET `meta_key` = REPLACE(`meta_key`, 'wp_', 'wp2_');
UPDATE `wp2_options` SET `option_name` = REPLACE(`option_name`, 'wp_', 'wp2_');
(note: please be sure to backup your database before you execute any SQL on it – if something goes wrong, there’s not a lot you can do to recover it without a backup!)
In those two examples, assume the original prefix was “wp” and the new one is “wp2″.
With that done, I can now log in to my newly upgraded blog again! :)
Feb/096
Album artwork doesn’t show on iPod touch
If you find that your iPhone/iPod Touch isn’t displaying the album artwork in coverflow, but your computer that you sync it to shows it fine in iTunes, you’re probably wondering what’s going on!
This happened to me a few days ago, so I did some searching – most people seem to think it’s only just started happening in the latest versions of iTunes and on iPhones/iPod Touches with the 2.2 firmware on – I didn’t notice it happening before I upgraded my firmware, but then I only noticed it happening now by chance, so I can’t really say if what these people are saying is true.
Anyway, it’s a solution you came here for, so here goes.
I tried resetting my iPod, incase it was just something dodgy going on on the file system, or another process interfering. No Joy. :(
I’ve tried clearing all my album artwork in iTunes and then finding the images again using a combination of the “Get Album Artwork” feature in the iTunes store and some Amazon.co.uk searches, then syncing the device again. Again, no joy.
Finally, I decided to just delete the offending albums from my iPod and upload them to it again. To do that without losing the albums from your iTunes library, just plug your iPhone/iPod in, start iTunes, click on the device name in the list on the left and tick the box that says “Manually manage music and videos”. That will allow you to browse the library on your device, select the albums in question and delete them. When you’ve done that, untick the box you just ticked, hit OK in whatever dialogue box iTunes pops up and let it sync your device again.
This should copy the songs/albums from your computer’s library back to the device, and hopefully send the album artwork along with them!
Well, that’s what worked for me – if anyone has any better method of restoring artwork on an iPhone/iPod Touch, please leave a comment and let me know what you did!