News:

Looking for documentation? Take a look on our wiki

Main Menu

Errors with Release com_virtuemart2.0.0_RC3_Pre_J

Started by giosanything, December 12, 2011, 22:45:58 PM

Previous topic - Next topic

giosanything

I tried to install the Pre_J and I get the following. It seems that everything was installed correctly but I cannot see a Virtuemart menu in Joomla.

Any suggestions?


Error building Admin Menus
Info: port Language categories found 0 vm1 entries for migration


Info: port Language manufacturers found 0 vm1 entries for migration
Info: port Language manufacturercategories found 0 vm1 entries for migration
Info: port Language products found 0 vm1 entries for migration
Info: port Language vendors found 0 vm1 entries for migration
Info: Taking config from file
Tablename jos_virtuemart_adminmenuentries dropped: 0 altered: 10 added: 0
Tablename jos_virtuemart_calcs dropped: 4 altered: 8 added: 1
alterTable DROP jos_virtuemart_calcs.virtuemart_calc_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_calcs` DROP INDEX `virtuemart_calc_id`
Tablename jos_virtuemart_calc_categories dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_calc_categories.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_calc_categories` DROP INDEX `id`
Tablename jos_virtuemart_calc_shoppergroups dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_calc_shoppergroups.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_calc_shoppergroups` DROP INDEX `id`
Tablename jos_virtuemart_calc_countries dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_calc_countries.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_calc_countries` DROP INDEX `id`
Tablename jos_virtuemart_calc_states dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_calc_states.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_calc_states` DROP INDEX `id`
Tablename jos_virtuemart_categories dropped: 0 altered: 13 added: 0
alterTable DROP jos_virtuemart_categories.virtuemart_category_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_categories` DROP INDEX `virtuemart_category_id`
Tablename jos_virtuemart_category_categories dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_category_categories.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_category_categories` DROP INDEX `id`
Tablename jos_virtuemart_category_medias dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_category_medias.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_category_medias` DROP INDEX `id`
Tablename jos_virtuemart_countries dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_countries.virtuemart_country_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_countries` DROP INDEX `virtuemart_country_id`
Tablename jos_virtuemart_coupons dropped: 0 altered: 2 added: 0
alterTable DROP jos_virtuemart_coupons.virtuemart_coupon_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_coupons` DROP INDEX `virtuemart_coupon_id`
Tablename jos_virtuemart_currencies dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_currencies.virtuemart_currency_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_currencies` DROP INDEX `virtuemart_currency_id`
Tablename jos_virtuemart_customs dropped: 0 altered: 6 added: 5
alterTable DROP jos_virtuemart_customs.virtuemart_custom_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_customs` DROP INDEX `virtuemart_custom_id`
Tablename jos_virtuemart_manufacturers dropped: 0 altered: 1 added: 0
alterTable DROP jos_virtuemart_manufacturers.virtuemart_manufacturer_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_manufacturers` DROP INDEX `virtuemart_manufacturer_id`
Tablename jos_virtuemart_manufacturer_medias dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_manufacturer_medias.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_manufacturer_medias` DROP INDEX `id`
Tablename jos_virtuemart_manufacturercategories dropped: 0 altered: 1 added: 0
alterTable DROP jos_virtuemart_manufacturercategories.virtuemart_manufacturercategories_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_manufacturercategories` DROP INDEX `virtuemart_manufacturercategories_id`
Tablename jos_virtuemart_medias dropped: 0 altered: 13 added: 0
alterTable DROP jos_virtuemart_medias.virtuemart_media_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_medias` DROP INDEX `virtuemart_media_id`
Tablename jos_virtuemart_migration_oldtonew_ids dropped: 0 altered: 1 added: 0
Tablename jos_virtuemart_modules dropped: 0 altered: 5 added: 0
alterTable DROP jos_virtuemart_modules.module_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_modules` DROP INDEX `module_id`
Tablename jos_virtuemart_orders dropped: 1 altered: 13 added: 0
alterTable DROP jos_virtuemart_orders.virtuemart_order_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_orders` DROP INDEX `virtuemart_order_id`
Tablename jos_virtuemart_order_histories dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_order_histories.virtuemart_order_history_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_order_histories` DROP INDEX `virtuemart_order_history_id`
Tablename jos_virtuemart_order_items dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_order_items.virtuemart_order_item_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_order_items` DROP INDEX `virtuemart_order_item_id`
Tablename jos_virtuemart_orderstates dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_orderstates.virtuemart_orderstate_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_orderstates` DROP INDEX `virtuemart_orderstate_id`
Tablename jos_virtuemart_order_userinfos dropped: 5 altered: 19 added: 0
Tablename jos_virtuemart_paymentmethods dropped: 1 altered: 5 added: 1
alterTable DROP jos_virtuemart_paymentmethods.virtuemart_paymentmethod_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_paymentmethods` DROP INDEX `virtuemart_paymentmethod_id`
Tablename jos_virtuemart_paymentmethod_shoppergroups dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_paymentmethod_shoppergroups.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_paymentmethod_shoppergroups` DROP INDEX `id`
Tablename jos_virtuemart_products dropped: 1 altered: 19 added: 0
alterTable DROP jos_virtuemart_products.virtuemart_product_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_products` DROP INDEX `virtuemart_product_id`
Tablename jos_virtuemart_product_categories dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_product_categories.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_categories` DROP INDEX `id`
Tablename jos_virtuemart_product_shoppergroups dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_product_shoppergroups.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_shoppergroups` DROP INDEX `id`
Tablename jos_virtuemart_product_customfields dropped: 0 altered: 6 added: 0
alterTable DROP jos_virtuemart_product_customfields.virtuemart_customfield_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_customfields` DROP INDEX `virtuemart_customfield_id`
Tablename jos_virtuemart_product_downloads dropped: 0 altered: 6 added: 0
alterTable DROP jos_virtuemart_product_downloads.virtuemart_product_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_downloads` DROP INDEX `virtuemart_product_id`
Tablename jos_virtuemart_product_medias dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_product_medias.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_medias` DROP INDEX `id`
Tablename jos_virtuemart_product_manufacturers dropped: 0 altered: 2 added: 0
alterTable DROP jos_virtuemart_product_manufacturers.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_manufacturers` DROP INDEX `id`
Tablename jos_virtuemart_product_prices dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_product_prices.virtuemart_product_price_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_prices` DROP INDEX `virtuemart_product_price_id`
Tablename jos_virtuemart_product_relations dropped: 0 altered: 2 added: 0
alterTable DROP jos_virtuemart_product_relations.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_product_relations` DROP INDEX `id`
Tablename jos_virtuemart_rating_reviews dropped: 0 altered: 7 added: 0
alterTable DROP jos_virtuemart_rating_reviews.virtuemart_rating_review_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_rating_reviews` DROP INDEX `virtuemart_rating_review_id`
Tablename jos_virtuemart_ratings dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_ratings.i_virtuemart_product_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_ratings` DROP INDEX `i_virtuemart_product_id`
alterTable DROP jos_virtuemart_ratings.i_virtuemart_product_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_ratings` DROP INDEX `i_virtuemart_product_id`
Tablename jos_virtuemart_rating_votes dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_rating_votes.virtuemart_rating_vote_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_rating_votes` DROP INDEX `virtuemart_rating_vote_id`
Tablename jos_virtuemart_shipmentmethods dropped: 0 altered: 0 added: 0
Tablename jos_virtuemart_shipmentmethod_shoppergroups dropped: 0 altered: 0 added: 0
Tablename jos_virtuemart_shoppergroups dropped: 0 altered: 5 added: 0
alterTable DROP jos_virtuemart_shoppergroups.virtuemart_shoppergroup_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_shoppergroups` DROP INDEX `virtuemart_shoppergroup_id`
Tablename jos_virtuemart_states dropped: 0 altered: 6 added: 0
alterTable DROP jos_virtuemart_states.virtuemart_state_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_states` DROP INDEX `virtuemart_state_id`
Tablename jos_virtuemart_vmusers dropped: 0 altered: 6 added: 0
alterTable DROP jos_virtuemart_vmusers.i_virtuemart_user_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_vmusers` DROP INDEX `i_virtuemart_user_id`
alterTable DROP jos_virtuemart_vmusers.i_virtuemart_user_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_vmusers` DROP INDEX `i_virtuemart_user_id`
Tablename jos_virtuemart_vmuser_shoppergroups dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_vmuser_shoppergroups.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_vmuser_shoppergroups` DROP INDEX `id`
Tablename jos_virtuemart_permgroups dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_permgroups.virtuemart_permgroup_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_permgroups` DROP INDEX `virtuemart_permgroup_id`
Tablename jos_virtuemart_userfields dropped: 1 altered: 9 added: 1
alterTable DROP jos_virtuemart_userfields.virtuemart_userfield_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_userfields` DROP INDEX `virtuemart_userfield_id`
Tablename jos_virtuemart_userfield_values dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_userfield_values.virtuemart_userfield_value_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_userfield_values` DROP INDEX `virtuemart_userfield_value_id`
Tablename jos_virtuemart_userinfos dropped: 5 altered: 18 added: 1
Tablename jos_virtuemart_vendors dropped: 0 altered: 4 added: 0
alterTable DROP jos_virtuemart_vendors.virtuemart_vendor_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_vendors` DROP INDEX `virtuemart_vendor_id`
Tablename jos_virtuemart_vendor_medias dropped: 0 altered: 3 added: 0
alterTable DROP jos_virtuemart_vendor_medias.id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_vendor_medias` DROP INDEX `id`
Tablename jos_virtuemart_waitingusers dropped: 0 altered: 6 added: 0
alterTable DROP jos_virtuemart_waitingusers.virtuemart_waitinguser_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_waitingusers` DROP INDEX `virtuemart_waitinguser_id`
Tablename jos_virtuemart_worldzones dropped: 0 altered: 6 added: 0
alterTable DROP jos_virtuemart_worldzones.virtuemart_worldzone_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_worldzones` DROP INDEX `virtuemart_worldzone_id`
DROP jos_virtuemart_carts, jos_virtuemart_customplugins, jos_virtuemart_order_payment_paypal, jos_virtuemart_order_payment_standard, jos_virtuemart_shippingcarrier_shoppergroups, jos_virtuemart_shippingcarriers,
Installing component was successful.

