Overclock.net - Overclocking.net
     
 
Home Gallery Reviews Blogs Register Today's Posts Mark Forums Read Members List


Go Back   Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming > Web Coding

Reply
 
LinkBack Thread Tools
Old 05-14-08   #1 (permalink)
PC Gamer
 
TrAncE XD's Avatar
 
intel nvidia

Join Date: Jun 2005
Location: Naperville, IL
Posts: 2,279

Rep: 160 TrAncE XD is acknowledged by manyTrAncE XD is acknowledged by many
Unique Rep: 122
FAQs Submitted: 4
Trader Rating: 0
Default PHPBB3 MYSQL ERROR : Need help urgently




This error occurs whenever someone tries to register a new account with the forums.


In the error logs it says :

E-mail error
» EMAIL/PHP/mail()
/phpBB3/ucp.php

For the action, however, sometimes its not ucp.php...




It's definetely something to do with the mysql database, and I have full access to the database.

System: Saibot
CPU
Intel E6600
Motherboard
DFI P965-S Dark
Memory
2gigs G SKILL D9 4-4-4-12 DDR800
Graphics Card
EvGa 8800GTX
Hard Drive
2x320gig Seagates (RAID 0)
Sound Card
XFI XtremeMusic
Power Supply
Corsair hx620w Modular
Case
Ultra Aluminus: Glossy Black
CPU cooling
Enzotech Ultra-x
GPU cooling
Stock
OS
Microsoft XP Pro
Monitor
Acer 24" 1920x1200 5ms LCD
TrAncE XD is offline   Reply With Quote
Old 05-15-08   #2 (permalink)
Programmer
 
Dismounted's Avatar
 
intel ati

Join Date: Oct 2007
Posts: 290

Rep: 29 Dismounted is acknowledged by some
Unique Rep: 20
Folding Team Rank: 557
Hardware Reviews: 2
Trader Rating: 0
Default

The most common reasons for the MySQL server has gone away error are:

1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.

2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.

i.e. to check mysql uptime, in shell as root user type:

mysqladmin -u root -p version

3. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row

4. Or simply your host restarted MySQL. I'd contact your web host and ask him to look into this.
__________________
System: Powered By Xeon
CPU
Intel Xeon X3320 (45nm Quad)
Motherboard
ASUS Maximus "Rampage" Formula SE
Memory
4GB (4x1GB) Crucial Ballistix Tracer DDR2-800
Graphics Card
ASUS EAH3870 512MB
Hard Drive
WD Raptor 150GB, WD Caviar SE16 500GB + 250GB
Sound Card
ASUS SupremeFX II
Power Supply
Corsair HX-620
Case
Cooler Master RC-690
CPU cooling
Thermalright Ultima-90I
GPU cooling
Stock
OS
Windows Vista 64-bit
Monitor
Samsung 226BW
Dismounted is offline I fold for Overclock.net   Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools



All times are GMT -4. The time now is 12:00 AM.


Overclock.net is a Carbon Neutral Site Creative Commons License Internet Security By ControlScan

Terms of Service / Forum Rules | Privacy Policy | Advertising | Become an Official Vendor
Copyright © 2008 Shogun Interactive Development. Most rights reserved.
Page generated in 0.11166 seconds with 9 queries