getting this error Database error in vBulletin 2.2.5:

Invalid SQL: SELECT privatemessage.*,icon.title as icontitle,icon.iconpath,attachment.attachmentid,at tachment.filename,attachment.counter
FROM privatemessage
LEFT JOIN icon ON (privatemessage.iconid = icon.iconid)
LEFT JOIN attachment ON (attachment.attachmentid = privatemessage.attachmentid)
WHERE privatemessageid=97729
mysql error: Unknown column 'privatemessage.attachmentid' in 'on clause'

mysql error number: 1054

Date: Thursday 02nd of May 2002 07:13:57 PM
Script: http://www.emusanet.com/forums/forum...essageid=97729
Referer: http://www.emusanet.com/forums/private.php?s=


i assume thats a problem with my private.php file, its attached, as far as i can tell everything is fine with it :(

----

can u explain that pls?

my txt is [better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth]ed up

any reason why when i delete the messages from the sender and reciver that the attachments are still in the database?

Hallo fire,
I have a weird error with this one. All seems to be working but if I have a look at my pm sent box a day later, then the attachment is gone. The attachment Icon in the pm does not show up anymore and the amount of downloads also no longer. This attachment link is also gone.

Any Ideas what that might be. This happens on the sender als well as the recipient side.

greetings tina

can anyone please help me get thisd hack working cause it still doesnt work with kidney's fix :(

getting this error when i try to view a attachment

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT forumid FROM thread WHERE threadid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Saturday 22nd of June 2002 06:26:17 PM
Script: http://www.totalshock.net/forums/for...atemessageid=5
Referer: http://www.totalshock.net/forums/pri...atemessageid=5


any help pls

I am able to attach files to pm's however when a person goes to view them they get
Parse error: parse error in /home/xxxxxxxxxxxxxx/forums/attachment.php on line 67

I did this step correctly
In file attacment.php replace this: |
+-------------------------------------------------------------------------------------------------+
updateuserforum($getforuminfo['forumid']);
+-------------------------------------------------------------------------------------------------+
| |
+-------------------------------------------------------------------------------------------------+
| With this: |
+-------------------------------------------------------------------------------------------------+
if ($privateok==0) {
updateuserforum($getforuminfo['forumid']);
}

-----------------------------------------------------------------------
the updateuserforum line is line 67 in my file
here are the lines surrounding that part

if ($privateok==0) {
updateuserforum($getforuminfo['forumid']);
}
$getforuminfo['threadid']);

if ($noshutdownfunc) {

does anyone see any errors here?
thanks in advance.
p.s. it seems to have problems attachming anywhere even to posts.

Nice work Chen

*clicks install*

Email me your attachment.php file by email.

Oh bummer :(

This one is no longer working. Upgraded to vB2.2.6 a while ago, and changed php (register_globals = Off)

Now there's no more attachment in pm's. I've taken a peek with phpMyAdmin, and the private message that's supposed to have an attachment shows no attachmentid (= 0)

:ermm: