News:

Support the VirtueMart project and become a member

Main Menu

Error loading: com_virtuemart, 1

Started by mfuller526, January 24, 2015, 08:56:59 AM

Previous topic - Next topic

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:

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!


Joomla! 2.5.28, PHP 5.4.36,  MoWebSo3.2.19

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

mfuller526

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

[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!!!
Joomla! 2.5.28, PHP 5.4.36,  MoWebSo3.2.19

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

mfuller526

#4
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!
Joomla! 2.5.28, PHP 5.4.36,  MoWebSo3.2.19

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. ;D Thanks to all who helped! 8)
Joomla! 2.5.28, PHP 5.4.36,  MoWebSo3.2.19