Error installing 2.0.10

[Jason Farmer]

Stable label on this version already?

Installed com_virtuemart.2.0.10 - no error messages - all appeared OK but can not access virtuemart admin ... Error 500 ...

Server error
The website encountered an error while retrieving http://localhost/horsecare/administrator/index.php?option=com_virtuemart. It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this web page later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfil the request.

nothing in the apache log

thought that aio would help ... so Installed com_virtuemart.2.0.10_ext_aio too, and got the following error and still can't access the backend

com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_standard
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_paypal
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_shipment_plg_weight_countries
Install Component Success
vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `jos_virtuemart_payment_plg_standard` ( `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(1) UNSIGNED, `order_number` char(64), `virtuemart_paymentmethod_id` mediumint(1) UNSIGNED, `payment_name` varchar(5000), `payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000', `payment_currency` char(3), `cost_per_transaction` decimal(10,2), `cost_percent_total` decimal(10,2), `tax_id` smallint(1), `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `jos_virtuemart_payment_plg_paypal` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(1) UNSIGNED, `order_number` char(64), `virtuemart_paymentmethod_id` mediumint(1) UNSIGNED, `payment_name` varchar(5000), `payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000', `payment_currency` char(3) , `cost_per_transaction` decimal(10,2), `cost_percent_total` decimal(10,2), `tax_id` smallint(1), `paypal_custom` varchar(255), `paypal_response_mc_gross` decimal(10,2) NULL DEFAULT NULL, `paypal_response_mc_currency` char(10) NULL DEFAULT NULL, `paypal_response_invoice` char(32) NULL DEFAULT NULL, `paypal_response_protection_eligibility` char(128) NULL DEFAULT NULL, `paypal_response_payer_id` char(13) NULL DEFAULT NULL, `paypal_response_tax` decimal(10,2) NULL DEFAULT NULL, `paypal_response_payment_date` char(28) NULL DEFAULT NULL, `paypal_response_payment_status` char(50) NULL DEFAULT NULL, `paypal_response_pending_reason` char(50) NULL DEFAULT NULL, `paypal_response_mc_fee` decimal(10,2) NULL DEFAULT NULL, `paypal_response_payer_email` char(128) NULL DEFAULT NULL, `paypal_response_last_name` char(64) NULL DEFAULT NULL, `paypal_response_first_name` char(64) NULL DEFAULT NULL, `paypal_response_business` char(128) NULL DEFAULT NULL, `paypal_response_receiver_email` char(128) NULL DEFAULT NULL, `paypal_response_transaction_subject` char(128) NULL DEFAULT NULL, `paypal_response_residence_country` char(2) NULL DEFAULT NULL, `paypal_response_txn_id` char(32) NULL DEFAULT NULL, `paypal_response_txn_type` char(32) NULL DEFAULT NULL, `paypal_response_parent_txn_id` char(32) NULL DEFAULT NULL, `paypal_response_case_creation_date` char(32) NULL DEFAULT NULL, `paypal_response_case_id` char(32) NULL DEFAULT NULL, `paypal_response_case_type` char(32) NULL DEFAULT NULL, `paypal_response_reason_code` char(32) NULL DEFAULT NULL, `paypalresponse_raw` varchar(512) NULL DEFAULT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `jos_virtuemart_shipment_plg_weight_countries` ( `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(11) UNSIGNED, `order_number` char(32), `virtuemart_shipmentmethod_id` mediumint(1) UNSIGNED, `shipment_name` varchar(5000), `order_weight` decimal(10,4), `shipment_weight_unit` char(3) DEFAULT 'KG', `shipment_cost` decimal(10,2), `shipment_package_fee` decimal(10,2), `tax_id` smallint(1), `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
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
VirtueMart2 pdf moved to the joomla libraries folder
Installing Virtuemart Plugins and modules Success.

You may directly uninstall this component. Your plugins will remain

Ignore the message JLIB_INSTALLER_ABORT_COMP_BUILDADMINMENUS_FAILED

[Jason Farmer]

I thought I'd just go back to 2.08e...

So I restored all the files from my vm1.x set up, dropped all the jos_virtuemart tables and downloaded and installed 2.08e .. same problem Error 500 on all attempts to access the virtuemart back end. Odd thing is I have a (somewhat) working 2.08e installation ... it was 2.08c patched to 2.08e - it is offering to update me to 2.08e ... even though the version.php file states that it is 2.08e already.

I'm a bit fed up with all this bleeding edge. So much to do and so little time available. What is the oldest most stable version available that runs with PHP 5.3?

[jenkinhill]

Most stable version is 2.0.10 on Joomla 2.5.6  - I don't understand your error messages.

[alatak]

Hello,

What are you trying to do?
Are you installing a fresh version or updating?

Or are you trying to migrate your VM1 store?
If you are trying to migrate, you can read this http://dev.virtuemart.net/projects/virtuemart/wiki/Upgrading_VM1_to_VM2_with_provided_packages
And there are also some posts about the migration process

[alatak]

Hello,

also,

The component "com_virtuemart" must be successfully installed first.
Only then you can install the other component called "com_virtuemart_aio"

[K&K media production]

Hi,
delete the entries in session table from Joomla, maybe this will fix the 500 error.

[Milbo]

I also just checked the code and th sql you posted should never appear. The primary is missing, but it is always there. Also no one else has this error.

[Jason Farmer]

Thank you for your help. Much appreciated.

The database errors seem to have been caused by some backup tables that I was restoring using drop and create table from select... etc which I now know deletes the keys, so I won't be doing that again.

The 500 error is something different... It only appears when trying to access com_virtuemart after the 2.0.10 install - the rest of the site works

I am upgrading from J1.5.14  vm1.1.3 via J1.5.26 vm1,1,3 to j1.5.26 vm2.0.10

Immediately after the error free 2.0.10 install (before aio) If I click install the sample data button, i get a 500 error, but then if I go back in my browser and then click on for example Extensions... Module Manager - I then get the module manager page along with the information that the sample data has been included ... very weird.

In the apache error log, the messages (which seem to take an age to arrive there) are as below...

[Fri Aug 24 05:42:19 2012] [error] [client 127.0.0.1] File does not exist: C:/xampp/htdocs/htdocs

C:\xampp\htdocs\ is my apache document root, and my joomla  installation is in C:\xampp\htdocs\horsecare

no idea where this C:/xampp/htdocs/htdocs is coming from, althou I created the directory to see if it would fix the error - but no such luck...

[StormIT]

...Also no one else has this error.

I'm having this exact problem. Just updated to 2.0.10 (running Joomla 2.5.6) and the menu item for Virtuemart has disappeared from the admin (backend) menu.

I upgraded from 2.0.8 and thought this may have been the problem, so uninstalled 2.0.10, deleted all the references to virtuemart using PHPMyAdmin and cleared cache, then reinstalled 2.0.10 but still not appearing in the admin menu!

Help needed please!!

[Renata]

...Also no one else has this error.

I'm having this exact problem. Just updated to 2.0.10 (running Joomla 2.5.6) and the menu item for Virtuemart has disappeared from the admin (backend) menu.

I upgraded from 2.0.8 and thought this may have been the problem, so uninstalled 2.0.10, deleted all the references to virtuemart using PHPMyAdmin and cleared cache, then reinstalled 2.0.10 but still not appearing in the admin menu!

Help needed please!!

This is an error which i had in the past too. You can fix this via database:

1. Go to the backend extension manager > manage and find VM component. Look at the ID number and wright that down.
2. Login to phpmyadmin and  go to the concerning database. Find the "#-menu" table (#- is the prefix). Open this one and look for the column title "COM VIRTUEMART" and after that look for the component-id. If this number differs from the one you have written down, than change this number into the right one.
3. after that safe the new settings (start)

Go to the backend of Joomla and you will see Virtuemart in the menu.

Kind regards
Renata

[StormIT]

Renata,

Thank you very much for your help and the prompt response. It's working great now!!

regards

Russell

[jenkinhill]

The usual reason for no link in BE components is that you have xmap installed without the VirtueMart plugin.

[Renata]

The usual reason for no link in BE components is that you have xmap installed without the VirtueMart plugin.

Howdy jenkinhill

Thanks for your info. However i encountered this problem on a webshop where no xmap at all has been installed. Don't know why suddenly i have to do all this just to make virtuemart visible in the components menu at the backend.

Kind regards
Renata

[katrey]

vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `jos_virtuemart_payment_plg_standard` ( `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(1) UNSIGNED, `order_number` char(64), `virtuemart_paymentmethod_id` mediumint(1) UNSIGNED, `payment_name` varchar(5000), `payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000', `payment_currency` char(3), `cost_per_transaction` decimal(10,2), `cost_percent_total` decimal(10,2), `tax_id` smallint(1), `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

I am also have same prodlem during update AIO from 2.0.8e to 2.0.10

[Jason Farmer]

Most stable version is 2.0.10 on Joomla 2.5.6  - I don't understand your error messages.

I got away from this error by scrapping the whole thing and starting from scratch.

Installed J2.5.6 and vm 2.0.10 into a new database, including all sample data
installed vm aio
copied in old vm tables from another database
used the vm migrate tool
deleted sample data
used some sql magic to recast all the product, category, manufacturer etc ids to be the same as the one on the existing system.
then used j2xml to migrate the content, articles,categories and weblinks over
Just needed to manually rebuild all the menus, and set up the modules and plugins that I want (which I would have had to do in any case as moving to J2.5 from 1.5)
I have ended up with (imho) a much cleaner and more stable installation then trying to do everything on top of an ancient setup.