vb.org Archive
Page 1 of 2 1 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 during vbProject update 2.1.1 to 2.1.2 (https://vborg.vbsupport.ru/showthread.php?t=256117)

jluerken 12-29-2010 10:27 AM
Database error during vbProject update 2.1.1 to 2.1.2
 
Database error during vbProject update 2.1.1 to 2.1.2

Quote:
Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT INTO vb305_pt_issueimport
(contenttypeid, contentid, data)
VALUES
(2, 43573, 'a:2:{s:10:"pt_issueid";s:4:"2727";s:14:"pt_forwar dmode";s:1:"1";}');

MySQL Error : Duplicate entry '0' for key 'PRIMARY'
Error Number : 1062
Request Date : Wednesday, 29.12.2010 @ 13:24:09
Error Date : Wednesday, 29.12.2010 @ 13:24:10
Script : http://www.tld.com/forum/admincp/plu...=productimport
Referrer : http://www.tld.com/forum/admincp/plu...?do=productadd
Classname : vB_Database
MySQL Version : 5.1.49-2
Tried to update vbproject today and get this db error if I try to import the product.

Wakey 12-29-2010 12:44 PM
It takes them forever to release an update and when they do it BREAKS the whole thing when you try and upgrade.

And to make matters worse they take the old version down so you can't even revert back. Seriously Pathetic

Andrew Elkins 12-29-2010 01:22 PM
Change line 1129 in includes/xml/product-vbprojecttools.xml
From:
CREATE TABLE " . TABLE_PREFIX . "pt_issuestatusprojectset (
issuestatusid INT UNSIGNED NOT NULL DEFAULT 0,
projectid INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (issuestatusid, projectid)
)
To:
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "pt_issuestatusprojectset (
issuestatusid INT UNSIGNED NOT NULL DEFAULT 0,
projectid INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (issuestatusid, projectid)
)

This is for your first error you PM'd me about.

jluerken 12-29-2010 03:54 PM
No that does not fix it

Quote:
Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT INTO vb305_pt_issueimport
(contenttypeid, contentid, data)
VALUES
(2, 45238, 'a:2:{s:10:"pt_issueid";s:4:"2871";s:14:"pt_forwar dmode";s:1:"1";}');

MySQL Error : Duplicate entry '0' for key 'PRIMARY'
Error Number : 1062
Request Date : Wednesday, 29.12.2010 @ 18:52:24
Error Date : Wednesday, 29.12.2010 @ 18:52:25
Script : http://www.tld.com/forum/admincp/plu...=productimport
Referrer : http://www.tld.com/forum/admincp/plu...?do=productadd
Classname : vB_Database
MySQL Version : 5.1.49-2

Andrew Elkins 12-29-2010 04:30 PM
Ah misread the error. One moment.

Andrew Elkins 12-29-2010 04:32 PM
I had assumed this was the same error you PM'd me about. Just noticed this is a different error.

--------------- Added [DATE]1293647709[/DATE] at [TIME]1293647709[/TIME] ---------------

Quote:
Originally Posted by jluerken (Post 2140805)
I just tried to update vbproject and got this db error.

Database error during vbProject update 2.1.1 to 2.1.2

Database error in vBulletin 4.0.8:

Invalid SQL:

CREATE TABLE vb305_pt_issuestatusprojectset (
issuestatusid INT UNSIGNED NOT NULL DEFAULT 0,
projectid INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (issuestatusid, projectid)
);

MySQL Error : Table 'vb305_pt_issuestatusprojectset' already exists
Error Number : 1050
Request Date : Wednesday, 29.12.2010 @ 13:30:30
Error Date : Wednesday, 29.12.2010 @ 13:30:30
Script : http://www.tld.com/forum/admincp/plu...=productimport
Referrer : http://www.tld.com/forum/admincp/plu...?do=productadd
Classname : vB_Database
MySQL Version : 5.1.49-2
This error ^

--------------- Added [DATE]1293649681[/DATE] at [TIME]1293649681[/TIME] ---------------

Warning! I haven't been able to test this, but this might fix your issue.

line 1196
Change this:
$db->query_write("
INSERT INTO " . TABLE_PREFIX . "pt_issueimport
(contenttypeid, contentid, data)
VALUES
($contenttypeid, " . $movedthread['threadid'] . ", '" . $importdata . "')
");

To:
$db->query_write("
INSERT INTO " . TABLE_PREFIX . "pt_issueimport
(issueid, contenttypeid, contentid, data)
VALUES
($movedthread['pt_issueid'], $contenttypeid, " . $movedthread['threadid'] . ", '" . $importdata . "')
");

PitchouneN64ngc 12-29-2010 09:51 PM
I just forget to add the field which was the latest thing I added (fixed 3-4 non-released issues) and forget to add it to the importer when you upgrade.

Sorry, will be fixed in next release :)

----------------

The code is already edited with the right code in SVN. Maybe one of the allowed users can update the package with the right product file (King)?

For those who are already on vb-os and want to update with non-stable releases, you can make a svn update to get build 199 which contains the fixed product file and the corresponding MD5 file.

jluerken 12-30-2010 11:58 AM
Where can I download a fixed package now?

Paul M 12-30-2010 12:43 PM
Ive uploaded svn version 200 to the release thread.

https://vborg.vbsupport.ru/showthread.php?t=241453

PitchouneN64ngc 12-30-2010 01:36 PM
Thanks Paul :)


All times are GMT. The time now is 09:17 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01470 seconds
  • Memory Usage 1,737KB
  • 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
  • (3)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