Author Topic: impossible to install vm3 row size too large  (Read 2879 times)

berges

  • Jr. Member
  • **
  • Posts: 66
impossible to install vm3 row size too large
« on: March 25, 2015, 09:05:51 am »
hello when i try to install vm3 on j3.4.1 i have this error
Code: [Select]
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 `hba_virtuemart_medias` ADD file_class char(64) NOT NULL DEFAULT '' AFTER `file_meta`do you have some idea ?
regards

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: impossible to install vm3 row size too large
« Reply #1 on: March 25, 2015, 15:46:18 pm »
reduce the size of file_params manually to file_params varchar(17000)
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges

  • Jr. Member
  • **
  • Posts: 66
Re: impossible to install vm3 row size too large
« Reply #2 on: March 26, 2015, 08:51:12 am »
you say in phpmyadmin ? or in file (how file)?
regards

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: impossible to install vm3 row size too large
« Reply #3 on: March 26, 2015, 09:11:31 am »
for example with phpmyadmin, yes
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges

  • Jr. Member
  • **
  • Posts: 66
Re: impossible to install vm3 row size too large
« Reply #4 on: March 26, 2015, 09:26:19 am »
sorry i try to search file_params in my db i didn't find can explain more ?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: impossible to install vm3 row size too large
« Reply #5 on: March 26, 2015, 11:54:09 am »
how looks your hba_virtuemart_medias?
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges

  • Jr. Member
  • **
  • Posts: 66
Re: impossible to install vm3 row size too large
« Reply #6 on: March 26, 2015, 12:16:33 pm »
file_params is varchar 19000
need to be reduce to 17000?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: impossible to install vm3 row size too large
« Reply #7 on: March 26, 2015, 12:27:57 pm »
reduce the size of file_params manually to file_params varchar(17000)
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges

  • Jr. Member
  • **
  • Posts: 66
Re: impossible to install vm3 row size too large
« Reply #8 on: March 26, 2015, 12:31:40 pm »
yes it works 1000000 thanks

jamnagarsoftware

  • Beginner
  • *
  • Posts: 6
  • A beginner
Re: impossible to install vm3 row size too large
« Reply #9 on: September 08, 2016, 02:32:51 am »
Worked like a charm for me.

Thank you so much.

glenanpl

  • Beginner
  • *
  • Posts: 11
  • A beginner
Re: impossible to install vm3 row size too large
« Reply #10 on: October 05, 2016, 19:51:42 pm »
Hi,
with I reduce the size but I have the same bug
TABLE `#__virtuemart_orders` ADD `customer_note` varchar(9000);
What can I do
Thanks !

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: impossible to install vm3 row size too large
« Reply #11 on: October 07, 2016, 09:41:43 am »
lol which vm version? The customer note is NOT stored in the virtuemart_orders table in vm3, that was in vm2. Now it is handled as normal userfield.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

glenanpl

  • Beginner
  • *
  • Posts: 11
  • A beginner
Re: impossible to install vm3 row size too large
« Reply #12 on: October 09, 2016, 18:38:14 pm »
Hi Milbo,
vmmigrator 4.2.1
Joomla 3.6.2
Virtuemart 3.0.18
Regards

glenanpl

  • Beginner
  • *
  • Posts: 11
  • A beginner
Re: impossible to install vm3 row size too large
« Reply #13 on: October 09, 2016, 22:53:49 pm »
Hi Milbo,
I uninstall Virtuemart and VMMigrator
I delete all the table #_virtuemart*
I reinstall virtuemart and Vmmigrator and the migration is OK
Thanks !