bunglehaze

The SQL is just telling you what changes were made to the database structure. The VM menu is a module called VM category

giosanything

I also get the following in the front page..

Class 'vmPaymentPlugin' not found in /home/content/94/8495494/html/plugins/vmpayment/standard/standard.php on line 25

giosanything

When I installed the component I get this. I still don't see the menus for VirtueMart in Joomla.. Am I missing anything?

Error building Admin Menus
Installing component was successful.





VirtueMart2 modules moved to the joomla modules folder
VirtueMart2 language moved to the joomla language FE folder
VirtueMart2 language moved to the joomla language BE folder

Installing Virtuemart Plugins and modules Success.

You may directly uninstall this component. Your plugins will remain

Ignore the message Error building Admin Menus

bunglehaze

well if you take the time to read the text you will see the error at the top and then at the bottom a message telling you to ignore the error...

giosanything

I did.. and I got the front page issue resolved.. but I am trying to understand that if I am not suppose to get the "Typical" Virtuemart menus anymore by design. Or if something went wrong and they did not install. At the moment the typical menus for Virtuemart are no longer available through Joomla. I can see the modules for virtuemart but that's about it.

bunglehaze

You should be able to build a menu in J1.7 as any other Joomla item but not for individual categoried you can use the VM module for that part

Milbo

some explanations:
This message "alterTable DROP jos_virtuemart_rating_votes.virtuemart_rating_vote_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jos_virtuemart_rating_votes` DROP INDEX `virtuemart_rating_vote_id`" is for me a miracle, because it should only drop it when there is a key.

However the message appears, but it is correctly done.

The other problem is a joomla 1.7 problem. There are a lot things todo correct and some workarounds, but it seems we still did not get all glitches. One problem left seems to be when you install it with a different BE language than english en_GB. Other problem is now that the installation is after it happens one time often a bit scratched. You should take a look in the _extensions table and remove the old entry.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

giosanything

Got it working now.. We had to inject the menu item in the SQL table to make it available through Joomla!.. the problem is that the Add to Car function does not work. We have been looking around and try some recomendations. Redirecting the "www" in the ini file did not work and we ran out of ideas.. Any recommendations? I am using IE 9.0 and it does not work in Google Chrome.