virtuemart 2.0 installation problem

[bmc]

Hi,

Scroll down to the 3rd post.

[Milbo]

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

[bmc]

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

[Milbo]

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.

[bmc]

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?

[Milbo]

Here http://forum.virtuemart.net/index.php?topic=94183.0

[bmc]

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