Data bug thingy Tys

[Dubs]

I tried to edit his post myself and got the following:

Text in the yellow box was:

Database error in vBulletin 3.7.1:
Invalid SQL:
UPDATE vb_post SET
showsignature = 0,
allowsmilie = 1,
title = 'Bike gear',
pagetext = 'Some gear has to go.\nAll of it is approximately 4 months old, being used regularly except for the last month it wasn\'t used at all.\n \nHJC CL-15 helmet SMALL comes with iridium visor - $250 ono\n \nAlpinestars SP-2 leather gloves MEDIUM - Sold\n \nShift SR-1 LARGE - $400 ono',
iconid = 0,
attach = 4,
ame_flag = 2
WHERE postid = 1046485;
MySQL Error : Incorrect key file for table './psb_vb/vb_post.MYI'; try to repair it
Error Number : 126
Request Date : Friday, September 5th 2008 @ 02:58:16 PM
Error Date : Friday, September 5th 2008 @ 02:58:16 PM
Script : http://www.perthstreetbikes.com/foru...postid=1046485
Referrer : http://www.perthstreetbikes.com/foru...ke-gear-64034/
IP Address : 165.12.252.12
Username : Dubs
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

[lee]

Theres also a bug where you can't search for 3 characters anymore *coff*

I'll let u admin ppl sleep with KJ if you fix it

[Pkunk]

That really should be a stored proc, not plain SQL

But I am guessing thats teh board softwares fault

[TYSON]

Originally Posted by lee

Theres also a bug where you can't search for 3 characters anymore *coff*

I'll let u admin ppl sleep with KJ if you fix it

It was fixed last night, just the index needs to be rebuilt.

[TYSON]

Originally Posted by Pkunk

That really should be a stored proc, not plain SQL

But I am guessing thats teh board softwares fault

Board has to support both mysql 4 and mysql5

[Pkunk]

Interesting!

[D'Artagnan]

Just another quick point dubs. Probably best not to post up too much info (IP address etc) but maybe just fling a PM?

D'Art

edit: Scrub that. I see now you work where I used to. I knew that address rang a bell. Now where's my password list!