News:

Looking for documentation? Take a look on our wiki

Main Menu

Error after trying to update userinfo

Started by digimate, May 01, 2015, 14:03:58 PM

Previous topic - Next topic

digimate

Hi there,

After migrating a Joomla 1.5 and Virtuemart 1.1.6 website to Joomla 3.4 and Virtuemart 3.0.8 I got an error when trying to update the userinfo from the shop:

1054 Unknown column 'metarobot' in 'field list' SQL=UPDATE `u7q6b_virtuemart_vendors` SET `vendor_name`='Name of vendor',`vendor_currency`='47',`vendor_accepted_currencies`='47',`vendor_params`='vendor_min_pov=\"0\"|vendor_min_poq=1|vendor_freeshipment=0|vendor_address_format=\"\"|vendor_date_format=\"\"|vendor_letter_format=\"A4\"|vendor_letter_orientation=\"P\"|vendor_letter_margin_top=\"55\"|vendor_letter_margin_left=\"25\"|vendor_letter_margin_right=\"25\"|vendor_letter_margin_bottom=\"25\"|vendor_letter_margin_header=\"20\"|vendor_letter_margin_footer=\"20\"|vendor_letter_font=\"helvetica\"|vendor_letter_font_size=\"8\"|vendor_letter_header_font_size=\"7\"|vendor_letter_footer_font_size=\"6\"|vendor_letter_header=\"1\"|vendor_letter_header_line=\"1\"|vendor_letter_header_line_color=\"#000000\"|vendor_letter_header_image=\"1\"|vendor_letter_header_imagesize=\"60\"|vendor_letter_header_cell_height_ratio=\"1\"|vendor_letter_footer=\"1\"|vendor_letter_footer_line=\"1\"|vendor_letter_footer_line_color=\"#000000\"|vendor_letter_footer_cell_height_ratio=\"1\"|vendor_letter_add_tos=\"0\"|vendor_letter_add_tos_newpage=\"1\"|vendor_mail_width=640|vendor_mail_header=1|vendor_mail_tos=1|vendor_mail_logo=1|vendor_mail_logo_width=200|vendor_mail_font=\"helvetica\"|vendor_mail_header_font_size=11|vendor_mail_font_size=12|vendor_mail_footer_font_size=10|',`metarobot`='',`metaauthor`='',`modified_on`='2015-05-01 11:53:54',`modified_by`='384' WHERE `virtuemart_vendor_id`='1'

When I try 'Install or if necessary update tables' with DB tools then I get:
1062 ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '8' for key 'PRIMARY' SQL=ALTER TABLE `u7q6b_virtuemart_userinfos` CHANGE COLUMN `virtuemart_userinfo_id` `virtuemart_userinfo_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT FIRST

What could be (done) wrong ??

Any help will be very much appreciated!!