Jump to content

What tables contain any upload paths/URL's ?


AndyF
Go to solution Solved by Nathan Explosion,

Recommended Posts

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.

Β 

p1.png.0b92fe25c21d38ebdafa0d305b17e3c9.png

Β 

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 by AndyF
Link to comment
Share on other sites

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 by AndyF
Link to comment
Share on other sites

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 by AndyF
Link to comment
Share on other sites

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 😞

Link to comment
Share on other sites

  • Solution

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.

Link to comment
Share on other sites

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 by AndyF
Link to comment
Share on other sites

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 by AndyF
Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
Γ—
Γ—
  • Create New...