Created on 23 February 2015, over 10 years ago
Updated 19 August 2025, 4 days ago

I'm so over it with this module. I've installed and re-installed way too many times than I should have to. =\

I get this error message when I go to create/add a product for a "membership type", in addition to editing the entity reference field, etc.
I took a look at the database, and yup, sure enough, the field is missing. Why or how would that happen on a new install?

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbxxx.xxxfield_data_commerce_license' doesn't exist: SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {field_data_commerce_license} field_data_commerce_license0 WHERE (field_data_commerce_license0.deleted = :db_condition_placeholder_0) LIMIT 1 OFFSET 0) subquery; Array ( [:db_condition_placeholder_0] => 0 ) in field_sql_storage_field_storage_query() (line 632 of /modules/field/modules/field_sql_storage/field_sql_storage.module).

Backtrace:
PDOStatement->execute(Array) database.inc:2171
DatabaseStatementBase->execute(Array, Array) database.inc:683
DatabaseConnection->query('SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
{field_data_commerce_license} field_data_commerce_license0
WHERE (field_data_commerce_license0.deleted = :db_condition_placeholder_0)
LIMIT 1 OFFSET 0) subquery', Array, Array) select.inc:1265
SelectQuery->execute() entity.inc:1327
EntityFieldQuery->finishQuery(Object, 'entity_id') field_sql_storage.module:632
field_sql_storage_field_storage_query(Object)
call_user_func('field_sql_storage_field_storage_query', Object) entity.inc:1154
EntityFieldQuery->execute() field.module:948
field_has_data(Array) field_ui.admin.inc:1910
field_ui_field_edit_form(Array, Array, Array)
call_user_func_array('field_ui_field_edit_form', Array) form.inc:841
drupal_retrieve_form('field_ui_field_edit_form', Array) form.inc:350
drupal_build_form('field_ui_field_edit_form', Array) form.inc:130
drupal_get_form('field_ui_field_edit_form', Array)
call_user_func_array('drupal_get_form', Array) menu.inc:517
menu_execute_active_handler() index.php:21

πŸ› Bug report
Status

Closed: outdated

Version

1.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States Kebz

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024