Database Error

[Lynessa]

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) :)

[Lynessa]

Ok. Then I will translate the italian language (attached file with download) to a german .xml

I will send you a link when I'm finished (and after I have tested this)

[rovo]

I had to delete ./includes/xml/product_vbcms.xml to upgrade from 2.0.1 (vB 3.8.6) to 2.1.2 (vB 4.1.5 PL1). As I don't need CMS and Blog, I had uninstalled the addons, but the XML file remained. So it's good to here that this check will be changed.

Regarding German language fles, you can find them here (for 2.1.1): http://www.vbulletin-germany.com/forum/showthread.php/50693-vBulletin-Projektverwaltung-2.1.1-Deutsches-Sprachpaket

[PitchouneN64ngc]

Great to know for the German language file :)