Perfecto mondo. BB you never cease on enthuiasm :D

Im gonna hack the attachments out of Short-Media's 2.3.0 until VB3 is ready and then I shall use your (now bookmarked) guide to getting them back in for the upgrade ;)

Sweet! Gonna dump 250mb of attachments into the filesystem.. take that FreeBSD :p

Alright I installed the vb3 Attachments hack a while back - the one that lets you post multiple attachments and such. Now I just installed this hack as well, and low and behold the two conflict with each other.

The thing is, old attachments work fine after I did that scan thing to them all, but when I try to post new attachments I get a bunch of errors:

Any thought as to getting the two hacks to integrate together? Or anyway to fix the problems im having?

Great. The Uninstall works perfectly.

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: UPDATE attachment SET hash='3315f4bdf94d848b53a3ef8756408772' WHERE attachmentid='1'
mysql error: Unknown column 'hash' in 'field list'

mysql error number: 1054

Date: Tuesday 14th of October 2003 01:04:06 AM
Script: http://www.paintballmessage.com/foru...&total=&pergo=
Referer: http://www.paintballmessage.com/foru....php?s=&step=8


When I try to import my posts from the database, that is the database error im getting. It also says there has been a problem attaching the file when you try to make a new post within the forum. The path is set correctly, and I have tried uninstalling and it wont let me.

Please help me get this beast working ;)

ok I figured that out, i had to execute the lines manually..

Now I have this problem..

Warning: fwrite(): supplied argument is not a valid File-Handle resource in /usr/local/psa/home/vhosts/paintballmessage.com/httpdocs/forums/admin/attachment_install.php on line 333

Warning: SAFE MODE Restriction in effect. The script whose uid is 14426 is not allowed to access / owned by uid 0 in /usr/local/psa/home/vhosts/paintballmessage.com/httpdocs/forums/admin/functions.php on line 1949

Warning: stat failed for /attachments/b0e10845b2e4ad1d63087a7ab2f1cd6c.file (errno=2 - No such file or directory) in /usr/local/psa/home/vhosts/paintballmessage.com/httpdocs/forums/admin/functions.php on line 1953

And that when I try to make a new post

Ok got it all fixed on my own ;) Im good, lol...

One more question, can I drop the file data or not, if so whats the query to do it? If I ever want to upgrade to a vb3 board, would it effect anything?

grr ok one more that I cant figure out.. When you go to delete a thread that has attachments in it...

This is what it says..

Warning: unlink() failed (No such file or directory) in /usr/local/psa/home/vhosts/paintballmessage.com/httpdocs/forums/admin/functions.php on line 2001

I looked up line 2001 and it was this area:

// ###################### Start removeattachment #######################
function removeattachment ($attachmentid) {
global $DB_site,$attachpath;
$fileinfo = $DB_site->query_first("SELECT attachmentid, hash FROM attachment WHERE attachmentid='$attachmentid'");
$path = "$attachpath/$fileinfo[hash].file";
unlink($path);
}

It deletes the thread, its just returning that error, and its bugging me... Please help me

I have been running in 2.2.9 in production for months with this hack working perfectly. All of the sudden, this week, attachments stopped being accepted. We ran the repair.php routine to repair and optimize the tables, and this seemed to help temporarily, but the problem has recurred, and now the "fix" isn't working either.

Where do I start looking for clues as to the problem?
I have checked permissions on the forums, on the attachment directory, disk space, etc. No clues there. Since our company uses vBulletin for document control and we have an ISO9000 audit coming up next week, I am in a panic.

Please help?

No error messages, no attachment queue issues, either.

Here's my.ini:
and my phpinfo: