Search found 24 matches

by BPickle
Sun Jun 07, 2026 8:05 pm
Forum: Community Help & Support
Topic: 1.1.0.2 Questions / Comments / Concerns / Feedback
Replies: 9
Views: 4890

Re: 1.1.0.2 Questions / Comments / Concerns / Feedback

BPickle wrote: Tue Jun 02, 2026 11:08 am This also shows the hazards of upgrading to too many versions at one time. It might make it more easy to miss something.
Just in case you didn't notice, this closing comment blamed me.
by BPickle
Tue Jun 02, 2026 11:08 am
Forum: Community Help & Support
Topic: 1.1.0.2 Questions / Comments / Concerns / Feedback
Replies: 9
Views: 4890

Re: 1.1.0.2 Questions / Comments / Concerns / Feedback

3. REQUIRED Visit Info Pages page in Admin and create any that are missing (there will be at least two pages that you need to set up) Admin > Tools > Info Pages Seems like adding the pages in update.sql and then editing them might have been helpful, rather than adding them from scratch. This also s...
by BPickle
Tue Jun 02, 2026 2:11 am
Forum: Community Help & Support
Topic: 1.1.0.2 Questions / Comments / Concerns / Feedback
Replies: 9
Views: 4890

Did an SQL get left out of an the update for 1.1.0.1 to 1.1.0.2?

Due to a bots issue, I turned off cookies to test something, and ended up with errors on the cookie_usage.php page. That led to this discovery: update_1.1.0.1_1.1.0.2/1.1.0.2/1.1.0.1/update/install/phoenix.sql: has this: INSERT INTO pages (pages_id, date_added, pages_status, slug, sort_order) VALUES...
by BPickle
Sun May 31, 2026 8:26 pm
Forum: Community Help & Support
Topic: Is there a way to cache queries?
Replies: 9
Views: 1699

Re: Is there a way to cache queries?

I went ahead and enabled Redis for sessions in PhoenixCart, and the errors have suddenly stopped. So on Friday when the web host tech support added two indexes and cleared out stale data, whatever that means, things improved. I repeatedly clicked various categories in the tree, and didn't come up wi...
by BPickle
Sun May 31, 2026 6:11 pm
Forum: Community Help & Support
Topic: Is there a way to cache queries?
Replies: 9
Views: 1699

Re: Is there a way to cache queries?

Check your clients hosting situation. Shared hosting + 503 errors -> almost always a plan limit. If it's a `bucket` host (GoDaddy, HostGator, etc.) with zillions of sites on every server, your 503 could be someone elses fault entirely. Get the error logs. If see "worker connections exceeded&qu...
by BPickle
Sun May 31, 2026 6:01 pm
Forum: Community Help & Support
Topic: Is there a way to cache queries?
Replies: 9
Views: 1699

Re: Is there a way to cache queries?

MySQL (and probably MariaDB) can cache database queries if you turn it on. Cloudflare can cache page hits if you turn that on. It has a free tier. In addition to robots.txt, etc. CloudFlare is already caching static files, but not PHP files. I will inquire from the web host about caching database q...
by BPickle
Sun May 31, 2026 5:58 pm
Forum: Community Help & Support
Topic: Is there a way to cache queries?
Replies: 9
Views: 1699

Re: Is there a way to cache queries?

It should be in robots.txt not .htaccess You might want to add some disallows while you're at it User-agent: * Disallow: /account* Disallow: /address* Disallow: /advanced_search* Disallow: /checkout* Disallow: /cookie_usage.php Disallow: /account* Disallow: /create_account* Disallow: /login.php Dis...
by BPickle
Fri May 29, 2026 7:47 pm
Forum: Community Help & Support
Topic: Is there a way to cache queries?
Replies: 9
Views: 1699

Re: Is there a way to cache queries?

It only caches the urls that it writes, so no it won't help. First step - make sure that Prevent Spider Sessions is set to True Update the includes/spiders.txt if not recently done. You can get one here: https://github.com/BrockleyJohn/spiders Make sure there's a robots.txt set up and that it has a...
by BPickle
Fri May 29, 2026 6:01 pm
Forum: Community Help & Support
Topic: Is there a way to cache queries?
Replies: 9
Views: 1699

Is there a way to cache queries?

Hi. I'm trying to tweak my client's Phoenix Cart 1.1.0.6 setup to lessen the load on the server CPU. Right now high CPU usage seems to be triggering 503 errors due to exceeding the limit. Is caching queries an option? I would think caching only some queries would work, if it's even possible, since c...
by BPickle
Thu May 05, 2022 3:25 am
Forum: Community Help & Support
Topic: 1.0.8.14 Questions / Comments / Concerns
Replies: 10
Views: 6416

Re: 1.0.8.14 Questions / Comments / Concerns

In the file includes/modules/pi/product_info/pi_options_attributes.php I would suggest changing line 50 from if ((PI_OA_ENFORCE === 'True') && (PI_OA_HELPER === 'True')) { to if ((PI_OA_ENFORCE === 'True') && (PI_OA_HELPER === 'True') && count($attribute['values']) > 1) { Thi...