Unfortunately the whole product page went missing, I cannot afford to keep the site like this for a long period.
I tried to turn the cache off and it fixed the problem for the moment. Turned back the cache again however I was wondering if there is a connection.

About the same time the problem appears I get long orror messages in OC Log. Ex:

2015-01-19 15:16:49 – PHP Notice: Error: MySQL server has gone awayError No: 2006SELECT p.*, pd.name, pd.description, pd.meta_description, m.name AS manufacturer,(SELECT pi.image
FROM oc_product_image AS pi
WHERE pi.product_id = p.product_id
ORDER BY pi.sort_order ASC
LIMIT 1) AS secondary_image,
(SELECT price
FROM oc_product_discount AS pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id = ’1′
AND pd2.quantity = ’1′ AND ((pd2.date_start = ’0000-00-00′ OR pd2.date_start NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC
LIMIT 1
) AS discount,
(SELECT price
FROM oc_product_special AS ps
WHERE ps.product_id = p.product_id
AND ps.customer_group_id = ’1′
AND ((ps.date_start = ’0000-00-00′ OR ps.date_start NOW()))
ORDER BY ps.priority ASC, ps.price ASC
LIMIT 1
) AS special,
(SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id
AND r1.status = ’1′
GROUP BY r1.product_id
) AS rating,
(SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id
AND ss.language_id = ’2′
) AS stock_status,
(SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = ’1′
GROUP BY r2.product_id
) AS reviews
FROM oc_product AS p
INNER JOIN oc_product_description AS pd ON p.product_id = pd.product_id
LEFT JOIN oc_manufacturer AS m ON p.manufacturer_id = m.manufacturer_id INNER JOIN oc_product_to_store p2s ON p.product_id = p2s.product_id
WHERE p.status = 1
AND p.date_available <= NOW()
AND pd.language_id = 2 AND p2s.store_id = 0 ORDER BY RAND() LIMIT 0,20 in /home/pufushop/public_html/system/database/mysql.php on line 50

Hi,

It is a local company and it is shared hosting. Acording to the details in cPanel report my limit is:

100 processes, 300 Mb Physical Memory and 300 Mb Virtual Memory.

In the reporting page I got the message:
“You have reached entry processes (number of simultaneously running php and cgi scripts, as well as cron jobs and shell sessions) limit 11 times”

With the new setup I recon you will recomend to upgrade my hosting as the site needs more resources. Even without the issues there is a significant slowdown since I applied the new theme.

Still, not all issues are related to this and I still do not understand, if something happens when limit is reached why do I have to log in to Pavilion cpanel and save rather then things return to normal by themselves when load is balanced?

If the problem is the hosting company, I will talk to them for an upgrade. In the meantime pleasetake a look at the other issues described above. To make things simpler I will re-post the still unfixed ones here:

3. Facebook settings are pretty straight FW in Pavilion CP > Theme Settings > Social.
Facebook is enabled, app id is correct and the widget is working properly on the bottom ofthe page, only the Like / Share button is not displayed neither on home page nor on product page. I do not see any other settings how these could be activated and I would like both like and share buttons to work.

5. Yes it is still valid although not that that important(style difference between modules in tabs/accordion). If you check on the home page in the tabs/accordion there are 3 tabs, in the 1st one (“Oferte speciale”) the products are displayed with the text wery close to the margins, the second (“Noutati”) and 3rd(“Cele mai vandute”) displays the text with padding. I would like to know why and if I can change it so all 3 look the same (like the 1st one). This seems like a bug, things seems to be inherited differently in case of the Specials.

6. So you are saying that the Specials and Best sellers are from the default OC modules and they are probably not working. I did not compare them and do not have the courage to go back to the default theme. (last time i reverted back to default there were some unintended changes with picture size and some minor settings and I will not risk it with the live store). P.S. I have a dev. server but it is a work in progress so it does not work properly su I have to work on the live store…hence my desperation when things do not work properly

7. Customers pointed a few issues I was not aware:

a> when accessing the site in the format pufushop.ro (without www in front, as probably most do) the icons (shopping cart, whishlist, compare) are not displayed. In case of chrome there is a thin black square, in explorer nothing…
I fixed this with a redirect from cpanel to www but it does not fix the root cause.
Is the redirect a proper solution or it can have some concequences I am not aware?

b> when accessing the site from anandroid phone and in portrait position, the text from the add to cart button (“adauga in cos”) is not resized properly and it overlaps the compare and whislist buttons. From iOs it work properly.

c> with mobile access (android mobile phone) the icon list on the home page is displayed in a vertical line and on the left side rateher then horizontal and middle.

d> In the meantime I found several minor bugs with mobile access, unfortunately it presents itself diferent from one phone to another depending on the resolution. Basicly some of the page content is not properly “responsive” text overpaps the text box/button, product details are not resized properly and are displayed either outside of the margins or overlapping other stuff. Basicly minor stuff but it makes the site on the mobile phone look unfinished. I would like to know how I can fix these.

Some of these issues are important to be fixed, others I pointed out as others might be facing the same issues without being aware. Hope it helps with developing the next update.

P.S. I am looking for an opencart “specialist” locally as support over mail is not efficient and fast but noone seems to invest in opencart and are moving on to prestashop and other platforms.

Thank you

Thank you for your prompt answer!

Ok, will do what you suggested. Also contacted the the hosting company and they provided further details:

Currently I have this package:

Max 25% CPU, 15 processes and 300MB RAM – shoud it be enough?

For the next 48 hours they set up the next package in line to see if it improves the situation:

Max 30% CPU, 20 processes and 400MB RAM

Are there any risks of installing vqmod? Could it potentially cause further problems to the site? I couldn’t find a web designer/opencart specialst and don’t want to risk doing further damage.

Thank you

Hello again,

With all the improvements (optimization mod and better plan from hosting) the issues still persist.
Both server gone away errors on frontend and randomly not working components.
Hosting support is positive that issues are not from server side as limit was rarely reached in the last couple days and issues persisted even with improved plan.
I am getting customers creating accounts and not ordering anything which does not make sense, so there might be some issues with checkout or adding products to cart too. I simulated a few orders and for me they work.

There are a lot of small “gliches” which probably will be sorted out with upgrades and I can live with them but untill then I need my site to be working again.

Please advise, should I try an even better plan or how should I approach this. I invested too much time and lost too many nights to go back to the default theme. I am aware that I am one of many you have to help sort out issues but for me this is all I got.

Thank you.

Hello,
I am not sure where you are going with this approach, but you are not offering me real help.

As I mentioned above I installed the vqmod immediately after you suggested but did not help a lot. The category product count is off, still the count appears on the left side menu, it only disables it on the top display.

My hosting company has an 8sec limit for scripts and that was enough until now. They cannot offer me more.

Not sure how you see this situation but from my perspective I installed properly your theme to a near stock and working OC installation, and after the installation I started to have a lot of issues. My error log is full with error messages I never encountered before (not just server gone away but “undefined variable”, “invalid argument” etc, some complicated and some pointing to the pavilion theme, or some tb_* stuff)
The vQmod did not solve the issue and my site is not working properly since.
The theme was advertised as optimized for speed and fast performance but my site is slower then ever, even with a much better plan. I am pretty sure that it is not because of the absolutely minor changes made which were mostly language related.

Facebook like button is not working although it is set up properly.

On mobile it looks…well take a look from and android device, although it looks different from one mobile to another, it is not displayed properly on none, neither iOs not android stock browser, with images overlayed, site logo under buttons, content not centered and other minor issues.

In my opinion these are issues with applying the theme, issues that are not from my fault and should be fixed by you. I was hoping that fixing these issues would also help you prevent them happening with others.

When you offer a product on the international market for a large number of customers it is normal that it will not work perfectly for all and there will be some customer who will require more help then others to make it work, you cannot set it up for every possible situation but you cannot expect that every customer installs it to a new OC install. If the site works with default theme, it should work with pavilion.

I am sure that you approach and opinion on this is different, I presented you my perspective as the customer.

I need an honest answer from you if you are willing to help me with the above or not. I wrote at least in 3 post a detailed description of the issues and I am tired of writing posts which are clearly not read carefully and receiving in a few days a short and “dry” answer, mostly blaming someone else or lack of info for them. I am positive that you are a competent team and with a few minutes of dedicated attention you could fix most of them. I saw what a programmer who never worked with OC could do in a few minutes! You guys must be way better.
If the support you offer is going to be like this I will accept NO for an answer and leave you alone. The theme is great and I will find a way to properly implement it but for support in these conditions it is just not worth it to continue. We will just end up hating each other.

Hope you understand and accept my point of view,

Zsolt

P.S Please send me the requirements for OC 1.5.5.1 to work properly with your theme(I have under 1000 products and 5000-10000 unique visitor/month, images are optimized, gzip and usual optimizations are enabled). It seems to need more resources or a different setup then the default theme and I need these to find a proper host. I will accept any suggestion for this matter.

About the site’s performance.

We have applied some fixes to tb_optimizations.xml, because it had some minor issues with OC 1.5.5.1. We have measured then the performance of your site and came to the following conclusions:
- The average page generation time (this reflects the server performance) and mysql queries number with Pavilion + optimizations vqmod is lower than OC + default theme
- Although the performance of Pavilion is higher than the default theme, it’s insufficient for your setup, so shared hosting is just improper. A VPS hosting would be recommended.

We also noticed several things with the default theme – random script errors, the slider does not sometimes load (see attached image), notices about corrupt or truncated images… This happened with the Pavilion theme disabled, so it couldn’t cause effect. We didn’t go further in investigating errors that are not caused by the theme.

8sec limit for scripts is enough. We talked about mysql connections/queries limit, which is different. A single script request could generate 300 mysql queries within one second, which would still result in ‘mysql has gone away’ error if it hits the database resources limit.

We disabled the ‘gzip compression’ from the opencart admin panel as it does not make big difference in terms of frontend speed. You better enable ‘mod_deflate’ on your server, which will compress not only your html but also your resources (scripts, styles), which will make difference.

We are very sorry if this sounds like blaming someone else, but these are the objective results of our analysis, which goes far beyond the free support we offer.

About the error logs – they are really some errors that appear in the log because of Pavilion, but they are harmless and will be fixed with the next minor update, coming till the end of the week.

Hope this doesn’t fall into ‘dry answers’ category.

BR,
ThemeBurn team