matchattaxoutlet

January 14, 2014

Hi all,

I am seeing spikes in my CPU usage stats in my web hosting panel and as a consequence of this my site is occasionally restricted.

I have raised this with my web hosting support team and they put it down to heavy usage periods, however, i am also seeing these spikes in the middle of the night. Here is part of the response from them;

"Looking closely I can see a lot of hits to:
/js/plugins.php 149,171
/js/styles/styles.php 148,264

These two pages by far are the highest hit pages, with the homepage being:
/ 14,188

The traffic does seem to come from a good range of IP, and there is a little bot traffic compared to what I believe to be legitimate traffic. I see you have a robots.txt file in place to control this.

What have you got running as part of those plugins? Are you able to contact a developer as this would suggest the design and plugins may be coded non-efficiently, and a developer may be able to shed light on this?
a fairly large amount of traffic, with :

1,910,770 Hits
(95 Hits/Visit)

This month so far, it may be a signal to upgrade, let me know if you would like any information on that, however reviewing your plugins and themes may help towards the issue."

Can anyone shed any light on what may be causing this?

Thanks in Advance

January 14, 2014

Any ideas on this? Anyone?

November 22, 2013

This is something that i would find useful too as i sell football cards and have products with same names but from different categories. It would be great if categories were displayed too.

Any ideas guys or could this become a feature in a future release maybe?

November 6, 2013

Interesting that Mehisahar's question is copied from my earlier post, '?do=embed' frameborder='0' data-embedContent>> word for word!!

November 1, 2013

Thanks, i'll give it a try.

just one thing can you confirm that the file should actually be /controllers/controller.index.inc.php

October 30, 2013

Hi,

My error logs are full of hundreds the following type of error, occurring at varying intervals, the only thing differing in each line is the filename ending in .cache.

[25-Oct-2013 08:16:44 Europe/London] PHP Warning: unlink(/home/xxxxx/public_html/cache/89e12.sql.a1cb2ebcda10fd4d50ae9ae7b34addbd.cache) [<a href='http://docs.php.net/manual/en/function.unlink.php'>function.unlink.php</a>]: No such file or directory in /home/xxxxx/public_html/classes/cache/file.class.php on line 70

Any ideas on the cause of this?

All help gratefully received!

October 23, 2013

Thanks guys for yet more invaluable advice.

October 22, 2013

Hi Guys,

I am looking to upgrade my CC5.2.2 installation (first to 5.2.3 then on to 5.2.4) by manually editing all the files listed in the file diffs uploaded by BSmither.

I know this will take time but i'm wondering if there is anything i need to do to upgrade / alter my database, e.g. is there a command i need to run after i have manually made my changes?

It's just that i noticed a new file in the list called /setup/db/upgrade/5.2.3.sql in the list and wondered if this changed anything and if i am doing manual changes i won't be running the setup wizard

Thanks for any enlightenment

September 25, 2013

Hi Guys,

Just been trawling through my php_errorlog and came across the following error (amongst many)

25-Sep-2013 10:30:04 Europe/London] PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 1106

[25-Sep-2013 10:30:06 Europe/London] PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/classes/ajax.class.php on line 163

[25-Sep-2013 10:30:06 Europe/London] PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 1088

[25-Sep-2013 10:30:06 Europe/London] PHP Warning: implode() [<a href='http://docs.php.net/manual/en/function.implode.php'>function.implode.php</a>]: Invalid arguments passed in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 1102

Also get lots of these in my system error logs after installing loyalty points mod. Noodleman says they are nothing to fret about. Is this the case?

File: [controller.index.php] Line: [0] "DELETE FROM plugin_customer_rewards WHERE related_order_number IN (SELECT * FROM (SELECT cart_order_id FROM cc4_CubeCart_order_summary WHERE status IN (1,4,5,6) AND cart_order_id IN (SELECT distinct(cr.related_order_number) FROM plugin_customer_rewards cr)) as a) " - Deadlock found when trying to get lock; try restarting transaction

Thanks in advance

September 17, 2013

Thanks guys for your input.

TBH i am convinced this is due to connection issues with my host, getting them to admit it is proving hard work.

Dirty butter, you are correct in your assumption, my cubecart is an upgrade (i have it in my signature).

September 16, 2013

Hi Dirty Butter, thanks for taking a look.

I think the reference in the comment to cc4 is due to the fact my sql database is called xxxx_cc4

Are you aware of any limits on the number of items in a customers basket? On cc4 i found that if anyone added more than 250 individual items then as soon as they left the basket it would empty. A very frustrating scenario and during the time these errors appeared there was a customer online who may have added many items. This though may be totally unrelated.

September 16, 2013

Can anyone shed any light on this error message?

File: [gui.class.php] Line: [914] "SELECT * FROM `cc4_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc4_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

