SQL ERROR [ mysql4 ] - Out of memory

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
ricjonhay
Registered User
Posts: 247
Joined: Tue Feb 16, 2010 6:08 pm

SQL ERROR [ mysql4 ] - Out of memory

Post by ricjonhay »

Support Request Template
What version of phpBB are you using? phpBB 3.0.7-PL1
What is your board's URL? http://thehazey.co.uk
Who do you host your board with? webhostinguk
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? No
What MODs do you have installed? Over 36
What styles do you currently have installed? Bluesilver
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
When did your problem begin? It's been going on for about 10 days
Please describe your problem. Every so oftern I get the error below and the only way to fix it is to clear my sessions via the ACP, what is causing it?
Generated by SRT Generator ($Rev: 4351 $)
This is the error:

Code: Select all

SQL ERROR [ mysql4 ]

Out of memory (Needed 16777124 bytes) [5]

SQL

SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM phpbb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1284908940

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 3728
CALL: dbal_mysql->sql_query()

FILE: includes/functions.php
LINE: 3762
CALL: obtain_guest_count()

FILE: includes/functions.php
LINE: 4097
CALL: obtain_users_online()

FILE: index.php
LINE: 276
CALL: page_header()
User avatar
soumik
Registered User
Posts: 486
Joined: Tue Nov 06, 2007 7:27 pm
Contact:

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by soumik »

You need to talk about this error to your host.
Powered by chocolate
ricjonhay
Registered User
Posts: 247
Joined: Tue Feb 16, 2010 6:08 pm

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by ricjonhay »

I already have numerous times.

The reply is the same, you need to optimize your database :roll:
User avatar
MichaelC
Consultant
Consultant
Posts: 3642
Joined: Mon Dec 21, 2009 3:36 pm
Location: Surrey, UK
Name: Michael Cullum
Contact:

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by MichaelC »

And have you?
:)
Formerly known as Unknown Bliss.
Formerly Website Team Lead/Manager & Development Team.
Please don't PM me for support (or stuff that belongs in the forums or tracker) but otherwise feel free
ricjonhay
Registered User
Posts: 247
Joined: Tue Feb 16, 2010 6:08 pm

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by ricjonhay »

To be honest it is not something I have ever done :?
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51669
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by stevemaury »

How much memory has your host allocated for MySQL? Because it looks like less than 16 MiB, in which case it is inadequate to run phpBB.

Also,what is your setting for View online time span in the ACP, Load settings?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
ricjonhay
Registered User
Posts: 247
Joined: Tue Feb 16, 2010 6:08 pm

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by ricjonhay »

stevemaury wrote:How much memory has your host allocated for MySQL? Because it looks like less than 16 MiB, in which case it is inadequate to run phpBB.

Also,what is your setting for View online time span in the ACP, Load settings?
How much memory do you recommend Steve and its been reduced to 15 minutes but will take it back down to default time
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51669
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by stevemaury »

16 MiB would be the minimum,particularly if your posts often have special characters.

If you change from 15 to 5 minutes, that query will generally take less memory.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
ricjonhay
Registered User
Posts: 247
Joined: Tue Feb 16, 2010 6:08 pm

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by ricjonhay »

For the record its 32MB according to my hosts
User avatar
d1m0
Registered User
Posts: 127
Joined: Wed Nov 25, 2009 9:20 am

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by d1m0 »

Provided that you have over 36 mods installed, it is no surprise that you are having such issues. I would advise you to disable as many mods as possible, this should significantly reduce your forum's memory usage and, hopefully, will resolve your issue.

The other alternative would be to start looking for a more powerful hosting solution.
SiteGround Technical Support Team Member
Check out our special phpBB hosting package
ricjonhay
Registered User
Posts: 247
Joined: Tue Feb 16, 2010 6:08 pm

Re: SQL ERROR [ mysql4 ] - Out of memory

Post by ricjonhay »

The issue has been sorted, the host expanded the memory so all is good .
Locked

Return to “[3.0.x] Support Forum”