"Login or Sign up" - background colour

[ayjayef]

Thanks Wayne.
The gotcha for me was that "main_nav_admin_bar_background" was nested under "Site Builder Navigation" and I didn't expect that.

Makes more sense n...

[ayjayef]

I've had a few users not be able to find the "Login or Sign up" bar at the top of the forum,
the colour sort of blends into their bookmarks and they can't see even when I tell them where...

[ayjayef]

Thanks Wayne ,cleaned them all up.
My customavatars are stored in the database so that went too.

FYI for those playing at home, I went from dozens of files in .\core\vb to just two....

[ayjayef]

History: This was VB4.x then VB5.x then more recently VB5.6.1 patch 1, VB5.6.2, VB5.6.2 patch 1 now VB5.6.3

I get dozens of files listed, most I recognise as files and dir's I've added (and...

[ayjayef]

Thanks Wayne,
I'll let him know he dreamt it and we'll kick around the solution.

Cheers.

[ayjayef]

One of our moderators was sure that there was a way of banning a single user from a channel (not the whole forum) but for the life of us we can't find it.

Did he dream it?

He...

[ayjayef]

Done and the forum still works, woohoo

For those playing at home (or someone in the future that finds this while troubleshooting)
...this was the SQL that I used.

-----...

[ayjayef]

Paranoid double checking...



I'm running 8.0.19 - MySQL Community Server

So it's okay to change those tables too?...

[ayjayef]

Thanks for the excellent instructions Wayne.



I certainly didn't create them so can only guess that these are something that migrated from VBull v4.x


I added...

[ayjayef]

Thanks Mark,
I agree, the server restarting is a problem and we are well aware and will work toward a better solution (per my second last line in the post)

...but this was a request...

[ayjayef]

Ver 5.6.2
(but same in prior versions back to 4.x)

------
Database error in vBulletin 5.6.2:
Invalid SQL:
REPLACE INTO searchlog
(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,result...

[ayjayef]

Yeah yeah that's what we did.
It''s really easy for the browser mafia to demand that but it required a server upgrade as the old OS didn't support over TLS1.1
Took a few months to sort the...

[ayjayef]

Chrome: Version 83.0.4103.61 (Official Build) (64-bit)


Okay, so yesterday I renewed the SSL certificate on the server that the image was coming from and BINGO, it works now.
...

[ayjayef]

(same image, saved locally, uploaded via Maintenance -> Diagnostics)

Pertinent PHP Settings

file_uploads: On
open_basedir: None
upload_tmp_dir: C:\temp
upload_max_filesize:...

[ayjayef]

Versions installed are:
ImageMagick-6.9.11-12-Q16-x64-dll
ImageMagick-7.0.10-13-Q16-x64-dll

...but I've gone back to GD (to take imagemagick, imagic, ghostscript out of the variables)...

[ayjayef]

Search Result Cache Lifetime=0

Works. Edits made to posts happen in real time. Prefix changes "stick" without hitting the installation with an admincp "clear system cache...

[ayjayef]

Stored in the file system.

-- file upload diagnostic under Maintenance -> Diagnostics.
No errors occurred while opening the uploaded file for reading.

but, I also found...

[ayjayef]

No cloud hosting, this is just a standalone webserver.

[ayjayef]

(ouch - I'll wear that).

vB - 5.6.1p1
PHP - 7.4.1
MySQL - 8.0.19
Windows Server 2019 / IIS

Like I said, this problem happens using GD and default settings....

[ayjayef]

Search Result Cache Lifetime = 1
I really didn't expect that topic prefixes or post content edits would be affected by what I assumed was only "search cache"

Moderator is...