Top logo image not showing after moving to a different server / hosting plan

[blrs]

The code shows the image under:

http://my-domain.com//filedata/fetch?filedataid=28 (this is correct, two slashes there)

... and I was able to display it I think (from the new server), but it does not load most of the time (like 98% lets say). The name of the file is image_28.png, and I was not able to find it on the server, for some reason.

I got something like this in Firefox:

The image "http://my-domain.com//filedata/fetch?filedataid=28" cannot be displayed because it contains errors.

Like I said, I was trying to find its location and check the permissions, but I am not sure where this file would be. It used to work correctly on a different hosting, and I was moving everything with rsync.

[blrs]

The theme that I am using (custom made graphic design) is a child theme to vBulletin Default Theme. When I go to Style Variable Editor for this, it has this assigned under ImagePaths -> titleimage:

/filedata/fetch?filedataid=28

and I guess it is looking for this image there, but I am not sure where to find it, the actual image on the hosting plan, through the ftp. I also have full root access to the system, as this is a self-managed hosting plan.

It seems to be loading sometimes, but it does not load most of the time. It used to work 100% correctly on the previous hosting plan.

[blrs]

When I run something like:

find /home/www/html/domain-name -name image_28.png

it does not return anything, and when I run something like this:

find /home/www/html/domain-name -name test-file.png

it would show the path.

So it is like this file would not be on the server actually, and it would be generated dynamically in some way, but it cant be and it is not like that. I also tested the above on the previous hosting (where everything worked), and the image_28.png file is not findable there too (test file is).

So, like I said, there is a couple of things that I don't understand here.

###Edit:
Ok, and when I went there now, in Chrome, the image is showing. I will try Firefox and it will show there too (most likely), and I've never seen in in Internet Explorer showing yet (on the new hosting). After that I may refresh (I always use CTRL+F5 to turn off the browser cache) the image will not be showing at all. So something is wrong with some settings on the server. It works at times, which is a good sing, but what would I be doing wrong here? I've been also looking at the error log for the Apache web server too. I get something like this there:

client denied by server configuration: /home/www/html/domain-name/images/misc/image-name.jpg
client denied by server configuration: /home/www/html/myadultforum/core/image.php

So it looks like some settings may need to be changed.

[blrs]

This does not seem to be the cause of the problem, but should it be:

a) "/filedata/fetch?filedataid=28" -> http://domain . com//filedata/fetch?filedataid=28
b) "filedata/fetch?filedataid=28" -> http://domain . com/filedata/fetch?filedataid=28 (just a single quote like in all the urls; I added the spaces on the both sides of the dot)?

I keep trying to figure it out, so at this point it looks like the designer added the top logo as an attachment? Is this a good solution, or would I redo this part, somehow?

[blrs]

Image processing library - this is set to GD (and php-gd is installed and the latest version)
Attachment storage type: Attachments are currently being stored in the database

[blrs]

I am in Attachments - > Attachment Statistics, and when I click on "View content" for any of them, no image shows up in a browser (just blank white screen, with nothing on it).

[Wayne Luke]

The easiest way to fix this is just re-upload your image. If you store your attachments in the file system and use an absolute directory path, moving them will cause them to break. You will need to update the path where your attachments are stored.

[blrs]

As far as this one it has always been stored in the database (before and after moving). I did not change any settings there.

And also, can you tell me how would I re-upload this image, if this is needed.

[Wayne Luke]

Go to Site Builder on your front page, click Header and then click the Edit Logo button.

[blrs]

