WordPress.org

1. shannonodom
   Member
   Posted 5 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://wordpress.org/extend/plugins/eventbrite-for-pods/

2. Scott Kingsley Clark
   Member
   Posted 5 months ago #

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

3. Scott Kingsley Clark
   Member
   Posted 5 months ago #

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

4. shannonodom
   Member
   Posted 5 months ago #

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

5. Scott Kingsley Clark
   Member
   Posted 5 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.

6. shannonodom
   Member
   Posted 5 months ago #

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

7. Scott Kingsley Clark
   Member
   Posted 5 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.wordpress.org/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.

8. shannonodom
   Member
   Posted 5 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'

9. Scott Kingsley Clark
   Member
   Posted 5 months ago #

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

10. shannonodom
    Member
    Posted 5 months ago #

    Yes. Just one ticket type for this event.

11. ghostgeek
    Member
    Posted 4 months ago #

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

Reply

You must log in to post.