Can't delete Topics/Messages

[JimM]

If you are on a shared server these settings are not normally available for you to change.  You would have to contact your host.

[EvilDeeds]

If you are on a shared server these settings are not normally available for you to change.  You would have to contact your host.

I got a Virtual Private Server, so I think I can change everything if I want..
But I was in my /etc/ map en found my.cnf then I searched for wait_timeout and connect_timeout settings, but I coudln't find them..

[JimM]

You sure can and if the value isn't in your my.cnf file then you just add it.  Add each on a separate line and the time is expressed in seconds. 

[EvilDeeds]

You sure can and if the value isn't in your my.cnf file then you just add it.  Add each on a separate line and the time is expressed in seconds.

And what do I need to add, can't find that on http://docs.simplemachines.org/index.php?topic=1501.0.
And if I change it, in how many seconds I have to configure it?

[JimM]

Add:

connect_timeout=10
wait_timeout=28800

Start with these values and you can tweak from there.

[EvilDeeds]

Databasefout: Lost connection to MySQL server during query
Bestand: /srv/www/vhosts/coole******.nl/httpdocs/Sources/RemoveTopic.php
Regel: 368

Still error; I doubled the connect_timeout en wait_timeout..
What else can be the problem?

[JimM]

Did you restart MySQL?  You would have to restart it for the changes to take affect.

[EvilDeeds]

Did you restart MySQL?  You would have to restart it for the changes to take affect.

Jep I restarted it with # service mysqld restart.

[Aleksi "Lex" Kilpinen]

Just a thought, but I've seen 404's sometimes when mysql hits the max_allowed_packet limit, so that is an option to check as well

[EvilDeeds]

I think the chance that something is wrong with MySQL very little. Because other forums DO work on my server..

Is there nothing wrong with:
File: /srv/www/vhosts/coole******.nl/httpdocs/Sources/RemoveTopic.php
Line: 368

Which says;
WHERE ID_TOPIC $condition", __FILE__, __LINE__);

Just a thought, but I've seen 404's sometimes when mysql hits the max_allowed_packet limit, so that is an option to check as well

It's no 404 page.. It was with IE, but FF is only showing the error.

Also I CAN delete normal messages, but no topics.

[JimM]

Is there nothing wrong with:
File: /srv/www/vhosts/coole******.nl/httpdocs/Sources/RemoveTopic.php
Line: 368

Which says;
WHERE ID_TOPIC $condition", __FILE__, __LINE__);

That's the line that deletes the topic from the smf_messages table.  Here is the line before that on in a unmodified RemoveTopic.php file:

Code Select Expand

DELETE FROM {$db_prefix}messages
WHERE ID_TOPIC $condition", __FILE__, __LINE__);

[EvilDeeds]

Is there nothing wrong with:
File: /srv/www/vhosts/coole******.nl/httpdocs/Sources/RemoveTopic.php
Line: 368

Which says;
WHERE ID_TOPIC $condition", __FILE__, __LINE__);

That's the line that deletes the topic from the smf_messages table.  Here is the line before that on in a unmodified RemoveTopic.php file:

Code Select Expand

DELETE FROM {$db_prefix}messages
WHERE ID_TOPIC $condition", __FILE__, __LINE__);

Hm, I really don't know what the cause of the error is then.. ;x

[JimM]

Any update on this EvilDeeds?  Are you still getting the "Lost connection to MySQL server during query" errors?

[EvilDeeds]

Any update on this EvilDeeds?  Are you still getting the "Lost connection to MySQL server during query" errors?

Yeah, I still getting those errors.. I really don't know it anymore..
Sorry for late response was very busy with school..

[JimM]

So I take it you still can't delete topics?  Are you the only one with permission to delete topics?

[EvilDeeds]

So I take it you still can't delete topics?  Are you the only one with permission to delete topics?

Jep, I'm the only admin and moderator.

[JimM]

Any update on this EvilDeeds? 

[EvilDeeds]

Well update,

I installed a fresh SMF on my site, no problem I could delete topics/messages. But now of a sudden I can't delete topics anymore. It looks like at x topics, I can't delete any topics anymore.
I don't know at which number..

Still got the same error, Database error.

And sorry for my bad English..

Greetings,

EvilDeeds

[JimM]

That is definitely strange.

Something had to change if it worked fine for a bit and then at some point it stopped.  Did you edit any files or add any mods about the time that it stopped?

[EvilDeeds]

That is definitely strange.

Something had to change if it worked fine for a bit and then at some point it stopped.  Did you edit any files or add any mods about the time that it stopped?

No, with everything I changed I tried if I could delete a topic. And nothing went bad after I changed the Theme and installed the AEVA mod. So I thought the problem was gone, but I tried a few days ago and I got the same error again.