Comments and changes to this ticket

• You flagged this item as spam.
  

  peters@slx-online.biz October 15th, 2018 @ 09:26 AM

  https://www.britishtrolley.org.uk

• You flagged this item as spam.
  

  peters@slx-online.biz October 23rd, 2018 @ 12:19 PM

  I've escalated this to UK2 2nd line support, still awaiting a response. Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz November 15th, 2018 @ 01:51 PM

  Just to complete the picture from this end: UK2 made the change to strict on MySQL with a PHP update. They are not prepared to revert. As a temporary measure I have moved the database only to my Fasthosts account. Update capabilities are restored, but it runs noticeably slower with the db not in-house at UK2.

• You flagged this item as spam.
  

  peters@slx-online.biz October 29th, 2019 @ 02:48 PM

  Hi Dave. I've not been able to keep tabs on this since a year ago. As we left it, I moved the MySQL database to another platform as the web site host had updated MySQL to enforce Strict. With no access to the actual (shared) server, we've lived with this since - works fine although doing updates is a bit slow!

  Is this an issue that you may have resolved in the last year, is it perhaps in 2.5.1? When will that be available please? I'm still at 2.4.2.

  I am currently handing over to a new Webmaster, so am trying to sort out what he may need to do!!

  Many thanks.
  Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz December 9th, 2019 @ 04:52 PM

  Hi Dave. I appreciate you're busy, but now I've handed over my webmaster duties I am still left with the responsibility of sorting out this issue. At some point in the not-too-distant future I'd really like to get the database moved back to the same provider as Exponent. Right now the database is on my own account at Fasthosts where I can't allow the new webmaster access.

  Please could you let me know if this issue has been resolved in any updates or is it still outstanding? If the latter, when might it be resolved please? It's over a year since the last update.

  Thanks.
  Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz December 10th, 2019 @ 09:45 AM

  I did try this, but they refused. I can try again, but don't hold your breath! Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz March 5th, 2020 @ 02:08 PM

  Hi Dave. Just looked at the changes in the new release 2.5.x - no mention of this issue so I wondered if there's any plans to fix it in the code please??

  I have been around the houses again pn changing sql_mode without success. I've looked at alternative ISPs but am left with Fasthosts hosting the database and the site at UK2. Nobody wants to change their shared servers. The only way I can potentially get everything back under one roof is to rent a VPS and transfer into that. Because this site is for a charity with limited resources, it is doubtful they will fund the somewhat higher costs.

  I do hope you can plan this in soon.

  Thanks.
  Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz March 5th, 2020 @ 05:43 PM

  Yes, I understand that and did say so. My question was, do you have any plans to fix this long-standing problem that puts us at the mercy of inflexible ISPs?

  Thanks.
  Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz March 11th, 2020 @ 09:23 AM

  Sounds hopeful. Thanks. I'll probably need to wait a little while depending when you release. This and next month are the peak times for membership renewals, but then it should quieten down. Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz September 6th, 2020 @ 09:13 AM

  Hi. You marked this as Resolved and said it would be fixed in 2.5.2, which would be available late 2020. I've just checked status and see you are now saying December 2021. This is becoming an issue at this end, as I have had to pass site support to someone else, but am still running the MySQL database on my own web space. I must get this resolved so I can help the new support guy to migrate the database to the web site ISP and free up my own resources.

  Is there any way you can help me here so I don't have to continue my involvement with this web site for another 15+ months?

  Thank you.

• You flagged this item as spam.
  

  peters@slx-online.biz September 6th, 2020 @ 12:31 PM

  Thanks for the prompt reply. I obviously didn't understand your comment about recent code push. I wish I'd realised a lot sooner, but hey, we are where we are.

  I'm not sure how to manage the upgrade with the database currently somewhere entirely different from the website.

  So I guess I need to create a new database on the web site server and populate it by copying all the data across from my own server. Then presumably I can point Exponent to the new database, run the 2.5.1 plus patches followed by the database update. However this is a live site so not sure if we can take it down for long. Of course I'm always nervous about upgrades in case something goes wrong....

  Any advice you can give would be gratefully appreciated! It's so long since I did the last upgrade I can't remember the procedure! Is it feasible to do this with minimum downtime?

  BTW - I replied to the email 'above the line' but it got bounced as you used a 'noreply' address.

