ToeJam

Thank You!

6 minutes ago, Stuart Silvester said:

It was used for guest page caching in earlier versions. It's no longer used in current releases.

Thank you for responding.  Is there a command or something to run, to clear it out to free up space?

Thanks

So my issue with this froze up my sites from my hosting company because the data bases of 2 of three sites became too large.  

My hosting company wants to know what the table CORE_OUTPUT_CACHE is for.  These have thousands of database entries.

Of the three sites, the only one that is active is less than 10 megs.  The other two for th sites that are not active and only use as viewing websites are 28 Gigs, and other being 11 Gigs.

What is this table for?

Thanks

1 hour ago, teraßyte said:

The EasyPost integration is a Community Enhancement.

 

You can refer to this guide to find the setting I mentioned (see the 2nd and 4th screenshots):

So I set it to Customer cannot choose, and tried to do a purchase with a random address that is physical and it shows this "Cannot send to your location". I'm a little confused, am I by not allowing customer to choose preventing EZ Post, or is it supposed to limit variations of shipping services such as FedEX ground options all the way to Next Day

8 hours ago, Marc Stridgen said:

We would not talk with your external suppliers. That would be something for yourself to do. I will see if I can get someone to take a look at this topic for you, however I would say its been answered above here

Do you have that setting switched on? If you do, Im not sure what other answer you are looking for there, as the answer is already present in this topic

Are you referring to this?  Allow Customer to Choose Rate

If so, where is this setting?  Is this where in each physical product has Shipping Method?  Or is this something else?

If this is somewhere else is it something to decide something like Ground, express saver, express next Day?

Thanks

Can I get someones email address here from IPB Support so I can include in with the support ticket I have with Easy Post, I need to get a three way conversation so I can get this solved, I'm going in circles with them telling me it's a IPB issue....and I can't get them to tell me from my logs provided what they saying is activating the rate calls

If someone form here is talking with their support team from here my ticket number is 393552

Thanks

Okay

Any feed back?  I have my logs for January, I just don't know what would count as the rate call.

Thanks

13 minutes ago, Marc Stridgen said:

Of your database is that large with only a very small number of posts, then something is very likely wrong on the hosting side, to be honest. However you do have a duplicate set of data there. check your prefix in conf_global.php. If it doesnt start with orig_ then you should delete all the tables that begin with that. Ensure you backup of course

Here's what I see when I open up that file

<?php

$INFO = array (
  'sql_driver' => 'mysql',
  'sql_host' => 'localhost',
  'sql_database' => 'westco5_IPB',
  'sql_user' => '*****',
  'sql_pass' => '*******',
  'sql_tbl_prefix' => '',
  'sql_debug' => '1',
  'sql_charset' => 'utf8mb4',
  'board_start' => '1264124418',
  'installed' => '1',
  'php_ext' => 'php',
  'safe_mode' => '0',
  'board_url' => 'http://westcoastsignco.com/forums',
  'banned_group' => '5',
  'admin_group' => '4',
  'guest_group' => '2',
  'member_group' => '3',
  'auth_group' => '1',
  'use_friendly_urls' => '0',
  '_jsDebug' => '0',
  'mysql_tbl_type' => 'MyISAM',
  'sql_utf8mb4' => true,
);

except for the ***** 

So, these should say for example:

orig_'sql_driver' => 'msql'

23 minutes ago, Jim M said:

Without understanding what particular table is large or what is going on at the database level, we can't really tell you if this is normal or not.

Sorry if this is not the right way to do it or if I need to get you channel access

Here's a snap shot of what I can see without doing anything serious to the tables.  I only have 11 posts, and use the gallery.  

Sorry forgot to include this screen shot

Hi,

I have a site that only has 11 Posts that I primarily use as a website for viewing with no interaction with members, I don't take members.  

But my hosting company contacted me to tell me that the Database is unusually large of 14gb.  Is there anything I can do to possibly clean this up?

I have my logs too.  maybe they can tell me what would register as a rate.  I can't find much other than spiders viewing products

31 minutes ago, Jim M said:

I have tagged this to a developer to confirm when the rate check is performed. 

Thank you very much Jim

Thanks Marc

So I'm trying to figure out a way where guests and spiders can view but not make a purchase or trigger where they can see shipping rates.  I played with Commerce > Billing & Purchases > permissions.  This didn't look like it affected anything when deselecting.

I logged to and went in as a guest, posting pics in order.

Store View

Item in a category

Item to select 

Checking out

Clicking Checkout and now I need to Login to proceed

So this is my normal process.  So if I'm not able to get past this point and no shipping rates, why would this count against me as this "ratings call"?  When I go to the ACP I see that a guest tried to make a purchase

If I deselect Guests & Spiders (Billing & Purchases) I can still make it as far as above and the attempt or pending invoice is still visible in the ACP.  Are the Billing & Purchases permissions not working?

I would rather not block guests and especially spiders outright, but I'll do whatever it takes I suppose.  

I don't see anything for permissions there for guests and bots for the store.  Wasn't there something somewhere that doesn't allow guests or bots to purchase or put items in the cart.  I thought there wa something there that if you were not logged in, it would tell you you must be a registered member to purchase?

So, right now I'm getting charged up the ring yang for this by EasyPost.  It's been some time, but is there a way to shut off guest view of the shopping cart/store?  I thought there was but can't seem to find it.  

Thanks

53 minutes ago, Jim M said:

You would want to contact your hosting provider or server administrator if you are not comfortable or have the knowledge to do this kind of log investigation on your server.

These would be shipping rates.

Attaching a screen shot of my Invoices, some things failed...where I guess they would have been giving shipping rates, but for the date span they are telling me in the last 11 days they got nearly 2,000 rating calls.

Here I see 10 failed tries, and only 6 physical products sold. (Last 30 Days)

I can't find where permissions are, but I'm sure you have to be logged in to attempt to purchase something, or be a member.  Wait, I do see guest, but that is logged.  

Or am I just not fully understanding how tis works.

Thanks

What logs do I check for this?  

Also, when you say checking rates, are you saying viewing a product, or going to far as to put it in a cart get ready to check out but not complete it by paying....or something along those lines?

Thanks

Erik

Hi,

I'm having an issue.  I have a very low traffic site and I'm having Easy Post do my physical shipping in my store.  In 1 month I got charged $100 for 6 physical items shipped.  When I contact them they're telling me below

Quote

Thank you for reaching out to us regarding the Rating overage fee that has been assessed on your account. Currently, on the Developer plan, if you create and purchase a Shipment through EasyPost (up to 120,000 per year), then you get one Address Verification call, one Tracker call, and up to three Rating calls included without any overages or additional "per label" fees. Each Rating call in excess of the 3:1 ratio is assessed an overage fee of $.02 per additional call. If you never purchase any labels through EasyPost, then every call will be an overage. This rating overage charge of $96.98 was assessed for the date range 12/25/23 - 01/27/24. 
 
If your company’s volume is higher than what’s provided for in the Developer plan, then we would be happy to evaluate a Custom Plan for you that could possibly be negotiated to include unlimited Rating calls. Let me know if you would like to explore this option, and I can gather some information from you so I can get you in touch with the right team. Please let me know if you have additional questions.

******2nd Email reply******

These fees are not about the amount of products you've sold on your website. These fees are about the number of rating calls being made to our API that are in excess of the 3:1 ratio I mentioned previously. Overage fees for excess Rating calls and AVS calls are only assessed once per month by our Finance team. Unfortunately, we don't have reporting available for these overages, as it is simply the total number of Rating/AVS calls compared with the number of labels purchased over a specific period of time.
 
Our active, accessible Request Logs only go back about 11 days, and in that timeframe, I'm seeing about 1961 Rating calls, but 0 labels have been purchased. This likely will result in an overage fee in the amount of around $39.22 for that time period. Sadly, I'm not able to compile this information into any sort of report and I would recommend reaching out to your third-party application or developer to reduce the amount of calls. 

I'm getting charged on these "Rating calls". What is this, is it caused by bots?  I have a very low traffic site like I said, it's dedicated to a small industry trade.

I thought I had read at one time there were some different online cart software companies to use once the IPS5 comes out, I just can't seem to find where I read it.  But you will be releasing this information on where it's suggested to transition too?

Sorry if it's been mentioned multiple times, I just haven't been very active

Thanks

11 minutes ago, Jim M said:

 

Please see my colleague’s answer I quoted here.

Version 5 will most likely be Q1 2024. 

So what were the suggested store software companies to use to continue selling physical products?

25 minutes ago, Jim M said:

You have wrong information. Our Commerce application is not getting removed. Only physical products (those which are tangible and need to be shipped) are. 

So what were the suggested stores to continue selling products?  Also, any ETA on when this IPS 5 will be out?  Early, mid, or late next year?

Thanks

What were some of the options out there to integrate a store to sell physical products?

Thanks

I'm having a issue with my front page banner not showing up sometimes in Unreal Portal and not sure if this error is related to my error log

UnexpectedValueException: Missing: /applications/uportal/Application.php (0)
#0 /home/thesig5/public_html/forums/system/Patterns/ActiveRecord.php(148): IPS\_Application::constructFromData(Array)
#1 /home/thesig5/public_html/forums/system/Application/Application.php(236): IPS\Patterns\_ActiveRecord::load('uportal', 'app_directory', NULL)
#2 /home/thesig5/public_html/forums/system/Dispatcher/Standard.php(161): IPS\_Application::load('uportal')
#3 /home/thesig5/public_html/forums/system/Dispatcher/Front.php(106): IPS\Dispatcher\_Standard->init()
#4 /home/thesig5/public_html/forums/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init()
#5 /home/thesig5/public_html/forums/index.php(13): IPS\_Dispatcher::i()
#6 {main}

Backtrace

#0 /home/thesig5/public_html/forums/init.php(1034): IPS\_Log::log('UnexpectedValue...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(UnexpectedValueException))
#2 {main}

What is the Dispatcher?