I purchased the VM Invoice product this afternoon and attempted to install on a clean installation of Joomla 2.5.19, Virtumart 2.0.26d and received the following error:

JInstaller: :Install: Error SQL DB function failed with error number 1071 (screenshot attached).


It was installed on the test site I provided during purchase.

I edited the file "install.mysql.utf8.sql" in the admin/sql folder of the unzipped install and removed the field "type" from the primary key for the table vminvoice_template. I left "config_id" and "document" as primary keys (file attached). After rezipping the file, I was able to install it without further errors (screenshot attached).

Side note: I happened upon this fix by attempting to manually add the vminvoice_template table. Using PHPMyAdmin provided by my hosting company, I was unable to designate three fields as primary.

I will begin using the program on my test site but want to know if this will cause any issues long term. I need this to go live ASAP. Many thanks!

Trying again to attach files referenced in original post. The sql was renamed with a .txt extension.

Answered my first question. Yes, it causes a problem.

However, the install problem was not caused by trying to designate 3 primary fields, but rather the length of those fields.

I again modified "install.mysql.utf8.sql" as follows:

CREATE TABLE IF NOT EXISTS `#__vminvoice_templates` (
`config_id` int(11) NOT NULL,
`document` varchar(25) NOT NULL,
`type` varchar(25) NOT NULL,
`name` varchar(255) NOT NULL COMMENT 'custom name',
`template` text NULL,
`params` text NOT NULL,
`last_template_change` INT NOT NULL,
PRIMARY KEY (`config_id`,`document`,`type` ),
KEY `last_template_change` (`last_template_change`)
) ;

Changing the length of document and type to 25 rather than 255.

This works.

Will this cause a problem I have not yet discovered?

What is the solution to this error?

I unzipped the files locally and then edited the file admin/sql/install.mysql.utf8.sql as described previously. Specifically, I changed the length of the document and type fields to 25:

`document` varchar(25) NOT NULL,
`type` varchar(25) NOT NULL,

I then reshipped the files and installed without problem. Still waiting to hear if these solution will cause other issues.

Hello. artechulate's solution is right. We are deeply sorry about these problems. We just released fixed version 2.0.33, which should fix these installation problems.