Where is table qa_usermeta (asked for by theme-switcher)?

Question

When I have installed the plugin theme-switcher I get

Database query error 1146

Table 'bibfaq_main.qa_usermeta' doesn't exist

SELECT meta_value FROM qa_usermeta WHERE user_id=1 AND meta_key=_utf8 'custom_theme'

Apparently the plugin expects such a table but where to find it?

 

 

Answer 1

Like any database table, it should be found in the database :)

I'm not sure how this happens, but it's a bit of a problem; I think you can fix it in this way:

1. update the plugin to the latest git version
2. go directly to yoursite.com/admin/plugins (type it into the address bar, don't visit your site)

This should now create the table if it doesn't exist.

 

Comments

Updating the plugin went good but I don't understand the second part - at least it didn't work adding /admin/plugins to my url
Can you elaborate on the second part?

---

you have to visit the admin/plugins page, where ever that is.

---

OK, got it now, but it doesn't help. The error_log says

"PHP Fatal error:  Class 'qa_html_theme_base' not found in /home/bibfaq/..../qa-plugin/theme-switcher/qa-theme-layer.php on line 3"

---

try updating the plugin again, I've made another change.

---

Nope! One step forward, however. No error_log this time, but still no table inserted in the database...

---

strange... try downloading the admin plugin, and putting this in the admin plugin box:

            qa_db_query_sub(
                'CREATE TABLE IF NOT EXISTS ^usermeta (
                meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                user_id bigint(20) unsigned NOT NULL,
                meta_key varchar(255) DEFAULT NULL,
                meta_value longtext,
                PRIMARY KEY (meta_id),
                UNIQUE (user_id,meta_key)
                ) ENGINE=MyISAM  DEFAULT CHARSET=utf8'
            );

Edit: if you can't access admin/plugins, try putting the above code in the theme-switcher's qa-plugin.php, right after the opening <?php tag.

---

Adding the table manually did the trick! Thank you very much!

---

NoahY, on your Git-Hub page, the instructions says:

git clone git://github.com/NoahY/q2a-admin.git admin

should be

git clone git://github.com/NoahY/q2a-admin-plus.git admin-plus

but that was pretty obvious.