Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Install Failed with 1071 Errir
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1
  • 2

TOPIC: Install Failed with 1071 Errir

Install Failed with 1071 Errir 10 years, 8 months ago #43638

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!
Attachments:
The topic has been locked.

Re: Install Failed with 1071 Errir 10 years, 8 months ago #43641

Trying again to attach files referenced in original post. The sql was renamed with a .txt extension.
Attachments:
The topic has been locked.

Re: Install Failed with 1071 Errir 10 years, 8 months ago #43643

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?
The topic has been locked.

Re: Install Failed with 1071 Errir 10 years, 8 months ago #43682

What is the solution to this error?
The topic has been locked.

Re: Install Failed with 1071 Errir 10 years, 8 months ago #43683

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.
The topic has been locked.

Re: Install Failed with 1071 Errir 10 years, 8 months ago #43689

  • pama
  • OFFLINE
  • Posts: 489
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.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
  • 2
User Login Empty