Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 29 Dec 2010, 12:27
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Database error during vbProject update 2.1.1 to 2.1.2

Database error during vbProject update 2.1.1 to 2.1.2

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_forwardmode";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.
__________________
Ciao jluerken
Reply With Quote
Comments
  #2  
Old 29 Dec 2010, 14:44
Wakey Wakey is offline
 
Join Date: Dec 2008
Real name: Simon Wakefield
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
Reply With Quote
  #3  
Old 29 Dec 2010, 15:22
Andrew Elkins Andrew Elkins is offline
 
Join Date: Nov 2009
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.

Last edited by Andrew Elkins; 29 Dec 2010 at 18:32.
Reply With Quote
  #4  
Old 29 Dec 2010, 17:54
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
No that does not fix it

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_forwardmode";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
__________________
Ciao jluerken
Reply With Quote
  #5  
Old 29 Dec 2010, 18:30
Andrew Elkins Andrew Elkins is offline
 
Join Date: Nov 2009
Ah misread the error. One moment.
Reply With Quote
  #6  
Old 29 Dec 2010, 18:32
Andrew Elkins Andrew Elkins is offline
 
Join Date: Nov 2009
I had assumed this was the same error you PM'd me about. Just noticed this is a different error.

--------------- Added 29 Dec 2010 at 18:35 ---------------

Originally Posted by jluerken View Post
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 29 Dec 2010 at 19:08 ---------------

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 . "')
");

Last edited by Andrew Elkins; 29 Dec 2010 at 22:05. Reason: Auto-Merged DoublePost
Reply With Quote
  #7  
Old 29 Dec 2010, 23:51
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
 
Join Date: Aug 2002
Real name: Yves
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.
__________________
Administrator of http://forum.vbulletin-fr.org/

vBulletin QA Engineer / Lead Project Tools Developer

Last edited by PitchouneN64ngc; 30 Dec 2010 at 00:03.
Reply With Quote
  #8  
Old 30 Dec 2010, 13:58
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Where can I download a fixed package now?
__________________
Ciao jluerken
Reply With Quote
  #9  
Old 30 Dec 2010, 14:43
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Ive uploaded svn version 200 to the release thread.

http://www.vbulletin.org/forum/showthread.php?t=241453
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #10  
Old 30 Dec 2010, 15:36
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
 
Join Date: Aug 2002
Real name: Yves
Thanks Paul
__________________
Administrator of http://forum.vbulletin-fr.org/

vBulletin QA Engineer / Lead Project Tools Developer
Reply With Quote
  #11  
Old 30 Dec 2010, 16:57
Andrew Elkins Andrew Elkins is offline
 
Join Date: Nov 2009
Thanks Paul
Reply With Quote
  #12  
Old 30 Dec 2010, 16:59
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Tried to install 2.1.2r200 still error. Do you guys test what you upload?

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 : Thursday, 30.12.2010 @ 17:58:08
Error Date : Thursday, 30.12.2010 @ 17:58:08
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
__________________
Ciao jluerken
Reply With Quote
  #13  
Old 31 Dec 2010, 00:36
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
 
Join Date: Aug 2002
Real name: Yves
Delete the existing table.

Only this table have this issue when you install/upgrade, others have the right syntax to avoid this error.

And yes, the system was tested but not by a lot of users because as Andrew said, we are volunteers and donating out time to put out a product. And it seems I'm the only one on this product. And maybe as you could see, it's 2am for me, just back from my job and tired. With that, I fixed this issue.

Fixed in build 201.

--------------- Added Friday 31 December 2010 at 1:39 ---------------

Now I'm preparing the system to start the dev of 2.2.0 version.
__________________
Administrator of http://forum.vbulletin-fr.org/

vBulletin QA Engineer / Lead Project Tools Developer

Last edited by PitchouneN64ngc; 31 Dec 2010 at 00:42. Reason: Auto-Merged DoublePost
Reply With Quote
  #14  
Old 31 Dec 2010, 13:45
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Hi PitchouneN64ngc,

I did not want to value the work you do in this project low.
It's only that I have installed the product 3 times and I always got DBs error and no real fix.

I do not want to delete tables if possible so is 201 fixing the issues that I can install the update without doing something manually in the database?
__________________
Ciao jluerken
Reply With Quote
  #15  
Old 31 Dec 2010, 18:48
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
 
Join Date: Aug 2002
Real name: Yves
Use this product file.
Attached Files
File Type: xml product-vbprojecttools.xml (502.8 KB, 12 views)
__________________
Administrator of http://forum.vbulletin-fr.org/

vBulletin QA Engineer / Lead Project Tools Developer
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:53.

Layout Options | Width: Wide Color: