View Full Version : Database Error

29 Jul 2011, 13:04
Datenbankfehler in vBulletin 4.1.4:

Invalid SQL:

INSERT INTO pt_projectpermission
(usergroupid, projectid, issuetypeid, generalpermissions, postpermissions, attachpermissions)
(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?

29 Jul 2011, 13:41
When does it appear? Is it reproduceable?

29 Jul 2011, 14:01
It apperas when i want to add the whole thing to the products

29 Jul 2011, 19:31
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?

29 Jul 2011, 21:40
Ok i have deleted the old table but now there is the following error

Invalid SQL:

INSERT INTO cms_widgettype
(class, packageid)
('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

30 Jul 2011, 02:08
I already added a check for this (to not run these queries if you don't use Suite Publishing) but I will review it.

30 Jul 2011, 08:20
What does this mean, you added a check? Can i find a solution here in the forums???

30 Jul 2011, 08:34
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.

30 Jul 2011, 10:07
Thank you. It has worked so far.

One last question.

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

30 Jul 2011, 13:08
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) :)

30 Jul 2011, 15:17
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)

21 Aug 2011, 09:01
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

21 Aug 2011, 09:14
Great to know for the German language file :)