Turning Tiki-Calendar off in Features creates scripting loop issue, causing Tiki 10.0 to stop working due to max queries server issue
- Status
- Closed
- Subject
- Turning Tiki-Calendar off in Features creates scripting loop issue, causing Tiki 10.0 to stop working due to max queries server issue
- Version
- 10.x
- Category
- Error
- Regression
- Less than 30-minutes fix
- Support request
- Feature
- Accessibility
Calendar - Submitted by
- Al Drake
- Lastmod by
- Al Drake
- Rating
- Description
Recently, I went into Admin and turned off one of the features in Admin at tiki-admin.php?page=features. The feature was Calendar in Global Features. But that brought up a problem that I was able to investigate in my host server's error logs:
.../tiki-calendar.php
PHP Warning: PDO::query(): SQLSTATE42000: Syntax error or access violation: 1226 User ... has exceeded the 'max_questions' resource (current value: 75000) in .../wiki/lib/core/TikiDb/Pdo.php on line 78PHP Warning: Invalid argument supplied for foreach() in .../wiki/db/tiki-db.php on line 152
PHP Warning: PDO::query(): SQLSTATE42000: Syntax error or access violation: 1226 User ... has exceeded the 'max_que ...
... /wiki/tiki-lastchanges.php- Solution
Update: None so far. I just checked my error logs and unfortunately, the same looping error messages have begun to reappear. My server host isn't happy with this situation and apparently the problem hasn't been solved — the excessive server queries keep causing the site to become unavailable until the quota resets every hour or two. I would appreciate any advice you might have!
Older:The above is an edited snippet of the error logs, and may be what caused my site to become unavailable: too many queries had resulted, requiring an hour or so's wait until the database quota reset. What I did was go ahead and turn the Calendar feature back on. So far I am not seeing the same or any error messages in the logs, and the Tiki site hasn't become inaccessible again. I will keep monitoring the issue, but at present it seems like turning Calendar on may have dealt with it.
- Importance
- 8
- Easy to solve?
- 5
- Priority
- 40
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 4353
- Created
- Wednesday 02 January, 2013 15:40:13 UTC
by Al Drake - LastModif
- Wednesday 02 January, 2013 21:43:34 UTC