News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Question regarding "Connection type" for MYSQL

Started by [chrisB], January 16, 2023, 05:37:59 PM

Previous topic - Next topic

[chrisB]

When I migrated from Invision, I didn't start to have issues until I started installing mods.

One issue that remained was this weird habit where CSS and images wouldn't load, usually refreshing would bring it back and then everything appeared fine (beside the error log at times going crazy).

Using the repair_settings.php file;

I noticed that the "Connection type" wasn't set, Standard (recommended) is now selected.

Could this be what caused the issue?
I'm stuck in a time warp from the early 00's.

Sesquipedalian

I promise you nothing.

Sesqu... Sesqui... what?
Sesquipedalian, the best word in the English language.

Doug Heffernan

Quote from: [chrisB] on January 16, 2023, 05:37:59 PMWhen I migrated from Invision, I didn't start to have issues until I started installing mods.

Do you get those issues with each mod that you install or only with particular ones?

[chrisB]

Quote from: Doug Heffernan on January 17, 2023, 05:44:55 AM
Quote from: [chrisB] on January 16, 2023, 05:37:59 PMWhen I migrated from Invision, I didn't start to have issues until I started installing mods.

Do you get those issues with each mod that you install or only with particular ones?
I installed several before I noticed, some mods were extremely buggy for my site which I no longer use but VBgamer cleaned that up and fixed an issue where mods wasn't installing correctly.

So far with the database connection type being set as standard I haven't experienced the issue.

Although I wasn't sure that would be the reason, maybe it plays up with one of the mods I installed? I'll see if I can replicate the issue on a test site checking between mods.
I'm stuck in a time warp from the early 00's.

[chrisB]

I can't replicate the issue. 😌

When I look at the inspect tool when nothing shows [always when its the first visit now - I have to clear the cookie to trigger the issue].
div {
    display: block;
}

Shows where the CSS normally would.

