Database ERROR

All Help Appreciated

My site has started generating database errors with video uploads. Before there was no problem, now = problem

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-1610611985 1073750091 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {mso-style-noshow:yes; mso-style-priority:99; mso-style-link:"Plain Text Char"; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; font-family:Consolas; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} span.PlainTextChar {mso-style-name:"Plain Text Char"; mso-style-noshow:yes; mso-style-priority:99; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Plain Text"; mso-ansi-font-size:10.5pt; mso-bidi-font-size:10.5pt; font-family:Consolas; mso-ascii-font-family:Consolas; mso-hansi-font-family:Consolas;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -->

Database error in Over Two Wheels Only

Query:

SELECT 1 FROM RayMovieFiles WHERE Uri = 'skyler' LIMIT 1

Mysql error:

MySQL server has gone away

Found error in file /home/overtwon/public_html/inc/utils.inc.php

at line 744. Called db_arr function

with erroneous argument #0

Debug backtrace:

Array

(

[1] => Array

(

[file] => /home/overtwon/public_html/inc/db.inc.php

[line] => 115

[function] => db_res

[args] => Array

(

[0] => SELECT 1 FROM RayMovieFiles WHERE Uri = 'skyler' LIMIT 1

[1] => 1

)

)

[2] => Array

(

[file] => /home/overtwon/public_html/inc/utils.inc.php

[line] => 744

[function] => db_arr

[args] => Array

(

[0] => SELECT 1 FROM RayMovieFiles WHERE Uri = 'skyler' LIMIT 1

)

)

[3] => Array

(

[file] => /home/overtwon/public_html/inc/utils.inc.php

[line] => 719

[function] => uriCheckUniq

[args] => Array

(

[0] => skyler

[1] => RayMovieFiles

[2] => Uri

)

)

[4] => Array

(

[file] => /home/overtwon/public_html/ray/modules/movie/inc/customFunctions.inc.php

[line] => 13

[function] => uriGenerate

[args] => Array

(

[0] => skyler

[1] => RayMovieFiles

[2] => Uri

[3] => 255

)

)

[5] => Array

(

[file] => /home/overtwon/public_html/ray/modules/movie/inc/actions.inc.php

[line] => 188

[function] => genUri

[args] => Array

(

[0] => skyler

)

)

[6] => Array

(

[file] => /home/overtwon/public_html/ray/XML.php

[line] => 42

[args] => Array

(

[0] => /home/overtwon/public_html/ray/modules/movie/inc/actions.inc.php

)

[function] => require_once

)

)

Called script: /ray/XML.php

Request parameters:

Array

(

[module] => movie

[action] => initFile

[id] => 1

[_t] => 32585

[description] => Skyler

[tags] => skyler

[title] => skyler

[bblastvisit] => 1222462335

[bblastactivity] => 0

[memberID] => 1

[memberPassword] => 413d6f9b539dd45480cb2a05c47ecdc5

[bbsessionhash] => 6f69eb620796f94b06d02a14415b33ae

[bbthread_lastview] => 117ea30a0a7b68db228d5cb18cc79bf0a-1-{i-25_i-1222913267_}

)

--

Auto-report system

Quote · 3 Oct 2008

Answer to question call server my guess is you have osx. Tell them to make your mysql run time higher will work Drew.

Quote · 4 Oct 2008

.. try to restart your SQL server .. possible you fill max amount of connections at your server ..
and .. in same strange situations I recommend you not neglect searching in google :) - it helps often

Quote · 6 Oct 2008

I tried a google search on it, came up empty. I am not sure how to restart my sql server?

Quote · 6 Oct 2008

You need just to contact your hosting and ask them to enlarge timeout and after it to restart MySQL server.

They should help you.

Regards

Artur A

Quote · 7 Oct 2008

Why search result (from google) is empty - just now I cheched,

http://www.google.com/search?hl=en&q=MySQL+server+has+gone+away&btnG=Google+Search&aq=f&oq=

it give me tonns of result.

Seems you even not used search.

First link in search results was

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

open it, here total description of this error, reading:

The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. In this case, you normally get one of the following error codes (which one you get is operating system-dependent) ...

By default, the server closes the connection after eight hours if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld. See Section 5.1.3, “System Variables”.

So yes - just change timeout value of your SQL server.

Quote · 7 Oct 2008
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.