I have installed your latest 7.x-1.x-dev eventbrite api from github. I have 51 events in eventbrite and the api is only returning 1 event (the last event based on the latest date of the event). It is returning all 51 tickets associated with all the events. 50 of the events are a 'online only' event and only one event has a venue location. Can you tell me if there is a bug in the api? It seems the foreach loop is not storing values in the database until the last entry. Maybe a array problem.
All key fields (event, ticket, venue) are bigint(20) defined in the api tables. I am seeing 11 digit ids for events, tickets and venue ids on the eventbrite site. Looking at the tickets table I see a couple of tickets with negative id values (-) before id number. Anything I can do to troubleshoot this?

Comments

jamiehollern’s picture

jamiehollern
he/him
Primary language English
Location Alba/Scotland
CreditAttribution: jamiehollern commented
Status: Active » Postponed (maintainer needs more info)

Hi kcomply, would you be able to let me access your install or alternatively have access to your api keys?

kcomply’s picture

kcomply CreditAttribution: kcomply commented

Would you be able to do over a gotomeeting web support session? This is my customers data and cannot give out those details. Please contact me with your email address via private contact method.

kcomply’s picture

kcomply CreditAttribution: kcomply commented

Currently working with author to resolve this issue. Problem has been identified that current array handling of key id fields used by eventbrite do not work on linux 32bit os. After further research we have found that on a 32bit linux kernel and PHP_INT_MAX maxes out at 2147483647. There are 11 character ids on eventbrite and 10 char id above 2147483647 so big int designations do not work on 32bit linux. ID values need to be change to decimal 20,0 in api tables and array handling needs to work with string or floats to accomodate larger id numbers than +- 2147483647.

jamiehollern’s picture

jamiehollern
he/him
Primary language English
Location Alba/Scotland
CreditAttribution: jamiehollern commented
Title: Only retrieving 1 event from eventbrite account » MAX_INT_VAL for 32 bit operating systems too low and causes import failure
Status: Postponed (maintainer needs more info) » Active

Thanks to kcomply's hard work, the issue and a fix has been identified for this issue. I'm going to release an update for the module when I can figure out a way of ensuring user data won't be lost on upgrade.

SocialNicheGuru’s picture

SocialNicheGuru CreditAttribution: SocialNicheGuru commented

has this been fixed?

jamiehollern’s picture

jamiehollern
he/him
Primary language English
Location Alba/Scotland
CreditAttribution: jamiehollern commented

This hasn't been fixed as of yet.

drupal_andrew’s picture

drupal_andrew CreditAttribution: drupal_andrew commented

I'm receiving this error on import:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'barcode' at row 1: INSERT INTO {eventbrite_api_attendees}

Is that this same issue? Is there any workaround?

jamiehollern’s picture

jamiehollern
he/him
Primary language English
Location Alba/Scotland
CreditAttribution: jamiehollern commented

@drupal_andrew This isn't the same issue. I've opened a new bug for this: https://www.drupal.org/node/2561761.