vb.org Archive - Database Error

Page 1 of 2

Show 40 post(s) from this thread on one page

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

All times are GMT. The time now is 03:57 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01452 seconds Memory Usage 1,728KB 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)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: