vb.org Archive - Database error during vbProject update 2.1.1 to 2.1.2

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

Andrew Elkins

12-30-2010 02:57 PM

Thanks Paul

jluerken

12-30-2010 02:59 PM

Tried to install 2.1.2r200 still error. Do you guys test what you upload?

Quote:

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

PitchouneN64ngc

12-30-2010 10:36 PM

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.

jluerken

12-31-2010 11:45 AM

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?

PitchouneN64ngc

12-31-2010 04:48 PM

1 Attachment(s)

Use this product file.

King Kovifor

01-01-2011 03:33 AM

Thanks Paul.

jluerken

01-01-2011 09:38 AM

That worked PitchouneN64ngc.

Where do I find a changelog?

King Kovifor

01-02-2011 06:03 AM

<a href="http://www.vb-os.com/projectsearch.php?do=searchresults&searchid=353" target="_blank">http://www.vb-os.com/projectsearch.p...s&searchid=353</a>

Ryan Ashbrook

01-02-2011 02:41 PM

Quote:

Originally Posted by King Kovifor (Post 2142640)

http://www.vb-os.com/projectsearch.p...s&searchid=353

This link isn't working, as that search has since expired.

For a general changelog, see the Milestone for 2.1.2.

Additionally, you may wish to review the Milestone for 2.1.1 as well to see all changes made to vBPT after being taken over by the vB-OS Team.

PitchouneN64ngc

01-02-2011 05:15 PM

I wrote some changelogs when I developed this version. If this could help (maybe add a sort of 'changelog generator' in PT for 2.2?):

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

Lists of new features / bug fixes in Project Tools 2.1.2.

Features
- Human Verification
- Added a 'Check all' checkbox in project subscriptions page
- Page navigation in issue list (if an issue have more than 1 page, a little page navigation is displayed next to the issue title)
- Color Title by Status (allow the admin to define a specific background color in issue listings in specific styles)
- Project Jump (allow anyone to jump from one project to another without going back to the project listings)
- Create new issue from reply (allow anyone to import a post into a new issue)
- Per-user Issue Counter (same as post count in profile)
- More type of notifications (the admin can allow users to be notified via PM for selected projects)
- Added 2 new CMS widgets
- Added 1 forum block
Bugs
- Style issue with the 'Search' dropdown
- Style bug with 'Go to the first unread'
- Text out of the box with some languages
- Single Milestone Style Issues
- Link to wrong URL
- Uncached templates in various locations
- Invalid Thread Error
- Page Navigation style issues on project search
- Magic Select CSS merged into projecttools.css
- Projects tab breaks Forum tab with some pages in 'Settings'
- Missing Icon
- Magic Selects / IE6 style issues
- Fixed various bugs/issues
Tasks
- Updated files to use PHP 5 design (private / public functions, etc.)
- Added a 'Post new link' into Milestone issues list
- All CSS definitions are in projecttools.css only (and projecttools-ie.css for IE6/7)
- Removed redundant code
- Removed useless index.html files
- The CSS uses now more default stylevars.
- Reworked code between <head> templates to remove useless code & to optimize variable calls.

All times are GMT. The time now is 04:09 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01344 seconds Memory Usage 1,788KB 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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (20)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: