Author Topic: [SOLVED] Product errors after upgrade to 2.0.6 (MySQL)  (Read 2426 times)

JohnnyC

  • Jr. Member
  • **
  • Posts: 53
[SOLVED] Product errors after upgrade to 2.0.6 (MySQL)
« on: May 20, 2012, 20:29:37 pm »
I use JM 2.5 and VM 2.0.6 upgraded from 2.0.2. After the upgrade I had an issue with my products, couldn't find any media and it displayed MySQL errors when entered details, also didn't show some modules (menus with featured products). I used phpMyAdmin to backup my database (tables) and after that I rebuilt it and restored the old tables into the new ones. As a result the error messages kept on displayed. As my shop is still in test mode (lucky me) I deleted all my products and created some new ones. But the problems still remain.

The errors (the language is GREEK but I will translate hoping you will find out which error message is in English):

1. When I enter a products details page I take the error
            Σφάλμα κατά την φόρτωση της εφαρμογής: com_users, 1
            Σφάλμα κατά την φόρτωση της εφαρμογής: com_users, 1
            Σφάλμα κατά την φόρτωση της εφαρμογής: com_content, 1
            Σφάλμα κατά την φόρτωση της εφαρμογής: com_content, 1

   TRANSLATION Σφάλμα κατά την φόρτωση της εφαρμογής == Error loading component
SEE case 1.jpg ATTACHMENT

2. When I enter a category or subcategory which is not empty (includes products) I take the error
    Σφάλμα κατά την φόρτωση του ενθέματος MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-05-17 09:06:53') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-17 09:06:53') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 583 OR mm.menuid <= 0) AND m.language IN ('el-GR','*') ORDER BY m.position, m.ordering

    TRANSLATION Σφάλμα κατά την φόρτωση του ενθέματος == Error loading module

    In this case no modules are being displayed, especially the menus (right sidebar) that show featured or best products

SEE case 2.jpg ATTACHMENT

I would be glad if you could help me as it is very important for me to start importing real products (not in test mode anymore). So I need a solution to prevent this errors in future upgrades.

Thanks

[attachment cleanup by admin]

JohnnyC

  • Jr. Member
  • **
  • Posts: 53
Re: Product errors after upgrade to 2.0.6
« Reply #1 on: May 24, 2012, 20:17:21 pm »
Anyone?? Anything...?  :'(

JohnnyC

  • Jr. Member
  • **
  • Posts: 53
Re: Product errors after upgrade to 2.0.6
« Reply #2 on: June 01, 2012, 08:17:43 am »
SOLVED
MySQL caused the problem. I had version 5.2.7 and upgraded to 5.5.21-55 so everything works now...

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27502
  • Always on vacation
    • Jenkin Hill Internet
Re: [SOLVED] Product errors after upgrade to 2.0.6 (MySQL)
« Reply #3 on: June 04, 2012, 16:22:43 pm »
Interesting. Minimum recommended spec is MySQL 5.0.4 
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.6.1.10121 on Joomla 3.9.11 PHP 7.0.33
Testing 3.6.1.10129 on Joomla 3.9.11

JohnnyC

  • Jr. Member
  • **
  • Posts: 53
Re: [SOLVED] Product errors after upgrade to 2.0.6 (MySQL)
« Reply #4 on: June 04, 2012, 17:04:06 pm »
So, check it, because this issue has been noted since 2.0.2 if I am not wrong. I found the solution a Greek forum and until now seems to work.