Error loading: com_virtuemart, 1

[mfuller526]

I upgraded from VM2 to VM3,  O now se Weeor loading: com_virtuemart, 1. Uninstalling/reinstalling did not help. The VM error log says:

Code Select Expand


2015-01-20 04:30:42 ERROR vmError: alterTable CHANGE j17_virtuemart_product_customfields.customfield_value :

2015-01-20 04:30:42 ERROR vmError: alterTable CHANGE j17_virtuemart_product_customfields.customfield_params : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `j17_virtuemart_product_customfields` CHANGE COLUMN `customfield_value` `customfield_value` VARCHAR(2500) COMMENT 'FIELD VALUE' AFTER `virtuemart_custom_id`

2015-01-20 04:30:42 ERROR vmError: Tableupdater updating table j17_virtuemart_product_customfields throws error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `j17_virtuemart_product_customfields` CHANGE COLUMN `customfield_params` `customfield_params` VARCHAR(17000) NOT NULL DEFAULT '' COMMENT 'PARAM FOR PLUGINS' AFTER `override`


I used phpMyAdmin to make the SQL  corrections but still no change. I cannot select VM for a menu item, it does not show. When I install VM it hangs then gives the WSOD (white screen of death). VM all in one is installed, tables updated. I've read many posts on this but can't solve. Oh, I uninstalled XMAP too. Help greatly appreciated, thanks!

[jenkinhill]

Check the server error log file to see if that helps:  http://forum.virtuemart.net/index.php?topic=117042.0

[mfuller526]

Here's what i found in the server log, but i don't think it relates to VM:

Code Select Expand

[Sat Jan 24 11:01:44 2015] [error] [client 66.249.79.84] File does not exist: /home/bethel/public_html/flash_media/VideoPlaylistFlashVars.swf
[Sat Jan 24 11:01:41 2015] [error] [client 66.249.79.92] File does not exist: /home/bethel/public_html/flash_media/AC_RunActiveContent.js
[Sat Jan 24 11:00:21 2015] [error] [client 104.154.38.93] client denied by server configuration: /home/bethel/public_html/tmp/
[Sat Jan 24 11:00:21 2015] [error] [client 104.154.38.93] client denied by server configuration: /home/bethel/public_html/private/
[Sat Jan 24 11:00:21 2015] [error] [client 104.154.38.93] client denied by server configuration: /home/bethel/public_html/.htaccess
[Sat Jan 24 08:26:45 2015] [error] [client 66.249.79.92] File does not exist: /home/bethel/public_html/flash_media/VideoPlaylistFlashVars.swf
[Sat Jan 24 07:22:03 2015] [error] [client 66.249.79.76] File does not exist: /home/bethel/public_html/modules
[Sat Jan 24 06:57:06 2015] [error] [client 220.129.4.86] client denied by server configuration: /home/bethel/public_html/tmp/
[Sat Jan 24 06:57:06 2015] [error] [client 220.129.4.86] client denied by server configuration: /home/bethel/public_html/private/
[Sat Jan 24 06:57:06 2015] [error] [client 220.129.4.86] client denied by server configuration: /home/bethel/public_html/.htaccess
[Sat Jan 24 06:39:00 2015] [error] [client 176.10.98.132] client denied by server configuration: /home/bethel/public_html/tmp/, referer: http://www.bethelchristianfellowship.info/?q=node/add
[Sat Jan 24 06:39:00 2015] [error] [client 176.10.98.132] client denied by server configuration: /home/bethel/public_html/private/, referer: http://www.bethelchristianfellowship.info/?q=node/add
[Sat Jan 24 06:39:00 2015] [error] [client 176.10.98.132] client denied by server configuration: /home/bethel/public_html/.htaccess, referer: http://www.bethelchristianfellowship.info/?q=node/add
[Sat Jan 24 06:39:00 2015] [error] [client 176.10.98.132] client denied by server configuration: /home/bethel/public_html/tmp/, referer: http://www.bethelchristianfellowship.info/
[Sat Jan 24 06:39:00 2015] [error] [client 176.10.98.132] client denied by server configuration: /home/bethel/public_html/private/, referer: http://www.bethelchristianfellowship.info/
[Sat Jan 24 06:39:00 2015] [error] [client 176.10.98.132] client denied by server configuration: /home/bethel/public_html/.htaccess, referer: http://www.bethelchristianfellowship.info/
[Sat Jan 24 05:37:08 2015] [error] [client 66.249.79.84] client denied by server configuration: /home/bethel/public_html/tmp/

I've placed a support ticket to my host re: php memory.

Step by step tips really help. Screenshots attached. Thank you!!!

[GJC Web Design]

So is VM actually successfully installed? i.e. if you run the installation does it complete?

If not it may be because your hitting your upload limit (search for installing Joomla extensions from the tmp folder
Or if your using the gzip pack the server can't unpack it ( search repacking as zip)

server log shows nothing vm related

[mfuller526]

VM not successfully installed. VM AIO was installed. I've tried both the tmp (uploading a folder first) file and uploading the VM com_virtuemart.3.0.2.tar.gz and com_virtuemart.3.0.3.zip using the extension manager. I'm in Firefox 35.0. I see a spinning sort of icon but after awhile a white screen. It does not go to "You have successfully installed VM". My host responded to my support ticket "The server's php.ini is set with memory_limit = 512M so if you're hitting a lower ceiling it must be overridden by code somewhere on your site."

Ideas? How do i find what has overridden the memory? Thanks!

[mfuller526]

The VM component was NOT in the database's xxx_extensions table. So using phpMyAdmin I inserted a row and copied verbatim the data from a working VM copy I have in a laptop local Joomla site. And it solved my non-functioning Community Builder login problem too!

BTW updating from VM3.02 to 3.0.4 did not solve the problem. Something went wrong in my VM2 > VM3migration. I may have accidentally installed the VM3 All-in-One first which is wrong.  VM3 core should be first per specs. When all else fails, read the instructions. Thanks to all who helped!