vb.org Archive - vBulletin Project Tools - vBulletin Project Tools Open Source 2.2.2

Page 9 of 11

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

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - vBulletin Project Tools - vBulletin Project Tools Open Source 2.2.2 (https://vborg.vbsupport.ru/showthread.php?t=270346)

persianpros

06-25-2014 05:00 AM

when i wanna merge 2 users :

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                UPDATE pt_issueattach SET

                        userid = 4967

                WHERE userid = 7689;



MySQL Error   : Unknown column 'userid' in 'where clause'

Error Number  : 1054

Request Date  : Wednesday, June 25th 2014 @ 01:51:49 AM

Error Date    : Wednesday, June 25th 2014 @ 01:51:49 AM

Script        : http://x/admincp/usertools.php?do=reallydomerge

Referrer      : http://x/admincp/usertools.php?do=domerge

IP Address    : x.x.x.x

PitchouneN64ngc

06-30-2014 12:54 PM

Maybe a valid bug. I'll check it later today or tomorrow.

ps: vb-os.com is back.

MrD	06-30-2014 07:06 PM

Hi Yves,
thx for this good Work :D

ETS_DeadShot

07-29-2014 04:46 AM

Any hope for a 5.x version for the new vB?

PitchouneN64ngc

08-01-2014 05:01 PM

I didnt had time to start to code for vB5 but it will have a lot of user file edits due to the nature of hooks in vB5.

MrD	08-03-2014 08:38 AM

Hi Yves,
Is there a newer Version avaible? Maybe with the latest bugfixings?

PitchouneN64ngc

08-05-2014 08:00 PM

Im working on it. Im reviewing the latest issues reported and found some others.

dunc07

09-03-2014 08:28 PM

Hi gents,

1st of all, kudos for your great work! We're using the project tools since a very long time, and they never failed us. :)

However... "a very long time" also means that we have accumulated quite a lot of "closed" issues by now.

I would like to know... is there a way of "bulk removing/deleting/pruning" closed issues from a project? I'm no PHP expert, but it seems that it should at least be possible to use e.g. the "projectpost.php" file and somehow "batch feed" it with a list of closed issue IDs for hard deletion?

Did someone actually do this before? Or is there a another/better option to "clean up" a long-running project?

Thanks!
Dunc.

Edit: sorry, didn't realize that support requests are only handled in the VB-OS forum. I posted the question over there now:
http://www.vb-os.com/threads/276-Bul...issues-from-DB

persianpros

10-13-2014 07:40 AM

is svn disabled or something ?

i can't connect via ubuntu 14.04 :(

PitchouneN64ngc

10-20-2014 01:56 PM

It works for me, I can see latest files on build 851.

persianpros

10-23-2014 07:33 AM

hhmm with a VPN connection it works here too

just upgraded from 2.2.1 to 2.2.2 on vb 4.2.2

PitchouneN64ngc

10-23-2014 09:00 AM

I'm not using any VPN to work on Project Tools. I'm not sure what is wrong here...

TMM-TT

10-31-2014 05:59 AM

Some observations made, if someone gets this problem:

When clicking on "My reports"
Parse error: syntax error, unexpected '}' in /www/htdocs/tornevall.net/forum/includes/functions_pt_search.php on line 953
In project.php:
Got an error on top of my forum if $projectgroupdata['projects'] does not contain any projects (Found out yesterday when I forgot to add projects in my project group).
Problem found at row 312 and solved with

Code:

if (is_array($projectgroupdata['projects']) AND isset($projectgroupdata['projects']))

PitchouneN64ngc

11-01-2014 04:49 PM

I'll fix this and I'll open an issue to display an error message if there is no project in the system.

Edit: it's already fixed in my code.

MrD	11-02-2014 09:14 AM

Hi Yves,
the Error with the Searchindex are in the latest Build too.

PitchouneN64ngc

11-02-2014 12:48 PM

It should be fixed now, you can give a try.

Black Snow

11-03-2014 09:31 AM

How do we install the patches? Do we have to manually add/edit/remove the lines in the patch files?

PitchouneN64ngc

11-03-2014 08:04 PM

Replied in the issue.

MrD	11-04-2014 05:02 PM

Hi Yves,
i have download the compl. PT from the SVN.
Build857 and if i run the searchindex.php via ssh this error comes

PHP Fatal error: Call to undefined method vB_Legacy_Issue::get_field_names() in /var/www/vhosts/xxxxxxxxx/httpdocs/packages/vbprojecttools/search/indexcontroller/issuenote.php on line 91s

PitchouneN64ngc

11-04-2014 07:21 PM

Strange as everything works fine for me. Can you open those files and post here what you have for the given lines:

- ./packages/vbprojecttools/search/indexcontroller/issuenote.php line 91
- ./vb/legacy/issue.php line 38

MrD	11-05-2014 03:23 AM

Hi Yves,
here are the Lines 90-91 from the issuenote.php

PHP Code:


		
			
$issuenote_fields = vB_Legacy_IssueNote::get_field_names();
        $issue_fields = vB_Legacy_Issue::get_field_names();

and here from the issue.php line 37-39

PHP Code:


		
			
*/
    public static function get_field_names()
    {

KGodel

12-09-2014 05:47 AM

I applied all the fixes listed in this thread but I am unable to update. Here is my error:

Quote:

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT projectgroupid
FROM xxxxx_pt_project
WHERE projectid = 3;

MySQL Error : Unknown column 'projectgroupid' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 9th 2014 @ 02:40:58 AM
Error Date : Tuesday, December 9th 2014 @ 02:40:58 AM
Script : http://www.zealotgaming.com/forum/ad...=productimport
Referrer : http://www.zealotgaming.com/forum/ad...?do=productadd
IP Address : xxxxxx
Username : DrMath
Classname : vB_Database
MySQL Version : 5.5.36-cll-lve

erosolmi

12-27-2014 06:11 AM

Same problem here upgrading from 2.1.4 to 2.2.1

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                SELECT projectgroupid

                FROM pt_project

                WHERE projectid = 1;



MySQL Error   : Unknown column 'projectgroupid' in 'field list'

Error Number  : 1054

Request Date  : Saturday, December 27th 2014 @ 08:10:39 AM

Error Date    : Saturday, December 27th 2014 @ 08:10:41 AM

Script        : http://www.thinbasic.com/community/admincp/plugin.php?do=productimport

Referrer      : http://www.thinbasic.com/community/admincp/plugin.php?do=productadd

IP Address    : xxxxxxx

Username      : xxxxxxxxxx

Classname     : xxxxxxxxxxxx

MySQL Version : 5.1.56-community

Where can I download previous version again?

TMM-TT

12-30-2014 02:03 PM

I've been looking around a bit for some kind of status report for this project, but I can't find anything. Neither I can find any updates for v2.2.2 on svn and on vb-os.com there's a worryiing silence from ... everybody. Does anyone have any status to give? I'm also interested in checking on the source code myself, but then I need to know how far the project has gone since 2.2.1 ...

TMM-TT

01-01-2015 07:33 AM

Quote:

Originally Posted by erosolmi (Post 2528984)

Same problem here upgrading from 2.1.4 to 2.2.1

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                SELECT projectgroupid

                FROM pt_project

                WHERE projectid = 1;



MySQL Error   : Unknown column 'projectgroupid' in 'field list'

Error Number  : 1054

Request Date  : Saturday, December 27th 2014 @ 08:10:39 AM

Error Date    : Saturday, December 27th 2014 @ 08:10:41 AM

Script        : http://www.thinbasic.com/community/admincp/plugin.php?do=productimport

Referrer      : http://www.thinbasic.com/community/admincp/plugin.php?do=productadd

IP Address    : xxxxxxx

Username      : xxxxxxxxxx

Classname     : xxxxxxxxxxxx

MySQL Version : 5.1.56-community

Where can I download previous version again?

SVN is probably your best shot (http://svn.vbulletin.org/svn/project_tools), from one of the older tags.

PitchouneN64ngc

01-01-2015 05:28 PM

I'll check this bug from upgrading then I'm releasing it :)

PitchouneN64ngc

01-16-2015 03:03 PM

I can confirm the issue, I'm working on it or no one will be able to upgrade from a previous version than 2.2.1.

MrD	01-17-2015 07:58 AM

Hi yves,
Thanks for the Info

Wedframe

03-23-2015 05:22 AM

Hello! I found little bug:

HTML Code:

PHP Parse error: syntax error, unexpected '}' in ****\includes\functions_pt_search.php on line 953

Can confirm. On line 952 - string:

PHP Code:


		
			
    return stripslashes(str_replace(' ' , '*', $matches[0]))

do NOT have semicolon at the end(at least in minified version).

Because of this don`t work any search-functions.

Good luck!

Hostboard

04-30-2015 10:31 AM

Quote:

Originally Posted by PitchouneN64ngc (Post 2532810)

I can confirm the issue, I'm working on it or no one will be able to upgrade from a previous version than 2.2.1.

It has been a year since the last update :(

MrD	04-30-2015 11:16 AM

maybe use PT from the Source Site.
There are newer Builds.

PitchouneN64ngc

05-24-2015 03:13 PM

vBulletin Project Tools 2.2.2 released.

If the release was a bit long, some changes happened (I'm hosting vb-os.com now) and some others should happen but it seems they wont appear at any time now.

persianpros

05-25-2015 02:11 AM

Great job like always :)

persianpros

06-21-2015 04:11 AM

Works on 4.2.3 without problem

persianpros

07-12-2015 05:38 AM

Still when you want to merge 2 users :

Code:

Database error in vBulletin 4.2.3:



Invalid SQL:



                UPDATE pt_issueattach SET

                        userid = x

                WHERE userid = x;



MySQL Error   : Unknown column 'userid' in 'where clause'

Error Number  : 1054

Request Date  : Sunday, July 12th 2015 @ 03:29:35 AM

Error Date    : Sunday, July 12th 2015 @ 03:29:35 AM

Script        : http://x.com/admincp/usertools.php?do=reallydomerge

Referrer      : http://x.com/admincp/usertools.php?do=domerge

IP Address    : x

Username      : x

Classname     : vB_Database

MySQL Version : 5.5.42-cll

I have to disable project tools each time I want to merge 2 users

mytreehouse

07-12-2015 10:34 AM

Save project gives:

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                                SELECT

                                        fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,

                                        a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,

                                        at.contenttypes, i.ispatchfile, i.status, u.username

                                FROM attachment AS a

                                        INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)

                                        LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)

                                        LEFT JOIN pt_issueattach AS i ON (i.attachmentid = a.attachmentid)

                                        LEFT JOIN user AS u ON (u.userid = a.userid)

                                WHERE

                                        a.contentid = 1

                                                AND

                                        a.contenttypeid = 

                        

ORDER BY a.contentid, a.displayorder;



MySQL Error   : 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 'ORDER BY a.contentid, a.displayorder' at line 15

Error Number  : 1064

When I click on Manage Subsriptions I got:

Code:

Trying to get contenttype class id from invalid contenttype '30' on line 533 in /home/xxx/xxx/forums/vb/types.php



Fatal error: Trying to get contenttype class id from invalid contenttype '30' on line 533 in ..../vb/types.php in ..../vb/vb.php on line 286

e24h	07-12-2015 01:28 PM

Great job like always

yotsume

12-10-2015 07:12 PM

Tried to install this version of Project Tools on vBulletin 4.2.3 and got this database error:https://vborg.vbsupport.ru/external/2015/12/15.jpg

PHP Warning: mysqli_query(): (23000/1062): Duplicate entry '4-IssueNote' for key 'packageclass' in ..../includes/class_core.php on line 1394

Database error in vBulletin 4.2.3:

Invalid SQL:

INSERT INTO vb_contenttype
(class, packageid, canplace, cansearch, cantag, canattach)
VALUES
('IssueNote', 4, '0', '0', '0', '0');

MySQL Error : Duplicate entry '4-IssueNote' for key 'packageclass'
Error Number : 1062

Script : http://www.mydomain/admincp/plugin.php?do=productimport
Referrer : http://www.mydomain/admincp/plugin.php?do=productadd

Classname : vB_Database_MySQLi
MySQL Version : 5.1.73-log

rbc	06-01-2017 05:54 PM

1 Attachment(s)

Tried to install this version of Project Tools on vBulletin 4.2.5.
Installation not possible - no way.

Attachment 156442

No error message ....... just the progressbar for ever :confused:

Someone an idea?

Dave	06-01-2017 08:39 PM

I'm pretty sure this project/plugin is dead and no longer developed/supported.

All times are GMT. The time now is 09:40 PM.

Page 9 of 11

« First

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08321 seconds Memory Usage 1,836KB 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 (7)bbcode_code_printable (1)bbcode_html_printable (3)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: