Answers.Body: <p>I would recommend you apply the patch here <a href="https://github.com/civicrm/civicrm-core/pull/10325" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/10325</a> There is a default limit on API calls to 25 records which is what your probably hitting here</p>
  
  <p>Seamus</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-16T10:31:45.367Z
Answers.LastActivityDate: 2017-05-16T10:31:45.367Z
Answers.UserDisplayName: Seamus Lee
Body: <p>I tried to create events. For the first 25 events it worked fine, after 25 events, I got an access denied error instead of the event configuration page:</p>
  
  <blockquote>
    <p>"Entschuldigung, eine Bereitstellung ist uns gerade nicht möglich. Sie
    haben nicht die notwendigen Berechtigungen, um diese Seite
    aufzurufen."</p>
  </blockquote>
  
  <p>The event is created in the database table civicrm_event but not shown in the event overview in civicrm. If I delete some rows in the sql database civicrm_event, I can create events again up to 25.</p>
  
  <p>I turned on the debug mode. I think, this query is the problem:</p>
  
  <blockquote>
    <p>CRM_Core_DAO: CONNECT: Checking for database specific ini ('') :
    database_ in options CRM_Core_DAO: QUERY: SELECT a.id as <code>id</code>, a.title
    as <code>title</code> FROM civicrm_event a LIMIT 25 OFFSET 0</p>
    
    <p>CRM_Core_DAO: query: QUERY DONE IN 0.000273 seconds. Result is 25 rows
    by 2 columns.</p>
  </blockquote>
  
  <p>So the resultset has only the first 25 rows and the created event isn't in the resultset. </p>
  
  <p>I use civicrm 4.7.19 with drupal 7.54</p>
  
Tags: <civievent><issues>
Title: Bugreport: Impossible to create more than 25 events
ThreadText: # Bugreport: Impossible to create more than 25 events
  
  (Asked by: username_0 on 2017-05-16)
  
  I tried to create events. For the first 25 events it worked fine, after 25 events, I got an access denied error instead of the event configuration page:
  
  > "Entschuldigung, eine Bereitstellung ist uns gerade nicht möglich. Sie
  > haben nicht die notwendigen Berechtigungen, um diese Seite
  > aufzurufen."
  
  The event is created in the database table civicrm\_event but not shown in the event overview in civicrm. If I delete some rows in the sql database civicrm\_event, I can create events again up to 25.
  
  I turned on the debug mode. I think, this query is the problem:
  
  > CRM\_Core\_DAO: CONNECT: Checking for database specific ini ('') :
  > database\_ in options CRM\_Core\_DAO: QUERY: SELECT a.id as `id`, a.title
  > as `title` FROM civicrm\_event a LIMIT 25 OFFSET 0
  >
  > CRM\_Core\_DAO: query: QUERY DONE IN 0.000273 seconds. Result is 25 rows
  > by 2 columns.
  
  So the resultset has only the first 25 rows and the created event isn't in the resultset.
  
  I use civicrm 4.7.19 with drupal 7.54
  
  **Tags:** civievent, issues
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-05-16. Score: 4 | Accepted answer
  
  I would recommend you apply the patch here <https://github.com/civicrm/civicrm-core/pull/10325> There is a default limit on API calls to 25 records which is what your probably hitting here
  
  Seamus
  
  
  ---
  
  