VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: JohnnyC on January 16, 2012, 09:45:02 AM

Title: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: JohnnyC on January 16, 2012, 09:45:02 AM

I would be very glad if you could give me some ideas on those questions.

Thanks!
Title: Re: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: Milbo on January 16, 2012, 11:39:12 AM
for 1. you should take a look in the template forum, what you want is 10 - 20 minutes.
2. http://forum.virtuemart.net/index.php?topic=96438.msg317068#msg317068

3. seems to be bug. First check if you have a default shoppergroup. But I think the real error is the second query, which is a joomla one. Maybe it is a robot running to fast throug all pages and using too much db connections.
Title: Re: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: JohnnyC on January 16, 2012, 11:57:34 AM
Thank you for the fast reply!

1. I will give it a try to look in the forum you mention, however before I started this thread I had about 3 weeks searching for these issues with no luck (for VM2)
2. I have allready read that post and I know that creating a Joomla account automatically creates the shopper in VM (and vise versa), but the only information it copies is the basic information. Isn't there a way to synchronize the rest profile details (there will be chosen the same ones to be displayed of course). Or another way to have information registration once by the user...
3. I know that maybe is a bug. There are two shoppergroups, -anonymous- and -default- (that is the default too). All users are "default" unless the admin changes it. But the SQL error tells me that SQL does a timeout and when it is needed by the site, it is not "there"... As I said my site is in a Webhosting Server so I don't know if there is something in the rest system, except my files tha I have access... I just wonder if there is something I can do by my side...
Title: Re: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: kiofcon on January 21, 2012, 16:54:32 PM
the same here :( . any solution ?
Title: Re: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: kiofcon on January 21, 2012, 17:16:35 PM
when i try to see my products i take this message from the admin page of virtuemart
MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM c5g8a_modules AS m LEFT JOIN c5g8a_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN c5g8a_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-01-21 16:14:45') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-01-21 16:14:45') AND m.access IN (1,1,2,3) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
and nothing works
Title: Re: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: JohnnyC on January 23, 2012, 08:38:10 AM
I guess if you make a few refreshes, or enter a link or save something in the backend ("wake up the database somehow"), it starts working...
I maybe found a way to figure it out.
Analysing the query I saw that Joomla had problem when trying to load VM modules (for example VM category module or/and featured products in a menu etc). My though on this is that Joomla and VM have 2 speeds on reading the database. So VM does timeout early and when Joomla asks to load a module MySQL "is not there"... I don't know how to sync the two systems to timeout and comeback at the same time, but I took a backup of my database (used phpMyAdmin) an then I reset the tables through the Tools->Tools&Migration->Reset all tables and do a fresh install. Then I recovered my old tables from the backup.
So far so good... This seems to work till now, but I don't claim it is definitely the solution, cause I don't know what will happen if the shop starts working normally with hundreds of products and many users... Maybe finding a way to syncronize VM and Joomla database reading is better...
Title: Re: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: JohnnyC on January 23, 2012, 11:36:43 AM
Continuing my post, I found something new.
At configuration.php change
public $dbtype = 'mysql';
to
public $dbtype = 'mysqli';

This changes the driver that contacts MySQL and might help. I just did it and don't have any remark yet...
Title: Re: product thumbnails to details + Joomla VS VM account details + MySQL error
Post by: jenkinhill on January 23, 2012, 12:24:33 PM
Best not to use the MySQLi setting with Joomla 1.7.3 on PHP 5.3 - http://forum.virtuemart.net/index.php?topic=95879.msg317331#msg317331