It appeared dozens of times in the space of 5 mins. Been on to my hosting company and they said there is no problem at their end.

I had a customer online at the time and his basket got wiped, he didn't come back!!!

Customer Sessions / Users Online · September 16, 2013

Hi all,

I used to use a mod on the admin of my CC4 store called customer sessions which allowed me to see in more detail who was on my store at any given time and also their basket contents.

I would love to have this facility in CC5 as the "Users Online" section is quite vague in it's output.

Is this do-able, not sure how easy it would be to achieve.

Thanks in Advance

September 11, 2013

Thanks once again Dirty Butter.

I did a search for this but it turned up nothing, so apologies for the repetition.

Interestingly, when i deleted the whole phrase it would not save, so i left a single character and saved, this worked. Then i went in again to delete the single character and saved again and this time having nothing in the box worked!!!!!!

September 11, 2013

Hi,

When i navigate to any of my subcategory pages i see " No products found" displayed below my subcategories. Please take a look at www.matchattaxoutlet.co.uk to see what i mean.

Is there a way to remove this at all?

Thanks in advance

September 10, 2013

I just restored the original and the images didn't reappear, so maybe i already edited the template file.

September 9, 2013

I did mean line 845, copy & paste let me down!!!

I have changed the config.xml file, if i recall i did this to remove the thumbnail image from my product details pages.

This was the original config.xml section i edited;

-<images>

<image default="noimage_thumbnail.png" quality="75" maximum="138" reference="thumbnail"/>

<image default="" quality="100" maximum="580" reference="category"/>

<image default="noimage_subcategory.png" quality="70" maximum="70" reference="subcategory"/>

And this is following the changes;

-<images>

<image default="noimage_thumbnail.png" quality="75" maximum="138" reference="thumbnail"/>

<image default="" quality="100" maximum="580" reference="category"/>

<image default="noimage_subcategory.png" quality="70" maximum="70" reference="subcategory"/>

<image default="noimage_normal.png" quality="90" maximum="270" reference="normal"/>

I assume this is wrong!!!

September 9, 2013

I Had a word with my hosting company and it seems the errors were related to issues with the server load.

Thanks for the tweaks Dirty Butter, i was wondering where the setting was to centre the title on my homepage.

Can i be a real pain in the derriere and ask for a bit more info on the following message from the same log?

PHP Notice: No image mode set in /home/xxxx/public_html/classes/catalogue.class.php on line 84

This seems to occur fairly often too.

September 9, 2013

I shall check with my hosting provider, thanks for the pointers.

September 9, 2013

I enabled debugging in my admin but am not seeing any errors.

Interestingly, i did a search on google for the messages and it gave me links to another cubecart store see below

http://www.gamblesgifts.com/eye-patches/plain-brown-with-leather-stitching.html

This shows similar messages in the debugging section!!!!

I have just cleared the log (after saving the original) and will try to monitor what triggers the problem.

September 9, 2013

Hi, Thanks for the reply, my store seems to be working fine. Please take a look at www.matchattaxoutlet.co.uk (any feedback would also be useful).

I can't really pinpoint anything that was going on with the store or admin at the time, these statements or similar have appeared approx 3 times today.

the following line also appeared

[09-Sep-2013 08:00:29 Europe/London] PHP Notice: `product_id` is not allowed as a key in 'CubeCart_inventory' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

Puzzled!!!!!

September 9, 2013

Just been checking my error log and found the following errors / notices.

Anyone shed any light on what these messages are?

[09-Sep-2013 11:33:53 UTC] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 11:33:53 UTC] PHP Notice: `session_last` is not allowed as a key in 'CubeCart_sessions' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:34:24 Europe/London] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:34:24 Europe/London] PHP Notice: `session_last` is not allowed as a key in 'CubeCart_sessions' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 11:36:47 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_hooks' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 11:36:47 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_code_snippet' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 11:36:47 UTC] PHP Notice: `path` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 11:36:47 UTC] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:07:21 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_hooks' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:07:21 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_code_snippet' table! in /home/xxxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:07:21 UTC] PHP Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:07:21 UTC] PHP Notice: `module` is not allowed as a key in 'CubeCart_modules' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:07:21 UTC] PHP Notice: `status` is not allowed as a key in 'CubeCart_modules' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:07:21 UTC] PHP Notice: `code` is not allowed as a key in 'CubeCart_currency' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 12:07:21 UTC] PHP Notice: `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `doc_home` is not allowed as a key in 'CubeCart_documents' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /home/xxxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `status` is not allowed as a key in 'CubeCart_inventory' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `featured` is not allowed as a key in 'CubeCart_inventory' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `active` is not allowed as a key in 'CubeCart_currency' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `type` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `item_id` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794

[09-Sep-2013 13:07:21 Europe/London] PHP Notice: `path` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794