Is there a way to reduce the number of querys on the oxwall script?
I receive this error:
SQLSTATE[42000] [1226] User 'romandie' has exceeded the 'max_questions' resource (current value: 75000)
The server provider doesn't support more than that, I asked them to increase the value and they won't do...
TeamIn your case you need to increase this amount. 0 - means unlimited db connections. If hosts declines to do that, you need to switch providers and obtain hosting plan where you'll be able to change configurations of the apache, php and mysql
Team
Thank you for your answer, the server do not provide more than the 75000 limit.
Is there other way to solve that, I already activated the query caching and it stills the same, I created some new users on database with the same result.
Team
Any idea? Thanks in advance
Team
This what the page supports write
It appears that the scripts related to your website's plugins/theme/widgets are not closing the MySQL connection after accessing the database and thus causing the query limit to exceed. Unfortunately, we can't say which exact scripts are causing the issue. Please contact your website developer and have them make sure that the scripts of your website's plugins/themes/widgets close the MySQL connection properly and are optimized so that they don't cause the query limits to be exceeded.
*0xard speed optimizer
The developer says that this plugin caches up to 30% of database queries within predefined lifetime.
*Anti brute force
*Advertisement
*Activity notifications
*Cron test
*Cache extreme
*Contact us
*Events
*Friends
*Groups
*Go top
*Gelocation IPs database
Needed to make the Advertisement plugin works
*Hint
*Image slideshow
*Messages
*MessageAll
*Newsfeed
*Profile snippets
*Private albums
*Privacy
*Profile progress bar
*Photo
*TopLink
*User IP Tracker
*User add
*Video
*Virtual gifts
*Who viewed me
*reCAPTCHA API v2.0
Do you know some issue in some of this plugins?
Thanks in advance
Team
Team
It have made a research and it seems that the last version reach easily the 150000 queries hour.
Team
I first ask them to increase the query limits I have paid for that.
After that wont work I have changed for a VPS server that never worked, the answer from their support it was that the Oxwall system is not compatible with their VPS servers.
After that I have back to the shared server and I have tried to optimize the database, until that I have asked them to mask my redirection (we don't have access to cPanel on their shared server) they have touched some file and screw the website who won't worked again...
I have wait 20h!!! for their specialists to fix the problem.
After does 20h I have decided to upload my backup to Arvixe servers and in less than 2 hours my website was online and working fine!!!
The Ipage specialists still trying to fix the issue, until now, the website still not working on their server after 2 days!!!
This is a warning for everyone who want's to run an Oxwall or similar website, do not chose Ipage as host provider.
I have tried Dolphin on their server and they don't have the latest PHP version installed yet.
I have tried the same Dolphin in a FREE provider and it worked
My website on Arvixe: Onbaise.ch working fine in less than twho hours
If you want to check the same website on Ipage, the website they screw trying to mask the domain http://sexxcouplecom.ipage.com/romandie/public_html ;
I'm sharing this experience to warning you before you chose your host provider.
