SQL Error

[Rodricks]

When I am trying to post a message on my board and I get this:

General Error
SQL ERROR [ mysqli ]

MySQL server has gone away [2006]

SQL

SELECT topic_type, forum_id FROM phpbb_topics WHERE topic_id = 0

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: posting.php
LINE: 872
CALL: dbal_mysqli->sql_query()

I don't know how to solve this problem.Please help

[Glenn]

You may face this problem MySQL connection being terminated due to it being idle longer than 45 seconds(According to setting in my.cnf) this may be because of poor script design.

Generally script are designed such way while posting it preparing the data to be inserted and then make connection to database hosted on the server. But it seems that script used by your site is connect to the database before preparing the data to be inserted. And so whole process take more than 45 sec (According to setting in my.cnf). So either increase the limit in my.cnf or resolve it by making modification in the script.

Glenn

[Christina]

Guys,

Even i have been facing the some SQL error on my forum :

rror in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1172317260, 15, 0, 0, 0)' at line 1

INSERT INTO thaiwahn_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('Euer Delitant', , 1172317260, 15, 0, 0, 0)

Line : 228
File : functions_post.php

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1172312402, 15, 0, 0, 0)' at line 1

INSERT INTO thaiwahn_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('Seitenzahlen', , 1172312402, 15, 0, 0, 0)

Line : 228
File : functions_post.php

Please advice :(

[Rodricks]

Originally Posted by glenn

You may face this problem MySQL connection being terminated due to it being idle longer than 45 seconds(According to setting in my.cnf) this may be because of poor script design.

Generally script are designed such way while posting it preparing the data to be inserted and then make connection to database hosted on the server. But it seems that script used by your site is connect to the database before preparing the data to be inserted. And so whole process take more than 45 sec (According to setting in my.cnf). So either increase the limit in my.cnf or resolve it by making modification in the script.

Glenn

I have modified the script and now it start working thanks glenn.

[Glenn]

Originally Posted by Christina

Guys,

Even i have been facing the some SQL error on my forum :

rror in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1172317260, 15, 0, 0, 0)' at line 1

INSERT INTO thaiwahn_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('Euer Delitant', , 1172317260, 15, 0, 0, 0)

Line : 228
File : functions_post.php

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1172312402, 15, 0, 0, 0)' at line 1

INSERT INTO thaiwahn_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('Seitenzahlen', , 1172312402, 15, 0, 0, 0)

Line : 228
File : functions_post.php

Please advice :(

It seems problem of mysql version conflict. Means script developed for a version mysql 4.X.X and is being used for mysql 4.Y.Y . So you need to make the changes in the script according to the version of mysql which is used to run this script.


Glenn.

[BodShane]

Perhaps, you may have to attempt it now. Check in with the versions and let us know if it has worked.

[Christina]

Originally Posted by Admin

Perhaps, you may have to attempt it now. Check in with the versions and let us know if it has worked.

Thanks for your reply.

I will check it and let you know soon.

[BodShane]

Your welcome. We will await for the updates from your end.

[Christina]

Thanks Glenn,
I had made the changes in the script according to the version and now it is working fine.