On administration page admin/people/signup appears only:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydb.field_data_field_date' doesn't exist: SELECT COUNT(*) AS expression FROM (SELECT n.nid AS nid, n.title AS title, n.type AS type, s.status AS signup_status, s.close_signup_limit AS signup_close_signup_limit, 1 AS expression FROM {node} n INNER JOIN {signup} s ON s.nid = n.nid LEFT OUTER JOIN {signup_log} s_l ON s.nid = s_l.nid LEFT OUTER JOIN {field_data_field_date} d ON d.entity_id = n.nid GROUP BY nid, title, type, signup_status, signup_close_signup_limit) subquery; Array ( ) in function PagerDefault->execute() (line: 74 in file C:\myweb\includes\pager.inc).

In db really not exists table field_data_field_date. There is only field_data_field_date_myevent.

CommentFileSizeAuthor
#1 signup-1457146-1.patch4.07 KBsgabe

Comments

sgabe’s picture

sgabe commented
Title: Page admin/people/signup - PDOException: SQLSTATE[42S02]: Base table or view not found » Get the proper date information when using a date field
StatusFileSize
new signup-1457146-1.patch4.07 KB

Currently a date field named "field_date" is hardcoded in the query. There is a workaround to get the proper date information for every event, but it needs to be updated. The attached patch does this, at least for the date field.

Note that you will not be able to see the date because of another bug which will be fixed in another issue, but it should be there in every $node variable.

sgabe’s picture

sgabe commented
Status: Active » Needs review

Changing status.

sgabe’s picture

sgabe commented
Title: Get the proper date information when using a date field » Get the proper date information on the events overview page

As I see the Event module does not exist for D7, so it won't be a problem.

ivo_m’s picture

ivo_m commented

It works fine. Thanks.

sgabe’s picture

sgabe commented
Status: Needs review » Fixed

Committed, thanks!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.