Advertisement:

Author Topic: Forum software vs Database  (Read 1088 times)

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Forum software vs Database
« on: January 21, 2021, 04:02:59 PM »
Does the database just hold members, post, boards, ect. or does it hold info from the mechanics of the form.

I'm planing a clean install to help with multiple operational errors but if that info is embedded in the Database I'm stuck where I am.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #1 on: January 21, 2021, 04:06:24 PM »
Database contains paths and settings.  What kind of "multiple operational errors" are you experiencing?
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #2 on: January 21, 2021, 04:12:09 PM »
Referring URL on login, marking forum read, attempting to post, trying to access PMs, hitting the notify tab.   Probably more that members are not saying.


There was a clean install while the hosting was an IP only.

Then the nameservers updated after and now has the domain name.
From an email I received, the hosting company updated the settings.php file to show the domain in the address bar and updated the SSL certificate.

THEN all the issues started.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #3 on: January 21, 2021, 04:13:51 PM »
Link to forum?
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #4 on: January 21, 2021, 04:15:17 PM »
Weaponsguild.com

I can create a user/pass for you

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #5 on: January 21, 2021, 04:19:52 PM »
Registration is broken as well.  Is that a clean install?  Does it work in Curve?  Did you have pretty urls installed previously?
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #6 on: January 21, 2021, 04:20:05 PM »
I also did create a new cookie after this .

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #7 on: January 21, 2021, 04:21:17 PM »
Registration is broken as well.  Is that a clean install?  Does it work in Curve?  Did you have pretty urls installed previously?
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #8 on: January 21, 2021, 04:23:30 PM »
Registration is broken as well.  Is that a clean install?  Does it work in Curve?  Did you have pretty urls installed previously?

Was a clean install on the new server, no pretty urls but did update simple portal.    I could not on the old forum but this one ,it installed no issues..

The forum worked 100% when installed during the IP address only. 
Now that it is wraponsguild.com this all started.

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #9 on: January 21, 2021, 04:24:32 PM »
I'll have to try in curve, I have not tried that.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #10 on: January 21, 2021, 04:27:12 PM »
It's not a theme problem.  Can you pm ftp access?
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,067
  • Gender: Male
    • Kindred-999 on GitHub
Re: Forum software vs Database
« Reply #11 on: January 21, 2021, 05:48:13 PM »
if the forum was installed using IP and you are now using URL, then you need to reset all URL settings.

Use repair_settings.php
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."

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #12 on: January 21, 2021, 06:04:05 PM »
Hostgator support did "things" to the database to try to correct the paths.  This is not encouraging. :P  Waiting for access, if I can get to db maybe it can be fixed.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,583
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Forum software vs Database
« Reply #13 on: January 22, 2021, 03:00:08 AM »
Hostgator support did "things"
Never a good sign :|
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #14 on: January 22, 2021, 07:23:43 PM »
if the forum was installed using IP and you are now using URL, then you need to reset all URL settings.

Use repair_settings.php

I can get you on to look at this.  SOOL also has accessim really thinking hostgator screwed something up with the database.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #15 on: January 22, 2021, 09:10:38 PM »
Someone undid the change I made earlier today.  Admin -> Server Settings -> Database and Paths -> Forum URL

It was set to IP url, that was causing the problem.  I changed it to domain url, that fixed it.  Someone changed it back to IP (didn't change itself).
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #16 on: January 23, 2021, 05:24:10 AM »
There are still issues but not as many as before.   The main part is people getting on.   But posting is a problem.   they get database error for posting photos (its not the security size one)
and if someone does a copy-paste they get a Subs-Post.php error and looking at the line is shows there is only "array('id_msg')"        That is the same line from sub-post that was on the working site.

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #17 on: January 23, 2021, 06:08:38 AM »
I cleared out my CPU and logging in got the refereing URL error again.
it was the domain and not the IP in the address bar.

One difference I see is that the https vs the old site was http.

The host put https security on and I already have a SSL certificate for the domain/forum. 

Is there a possibility that those are clashing?   I have ZERO experience with that other than people freaking out when they do not see the little lock symbol even though we have no valuable personal info.

Offline Dzonny

  • Localizer
  • SMF Super Hero
  • *
  • Posts: 12,509
  • Gender: Male
  • No sleep...
    • dzontra.nikola on Facebook
    • Dzonny on GitHub
    • dzontranikola on LinkedIn
    • @opusteniforum on Twitter
    • Samo opusteno
Re: Forum software vs Database
« Reply #18 on: January 23, 2021, 06:30:45 AM »
Can you post the exact errors you're getting though?

"Personal info" is email address, username and password, which is used for each login, so yeah..

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #19 on: January 23, 2021, 06:59:36 AM »
Can you post the exact errors you're getting though?

"Personal info" is email address, username and password, which is used for each login, so yeah..

This is the copy paste one
Incorrect string value: '\x92s Apr...' for column 'body' at row 1
File: /home/weaponsg/public_html/forum/Sources/Subs-Post.php
Line: 1834

The attachment one is just Database error, try again, if you come back to this screen contact an administrator.

The login is unable to verify the referring URL.        I could log in 7 times (Random number) and be fine, then the next time get that .

Im also looking into that there is no redirect for http to https, not sure if that could affect it.