Kwatog Interactive Technical Notes to self… and maybe some more

1Jan/100

Panglao WP

It's a modified version of the magnificent LightWord template by Andrei Luca

More info to follow

2Dec/090

WordPress : ‘You do not have sufficient permissions to access this page’

The problem looks like below.

You do not have sufficient permissions to access this page

The supposed permission problem has occured before and mainly involves plugins. For older version of wordpress, your problem may be solved by one or both of the

  • Change of table prefix - I suggest you visit this to solve that problem. And it also solves a string of other things, too.
  • Failed Upgrade - If you used an automatic upgrade and failed, it is possible that the version number saved in the database is already updated. You can force upgrade it by updating the your version number. Another alternative is by using MarkAquit's script here

However, these solutions are only applicable for older versions of WordPress. If you have a clean install, you should not encounter this. That's why it didn't work and was back to square one of investigation. Upon further checking, it turned out that the problem is related to old plugins. Apparently, there are plugins that was written before the current releases and whose parts of the code is no longer compliant with the current version of WordPress.

Finding the offending plugin is a bit tricky especially if you are using a lot of plugins. Luckily, I only encounter this in a contact page plugin and replace it accordingly with a new plugin which was released lately. The problem with my older plugin is that there's no more active development. And so when some of the codes were deprecated, the plugin fails.

So what's the problem then? Old Plugins.

22Aug/090

Rename Tables in MySQL

If you want to hand code renaming tables, here's the sample.

Single Table

RENAME TABLE wp_users TO kwg_users;

multiple tables

RENAME TABLE wp_users TO kwtg_users,
wp_usermeta TO kwtg_usermeta,
wp_site TO kwtg_wpsite,
wp_signups TO kwtg_signups;

This is handy when renaming a whole lot of tables as in the case of WordPress mu where each blog has its own set of tables. If you decide to rename them for security reasons (like you forgot to change the default table prefix during installation), it will be a pain to change them one by one through phpMyAdmin.

22Aug/091

Modified WP Table Prefix in bbPress

If you change your WordPress/WordPress mu table prefix (and thus, renamed the tables too) and you have a bbPress integrated with it, chances are your bbPress will lose its connection with WordPress since the configuration is not in bb-config.php. You'll need to update the meta tables, too through mysql or phpmyadmin. Here's the update query.


UPDATE bb_meta
SET meta_value = 'wpmu_'
WHERE meta_key = 'wp_table_prefix';

That's of course considering your bbPress table is bb_meta and the new prefix for WordPress/WordPress mu is wpmu.

16Aug/090

WordPress Upgrade Error(wp-comments)

I've been encountering this for a number of times already and on each time, I had to upgrade WordPress manually(through SSH to make it faster). Now, I was able to partially solve this by removing/renaming the existing upgrade folder under wp-contents. You can follow the steps below.

  1. Login to your server via FTP
  2. navigate to wp-contents folder
  3. rename the existing upgrade folder to a new name(you can also choose to delete)
  4. under wp-contents folder, create a new folder named upgrade
  5. set permission of the new upgrade folder to 666
  6. re-run the upgrade from within wordpress