vb.org Archive - Database Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Project Tools (https://vborg.vbsupport.ru/forumdisplay.php?f=266)

- - Database Error (https://vborg.vbsupport.ru/showthread.php?t=267618)

Lynessa

07-29-2011 12:04 PM

Database Error

Quote:

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

07-29-2011 12:41 PM

When does it appear? Is it reproduceable?

Lynessa

07-29-2011 01:01 PM

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

PitchouneN64ngc

07-29-2011 06:31 PM

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

07-29-2011 08:40 PM

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

Quote:

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

07-30-2011 01:08 AM

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

07-30-2011 07:20 AM

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

PitchouneN64ngc

07-30-2011 07:34 AM

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

07-30-2011 09:07 AM

Thank you. It has worked so far.

One last question.

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

PitchouneN64ngc

07-30-2011 12:08 PM

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

07-30-2011 02:17 PM

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	08-21-2011 08:01 AM

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/for...es-Sprachpaket

PitchouneN64ngc

08-21-2011 08:14 AM

Great to know for the German language file :)

All times are GMT. The time now is 02:22 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01284 seconds Memory Usage 1,732KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (13)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: