I ve run this query:

ALTER TABLE xxxx_attachment add usedin varchar(30) not null;

AND

I get the following mysql error:

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT attachmentid
FROM xxxx_attachment AS attachment
LEFT JOIN xxxx_pmtext AS pmtext ON attachment.usedin='pmtextid' AND attachment.itemid=pmtext.pmtextid
WHERE
pmtext.pmtextid IS NULL
AND usedin<>''
AND itemid<>'';

MySQL Error : Unknown column 'usedin' in 'where clause'
Error Number : 1054

any solutions?Thanks in advance!

How can i revert the table back to normal?

Hey m8, I put there the code I got, if you make a search, you will not find the "$_pmt = 1;"

Prob I?m dumb, dont know...

Were do the attachments go? I attach to a PM, it lists it in the popup window, I submit. When I do it again, the popup window doesnt show it in my attach inventory, nor does it in my main attachment inventory. Is it just a floating attachment or something? Oh and where it would normally list my attach inventory, it says array and nothing more.

I get this error when tryign to send pm with attachment:
Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='333';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Sunday, November 13th 2005 @ 01:54:34 PM
Script : http://www.talkinto.com/forums/private.php
Referrer : http://www.talkinto.com/forums/private.php?do=newpm&u=5
IP Address : 209.158.71.16
Username : Administrator
Classname : vb_database

I can also NO longer add regualr attachments to post...
anybody knows how to fix that?

Nvermind.
I configured config.php to allow me run quiries from admincp (used to run form phpmyadmin).
I ran them, everything is back to normal but I still cannot send attachments. I attach them, but when other person opens pm he sees no attachments there. No errors.

okey, I just deleted plugin and installed it again.
Works perfectly now! vb 3.5.0
Thank you!

Will this work for 3.5.1?

Yes it will.

Installed and works great.

A little hasty I was. It works for me, BUT others get this error:

I thought this was storing the attachments to the same place the threads are? I checked my permissions there and they are set to 777

BP, any news on an update to this?

Happy Holidays all.

Sorry to be thick but this is new to me. Right it is not working and it prop because of this

this much I get.

Right now how should the replacement look?

1.
or something similar.

2.

Or am I looking at this the wrong way?

Please help a vaild eg. would be very good.

bump

zooman, the second way. It needs an integer number of an active thread that is on your board. What I would do would be find the BIGGEST forum, go to the very last page and the last post and use that thread id number.

Cheers all working now, used number post #2 :) I now understand why. I will have deleted the frist post as it will have been a test.

Again Cheers

Glad I could help and that you got it working.

Does it work with vB 3.5.3???

And other Question: Can Picture-Attachments set to be visible in the PM instead of being a Link?

Greetings,
Matthias Moench

It does !

Danke redlabour ;)

PS: Was tut es? Mit 3.5.3 funktionieren und/oder Bilder in der PM anzeigen?

---

Because it`s not fair to speak German on an International Board - here comes the Translation ;):

Thanks redlabour!

Post Scriptum: What does it do? Working with vB 3.5.3 and/or show Pictures in the PM?

Gr??e,
Greetings,
Matthias Moench

Schau mal hier : http://www.vbhacks-germany.com/forum...newpost&t=2060

Take a look : http://www.vbhacks-germany.com/forum...newpost&t=2060

;)

Schweeeeet....
worked like a charm. 3.5.2
Nice Hack

INSTALL

I've the problem that only the admins and mods can use this function... When a normal user want to attach some files he get the message that he hasn't enough rights!

How can i change that?
I've the Version 3.5.3.

Thanks,
Cheers!

i hate to sound like a fool but im still getting the invalid post error

i went to the right plugin and change the 1 to a thread that is very old and wont ever be seen or deleted (110)

but still i get the error also i tried other threads, but all give me the same error

wouldnt it be better to just make a new table for PMattachments

anyways, any suggestions?

Sorry for a lil. off topic but can someone use this mod and make it for the calendar instead? I've spent so many days try to make a calendar attachment and ended up wipped out my forum after 2 months built it up!

Running 3.5.3... Installed every thing twice... dont get any errors... but dont get attachments button / section at the bottom of the PM box... any ideas.. i have read all that is in this thread....

Cheers Judge

is this hack going to support usergroup permissions ?

also this hack would be better as said to use its own database or file DIR, i dont know why this is not a feature in vbulletin for members to allow sending files in private messages (as long as file sizes are limited and or there is a certain amount of space a user can have before they need to clean there storage box ?

well i think so anyway lol

Sorry to be pain..

Judge

did u do the template edits?

yes m8... done both... files... well strange hey... like i say done em twice... I just saved.. or u think i should Save & Reload...

Cheers Judge

All sorted now... works a treat...
I forgot to enable plugins LMAO

Hi

EDIT: Sorted now, had to redo an edit :)

couldnt get to work on my php5 and mysql5 server, could it be just an issue with that?

I am also having a problem getting this to work.. What i am getting is this...

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='175';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Monday, February 6th 2006 @ 05:18:56 PM
Script : http://**********/forum/private.php
Referrer : http://**********/forum/private.php?do=newpm&u=31
IP Address : **.***.**.**
Username : DruidToolz
Classname : vbdatabase

Could someone help me please.. Thnx in advance

Hi, I got everything changed but when I went to do the SQL Queries, I ran into also when running all of them at the same time, I get this error.

I don't know what I am missing. Could you please help? This would be a nice hack to have on my board. Thanks! :)

is this working ok in 3.5.4 ?

Well i have all the modifications setup up on 3.5.4 I just wish there was an easier way then editing the sql query tables.. The reason i say this is i got a failed message which i didn't want to try it again unless i either backup my database or write over it and hope it doesn't mess up.. So please can someone help me with this.. Thnx

I was cruising right through the installation with no problems right up until the sql query. I wasn't able to execute an sql query from the vb control panel? I've installed several other hacks without a problem.

Presumably has something to do with access read/write permissions for the database? Opened up the file manager from my web control panel and the folder permissions seemed to be set correctly. I opend up myphpadmin and was going to try and run the querys from the tables following the instructions but quickly got in over my head.

The easiest thing for me would probably be just to execute the query from the vb control panle.

Any help in pointing me in the right direction to execute the sql query would be appreciated.

Thanks,
Jason

https://vborg.vbsupport.ru/external/2006/03/3.jpg

you need to edit your config.php with your id to allow to run queries,go to your server where your forum is installed then find includes folder inside the includes folder you will find config.php look for this code note in my code id is set at 1,edit to your user id then save you will now be able to run queries from your admin CP hope that helps

Hey all I am able to upload images and possibly other items but im trying to upload a tar.gz, it uploads with no problem (so it seems) but when adding to mysql its adding the content of the binary to the db causing this:

Any thoughts?

installed and working great thanx

i'm using 3.5.4 and get the same error as well... looks like there is no support for this one :confused: