I don't know if that hack modifies the announcement table or not. I'll have to look into it and create a compatible version, but my time is limited. I have a whole lot of exams this week. :nervous:

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT COUNT(*) FROM attachment WHERE visible=1 AND private=0
mysql error: Unknown column 'private' in 'where clause'

mysql error number: 1054

Date: Monday 18th of November 2002 08:08:53 PM
Script: http://www.impulseownersgroup.com/vb/vb/attach.php
Referer:


Is what I am getting

Larry

I'm not sure why, but I installed this hack to test it out, and as I tried to load attach.php my server load on a semi dedicated server wen't through the roof and stalled MySQL on my forums. I think something needs some optimization maybe.

I saw it driving the loads through the roof on two servers today. It locks multiple queries in the mysql server for huge amounts of time. I restarted mysql on both of them to get them back to normal.

The same to me.. :(
I need the another two hacks to make work this one?

I set to 0 the options, and use all te posibble combinations.. but don't work

Help please .. this hack looks SO Cool!

the answer is on the first page. A query needs to be replaced.
And FWC, would you mind running the script with explain=1 and posting the results? It might help finding the cause.

Hello..

I added the templates but as soon as I did that it got very very very slow...

Weird...

ok.. I removed the templates and everything became very fast again..

does VB have a template limit or something?

You showed me this hack earlier, and I was amazed. Now, when releasing it, it will soon become a part of my own community. Thanks for the contribution.

i love it rake, but, for some reason, it makes the whole damn server run so slow, especially that page O_o