Advertisement:

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

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,811
  • 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,811
  • 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,511
  • 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,811
  • 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,511
  • 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,811
  • 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,811
  • 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,811
  • 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,811
  • 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,811
  • 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,811
  • 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