Database Error

Datenbankfehler in vBulletin 4.1.4:

Invalid SQL:

INSERT INTO pt_projectpermission
(usergroupid, projectid, issuetypeid, generalpermissions, postpermissions, attachpermissions)
VALUES
(1, 0, 'bug',
65555, 0, 1),(1, 0, 'feature',
65555, 0, 1),(1, 0, 'task',
65555, 0, 1);

MySQL-Fehler : Duplicate entry '1-0-bug' for key 1
Fehler-Nr. : 1062
Klassenname : vB_Database
MySQL-Version : 5.0.92

Can anyone help me with this error?

[Disasterpiece]

When does it appear? Is it reproduceable?

[Lynessa]

It apperas when i want to add the whole thing to the products

[PitchouneN64ngc]

This type of error appears when you have already installed it (or tried to install it) and you did it twice without overwriting the installed non-referenced product.

Have you already tried to install it? It was an update of a previous install?

[Lynessa]

Ok i have deleted the old table but now there is the following error

Invalid SQL:

INSERT INTO cms_widgettype
(class, packageid)
VALUES
('RecentPTIssues', ),
('RecentPTComments', );

MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),
('RecentPTComments', )' at line 4
Fehler-Nr. : 1064

Do i need the CMS to use this??

I only have the usual forum license

[PitchouneN64ngc]

I already added a check for this (to not run these queries if you don't use Suite Publishing) but I will review it.

[Lynessa]

What does this mean, you added a check? Can i find a solution here in the forums???

[PitchouneN64ngc]

The check is already in the system. If the file ./includes/xml/product_vbcms.xml is present, it executes the corresponding queries.

Delete that file prior to install/update Project Tools.

I will alter the check to verify if the CMS is activated. If not, the corresponding queries will not be executed.

[Lynessa]

Thank you. It has worked so far.

One last question.

Is there any german language? because i have seen this somewhere in german??

[PitchouneN64ngc]

No one give us a german translation of the latest product version.

I would be happy to have a German language file to include for the next releases (or any other languages)

As a test, you can try to see if there is a language file in official germany forums (even from an older release)