Version: , by TWTCommish
Developer Last Online: Dec 2022
Version: Unknown
Rating:
Released: 02-18-2002
Last Update: Never
Installs: 0
No support by the author.
Alright, I'm stumped. I keep getting an error when I try to update my forum info counters. I've looked in the code, but the error I'm getting gives me little to work with, as it doesn't display any actual query. Can someone help me out?
I am getting the same thing! It's coming from all over the place too. I upgraded to 2.2.4 and appiled a couple of the hacks on this board. Now I get about 20-30 emails daily with this error.
I know the error is triggered by the "fetch_array" method in the DB class, but that is called by the "query_first" method too, so it's hard to pin down the exact cause.
The various referrers have been:
usercp.php
member.php
private.php
memberlist.php
Here are the hacks I have installed as well:
vBstats
Post Counter & Direct Link
New code, PHP and quote boxes!
Download PM's to File
vBpad
Reason for post edit
Improved PM popup Javascript
I can't revert to anything older, I'm on a shared server. Anyway, I am a little confused as to why that would be a problem. I didn't think there were any queries that would be effected by any newer versions of MySQL.
I got the same error for some reason when someone posted in my forum the other day. I can't delete it or view it to see what the problem is. Here is the email that keeps getting sent to me when someone trys to view it:
-------------------------
Database error in vBulletin Mod Control Panel 2.2.4:
Invalid SQL: SELECT userid,attachmentid,postid FROM post WHERE
threadid='70'
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Sunday 07th of April 2002 02:08:35 PM
Warning: MySQL: Unable to save result set
Invalid SQL: SELECT COUNT(*) AS posts FROM post WHERE post.threadid='70' AND post.visible=1
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Sunday 07th of April 2002 02:19:34 PM
There seems to have been a slight problem with the ->Infection database. Please try again by pressing the refresh button in your browser. An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists. We apologise for any inconvenience. Database error in vBulletin 2.2.4:Invalid SQL: SELECT COUNT(*) AS posts FROM post WHERE post.threadid='70' AND post.visible=1mysql error: Got error 127 from table handlermysql error number: 1030Date: Sunday 07th of April 2002 02:19:34
--------------------
Originally posted by TWTCommish I can't revert to anything older, I'm on a shared server. Anyway, I am a little confused as to why that would be a problem. I didn't think there were any queries that would be effected by any newer versions of MySQL.
Newer versions of software sometimes break things. I think you would be aware of that from vBulletin. A client of mine had this problem with a vague error caused by perfect queries on an uncorrupted database. The host had just upgraded her to the latest version of MySQL. I told her to have her host put her back on the version she was at. As soon as it was, the problem vanished. YMMV but you should be open to suggestions as to what the cause of the problem could be.
Originally posted by Lethal I got the same error for some reason when someone posted in my forum the other day. I can't delete it or view it to see what the problem is. Here is the email that keeps getting sent to me when someone trys to view it:
-------------------------
Database error in vBulletin Mod Control Panel 2.2.4:
Invalid SQL: SELECT userid,attachmentid,postid FROM post WHERE
threadid='70'
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Sunday 07th of April 2002 02:08:35 PM
Warning: MySQL: Unable to save result set
Invalid SQL: SELECT COUNT(*) AS posts FROM post WHERE post.threadid='70' AND post.visible=1
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Sunday 07th of April 2002 02:19:34 PM
There seems to have been a slight problem with the ->Infection database. Please try again by pressing the refresh button in your browser. An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists. We apologise for any inconvenience. Database error in vBulletin 2.2.4:Invalid SQL: SELECT COUNT(*) AS posts FROM post WHERE post.threadid='70' AND post.visible=1mysql error: Got error 127 from table handlermysql error number: 1030Date: Sunday 07th of April 2002 02:19:34
--------------------
Can someone please help me out with this?
You have a different problem. Your database is corrupted. You need to run repair.php on it.
Originally posted by freddie Newer versions of software sometimes break things. I think you would be aware of that from vBulletin. A client of mine had this problem with a vague error caused by perfect queries on an uncorrupted database. The host had just upgraded her to the latest version of MySQL. I told her to have her host put her back on the version she was at. As soon as it was, the problem vanished. YMMV but you should be open to suggestions as to what the cause of the problem could be.
I never said I disagreed, Freddie. I said I was confused as to why it would be an issue. If you take that as me questioning your knowledge or something of the sort, well, I'm sorry. It's not what I meant, or said, at all.
Anyway, as I said, it's not an option. Do you know of any queries offhand that could be causing this? Is there any relatively easy way around it?
Details »»
About Developer
Visit Web Site
No support by the author.
03-31-2002, 03:02 PM
