Hi,
Scroll down to the 3rd post.
The first problem is that you try to mix vm2 with vm1.
The thread is meant for vm1 not vm2. All vm1 modules,plugins and hacks do not longer work on vm2.
and yepp the second thins is that you should directly start with the RC3 :-).
Now I take a look on "JDatabaseMySQL::query: 1146 - Table 'izukeeco_jml4.extension_id' doesn't exist SQL=UPDATE `extension_id` SET `folder`="vmshipment" WHERE `extension_id`= 10075"
Very strange, because this command shouldnt be executed, since you use RC3. But maybe it tried to update a rest of the old installation with version m. Second, you use j1.7 and it is updating a joomla core table. aahhhh, I took a look on the code and found it, ... thx. Next version will have a correct fix.
The simpelst way for you is to uninstall within joomla extension view all shipment plugins and execute the aio again. The error comes, when you have an old vmshipper plugin registered and the wrong line is for updating vmshipper to vmshipment
Hi, Milbo,
thank you so much for your reply!
I am new to Joomla and having a very difficult time with Virtuemart 2.0 here. I spent lots of time to read posts on this forum and also did lots of installing and uninstalling, change between "com_virtuemart2.0.0_RC3_Pre_c_extract_first.zip" and "virtuemart1.9.8.RC2M_extract_first.zip". I got so many error messages and I keep undating my original post with new problems.
Now I forgot what are the first problem and the second problem you are referring. :-[
Here is what i did earlier:
i unistalled within joomla extesion. then went to phpmyadmin database deleted all the tables containing Virtuemart, also went into menu tables deleted COM_VIRTUEMART and VIRTUEMART AIO. then i installed "com_virtuemart2.0.0_RC3_Pre_c_extract_first.zip"
succesfully installed this zip file "com_virtuemart2.0.0_RC3_Pre_c.zip" through extension manager, but when i try to install this zip file "com_virtuemart_ext_aio.2.0.0RC3_Pre_c.zip" I got an error message shows below :
--------------------------------------------------------------------------------------------------------------------------------------------------------
500 - An error has occurred.
JDatabaseMySQL::query: 1062 - Duplicate entry '132-0' for key 'PRIMARY' SQL=UPDATE `my6or_modules_menu` SET `menuid`= "0" WHERE `moduleid`= "132"
Call stack
# Function Location
1 JAdministrator->dispatch() /home6/izukeeco/public_html/bluemountaincrossing/administrator/index.php:47
2 JComponentHelper::renderComponent() /home6/izukeeco/public_html/bluemountaincrossing/administrator/includes/application.php:153
3 require_once() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/installer.php:24
5 InstallerControllerInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/controller.php:679
6 InstallerModelInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/controllers/install.php:31
7 JInstaller->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/models/install.php:114
8 JInstallerComponent->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/installer.php:385
9 com_virtuemart_allinoneInstallerScript->postflight() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:470
10 com_virtuemart_allinoneInstallerScript->vmInstall() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edb92b24e2b7/script.vmallinone.php:36
11 com_virtuemart_allinoneInstallerScript->installModule() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edb92b24e2b7/script.vmallinone.php:82
12 JDatabaseMySQLi->query() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edb92b24e2b7/script.vmallinone.php:345
13 JError::raiseError() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/error/error.php:215
Errors
The database row is empty.
Information
Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home6/izukeeco/public_html/bluemountaincrossing/administrator/index.php:47
2 JComponentHelper::renderComponent() /home6/izukeeco/public_html/bluemountaincrossing/administrator/includes/application.php:153
3 require_once() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/installer.php:24
5 InstallerControllerInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/controller.php:679
6 InstallerModelInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/controllers/install.php:31
7 JInstaller->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/models/install.php:114
8 JInstallerComponent->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/installer.php:385
9 JInstallerComponent->_buildAdminMenus() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:441
10 JTableMenu->store() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:1234
11 JTable->load() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/database/table/menu.php:142
JDatabaseMySQL::query: 1062 - Duplicate entry '132-0' for key 'PRIMARY' SQL=UPDATE `my6or_modules_menu` SET `menuid`= "0" WHERE `moduleid`= "132"
Information
Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home6/izukeeco/public_html/bluemountaincrossing/administrator/index.php:47
2 JComponentHelper::renderComponent() /home6/izukeeco/public_html/bluemountaincrossing/administrator/includes/application.php:153
3 require_once() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/installer.php:24
5 InstallerControllerInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/controller.php:679
6 InstallerModelInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/controllers/install.php:31
7 JInstaller->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/models/install.php:114
8 JInstallerComponent->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/installer.php:385
9 com_virtuemart_allinoneInstallerScript->postflight() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:470
10 com_virtuemart_allinoneInstallerScript->vmInstall() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edb92b24e2b7/script.vmallinone.php:36
11 com_virtuemart_allinoneInstallerScript->installModule() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edb92b24e2b7/script.vmallinone.php:82
12 JDatabaseMySQLi->query() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edb92b24e2b7/script.vmallinone.php:345
13 JError::raiseError() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/error/error.php:215
Profile Information
Application 0.002 seconds (+0.002); 0.68 MB (+0.681) - afterLoad
Application 0.061 seconds (+0.059); 5.82 MB (+5.142) - afterInitialise
Application 0.061 seconds (+0.000); 5.82 MB (+0.000) - afterRoute
Memory Usage
11.05 MB (11,588,976 Bytes)
50 Queries Logged
...
-------------------------------------------------------------------------------------------------------------------------------------------------------
when i check component drop down menu, i didn't see Virtuemart aio. i opened my phpmyadmin database, in menue table, i did see
main VirtueMart AIO virtuemart-aio virtuemart-aio index.php?option=com_virtuemart_allinone component 0 1 1 10129 0 0 0000-00-00 00:00:00 0 1 class:component 0 329 330 0 1
and when i refresh my back end admin screen. i found Virtuemart aio in Component drop down menu. and when i open it. it shows "Installed version 2.0.0RC3 Latest version 1.9.8M" perhaps I installed this file succesfully "com_virtuemart_ext_aio.2.0.0RC3_Pre_c.zip" even though i got this error messages above?
Now, my new problem is: I can't save changes i made in the confiuration window of the shipping method and payment method. when i click save and it returns back to the default values. and in the front end in the shopping cart, i try to choose a shipping method but when i click on select shipment it returns a message:
We are sorry, no shipment method matches the characteristics of your order.
now what should i do?
Here is my website link:
http://www.bluemountaincrossing.com/index.php/shop
sorry for my poor English, I hope I explain this problem correctly. thanks in advance for your help.
many thanks!
Shawn
Yeah it was not good to delete your old posts. You may take a look on our guidelines http://dev.virtuemart.net/projects/virtuemart/wiki/Developer_guideline.
I think you should start with the new installer I create within next 2 hours, because there are you others probelems also fixed.
thanks, I read through the guidelines.
So, do I have to uninstall virtuemart 2.0 from backend and reinstall it? where can i find the new installer?
Here http://forum.virtuemart.net/index.php?topic=94183.0
i uninstalled com_virtuemart2.0.0_RC3_Pre_c_extract_first.zip from back end and installed com_virtuemart2.0.0_RC3_Pre_e_extract_first.zip. still i succesfully installed this zip file "com_virtuemart2.0.0_RC3_Pre_c.zip" through extension manager, but when i try to install this zip file com_virtuemart_aio I got the same error like before.
500 - An error has occurred.
JDatabaseMySQL::query: 1062 - Duplicate entry '132-0' for key 'PRIMARY' SQL=UPDATE `my6or_modules_menu` SET `menuid`= "0" WHERE `moduleid`= "132"
Return to Control Panel
Call stack
# Function Location
1 JAdministrator->dispatch() /home6/izukeeco/public_html/bluemountaincrossing/administrator/index.php:47
2 JComponentHelper::renderComponent() /home6/izukeeco/public_html/bluemountaincrossing/administrator/includes/application.php:153
3 require_once() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/installer.php:24
5 InstallerControllerInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/controller.php:679
6 InstallerModelInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/controllers/install.php:31
7 JInstaller->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/models/install.php:114
8 JInstallerComponent->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/installer.php:385
9 JInstallerComponent->update() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:141
10 com_virtuemart_allinoneInstallerScript->postflight() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:891
11 com_virtuemart_allinoneInstallerScript->vmInstall() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edbf3abe49aa/script.vmallinone.php:36
12 com_virtuemart_allinoneInstallerScript->installModule() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edbf3abe49aa/script.vmallinone.php:82
13 JDatabaseMySQLi->query() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edbf3abe49aa/script.vmallinone.php:345
14 JError::raiseError() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/database/database/mysqli.php:535
15 JError::raise() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/error/error.php:215
Errors
The database row is empty.
Information
Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home6/izukeeco/public_html/bluemountaincrossing/administrator/index.php:47
2 JComponentHelper::renderComponent() /home6/izukeeco/public_html/bluemountaincrossing/administrator/includes/application.php:153
3 require_once() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/installer.php:24
5 InstallerControllerInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/controller.php:679
6 InstallerModelInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/controllers/install.php:31
7 JInstaller->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/models/install.php:114
8 JInstallerComponent->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/installer.php:385
9 JInstallerComponent->update() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:141
10 JInstallerComponent->_buildAdminMenus() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:770
11 JTableMenu->store() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:1234
12 JTable->load() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/database/table/menu.php:142
JDatabaseMySQL::query: 1062 - Duplicate entry '132-0' for key 'PRIMARY' SQL=UPDATE `my6or_modules_menu` SET `menuid`= "0" WHERE `moduleid`= "132"
Information
Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home6/izukeeco/public_html/bluemountaincrossing/administrator/index.php:47
2 JComponentHelper::renderComponent() /home6/izukeeco/public_html/bluemountaincrossing/administrator/includes/application.php:153
3 require_once() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/installer.php:24
5 InstallerControllerInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/application/component/controller.php:679
6 InstallerModelInstall->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/controllers/install.php:31
7 JInstaller->install() /home6/izukeeco/public_html/bluemountaincrossing/administrator/components/com_installer/models/install.php:114
8 JInstallerComponent->install() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/installer.php:385
9 JInstallerComponent->update() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:141
10 com_virtuemart_allinoneInstallerScript->postflight() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/installer/adapters/component.php:891
11 com_virtuemart_allinoneInstallerScript->vmInstall() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edbf3abe49aa/script.vmallinone.php:36
12 com_virtuemart_allinoneInstallerScript->installModule() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edbf3abe49aa/script.vmallinone.php:82
13 JDatabaseMySQLi->query() /home6/izukeeco/public_html/bluemountaincrossing/tmp/install_4edbf3abe49aa/script.vmallinone.php:345
14 JError::raiseError() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/database/database/mysqli.php:535
15 JError::raise() /home6/izukeeco/public_html/bluemountaincrossing/libraries/joomla/error/error.php:215
Profile Information
Application 0.002 seconds (+0.002); 0.69 MB (+0.686) - afterLoad
Application 0.058 seconds (+0.056); 5.84 MB (+5.153) - afterInitialise
Application 0.058 seconds (+0.000); 5.84 MB (+0.000) - afterRoute
Memory Usage
11.11 MB (11,644,584 Bytes)
387 Queries Logged
then
I check the extension manager and only find this 7 lines of vertuemart:
VirtueMart Administrator Component 2.0.0RC3 October 2011 The VirtueMart Development Team N/A 10142
VirtueMart_allinone Administrator Component 2.0.0RC3 February 2011 The VirtueMart Development Team N/A 10143
Vm Custom Field Stockable Site Plugin 2.0.0RC3 June 2011 The VirtueMart Development Team vmcustom 10148
VMCustom - textinput Site Plugin 2.0.0RC3 June 2011 The VirtueMart Development Team vmcustom 10147
Vm Payment plugin Paypal Site Plugin 2.0.0RC3 June 2011 The VirtueMart Development Team vmpayment 10145
VMPAYMENT_STANDARD Site Plugin 2.0.0RC3 June 2011 The VirtueMart Development Team vmpayment 10144
VMSHIPMENT_WEIGHT_COUNTRIES Site Plugin 2.0.0RC3 June 2011 The VirtueMart Development Team vmshipment 10146
is this correct? did i miss anything?
now I can save changes i made in the confiuration window of the shipping method and payment method. But in the front end in the shopping cart, i try to choose a shipping method but when i click on select shipment it STILL returns a message:
We are sorry, no shipment method matches the characteristics of your order.
Here is my shop link, you can try to boy a product, it will reproduce the problem.
http://www.bluemountaincrossing.com/index.php?Itemid=138
Shawn