Problem with posting

[dedanna1029]

Screw it. This way way SUCKS. F*ck it.

I'm sick of this happening.

Glad you think it's so effing great. <sarcasm>

Even if I had had too many characters (which I seriously doubt is the case), or had code that it didn't like (which I KNOW isn't the case on this) this thing could effing pop up with "you have reached too many characters", and give us chance to go back and edit.

As it is, I find this stupid mysql thing to be just that - stupid. It makes us lose posts (and sometimes we DO have an important one or 2, y'know), it screws us over big time. It's ridiculous.

What the hell would you do, if you had a REAL political debater here, say, a new one, and they always got this crap too? The debate wouldn't piss them off, dealing with errors in posting would!!!

[viking60]

I am seriously doubting the value of a REAL political discussion.
Mostly the ones that are not contradicted are happy - and continue and continue and continue - until they are contradicted.. and then.... they get pissed. It is an experiment but I can see the dark clouds. We also risk the "pissed by proxy" effect.

About the technical issues and the quality of Mysql I think it has proven itself as a very good database. If you get a small outage you risk to loose data like you did. It can be a router/ISP thing or a weather thing or just "one of those things". It is hard to diagnose it, and jumping to the conclusion that phpbb or Mysql sucks is premature IMHO.
It might very well be that the error is on your end.
In any case if you put it in the correct forum and others have the same problem I will of course have a look at it. I think I have captured your small and subtle hints.

[dedanna1029]

It's the exact same one I've emailed to you some probably dozen times.

And this time, it did it just in preview mode. I fail to see how it could be on this end when 1) I don't use mysql 2) I'm on the latest chrome browser 3) All plugins necessary to function are installed, and it's happened in almost every browser; FF, Chrome, Iron, Seamonkey, in both Arch and Fedora.

Insofar as to the existence of politics here at the forum, who cares. It's your forum. You don't want politics, don't have politics. I'm sure it makes no diff to anyone here.

[viking60]

From the forum rules:

References to private places PM's or Mail, or to other places outside this forum that cannot be read by the public, have no place in this forum, and do not in any way constitute a valid argument in any discussion.

Please respect them.

Browsers and plugins will not help much if your line goes down for a few seconds, That is what I am talking about. Your router could do it while negotiating DHCP or it could be on your ISP's end. in short a number of reasons (storms in the area lately?) that neither you or I can control. The mere fact that Mysql gives you the error message is not necessarily due to a Mysql error, it only is only natural since you were interacting with the database when your work was interrupted.
It has happened to me too and in that case my router was the sinner (I am thinking of replacing it). It is a good habit to copy long and lasting posts to the clipboard so you have it as a "backup" that will enable you to paste it back.
PS: I have checked and optimized the Mysql tables now.

[dedanna1029]

I just got a new modem... don't use a router.

And actually, this has been discussed here on the forum before... a few times, IIRC, at the very least, referenced to.

viewtopic.php?f=8&t=1183&p=7690&hilit=mysql#p7690

viewtopic.php?f=20&t=962&p=6415&hilit=mysql#p6415

I'm sure there's other references to it if a different search were run as well.

At this point, I am requesting this portion of this thread, posts regarding the mysql error, be split off into another topic. Thanks.

[viking60]

I found a place to split the post (looks strange though). Please start a new thread the next time. And what do the links prove?
That it has been an ongoing problem for years?
It has not! It works fine over 99% of the time here. Problem identified and problem fixed; that is how we do it. No need to dig them up again every time you have a new problem.
"My gas tank is empty"
"See I told you so! It was empty last year too!"
Mysql checked - works just fine. Optimized it for good measure.
Response time is fine here but can be individual in other corners of the world. Probably your corner in this case. There is no way of reproducing your error here.

[dedanna1029]

That was not a speed issue. That was a General mysql error issue. Speed is irrelevant in this. It's the one that pops up here and there when we post, when this thing doesn't like code or something. Except this time, there was no code, there was no any cussing even - there was no reason for it to have done it. And yes, very similar to previous ones.

[dedanna1029]

In fact, here it is.



And a similar one:



That is the exact same kind of thing I got.

[dedanna1029]

My deal with it is this: if we are posting something that the forum software or whatever doesn't like, then why can't we have a popup telling us what it is, and have it give us a chance to edit so that we don't lose the post?

Or can mysql not do that? I've been in forums where they do. If there's something wrong with the post, it tells you so.

[viking60]

Mysql cannot do that, PHP can. If php does not, mysql will give you the error message.
Now looking into the specifics above......

An "Sql error while fetching the page" could clearly be a "time out" problem as I am now stating for the 5th time. Also you need to train your ability to be specific.

First you provide a link to a post with ping times and in your next post you state that speed does not come into it. What we do here is handle one problem per thread NOT all of your problems in one thread.
And I am hoping for some quality in the process. I know it is all about the same computer or the same database, that does not qualify to put all computer or database problems in the same thread. And to link to meaningless other statements (according to yourself!) in the process, does not make it better.

So now to the error you have with your search result:
First out of curiosity: Why are you searching for Chinese letters? The board language is EN!
The error you get is probably a locale setting in Mysql so I guess it can be fixed - But I will not do a shit load of work unless it is a real problem - and not "dedanna needs to be right" problem.
So what is it? How often do you need to search for Chinese letters?
I do not experience problems here so it is hard for me to tell, I will have another look at the database though.
Edit:
You might be experiencing the Mysql 1366 bug:
http://bugs.mysql.com/bug.php?id=1366
And the 1271 bug:
"incorrect result from a query that uses only `const' tables (such as one-row tables) and non-constant expression (such as `RAND()'). (Bug #1271)"
http://bugs.mysql.com/bug.php?id=31416

Those are fixed in the next stable Mysql release.

Changing the system charset to UTF-8 will fix the latter bug - must I?