What tables contain any upload paths/URL's ?

[AndyF]

Must admit I'm very reluctant to post this topic as its actually asking "for something" rather than me "giving something" however as I've been "away from IPS" for quite a while it felt appropriate.

 

Due to an odd issue (it is attempting to write /css_built_1 , javascript_core , javascript_forums , javascript_global outside the webroot , as in its creating a public_html/uploads directory in /home and writing them there.

I have no css and when I did the icons such as notifications and messenger were missing, but the rest of the site was fine. I did remove the legacy /screenshots and the like from the db as I'd already dropped the legacy files into uploads / monthly to match (this was tested on localhost without issue)

To be clear this is a 349 site upgraded to 4.5 on localhost then 'transplanted' onto a live server. Yes I did adjust conf_global 😉

Can't immediately see anything amiss unless the supplied from the ACP friendly URL .htaccess file is somehow interfering but that seems unlikely.

 

 

Aside from /datastore which I keep emptying out without much gain, I need to be sure where any path is being kept in the database please. In legacy versions this was core_settings and easy enough to find if anything really did go pear shaped.

 

I can't put a ticket in 😉 I've not done a 'help me' ticket since 2006 so I don't plan on doing it now! 😄

 

I could start digging and find things myself but if anyone has a few pointers to save me time (as time is not in plentiful supply today unfortunately) would be appreciated.

 

Edited November 29, 2020 by AndyF

[Nathan Explosion]

Pride is a horrible thing.

Anyway...try clicking the highlighted item and look around...

 

[AndyF]

Thanks. But I have no css in the ACP hence no button but I found the link directly anyway 🙂

But the paths in there are all the same ie:

" File System: /home/~~~~~/public_html\uploads

Note the " \ " there instead of " / " between public_html and uploads hence me thinking I ought to edit this in the DB directly, I'm not scared! 😄

 

Edited November 29, 2020 by AndyF

[Nathan Explosion]

Click the entry....it opens up to an edit form...modify the path...save

If you've already done the above, then tell us what you have already tried to save us wasting our time.

If you really want to dive in to the database, phpmyadmin allows you to do a search

Edited November 29, 2020 by Nathan Explosion

[AndyF]

5 minutes ago, Nathan Explosion said:

If you've already done the above, then tell us what you have already tried to save us wasting our time.

If you really want to dive in to the database, phpmyadmin allows you to do a search

I have explained what I'd done. 🙂

The first quoted line is slightly upsetting to me 😞

Wish the editor would behave properly when splitting quotes but that's something else.

5 minutes ago, Nathan Explosion said:

Click the entry....it opens up to an edit form...modify the path...save

It only shows the path I'd mentioned, nothing else. 🙂

5 minutes ago, Nathan Explosion said:

 

Edited November 29, 2020 by AndyF

[Nathan Explosion]

Click on this entry - anywhere on it, not just on the options on the right:

This is the end result of clicking that actual entry, then modifying the field labelled 'Directory' (yes, it will look different because of your lack of CSS, I know)

Edited November 29, 2020 by Nathan Explosion

[AndyF]

core_file_storage looks like this:

{"dir":"{root}\\uploads","url":"uploads"}

 

Note the double \\ although I see nothing else immediately amiss.

There are no options to change it there as there's only one choice in the dropdown itself. Changing it (to what it was) then saving it makes no difference.

I can see I'm not getting anywhere here 😞

[Nathan Explosion]

Screenshots help...and include urls

Edited November 29, 2020 by Nathan Explosion

[AndyF]

Just now, Nathan Explosion said:

Screenshots help...and include urls

Of what did you want to see

[Nathan Explosion]

2 minutes ago, AndyF said:

Of what did you want to see

What I am trying to guide you through - if I can see what you see then I can see if you are doing what I am suggesting, just to be sure.

Edited November 29, 2020 by Nathan Explosion

[Nathan Explosion]

I'm off out...try to navigate yourself to the following URL:

admin/?app=core&module=overview&controller=files&do=configurationForm&id=1

And then modify the field that contains the 'Directory'

If you cannot do the above, then either:

1) Search in phpmyadmin for the path you currently have or

2) Log a ticket with support.

[AndyF]

I found the (as mentionde previously) the final part of the upload path has a " \ " between public_html and uploads, whereas the rest of the path is " / " , ie :

/ home / blah etc / public_html \ uploads < see the " \ " there ?

I changed it in the link you provided, emptied out datastore and the nonsensical javascript it had built in uploads (this got recreated anyway)

Interestingly it lists two one correct now and one not, but it gave me a no permission error when I tried to alter one, it says its moving the files (except there is nothing to move) so I'll wait and see what happens.

 

Option is is not an option, there's probably a tool to fix this externally anyway (think of 3x 'upgrade finish' type of thing) at a completely random guess.

This is simply why I wanted the database details to save me searching, 🙂

Seems it is moving things, quite why I'm not sure as the two configuration paths both storage filesystem are identical except for the  " \ " vs the " / " , just wish the link to the path was pointed out as I could of done it. 🙂 Having said that i appreciate the help. I've told it to just run the move now until its done. Unsure if its going to make it worse or better tbh at this stage but we'll see.

 

Edited November 29, 2020 by AndyF

[AndyF]

I do have a few bug reports to post now too, well two at least that are reproducible and not related to my erm 'adventures'

EDIT... Editing the path above once it was found then checking it in the db as well as throwing out most of the generated js from uploads and all of datastore minus the blank index.htm file and it decided to work again.

Thanks. Marked the relevant post as solution, although option ( 2 ) was never an option for me. 🙂

Edited November 30, 2020 by AndyF