vmError: storing user adress dataTableVmusers::store failed - Unknown column 'virtuemart_shippingcarrier_id' in 'field list' SQL=UPDATE `z2re8_virtuemart_vmusers` SET `user_is_vendor`='1',`virtuemart_vendor_id`='1',`customer_number`='afecddf652465866d02234402bf5fb0c',`perms`='admin',`virtuemart_shippingcarrier_id`='0',`agreed`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2011-12-06 06:34:52',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_user_id`='42'
vmError: TableVendors
Looks like you have old files, but new database layout. virtuemart_shippingcarrier_id exists in the code only in the updater for the commands, which rename it.
I cant understand... how to correct it...I eanbled debug it is showing error 500..What to do? Please help..
This is the exact error
Errors
JDatabaseMySQL::query: 1146 - Table 'smilyo_saini.z2re8_virtuemart_adminmenuentries' doesn't exist SQL=SELECT count(id) AS idCount FROM `z2re8_virtuemart_adminmenuentries`
Information
Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home/smilyo/public_html/saini/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/smilyo/public_html/saini/administrator/includes/application.php:153
3 require_once() /home/smilyo/public_html/saini/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home/smilyo/public_html/saini/administrator/components/com_installer/installer.php:24
5 InstallerControllerInstall->install() /home/smilyo/public_html/saini/libraries/joomla/application/component/controller.php:684
6 InstallerModelInstall->install() /home/smilyo/public_html/saini/administrator/components/com_installer/controllers/install.php:31
7 JInstaller->install() /home/smilyo/public_html/saini/administrator/components/com_installer/models/install.php:114
8 JInstallerComponent->install() /home/smilyo/public_html/saini/libraries/joomla/installer/installer.php:406
9 com_install() /home/smilyo/public_html/saini/libraries/joomla/installer/adapters/component.php:427
10 com_virtuemartInstallerScript->checkIfUpdate() /home/smilyo/public_html/saini/tmp/install_4ede3b52be347/install/script.virtuemart.php:661
11 JDatabase->loadResult() /home/smilyo/public_html/saini/tmp/install_4ede3b52be347/install/script.virtuemart.php:52
12 JDatabaseMySQLi->query() /home/smilyo/public_html/saini/libraries/joomla/database/database.php:1010
13 JError::raiseError() /home/smilyo/public_html/saini/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /home/smilyo/public_html/saini/libraries/joomla/error/error.php:250
Profile Information
Application 0.001 seconds (+0.001); 0.51 MB (+0.515) - afterLoad
Application 0.044 seconds (+0.043); 3.29 MB (+2.775) - afterInitialise
Application 0.044 seconds (+0.000); 3.29 MB (+0.000) - afterRoute
I'm having what seems to be the same error.
I'm on a completely fresh install of Joomla 1.7, virtuemart has never existed on here. I installed once, tried to create a product catagory and got:
TableCategories: :store failed
Unknown column 'category_name' in 'field list' SQL=INSERT INTO `aat_virtuemart_categories` (`virtuemart_category_id`,`virtuemart_vendor_id`,`category_name`,`slug`,`category_description`,`category_template`,`category_layout`,`category_product_layout`,`products_per_row`,`ordering`,`shared`,`limit_list_start`,`limit_list_step`,`limit_list_max`,`limit_list_initial`,`metadesc`,`metakey`,`metarobot`,`metaauthor`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('','1','test','test','
test
','0','0','0','','0','0','0','10','0','10','','','','','1','2011-12-12 18:46:15','42','2011-12-12 18:46:15','42')
So I uninstalled, went into PHP and removed all instances of virtuemart tables and then did a fresh install and update of virtuemart.
Same problem.
If I try and put any information in the 'shop' config, i get
vmError: storing user adress dataTableVmusers::store failed - Unknown column 'virtuemart_shippingcarrier_id' in 'field list' SQL=UPDATE `aat_virtuemart_vmusers` SET `user_is_vendor`='1',`virtuemart_vendor_id`='1',`customer_number`='c3fb6d16426827ce9b1d1e362279ff79',`perms`='admin',`virtuemart_shippingcarrier_id`='0',`agreed`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2011-12-12 18:47:23',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_user_id`='42'
vmError: store vendor
No Shop Currency defined! Go to http://avanatesting.cloudaccess.net/administrator/index.php?option=com_virtuemart&view=user&task=editshop
Any assistance would be really appreciated
Hmm - I uninstalled it again, then removed ALL database entries.
Then I reinstalled it and IGNORED the 'theres an update available" both within VM and in AIO. Last time I did the updates before doing anything, seemingly thats where the error begins. The update specifies columns in the wrong databases which is what causes the errors. On visiting the VM download site, the VM i downloaded was only updated today so I presume the update shown within the VM component is wrong.
All works now!
Dont use the theres an update option, it actually links to an earlier release of VM (RC3 is unofficial for bugfixing)