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 78
PHP 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
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.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |