PDA

View Full Version : 78 Database errors :S NEED HELP ! :(


Dutch_Boy
07-20-2009, 05:30 PM
Hello,

I just got 78 database errors and they are all allmost the same.

Database error in vBulletin 3.8.3:

Invalid SQL:

REPLACE INTO vb_datastore
(title, data, unserialize)
VALUES
('template_lvl2_post', 'N;', 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, July 20th 2009 @ 08:24:04 PM
Error Date : Monday, July 20th 2009 @ 08:24:34 PM
Script : http://iwsgaming.nl/member.php?u=102
Referrer : http://images.google.com/imgres?imgurl=http://iwsgaming.nl/images/commerce/items/M4A1NEW.jpg&imgrefurl=http://iwsgaming.nl/member.php%3Fu%3D102&usg=__DZ-yKEhn8iJnEMvc3kYQh08VvpE=&h=300&w=576&sz=14&hl=nl&start=2&um=1&tbnid=LS8-QqxVRoz4tM:&tbnh=70&tbnw=134&prev=/images%3Fq%3Dm4a1%26hl%3Dnl%26client%3Dopera%26rls %3Dnl%26sa%3DG%26um%3D1
IP Address : 94.229.51.230
Username : Niet geregistreerd
Classname : vB_Database
MySQL Version :

The only thing what is diffrent is the link.

Plz can some tell me how to fix this!!

Kind regards,

Dutch_Boy.

--------------- Added 1248115455 at 1248115455 ---------------

Every link in the database error brings me to a profile of a member on my forum. And it shows in the upper left corner a picture.

Link in google. If you looking for a picture and you open it, it will be shown in the upper left corner.

HMBeaty
07-20-2009, 06:06 PM
That is a problem with your host. You need to contact your host to fix this problem.

Lynne
07-20-2009, 06:15 PM
MySQL server has gone away is a server error. You should talk to your host about this.

Dutch_Boy
07-20-2009, 06:27 PM
I just sended a e-mail to my host.

Thanks for the info!

--------------- Added 1248185154 at 1248185154 ---------------

Problem solved. Forum moved to a new server.

Thanks again!

Dutch_Boy
07-22-2009, 01:02 PM
Ok i dont wanna make a new topic for this. Because it happend after moving to the new server.

I got another problem. After moving to the new server i got this problem.

Warning: Division by zero in [path]/moderation.php(902) : eval()'d code on line 25

How can i fix this?

I see this when i wanna accept a post of a member on my forum.

Lynne
07-22-2009, 02:11 PM
Warning: Division by zero in [path]/moderation.php(902) : eval()'d code on line 25

Line 902 of moderation.php is:
eval('$postbits .= "' . fetch_template('search_results_postbit') . '";');

So, your error is from a modification using the search_results_postbit hook location.

Dutch_Boy
07-22-2009, 05:11 PM
Im putting this on a hold for a sec. Because my vBCommerce stop working 2 days ago and that mod uses postbits.

Maybe thats the problem because i turned all the other mods off that i just installed and it didnt go away.

--------------- Added 1248287732 at 1248287732 ---------------

Ok? the vbcommerce is online and working. And this doesnt cause the problem.

Im going to turn all the mods i installed on my forum offline in 1 hour en 30 min. Thats 22:00 in dutch time :)

I hope this will tell me what mod is causing this problem.

Are there other ways to find out what cause this problem?

Lynne
07-22-2009, 09:53 PM
Turning off the modifications that use that hook location is really the only way to figure out what is wrong. Well, or look at every plugin using that hook location and then see if line 25 of the plugin has an error. If you can spot it that way, then great.

Dismounted
07-22-2009, 11:43 PM
It's actually caused by malformed code in a template called search_results_postbit, not a plugin.

Lynne
07-23-2009, 02:15 AM
It's actually caused by malformed code in a template called search_results_postbit, not a plugin.
Glad you spotted that. How did I miss that? Oh boy... too much sun on the brain right now!

Dutch_Boy
07-23-2009, 11:04 AM
It's actually caused by malformed code in a template called search_results_postbit, not a plugin.

How can i fixs this. Or is it not a really big problem. If it doesnt matter then ill let it like this.

Dismounted
07-23-2009, 11:24 AM
Please post the template.

Dutch_Boy
07-23-2009, 05:35 PM
<a href="https://vborg.vbsupport.ru/showthread.php?t=202790&highlight=vB_Dark" target="_blank">https://vborg.vbsupport.ru/showt...hlight=vB_Dark</a>

noWhine! 3.8.x.zip

The last one.

Dismounted
07-24-2009, 10:20 AM
Please just post the template you have from your Admin CP. You may have made modifications to it, and thus, would not show on another download.

Dutch_Boy
07-26-2009, 12:50 AM
Is it possible that thinks like this just go away by them self? Because the error is gone :S

Dismounted
07-26-2009, 05:21 AM
It's possible. The underlying problem is a division/logic error, and when the value changes, the error "disappears". The root cause is still there though.