• You flagged this item as spam.
  

  peters@slx-online.biz September 25th, 2020 @ 11:03 AM

  Today I uploaded all of the 2.5.1 files and changed the folder permissions to 775 as shown in the guide.

  I am logged in as super admin. Entering https://www.britishtrolley.org.uk/install/index.php produces a Page Not Found error. The folder and file are there.

  HELP please!!

  • Capture7.JPG 90 KB

• You flagged this item as spam.
  

  peters@slx-online.biz September 25th, 2020 @ 12:22 PM

  I replied to your emails but they got sent back just now.

  As far as I can tell this is an Apache server.

  Attached is the main htaccess file. There isn't one in Install.

  Web site is still working. Version shown from the Exponent pull-down when logged in is 2.5.1

  Interestingly, before uploading the files I could not add a module (original problem) but after upload I can create and edit a new module.

  I tried putting a test file in Install with a meta redirect. The html file loads, displays a text message in its body then when it redirects I still get 'page not found'. So the folder and index.php are being accessed.

  One more question: Exponent shares its database now with the membership system. Am I right to assume that your updates only affect the Exponent tables and leave everything else in the database as-is?

  • .htaccess 2.9 KB

• You flagged this item as spam.
  

  peters@slx-online.biz September 25th, 2020 @ 12:31 PM

  Doesn't seem to want to process the htaccess file, here's the contents:

  Don't show directory listings.

  Options -Indexes

  Route requests to Exponent.

  DirectoryIndex index.php

  Various rewrite rules.

  
  RewriteEngine On

  # you may have to edit/uncomment the next line if running eXp from a subfolder
  

  RewriteBase /subfolder-name

  # if moving eXp from a subfolder to root, edit/uncomment ONLY one of the next 3 lines
  

  Redirect 301 /testfolder http://yourdomain.org/

  RedirectMatch 301 ^/testfolder/$ http://yourdomain.org/

  RewriteRule ^testfolder/(.*)$ /$1 [R=301,NC,L]

  # To redirect all users to access the site WITH the 'www.' prefix,
  # (http://example.com/... will be redirected to http://www.example.com/...)
  # uncomment and adapt the following:
  

  RewriteCond %{HTTP_HOST} ^example.com$ [NC]

  RewriteRule ^(.*)$ http://www.example.com/$1 [L,R=301]

  # To redirect all users to access the site WITHOUT the 'www.' prefix,
  # (http://www.example.com/... will be redirected to http://example.com/...)
  # uncomment and adapt the following:
  

  RewriteCond %{HTTP_HOST} ^www.example.com$ [NC]

  RewriteRule ^(.*)$ http://example.com/$1 [L,R=301]

  # To force the domain to serve the site securely using HTTPS,
  # (http://www.example.com/... will be redirected to https://www.example.com/...)
  # uncomment and adapt the following:
  

  RewriteCond %{HTTPS} !=on

  RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

  RewriteRule ^.*\.git.* - [R=404]
  

  the next two lines will dish out .html pages if they exist, which may not be a desired effect!

  RewriteRule ^$ index.html [QSA]
  RewriteRule ^([^.]+)$ $1.html [QSA]
  
  # RewriteRule ^login.php$ login/showlogin
  
  # Kludge out certain file types that we don't want to try to route thru the eXp router.
  RewriteCond %{REQUEST_URI} !\.(css|js|pdf|shtml|htc|map)$ [NC]
  # Kludge out image files that we don't want to try to route thru the eXp router.
  RewriteCond %{REQUEST_URI} !\.(jp?g|gif|png|tiff)$ [NC]
  # Kludge out media files that we don't want to try to route thru the eXp router.
  RewriteCond %{REQUEST_URI} !\.(mp3|mp4|webm|ogv|flv|f4v)$ [NC]
  # Kludge out certain other misc files that we don't want to try to route thru the eXp router.
  RewriteCond %{REQUEST_URI} !^/robots\.txt$ [NC]
  RewriteCond %{REQUEST_URI} !^/favicon\.ico$ [NC]
  
  # These rules basically state if it isn't an existing file, directory or symlink, route it to index.php
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteCond %{REQUEST_FILENAME} !-d
  RewriteCond %{REQUEST_FILENAME} !-l
  RewriteRule ^(.*)$ index.php [QSA,L]
  

  ErrorDocument 403 /index.php?controller=notfound&action=handle_not_authorized&error=403
  ErrorDocument 404 /index.php?controller=notfound&action=handle&error=404
  ErrorDocument 500 /index.php?controller=notfound&action=handle_internal_error&error=500

• You flagged this item as spam.
  

  peters@slx-online.biz September 29th, 2020 @ 08:32 AM

  PLEASE could you give me some clues as to why the install won't run? I need to get this done and Patch 3 installed so they can do some more updates.

  Thank you!

• You flagged this item as spam.
  

  peters@slx-online.biz September 29th, 2020 @ 01:03 PM

  Thanks. Still no luck.

  • Changed permissions on install folder to 777

  • index.html file loads OK

  • Renamed install folder to expinstall - same error

  I also ran through all of the files that are called from index.php and below, checked permissions and don't see a problem. I must have run install when I set the system up on this server, so it's weird it won't run now.

• You flagged this item as spam.
  

  peters@slx-online.biz September 29th, 2020 @ 01:10 PM

  Just tried a test php file with one line to display a message. Also get page not found...

  I am now doing live chat with UK2 support...

  live chat have seen the problem and asked me to open a ticket so they can escalate to higher level. This now done, so we'll see what they find. I'll let you know, meanwhile if you have any more thoughts please let me know.

• You flagged this item as spam.
  

  peters@slx-online.biz October 2nd, 2020 @ 10:45 AM

  UK2 determined that the reason I couldn't run php files from the install folder was because something in your .htaccess that came with the update was stopping it. They put some default .htaccess there instead and php files run OK.

  I logged in and ran the install index.php. This time it returned me to the site home page without the logged in top bar. I have put the original .htaccess from the update back and I get the same result again. Maybe they fixed something then blamed it on .htaccess??

  The question now is - is this the correct action when you run install/index.php or should there be other steps involved? I thought it should run through a whole upgrade process with you?

  How do I confirm if the upgrade has been done properly? Am I OK to do Patch 3 at this stage?

  Thanks.
  Peter.

• You flagged this item as spam.
  

  peters@slx-online.biz October 3rd, 2020 @ 02:49 PM

  No, it ran through none of the steps and just returned me to the home page without the logged in top bar.

  I'll go through your steps and report back.

  Thanks.

• You flagged this item as spam.
  

  peters@slx-online.biz October 3rd, 2020 @ 02:56 PM

  OK that went through OK until the last screen which lost its formatting, see attached. After closing and reopening browser it seems OK again.

  I did put your original .htaccess back yesterday.

  So it looks like we're now at 2.5.1 ? I'll try and do the patch later.

  • Capture.JPG 74.1 KB

• You flagged this item as spam.
  

  peters@slx-online.biz October 3rd, 2020 @ 06:06 PM

  That was after Run Upgrade Scripts.

  I have now installed Patch 3 and all is well. Phew! I didn't realise you could do the patch at the same time. The documentation doesn't seem to mention patches so I was being careful!

  Thanks for your help. I've documented everything for the new support guy, and I'm here as backup if needed.

• You flagged this item as spam.
  

  peters@slx-online.biz February 10th, 2024 @ 09:53 AM

  I have today received an email with spam content, but linked to this ticket. As there's no date on your last update I don't know if that refers to this or something earlier.

  Text reads:

  sarasrescue updated ticket #1439 on Feb 10th, 2024 at 05:58 AM
  Sell your silver items and get paid instantly with our reliable service. Turn your silver into cash without any delay – sell now! https://bit.ly/46koPNi

  Please can you do the necessary to block this person.

  Thanks.
  Peter.