vb.org Archive - database error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - database error (https://vborg.vbsupport.ru/showthread.php?t=202326)

geevest.com

01-19-2009 10:15 AM

database error

i get this database error message :

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:



                                SELECT smilieid, smilietext, smiliepath, smilie.title,

                                        imagecategory.title AS category

                                FROM smilie AS smilie

                                LEFT JOIN imagecategory AS imagecategory USING(imagecategoryid)

                                ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder;



MySQL Error   : Out of memory (Needed 322122456 bytes)

Error Number  : 5

Request Date  : Monday, January 19th 2009 @ 07:13:57 AM

Error Date    : Monday, January 19th 2009 @ 07:13:57 AM

Script        : http://abc.com/forum/newreply.php?do=newreply&noquote=1&p=242779

Referrer      : http://abc.com/forum/showthread.php?p=242779

IP Address    : 

Username      : name

Classname     : vB_Database

MySQL Version : 5.0.67-community

how i can fixed this issue? tq

SEOvB

01-19-2009 10:18 AM

Upgrade your hosting, or contact your hosting company

Try disabling modifications and addons as well i suppose

geevest.com

01-19-2009 10:21 AM

i take dedicated server for this bro,
500$/month.so its not enough?
it just i need to upgrade my RAM or what?

SEOvB

01-19-2009 10:25 AM

How much ram do you have?

Is your server optimized, or are you simply throwing all the hardware it can contain at it?

Try

Make a my.cnf backup before doing

Code:

cp /etc/my.cnf /etc/my.cnf.prev

Then change following values on /etc/my.cnf to

Code:

nano /etc/my.cnf

Code:

max_connections=500

wait_timeout = 30

query_cache_limit=2M

query_cache_size=24M

Restart mysql.

Code:

service mysqld restart

This should help

geevest.com

01-19-2009 10:40 AM

i have 4GB ram friend.visitor 20.000/day so its not enough? or i need to upgrade my ram?

Marco van Herwaarden

01-19-2009 10:55 AM

I would start by posting an optimisation request at vB.com.

SEOvB

01-19-2009 10:57 AM

Quote:

Originally Posted by geevest.com (Post 1717720)

i have 4GB ram friend.visitor 20.000/day so its not enough? or i need to upgrade my ram?

I dont know, there are lots of variables.

How many modifications?
What do those visitors do while there?
Is your server optimized?
Do you run anything other than vBulletin?

That error tells you 1 thing. Your MySQL is out of allowed memory

Solutions: Optimize Server/MySQL, Remove modifications/plugins, Throw more RAM and get the same error in a few weeks probably

I suggest posting over at vBulletin.com Server optimization forum: http://www.vbulletin.com/forum/forumdisplay.php?f=14

geevest.com

01-20-2009 05:22 AM

hello,now im already upgrade my server and Ram in to 8GB.
until now im always getting database error.
yes i have 3sites in 1dedicated server but other site is simple dont have traffic.that just blogs and imageshare.
do i need to disable all plugins?

SEOvB

01-20-2009 05:39 AM

no you shouldn't

And adding more ram may not solve your issue if you don't allow MySQL access to the more ram.

Post in the server optimization forum and you could probably save some money: http://www.vbulletin.com/forum/forumdisplay.php?f=14

Dismounted

01-20-2009 07:57 AM

Make sure you're running a 64-bit OS, otherwise, your RAM won't be fully utilised.

All times are GMT. The time now is 06:31 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01005 seconds Memory Usage 1,731KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: