Advertisement:

Author Topic: Forum software vs Database  (Read 1089 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.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #20 on: January 23, 2021, 03:18:14 PM »
Just got on, will take a look.  What is mediaprocache.php?  It's in /cache and contains a lot of external links.
“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 #21 on: January 23, 2021, 03:19:45 PM »
Just got on, will take a look.  What is mediaprocache.php?  It's in /cache and contains a lot of external links.

Brand-new install on a new server.

No freaking clue

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #22 on: January 23, 2021, 03:30:53 PM »
Forum url is correct.  I'm not having any problems logging in, posting, pming - everything works normally.  Cleared forum cache, it fills up quickly due to activity, but doesn't look like a caching problem.  Will do clean install in different directory, connect to db, see how it runs.  Would help if I could replicate any of these problems.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

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 #23 on: January 23, 2021, 03:31:31 PM »
Well, when I tried to open your forum it automatically transfer to https, so that looks like it's covered though. Not sure about other pages though, I can only see login page.
Take a look at this manual:
https://www.simplemachines.org/community/index.php?topic=555034.0

Regards your error, is your forum in utf8? If you open phpMyAdmin can you check the collation for the tables?

Edit: Sir Osis of Liver confirmed that the https is not problem in this case, as he can access the whole forum, so ignore that part :)


Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #24 on: January 23, 2021, 03:37:03 PM »
Looking at some of the formats in the mediaprocache.php, that might be from simple audio/video package

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #25 on: January 23, 2021, 03:38:34 PM »
Most tables are latin1_swedish_ci, two cleantalk tables are utf8_unicode_ci, overall collation is shown as utf8_unicode_ci.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

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 #26 on: January 23, 2021, 03:45:50 PM »
Well, errors like this are mostly caused by wrong collation, so converting to utf8 might help. Make sure you have working backup of files and database before doing that! :)
I have no other ideas what might be wrong though, you may pay attention when the error happen, what content is written in post, for example if there's audio/video, specific smiley, bbc tag or something else...

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #27 on: January 23, 2021, 03:47:19 PM »
Looking at some of the formats in the mediaprocache.php, that might be from simple audio/video package

Confirmed.  Can you give me a link to something that's not working?
“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 #28 on: January 23, 2021, 03:52:45 PM »
People are getting "Unable to verify referring url. Please go back and try again."
that is from https://weaponsguild.com/forum/index.php?action=login2

Going from weaponsguild.com        clicking the picture and logging in  (How a lot of people get on without bookmarking,

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #29 on: January 23, 2021, 03:53:10 PM »
Dumping db.  Is there a connections limit?  He's got approx. 1150 guests + users on now, posts are being rejected.
“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 #30 on: January 23, 2021, 03:55:15 PM »
Dumping db.  Is there a connections limit?  He's got approx. 1150 guests + users on now, posts are being rejected.

Not that I know of,  We had 2098 active members on at one time when the site was taken over     no clue on guests     

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #31 on: January 23, 2021, 04:00:12 PM »
Putting you in maint mode, will switch to clean install.
“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 #32 on: January 23, 2021, 04:13:38 PM »
The theme (Prince of darkness) was a modified theme.  Even though it worked on Godaddy, if it's an issue now ill go with ambassador and be done with it.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #33 on: January 23, 2021, 04:22:14 PM »
Back to production install.  Database is utf8.  Enabled force https redirect for domain.  Everything works for me.   Some of your users may have bookmarked ip url, or it's cached in their browsers.  Are you experiencing problems?
“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 #34 on: January 23, 2021, 04:24:58 PM »
Im running smooth other than that copy paste error sometimes in the Sub-Post .php
but that seems to be fixed as i just did it.   
I am not sure about others not being able to post though.

We just had over 1100 members on so I dont think logging in is an issue anymore

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #35 on: January 23, 2021, 04:34:58 PM »
Still logging referring url errors, those are usually bots unless you're getting reports of members unable to login.  I disabled forum caching and had to remove fulltext search index to run utf8 convrersion.  You can restore them, but let forum run a while to see if problems have cleared.  Don't think any of this is theme related.
“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 #36 on: January 23, 2021, 04:39:10 PM »
Right now it is running super fast. No issues on my end, Ill track user-posted complaints.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #37 on: January 23, 2021, 04:42:23 PM »
Just added a redirect to .htaccess that redirects IP to domain.  Did the problems start when you migrated to WHM?
“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 #38 on: January 23, 2021, 04:49:50 PM »
Just added a redirect to .htaccess that redirects IP to domain.  Did the problems start when you migrated to WHM?

Yes,. Godaddy was straight Cpanel.
This one, is WHM that I need to use to access everything.

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: Forum software vs Database
« Reply #39 on: January 23, 2021, 04:57:42 PM »
Hats off to Sir Osis of Liver.

King Arthur is sitting with his Knights of the Round Table, talking about hard times that have befallen the kingdom ever since the Black Knight stole the Singing Sword. He asks his knights—among them Sir Osis of Liver and Sir Loin of Beef—for a volunteer to get the sword back. The knights complain that the Black Knight has a fire-breathing dragon guarding the sword and is invincible.

He pulled the sword and slayed the forum gremlin.


Thank you greatly

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #40 on: January 23, 2021, 05:05:52 PM »
Too early to tell. ;)

Logged couple of these -

https://weaponsguild.com/forum/index.php?action=pm;f=sent;l=-1
Database Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'weaponsg_jestism.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT MAX(pm.id_pm) AS id_pm, pm.id_pm_head
FROM hbf_personal_messages AS pm
WHERE pm.id_member_from = 537
AND pm.deleted_by_sender = 0
GROUP BY pm.id_pm_head
ORDER BY pm.id_pm ASC
LIMIT 0, 15
Apply Filter: Only show the errors from this file
File: /home/weaponsg/public_html/forum/Sources/PersonalMessage.php
Line: 700



Also one of your guys had an attachment blocked (twice) -

Your attachment has failed security checks and cannot be uploaded. Please consult the forum administrator.
“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 #41 on: January 23, 2021, 05:11:15 PM »
No matter how many times we tell them about size limits on attachments they always try super big cell phone photos.

Many who have had issues are posting that they have been corrected.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,810
  • We were all equal in the end.
Re: Forum software vs Database
« Reply #42 on: January 23, 2021, 05:12:58 PM »
Had that problem on one of my forums, this mod fixed it.
“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 #43 on: January 23, 2021, 05:14:57 PM »
I'll have to install it.
It has been a real issue since cell phones take such large photos now