This does not work. I tried uploading it several times, and it does not show (I've tried in Chrome and Firefox also), so I probably have like 8 or so the same images in the database with the same logo image, and it could be good to delete it from there too. So it seems like the correct file was in the correct location from the very beginning but it was not showing on the site for some reason (and it is not showing, also the newly uploaded ones) on the new hosting plan (self-managed, latest Centos7, all updated to the newest available files, no changes done to any configuration files, only minor when needed if something did not work, but this is pretty much the only thing that does not work out of 6 different websites on 6 different scripts).

If possible, please go over the info above, I've been trying to provide a lot of detailed info, and I've been trying to fix it for the whole day. This is specific to this program, and this is first time when I work on images stored in the database.

###Edit:
I sent a PM with the domain name, if possible please don't post it here.

And like I've mentioned previously, it worked at times but the logo does not show like 98% of the time (I've seen it in Firefox and Chrome, but never in Internet Explorer yet; this probably does not matter, but again it worked periodically, but most of the time it doesn't.)

[Wayne Luke]

replied to your PM. Can't get any information to resolve the problem with what was provided.

You can "hardcode" the image URL in the AdminCP under Styles -> Style Manager -> Your Style -> Style Variable Editor. Put the path of the image into the titleimage style variable.

[blrs]

Ok, this works, and it solves the problem. Would you be able to tell me how this used to work / was suppose to work? I would like to know what may have been going on Linux-wise / system administration-wise. The .png image was stored in a database cell, and the php could not output it on the website for some reason? So this could be a permissions problem, or something like that (I was moving with rsync in archive mode, so all these should be kept the same)? Or maybe some php (php.ini) settings or something like this. Or some kind of database issue here?

When I was trying to import the database to this server, I got an error like this:

Error 2006 (HY000) at line 23048: MySQL server has gone away

...and since this was the only issue (the only error that has shown) this may be related to this. I added these to /etc/my.cnf (MariaDB configuration file), according to the info from the Net, from several places:

max_allowed_packet=500M (16M was suggested, but I added a higher value).

I don't want to sound like I am too particular, but I would like to know what is going on, as I am working on a self-managed server, and I am at the beginner level with this. I may be moving the program to multiple different hosting accounts over time, and I would not want to mess up the site over time, and it looks like something like this may be happening here. I make notes of everything like this, and it would be good to know what is going on here.

Are there any places where I could check what the situation is?

[blrs]

It looks like I cant upload attachments to the server because of the database errors. I added a testing post to the forum, I uploaded an image and it was not showing. When I was trying to post the post, I got this:

There has been a database error, and the current page cannot be displayed. Site staff have been notified.

So the logo which was uploaded this was is not showing (98% of the time) after the move to the new server, and I am not able to do the upload here (or do it correctly).

###Edit:
When I try to add a simple text only post, this does not work too. So this is not only image related. I will be checking all the settings now.

###Edit2:
I have 5.1.7 version of the script.

###Edit3:
I cant see any errors for "not being able to post a post" in Apache error log and MariaDB error log (I've been working on enabling it now, and I wanted to check there).

###Edit4:
I deleted the database, made a new export from the previous hosting, this time with cPanel / phpMyAdmin, created a new database, imported the file to this, granted all privileges to a user there, and I get the same error on the site. I have 4 other scripts on the server, and all of them work correctly database<--->script-wise.

I mean, the database works overall, since the forum sections and topics display, I am able to log in to the admin and all the settings are there. That logo was not displaying correctly, and I am not able to add a post now, so this is wrong.

###Edit5:
The logo will be now showing on the website, as it is displayed from the images folder, and not the database (but I did not change the overall setting for this, all is still suppose to be stored and coming from the database, atachments is the general name for it, I think). But the overall problem continues, like I said, a user cant start a topic, as there is a database error there:

http://prntscr.com/bjmr6l

###Edit6:
I have specified a gmail.com email address in the /core/includes/config.php file, but the database errors are not emailed to that. If I would be getting some info through this, it would be good, but this functionality does not work.

[blrs]

This seems to be the reason, and this is taken from the Apache error log:

client denied by server configuration: /home/www/html/domain-name/filedata

Quite a lot of errors like this, to different places (but the one above is specifically filedata):

client denied by server configuration: /home/www/html/domain-name/core/image.php
client denied by server configuration: /home/www/html/domain-name/images/misc/pic.png

### !!! EDIT !!!
Not being able to post may be another issue, not related to this. I was trying to do it now, and there is no info about it in this error log.

[blrs]

I am logged in to the admincp as admin, and when I go to Maintenance -> Execute SQL Query, I get:

You are not authorized to execute SQL queries

[Wayne Luke]

This is a setting in your /core/includes/config.php file. For security purposes, it should be off most of the time anyway.

You can run queries within the vBulletin Admin Control Panel by going to Maintenance -> Execute SQL Queries.

To run Queries in the Admin Control Panel you need to edit your config.php file and add your user ID to the Can Run Queries section. It looks like:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

Place your user id between the single quotes.

The AdminCP isn't really the best place to run queries. You should use PHPMyAdmin, Adminer or a standalone tool like HeidiSQL or NAVICAT if you can do remote access.