Issue trying to create content.

Submitted by TommWarham on Thu, 11/26/2015 - 11:12
Forums: 
Installation and server related problems

Hi,

I had an issue with drupal so I initated a fresh install and after installing and setting up h5p I am getting the following error trying to add content. 

It looks like a database table is missing but I'm not sure why.

Any help would be greatly aprecaited. 

Cheers. Tomm.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'h5pdrupal.h5p_content_user_data' doesn't exist: UPDATE {h5p_content_user_data} SET timestamp=:db_update_placeholder_0, data=:db_update_placeholder_1 WHERE (content_main_id = :db_condition_placeholder_0) AND (delete_on_content_change = :db_condition_placeholder_1) ; Array ( [:db_update_placeholder_0] => 1448532382 [:db_update_placeholder_1] => RESET [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 ) in H5PDrupal->resetContentUserData() (line 425 of/Users/tomwarham/Sites/h5p/drupal/sites/all/modules/h5p/h5p.classes.inc).

falcon's picture

falcon

Thu, 11/26/2015 - 11:57

I'm unable to reproduce this problem. Witch version of the module are you using?

TommWarham

Thu, 11/26/2015 - 12:09

Hi,

I'm using drupal 7.41, h5p module 7.x - 1.11.

Its a fresh install of drupal, my mySql version has been updated from 5.6.21 to 5.7.9

I'm going to see if I can get the previosu version of MySql and see if this resolves the issue. 

 

falcon's picture

falcon

Thu, 11/26/2015 - 13:54

Hi again, ok, were there any error messages when you installed the module? Could you check manually if the table "h5p_content_user_data" or "h5pdrupal.h5p_content_user_data" is in your database?

TommWarham

Thu, 11/26/2015 - 14:55

Hi,

Checking in sequel there was no table 'h5p_content_user_data' present.

I've just removed the newer version of MySql (5.7) and reinstalled the latest version of 5.6.x (5.6.27)

It has installed fine on this version of MySql, I appear to be having issues locally now connecting on localhost, but this is an issue with crossed over config files I presume. 

falcon's picture

falcon

Thu, 11/26/2015 - 16:23

Ok, maybe Drupal has an issue with mySQL 5.7 then. We use Drupal's script to create the table so I don't think the problem is in H5P.