Jump to:
| Project: | Skinr |
| Version: | 7.x-2.0-alpha1 |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Issue Summary
Hi,
My site keeps crashing after installing the Skinr module.
Once the module is removed, the site functions normally again.
This is the error I keep receiving:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jeebee_drpl2.skinr_skins' doesn't exist: SELECT s.sid AS sid FROM {skinr_skins} s WHERE (theme = :db_condition_placeholder_0) AND (module = :db_condition_placeholder_1) AND (element IN (:db_condition_placeholder_2)) AND (status = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => touchpro [:db_condition_placeholder_1] => views [:db_condition_placeholder_2] => calendar__page_1 [:db_condition_placeholder_3] => 1 ) in skinr_skin_get_sids() (line 1030 of /home/jeebee/public_html/sites/all/modules/skinr/skinr.module).
Do we need to create a table in the database, before installing the module?
Comments
#1
Are you installing Skinr for the first time, or did it previously exist (previous version) on your site?
We don't have the upgrade path yet, so you'll need to uninstall Skinr, which removes all related tables and allows you to do a fresh install afterwards.
#2
I had the problem from the first time I tried to install it, I already tried it 5 times.
Their is also no table 'Skinr' in the database.
Databases aren't really my thing, I tried to solve the problem by making a table, but that didn't changed a thing
#3
If the installation is successful there should be a skinr_skins table. If not, disable the Skinr module, then go to the uninstall module page and uninstall it. Only then can you enable the Skinr module again.
Could you please follow those steps, and then report any errors you get when enabling Skinr? If there are no errors and there is no skinr_skins table, you probably did not properly uninstall the module.
#4
I tried it, but still the same problem.
After installation I wanted to enable the module and got the same error.
With that error, I can't go the page to uninstall modules, I can't go to any page.
No table was created and I used FTP to get module out and the site working again.
#5
Is there really nobody else with the same problem?
I think I tried everything, but the site keeps crashing and the theme requires skinr.
#6
The only way to fox it at this point is to disable the skinr modules by editing the system table:
UPDATE system SET status = 0 WHERE name LIKE 'skinr%';After that you should be able to uninstall skinr through the uninstall feature in Drupal admin.
Alternatively you can manually remove all traces of Skinr by running the following SQL commands:
DELETE * FROM system WHERE name LIKE 'skinr%';Then, for each Skinr related table (you might have some additional ones from previous versions of Skinr which are no longer used):
DROP TABLE skinr_rules;DROP TABLE skinr_skins;
#7
I've had exactly the same problem just now trying to enable skinr to use Acquia Marina theme. :/ Just going to try the suggestions above to fix it.
#8
Have you had any error messages in your error log?
#9
I'm having the same problem after installing alpha1:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pwdrupal7.skinr_skins' doesn't exist: SELECT s.sid AS sid FROM {skinr_skins} s WHERE (theme = :db_condition_placeholder_0) AND (module = :db_condition_placeholder_1) AND (element IN (:db_condition_placeholder_2)) AND (status = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => bartik_plus [:db_condition_placeholder_1] => block [:db_condition_placeholder_2] => system__main-menu [:db_condition_placeholder_3] => 1 ) in skinr_skin_get_sids() (line 1030 of /home/content/p/w/a/pwarwick/html/sites/all/modules/skinr/skinr.module).
I note the following comment in skinr.install:
/**
* Install the new {skinr_skinsets} and {skinr_skins} tables.
*
* @todo Should we remove this? It was ported from skinr_update_6002() and
* skinr_update_6003(), but should not have been.
*
* Contents removed because the tables added here are no longer required.
*/
It implies that skinr_skins isn't needed although I may be misinterpreting it. Certainly I'm not a Drupal coder but I can't see that the tables are installed anywhere else.
#10
The skinr_skins table is needed. The code you refer to is related to an UPDATE (if you you installed a previous version of Skinr and are now updating to a newer one).
Obviously, with more than a few reports this is a real issue not unique to one person's setup.
Can you provide any more (different) error messages from when skinr was JUST enabled? Perhaps something that popped up when trying to enable the module?
#11
The comments I included is for both install and update. It is from skinr.install. I see no evidence in that program or elsewhere of creating the table. What should I look for to see where the table gets created?
#12
Please try the following:
1. Disable Skinr and Skinr UI (see /admin/modules/list)
2. Uninstall Skinr and Skinr UI (they should now show up in: /admin/modules/uninstall)
3. Clear your cache (if you have devel module installed this should be easy to do: /admin_menu/flush-cache)
4. Install Skinr and Skinr UI (see /admin/modules/list)
5. Check your logs immediately thereafter to see if any errors were posted (see /admin/reports/dblog)
#13