Great module, but seems to need some further testing? I'm reporting this as critical because my site is broken and I suspect that others may encounter this problem.
I'm running Drupal 7.10. Here are the steps that resulted in the error:
- Installed metatag 1.0-alpha3.
- Configured it and tested it.
(FYI: I observed a problem where the home page title value will not override the global setting.)
- Put the site in maintenance mode. Did not log off as user1.
- Backed up the database.
- Deleted the database from the server.
- Created a new database on the server of the same name and imported the database backup.
- Tried to log in as user1 (admin). I got the following fatal error:
DOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_database_name.metatag_config' doesn't exist:
SELECT t__0.* FROM {metatag_config} t__0 WHERE (instance IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => global ) in ctools_export_load_object() (line 427 of /home/mysite/public_html/sites/all/modules/ctools/includes/export.inc).
I examined the raw database backup sql file and found several dozen occurrences of "metatag" and one instance of "default_metatag_config".
I suspect the error would have occurred if I had simply logged off as user1 and logged back in. The problem is repeatable; I reproduced on two different servers when importing the same database backup.
I suspect the only solution for now is to revert to a prior version of the database before metatag was installed.
Thanks,
Fred
Comments
Comment #1
Fredo commentedAdditional info:
- The table metatag_conf does not exist when examining the database with phpMyAdmin.
- Database tables check as ok via cpanel server tool.
- I had an earlier version of the database taken after the metatag module was installed and configured. The same steps as above replicated the error.
- I reverted to a database prior to installing the module. The problem does not occur in this instance.
I had originally marked this as critical, but have changed to major as this is alpha software. Thanks for your work on this module!
Comment #2
dave reidThe either something went wrong with the import, or your backup did not include the {metatag_config} table.
Comment #3
Fredo commentedHi, Dave: Possibly. However, there have been no similar problems importing any other tables. Very strange.
Fred
Comment #4
Fredo commentedI have completely replicated all of the steps I initially took to reproduce the problem. The problem has not reoccurred. So the problem was almost certainly a user problem. Sorry for taking up your time.
Comment #5
dave reidThanks for following up Fredo. Glad to know it wasn't a larger bug.
Comment #6
bobburns commentedI can confirm this happens - and happened on version 7.x-1.21
AND . . . I had the same problem - a "table metatag_config does not exist" error - and the result => " no content type available in admin/config/search/metatags/config/add " This was caused possibly from a restored backup database copied to the working database name after having dropped it because another "update" crap canned it
Also taxonomy add or edit was not working
Uninstalling metatag was ugly as it had lots of other dependencies locking it in
If you have a backup of your database - expand it to a sql text file open it with an editor like EditPad Lite (or whatever you like that is a plain text editor) and look for the following CREATE TABLE query
A SOLUTION - via phpmyadmin is to run this - the query to recreate the table and then the data insert below it from your backup (or if you do not have a backup)
CREATE TABLE IF NOT EXISTS `metatag_config` (
`cid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The primary identifier for a metatag configuration set.',
`instance` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The machine-name of the configuration, typically entity-type:bundle.',
`config` longblob NOT NULL COMMENT 'Serialized data containing the meta tag configuration.',
PRIMARY KEY (`cid`),
UNIQUE KEY `instance` (`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Storage of meta tag configuration and defaults.' AUTO_INCREMENT=2 ;
see if that works - and you can try to then dump in some data with this query - AND the " admin/config/search/metatags/config/add " will populate and work again (obviously copy this exactly below)
INSERT INTO `metatag_config` (`cid`, `instance`, `config`) VALUES
(1, 'global', 0x613a36353a7b733a353a227469746c65223b613a313a7b733a353a2276616c7565223b733a33343a225b63757272656e742d706167653a7469746c655d207c205b736974653a6e616d655d223b7d733a31313a226465736372697074696f6e223b613a313a7b733a353a2276616c7565223b733a33303a22676f6f676c652d7472616e736c6174652d637573746f6d697a6174696f6e223b7d733a383a226162737472616374223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a383a226b6579776f726473223b613a313a7b733a353a2276616c7565223b733a32343a22676f6f676c655f7472616e736c6174655f656c656d656e74223b7d733a363a22726f626f7473223b613a313a7b733a353a2276616c7565223b613a31303a7b733a353a22696e646578223b693a303b733a363a22666f6c6c6f77223b693a303b733a373a226e6f696e646578223b693a303b733a383a226e6f666f6c6c6f77223b693a303b733a393a226e6f61726368697665223b693a303b733a393a226e6f736e6970706574223b693a303b733a353a226e6f6f6470223b693a303b733a363a226e6f79646972223b693a303b733a31323a226e6f696d616765696e646578223b693a303b733a31313a226e6f7472616e736c617465223b693a303b7d7d733a31333a226e6577735f6b6579776f726473223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a383a227374616e646f7574223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a363a22726174696e67223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a383a227265666572726572223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a393a2267656e657261746f72223b613a313a7b733a353a2276616c7565223b733a32383a2244727570616c20372028687474703a2f2f64727570616c2e6f726729223b7d733a363a22726967687473223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a393a22696d6167655f737263223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a393a2263616e6f6e6963616c223b613a313a7b733a353a2276616c7565223b733a32373a225b63757272656e742d706167653a75726c3a6162736f6c7574655d223b7d733a393a2273686f72746c696e6b223b613a313a7b733a353a2276616c7565223b733a32383a225b63757272656e742d706167653a75726c3a756e616c69617365645d223b7d733a393a227075626c6973686572223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a363a22617574686f72223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31353a226f726967696e616c2d736f75726365223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a343a2270726576223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a343a226e657874223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31333a22726576697369742d6166746572223b613a323a7b733a353a2276616c7565223b733a303a22223b733a363a22706572696f64223b733a303a22223b7d733a31363a22636f6e74656e742d6c616e6775616765223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31323a2267656f2e706f736974696f6e223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31333a2267656f2e706c6163656e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31303a2267656f2e726567696f6e223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a343a226963626d223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a373a2272656672657368223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31383a22616c3a616e64726f69643a7061636b616765223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31343a22616c3a616e64726f69643a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31363a22616c3a616e64726f69643a636c617373223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31393a22616c3a616e64726f69643a6170705f6e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31303a22616c3a696f733a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31393a22616c3a696f733a6170705f73746f72655f6964223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31353a22616c3a696f733a6170705f6e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31313a22616c3a697061643a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32303a22616c3a697061643a6170705f73746f72655f6964223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31363a22616c3a697061643a6170705f6e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31333a22616c3a6970686f6e653a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32323a22616c3a6970686f6e653a6170705f73746f72655f6964223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31383a22616c3a6970686f6e653a6170705f6e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32303a22616c3a77696e646f77735f70686f6e653a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32333a22616c3a77696e646f77735f70686f6e653a6170705f6964223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32353a22616c3a77696e646f77735f70686f6e653a6170705f6e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31343a22616c3a77696e646f77733a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31373a22616c3a77696e646f77733a6170705f6964223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31393a22616c3a77696e646f77733a6170705f6e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32343a22616c3a77696e646f77735f756e6976657273616c3a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32373a22616c3a77696e646f77735f756e6976657273616c3a6170705f6964223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32393a22616c3a77696e646f77735f756e6976657273616c3a6170705f6e616d65223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31303a22616c3a7765623a75726c223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32323a22616c3a7765623a73686f756c645f66616c6c6261636b223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a393a2266623a61646d696e73223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a393a2266623a6170705f6964223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a383a226974656d74797065223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31333a226974656d70726f703a6e616d65223b613a313a7b733a353a2276616c7565223b733a32303a225b63757272656e742d706167653a7469746c655d223b7d733a32303a226974656d70726f703a6465736372697074696f6e223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31343a226974656d70726f703a696d616765223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31313a227468656d652d636f6c6f72223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31353a224d6f62696c654f7074696d697a6564223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31363a2248616e6468656c64467269656e646c79223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a383a2276696577706f7274223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a393a22636c65617274797065223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a32343a22676f6f676c652d736974652d766572696669636174696f6e223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31353a22703a646f6d61696e5f766572696679223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31333a226d7376616c69646174652e3031223b613a313a7b733a353a2276616c7565223b733a303a22223b7d733a31393a2279616e6465782d766572696669636174696f6e223b613a313a7b733a353a2276616c7565223b733a303a22223b7d7d);
If it does not work you can always delete the TABLE and its DATA again
Comment #7
bobburns commented