Private Message Database Error

[keenan]

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT pm.*, pmtext.*
				, icon.title AS icontitle, icon.iconpath
			FROM pm AS pm
			LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
			LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
			WHERE pm.userid=1 AND pm.folderid=0
			ORDER BY pmtext.dateline DESC
			LIMIT 0, 50
		
mysql error: Got error -1 from table handler

mysql error number: 1030

Date: Sunday 17th of April 2005 03:00:55 PM
Script: http://www.blizzardfortress.com/forum/private.php?
Referer: 
Username: keenan

All of my members say they aren't having a problem though?

[Steve Machol]

Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

[keenan]

I ran the thing 6 times now... It's not helping :S

[Steve Machol]

Do all tables show 'ok'? If so, then reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Then change to this style and view your forums with it. Do you have the same problem?

[keenan]

I could do that but the problem is that I've got a large number of hacks installed on my forum and I don't really want to reinstall them :X

The only thing I did last night was made a few changes to init.php, adminpermissions.php, and admincp/index.php

[Dennis Olson]

"The only thing I did was..."

Yeah, and you broke it. Dude, if you want support here (as opposed to vB.org), you need to uninstall the hacks. It's apparent that something you did trashed it.

[keenan]

Well you sure put that nicely. I hope you weren't trying to make a friend with that post because it makes me want to E-slap you

On another note, I just got home from work and everything works fine... The strange thing is I didn't touch it. 'Must have been some server issues. Thanks for the help Steve.. I appreciate it.

[Dennis Olson]

Nice or not, I've been a programmer for over 30 years. I know when I break something. I know I gotta fix it. Usually, I know approximately where I did it and why. The oldest adage in IT: "you broke it, you fix it." I'm glad to hear your board is up & running, but you get no sympathy from me....

[keenan]

Nice or not, I've been a programmer for over 30 years. I know when I break something. I know I gotta fix it. Usually, I know approximately where I did it and why. The oldest adage in IT: "you broke it, you fix it." I'm glad to hear your board is up & running, but you get no sympathy from me....

Haha. Let me guess, 30 years ago you were programming on... stone with your chisel and mallet?

95% of the time I know when I've broken something, but the reason I didn't know what was going on is because everything was running fine the night before when I did the work. Besides, all I customized were a few admincp settings

[Dennis Olson]

Honeywell 66/20, HP-2000 series, etc. Stuff that actually required skill, unlike today's hand-holding software that lets any idiot think they're a programmer....

Bottom line: All your protestations aside, you broke it, but are either too obtuse or too stubborn to see that.

LMAO

[keenan]

Honeywell 66/20, HP-2000 series, etc. Stuff that actually required skill, unlike today's hand-holding software that lets any idiot think they're a programmer....

Bottom line: All your protestations aside, you broke it, but are either too obtuse or too stubborn to see that.

LMAO

But it works fine...? How could I have broken something if I didn't brake it?

[Dennis Olson]

Man, i f I had a nickel for every time I either SAID that, or HEARD it... you know?

[Steve Machol]

Since you have hacks on your forums and you do not want to restore the original files, you'll need to ask for further help at www.vbulletin.org.

[keenan]

Lol. You can close this thread... Everything seems to be working okay

[etom]

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50

mysql error: Got error 28 from table handler
mysql error number: 1030

There seems to be a real problem somewhere in vBulletin or MySQL!

Suddenly I am getting exactly error (just for my account), but
- no code changes before that
- there is enough free disk space
- tables are ok, manually checked (-r and -o options) many times
- database restarted etc.
- it doesn't disappear !

The strange thing: If you remove the ORDER BY clause, the query works !!!
Thus this seems to be a MySQL-Bug ?!

Please help, it's very annoying if the admin (me) has to read his PM through mysql command line interface

Greetings
Tom