Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Web Coding › PHPBB3 MYSQL ERROR : Need help urgently
New Posts  All Forums:Forum Nav:

PHPBB3 MYSQL ERROR : Need help urgently

post #1 of 2
Thread Starter 



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.
Saibot
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel E6600 DFI P965-S Dark EvGa 8800GTX 2gigs G SKILL D9 4-4-4-12 DDR800 
Hard DriveOptical DriveOSMonitor
2x320gig Seagates (RAID 0) DVD-ROM / CD-RW Microsoft XP Pro Acer 24" 1920x1200 5ms LCD 
KeyboardPowerCaseMouse
Logitech Gaming Keyboard Corsair hx620w Modular Ultra Aluminus: Glossy Black Razer Diamondback (red) 
Mouse Pad
Icemat v2 
  hide details  
Reply
Saibot
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel E6600 DFI P965-S Dark EvGa 8800GTX 2gigs G SKILL D9 4-4-4-12 DDR800 
Hard DriveOptical DriveOSMonitor
2x320gig Seagates (RAID 0) DVD-ROM / CD-RW Microsoft XP Pro Acer 24" 1920x1200 5ms LCD 
KeyboardPowerCaseMouse
Logitech Gaming Keyboard Corsair hx620w Modular Ultra Aluminus: Glossy Black Razer Diamondback (red) 
Mouse Pad
Icemat v2 
  hide details  
Reply
post #2 of 2
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.
Powered By Xeon
(15 items)
 
Dragon
(13 items)
 
Reborn
(13 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon X3320 (45nm Quad) ASUS Maximus "Rampage" Formula SE HIS HD 4850 IceQ 4 Turbo Crucial Ballistix Tracer DDR2 
Hard DriveOptical DriveCoolingOS
WD Raptor + WD Caviar SE16 (x2) ASUS 2014L1T 20x DVD-RW Thermalright Ultima-90 Windows 8 Pro 
MonitorKeyboardPowerCase
Samsung 226BW Logitech diNovo Keyboard Corsair HX-620 Cooler Master RC-690 
MouseAudio
Microsoft Touch Mouse Logitech G51 (5.1 Surround) 
CPUMotherboardGraphicsRAM
Intel Pentium Dual-Core E2160 Gigabyte G41MT-ES2L Intel GMA X4500 G.Skill NQ DDR3 
Hard DriveOptical DriveOSPower
Western Digital + Seagate Barracuda Green (x2) Lite-On DVD-RW FreeBSD 9.0 SHAW 680W 
CPUMotherboardGraphicsRAM
Intel Pentium 4 w/HT (Northwood) Gigabyte 8S655FX-L ATI Radeon 9800 Pro OCZ Gold DDR 
Hard DriveOptical DriveOSMonitor
Toshiba IDE Pioneer DVD-RW DVR-109 Linux Mint 12 Viewsonic 15" VA520 
KeyboardPowerMouse
Microsoft Wireless Desktop Elite Generic 450W Microsoft Wireless IntelliMouse Explorer 2.0 
  hide details  
Reply
Powered By Xeon
(15 items)
 
Dragon
(13 items)
 
Reborn
(13 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon X3320 (45nm Quad) ASUS Maximus "Rampage" Formula SE HIS HD 4850 IceQ 4 Turbo Crucial Ballistix Tracer DDR2 
Hard DriveOptical DriveCoolingOS
WD Raptor + WD Caviar SE16 (x2) ASUS 2014L1T 20x DVD-RW Thermalright Ultima-90 Windows 8 Pro 
MonitorKeyboardPowerCase
Samsung 226BW Logitech diNovo Keyboard Corsair HX-620 Cooler Master RC-690 
MouseAudio
Microsoft Touch Mouse Logitech G51 (5.1 Surround) 
CPUMotherboardGraphicsRAM
Intel Pentium Dual-Core E2160 Gigabyte G41MT-ES2L Intel GMA X4500 G.Skill NQ DDR3 
Hard DriveOptical DriveOSPower
Western Digital + Seagate Barracuda Green (x2) Lite-On DVD-RW FreeBSD 9.0 SHAW 680W 
CPUMotherboardGraphicsRAM
Intel Pentium 4 w/HT (Northwood) Gigabyte 8S655FX-L ATI Radeon 9800 Pro OCZ Gold DDR 
Hard DriveOptical DriveOSMonitor
Toshiba IDE Pioneer DVD-RW DVR-109 Linux Mint 12 Viewsonic 15" VA520 
KeyboardPowerMouse
Microsoft Wireless Desktop Elite Generic 450W Microsoft Wireless IntelliMouse Explorer 2.0 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Web Coding
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Web Coding › PHPBB3 MYSQL ERROR : Need help urgently