[Plugin: Eventbrite for Pods] Error After Install

  • shannonodom

    (@shannonodom)


    14 years, 6 months ago

    I installed Pods CMS Framework and activated. I also installed Eventbrite for pods and activated. I see both in the wordpress admin page. I input my API keys and when I click on any other settings in the Eventbrite plugin I get an error. When clicking on sync from eventbrite I get:

    Error: Pod does not existError: Pod name invalidNo Events Found
    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/smodom/public_html/blog/wp-content/plugins/pods/classes/Pod.php on line 63

    When I click on events I get:

    Error: Pod does not existCannot get datatype fields; SQL: SELECT * FROM wp_pod_fields WHERE datatype = ORDER BY weight; Response: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY weight’ at line 1

    When I click on attendees I get:

    Error: Pod does not existError: Pod name invalidError: Pod does not existCannot get datatype fields; SQL: SELECT * FROM wp_pod_fields WHERE datatype = ORDER BY weight; Response: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY weight’ at line 1

    When I click on tickets I get:

    Error: Pod does not existError: Pod name invalidError: Pod does not existCannot get datatype fields; SQL: SELECT * FROM wp_pod_fields WHERE datatype = ORDER BY weight; Response: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY weight’ at line 1

    Does anyone have any ideas?

    http://ww.wp.xz.cn/extend/plugins/eventbrite-for-pods/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    14 years, 6 months ago

    Hey I’m aware of the issue, I’ll get a fix released tomorrow if I can. Thanks or your patience.

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    14 years, 6 months ago

    I’ve updated the plugin, try version 1.1 when it hits the wp.org shortly.

    Thread Starter shannonodom

    (@shannonodom)

    14 years, 6 months ago

    Just installed version 1.1 and I’m getting the same errors.

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    14 years, 6 months ago

    I’m testing with the new version of Pods so maybe that’s hy it’s working for me. Should be out later today, so watch for Pods 1.12, I’ll reply when it’s up.

    Thread Starter shannonodom

    (@shannonodom)

    14 years, 6 months ago

    I just installed Pods version 1.12-rc-7 and I’m getting the same errors.

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    14 years, 6 months ago

    Try two things:

    1. Go to the Pods menu under “Setup”, go to the Settings tab, and click the Reset Pods button

    2. Go to the following URL and copy the text from it:

    http://plugins.svn.ww.wp.xz.cn/eventbrite-for-pods/trunk/package.txt

    3. Go to the Pods menu under “Package Manager” and on the Import tab, paste the above text into the text area. Click Import and follow the instructions there.

    Also, Pods 1.12 was just released a few moments ago and you should try upgrading to that too as running the latest stable release is always a good thing.

    Thread Starter shannonodom

    (@shannonodom)

    14 years, 6 months ago

    I followed these steps. It resolved the errors I was having. Now I added an event and Im getting the following message when syncing from eventbrite:

    Event Data Update Completed

    Updating Tickets..

    13 Ticket(s) Found.
    Processing Ticket: U
    SQL failed; SQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT t.*, p.id AS pod_id, p.created, p.modified FROM wp_pod AS p INNER JOIN wp_pod_tbl_eventbrite_ticket AS t ON t.id = p.tbl_row_id WHERE p.datatype = 1 AND ( t.eventbrite_id=U AND t.event_id=U AND t.ticket_id=’U’ ) ORDER BY t.id LIMIT 0,1; Response: Unknown column ‘U’ in ‘where clause’

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    14 years, 6 months ago

    I’ll check when I get home today, but do you only have one ticket type for this event?

    Thread Starter shannonodom

    (@shannonodom)

    14 years, 6 months ago

    Yes. Just one ticket type for this event.

    ghostgeek

    (@ghostgeek)

    14 years, 5 months ago

    I’m getting the same error. Any fix for this?

    jcashman

    (@jcashman)

    13 years, 12 months ago

    Also the same error received. It there s a fix for this? WordPress 3.3.2

    SQL failed; SQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT t.*, p.id AS pod_id, p.created, p.modified FROM wp_pod AS p INNER JOIN wp_pod_tbl_eventbrite AS t ON t.id = p.tbl_row_id WHERE p.datatype = 1 AND ( t.display_flag=1 ) ORDER BY t.name; Response: Unknown column ‘t.display_flag’ in ‘where clause’

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘[Plugin: Eventbrite for Pods] Error After Install’ is closed to new replies.