In the console this shows;
QuoteRefused to apply style from '<URL>' because its MIME type ('text/html') is not a supported stylesheet MIME type, and strict MIME checking is enabled.
poetryartonline.com/:1 Refused to execute script from 'https://poetryartonline.com/?PHPSESSID=0562f71ccf737b1411d69985fae7a466&/Themes/PA%20Online/scripts/minified_07b9d776cf4fcc1af42ff11903266f9a.js?smf213_1674656699'; because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
poetryartonline.com/:1 Refused to execute script from 'https://poetryartonline.com/?PHPSESSID=0562f71ccf737b1411d69985fae7a466&/Themes/default/scripts/tinyportal/TPShout.js?v210'; because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
poetryartonline.com/:1 Refused to execute script from 'https://poetryartonline.com/?PHPSESSID=0562f71ccf737b1411d69985fae7a466&/files/jquery.bxslider.js'; because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
poetryartonline.com/:1 Refused to execute script from 'https://poetryartonline.com/?PHPSESSID=0562f71ccf737b1411d69985fae7a466&/files/jquery.bxslider2.js'; because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
VM349 jquery.min.js:2 jQuery.Deferred exception: $(...).bxSlider is not a function TypeError: $(...).bxSlider is not a function
    at HTMLDocument.<anonymous> (https://poetryartonline.com/:677:20)
    at j (https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js:2:29948)
    at k (https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js:2:30262) undefined
r.Deferred.exceptionHook @ VM349 jquery.min.js:2
k @ VM349 jquery.min.js:2
setTimeout (async)
(anonymous) @ VM349 jquery.min.js:2
i @ VM349 jquery.min.js:2
fireWith @ VM349 jquery.min.js:2
fire @ VM349 jquery.min.js:2
i @ VM349 jquery.min.js:2
fireWith @ VM349 jquery.min.js:2
ready @ VM349 jquery.min.js:2
R @ VM349 jquery.min.js:3
jquery.min.js:2 jQuery.Deferred exception: $(...).bxSlider is not a function TypeError: $(...).bxSlider is not a function
    at HTMLDocument.<anonymous> (https://poetryartonline.com/:1141:20)
    at j (https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js:2:29948)
    at k (https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js:2:30262) undefined
r.Deferred.exceptionHook @ jquery.min.js:2
k @ jquery.min.js:2
setTimeout (async)
(anonymous) @ jquery.min.js:2
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
fire @ jquery.min.js:2
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
ready @ jquery.min.js:2
R @ jquery.min.js:3
VM349 jquery.min.js:2 Uncaught TypeError: $(...).bxSlider is not a function
    at HTMLDocument.<anonymous> ((index):677:20)
    at j (VM349 jquery.min.js:2:29948)
    at k (VM349 jquery.min.js:2:30262)
(anonymous) @ (index):677
j @ VM349 jquery.min.js:2
k @ VM349 jquery.min.js:2
setTimeout (async)
r.readyException @ VM349 jquery.min.js:2
(anonymous) @ VM349 jquery.min.js:2
j @ VM349 jquery.min.js:2
k @ VM349 jquery.min.js:2
setTimeout (async)
(anonymous) @ VM349 jquery.min.js:2
i @ VM349 jquery.min.js:2
fireWith @ VM349 jquery.min.js:2
fire @ VM349 jquery.min.js:2
i @ VM349 jquery.min.js:2
fireWith @ VM349 jquery.min.js:2
k @ VM349 jquery.min.js:2
setTimeout (async)
(anonymous) @ VM349 jquery.min.js:2
i @ VM349 jquery.min.js:2
fireWith @ VM349 jquery.min.js:2
fire @ VM349 jquery.min.js:2
i @ VM349 jquery.min.js:2
fireWith @ VM349 jquery.min.js:2
ready @ VM349 jquery.min.js:2
R @ VM349 jquery.min.js:3
jquery.min.js:2 Uncaught TypeError: $(...).bxSlider is not a function
    at HTMLDocument.<anonymous> ((index):1141:20)
    at j (jquery.min.js:2:29948)
    at k (jquery.min.js:2:30262)
(anonymous) @ (index):1141
j @ jquery.min.js:2
k @ jquery.min.js:2
setTimeout (async)
r.readyException @ jquery.min.js:2
(anonymous) @ jquery.min.js:2
j @ jquery.min.js:2
k @ jquery.min.js:2
setTimeout (async)
(anonymous) @ jquery.min.js:2
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
fire @ jquery.min.js:2
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
k @ jquery.min.js:2
setTimeout (async)
(anonymous) @ jquery.min.js:2
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
fire @ jquery.min.js:2
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
ready @ jquery.min.js:2
R @ jquery.min.js:3

Site: https://poetryartonline.com/
SMF version: 2.1.3

Installed Mods;
SMFPacks Menu Editor: Version: 1.0.4
Info Center Manager: Version: 1.0b3 [Emulating 2.1.2 I think]
Seperate the sticky topics: Version: 1.0.1
Members Online Today: Version: 1.0
Forum Width Setting: Version: 1.2
Quick Spoiler: Version: 1.5.1
Pretty URLs SEO Pro: Version: 2.0.5
Team Oage: Version 5.3.5
Avatar Display Integration: Version: 1.5.4
TinyPortal: Version: 2.2.2
Pretty URLs Extras: Version: 1.0
Awesome Post Ratings: Version: 2.0.4

Issues in the past:

As I mention I migrated from IPS 4.4, I think this is the root of the main issues and although it said the conversation was fine. VBgamer45 fixed some errors that was generated from some previously used mods which didn't work for me. He mentioned the following:

QuoteA few issues. old reactions mod file edits weren't removed uninstall.
Error in display.template.php from the cms mod.
Removed old hooks no longer used.

Had to set file permissions to 777 not sure why 755 wasn't allowing it to be installed with actually editing the files. Tested installing and uninstalling to see if succeeds/failures 777 was the combo that worked.

chmod 0777 /home/poetryar/public_html -R

I have tried uninstalling every plugin.
I have tried to replicate the issue in two other environments.

I thought it might be an issue with my SSL certificate [Free cPanel], but I am not so sure. I can say the issue can be triggered if you're new to visiting my site. Refreshing solves the problem from there on, although clearing the cookie for the domain will load only text on the first load.

Errors:

Quote2: foreach() argument must be of type array|object, null given

Quote2: Undefined array key "template_layers"

Quote2: Undefined array key "can_register"

Quote2: Undefined array key "session_id"

Quote2: Undefined array key "session_var"

Quote2: Undefined array key "id"

Quote2: Undefined array key "is_guest"

Quote2: Undefined array key "can_mod"

I'm not being impatient.

I thought the issue had resolved itself but returning members are telling me only text loads, which is how I replicated the first site load after clearing my site cookies.
I'm stuck in a time warp from the early 00's.

[chrisB]

I am not intending to spam, bump or be unfair to any other SMF user.

The issue I am experiencing is the same as this: https://www.simplemachines.org/community/index.php?topic=443444.msg3116048#msg3116048

Searching anything in relation to the sites first load did not bring this topic up for me, searching "PHPSESSID" did but that's only due to me figuring this out thanks to the wonderful SMFHelpers website.

The issue is caused by removing "/index.php" from the QueryString.php file.

Omitting this helps clean the URL's looking like: mydomain.com/ and mydomain.com/forum - personal preference but I prefer this.

Yet it causing an issue when a site first loads, when a cookie is created it seems to be fine from then on but for guests the occasional first visit whereby a cookie needs to be deployed triggers nothing but text to load.
I'm stuck in a time warp from the early 00's.

Kindred

Removing index.php will screw things up. Don't do it

No wonder it keeps breaking on you.
If you had mentioned your hack to start with, we would have told you that you broke it...
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: