Attachments directory displaying an array

[hungarianguy]

Where can I find the attachment directory path in the database to change it? Out of nowhere it's not being displayed anymore. I used the repair settings file but for the attachments directory I got an Array only and there was no save button so I am looking to change it in the database but don't know what table. I looked at the smm_settings table but no luck.

[Arantor]

Admin > Forum ? Attachments and Avatars > Attachment Directories ?

[Doug Heffernan]

If you can't get to your admin panel have a look at the smf_settings table. Or you can run this sql query:

Code Select Expand

SELECT value from smf_settings WHERE variable = 'attachmentUploadDir';

That will display the attachment directory path and you can change it from there, but make a backup of the table for just in case.

I looked at the smm_settings table but no luck.

I noticed that you said smm_settings. If that wasn't a typo then you should use that prefix in the aforementioned query. Hope it helps.

[Illori]

I looked at the smm_settings table but no luck.

I noticed that you said smm_settings. If that wasn't a typo then you should use that prefix in the aforementioned query. Hope it helps.

unless it is an old install, new SMF 2.1 installs set a random prefix.