cyberantweb.com

When the Revver plugin for Wordpress was presented, I downloaded it to my Wordpress blog. But when I tried to activate it nothing happen. And because there were no error message, I was not able to do much about it. I checked the requirements with my host and everything were correct.

Earlier this week, I updated my Wordpress to version 2.3.1 and I thought, that I should try installing the plugin again. Now I downloaded the plugin from Wordpress. This time I was more lucky because now I got an error message:

WordPress database error: [Table 'cyberat_wrdp2.wp_posts_revver' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*,wp_posts_revver.* FROM wp_posts LEFT JOIN wp_posts_revver ON wp_posts.ID = wp_posts_revver.post_id WHERE 1=1 AND post_type = 'post' AND (post_status = 'publish' OR post_status = 'private') ORDER BY post_date DESC LIMIT 0, 5

From Revver forum, I found a question related to this, with an answer:

make sure that the database user you have in your wp-config file has permission to modify the database.

From my www directory, I found wp-config.php file with information:

define(’DB_NAME’, ‘putyourdbnamehere’); // The name of the database
define(’DB_USER’, ‘usernamehere’); // Your MySQL username
define(’DB_PASSWORD’, ‘yourpasswordhere’); // …and password
define(’DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
define(’DB_CHARSET’, ‘utf8′);
define(’DB_COLLATE’, ”);

So I went to my cPanel X, and to MySQL databases, and I found the user and I configured all the privileges to the database user. But still I received the same error message. Then I sent email to asi (at) revver… and I asked, if they have any ideas. I received this email:

The db user still doesn’t have alter or create table privileges. The code that’s changing the database is actually core part of WordPress. In cpanel, when you go to the mySQL admin section, do you see “(Privileges: ALL PRIVILEGES) ” next to the username entered in your wp-config file?

Set all priveleges for that user, then deactivate the plugin and reactivate it. The table should be created for you.

I did, what I was suggested, but it did not work. However I thought, that I could try removing the Revver plugin directory from my host server and download it again. This is because I had noticed, that Wordpress download created different name for the plugin directory (revver/revver-wordpress-video-plugin) and sometimes even this can cause troubles.

So I removed the plugin directory from my server and replaced with the one downloaded from Revver site. Then I activated the plugin, tested it and it worked.

Now at the end it’s working, but I don’t know if it was the Wordpress version, database user rights, or the plugin directory name or all of them.

I hope this helps someone with the same problem.