[Plugin: Eventbrite for Pods] Seem to have issues with Installation SQL
-
Scott:
Just found and installed your plugin, got my keys from Eventbrite, entered my first two Eventbrite Event ID’s and hit the sync key…and got the following error:
SQL failed; SQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT
t.*,
p.
idAS
pod_id,
p.
created,
p.
modifiedFROM
wp_podAS
pINNER JOIN
wp_pod_tbl_eventbriteAS
tON
t.
id=
p.
tbl_row_idWHERE
p.
datatype= 1 AND (
t.
display_flag=1 ) ORDER BY
t.
name; Response: Unknown column 't.display_flag' in 'where clause'
When I click Attendees I get the following error:
SQL failed; SQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT
t.
event_id,
t.
nameFROM
wp_podAS
pINNER JOIN
wp_pod_tbl_eventbriteAS
tON
t.
id=
p.
tbl_row_idWHERE
p.
datatype= 1 AND (
t.
display_flag=1 ) ORDER BY
t.
name; Response: Unknown column 't.event_id' in 'field list'
When I click Tickets I get the following error:
SQL failed; SQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT
t.
event_id,
t.
nameFROM
wp_podAS
pINNER JOIN
wp_pod_tbl_eventbriteAS
tON
t.
id=
p.
tbl_row_idWHERE
p.
datatype= 1 AND (
t.
display_flag=1 ) ORDER BY
t.
name; Response: Unknown column 't.event_id' in 'field list'
I added a display_flag field to the wp_pod_tbl_eventbrite table as an INT(1) and that cleared the first error, but was not sure about the second…and thought you should know these issues are happening.
Please let me know what to do to get this up and running.
Thanks,
Paul
https://www.ads-software.com/extend/plugins/eventbrite-for-pods/
- The topic ‘[Plugin: Eventbrite for Pods] Seem to have issues with Installation SQL’ is closed to new replies.