The Arcive of Official vBulletin Modifications Site.

vBulletin Project Tools Open Source 2.2.2 · **Released**: 09-14-2011

We're excited that we are finally able to release Project Tools Open Source version 2.2.2.

Here's all you need to do to have Project Tools running on your site.

1. Download the files
2. Unzip the files locally
3. Upload the contents of the files located inside the /upload/ directory to your existing vBulletin directory.
4. Log in to your forum's control panel. Go to Plugins & Products > Manage Products > Add/Import Product
5. In the Import the XML file from your server field, enter: ./includes/xml/product-vbprojecttools.xml Change Allow Overwrite to yes if you are updating a previous installation.
6. Click Import

Comments, Questions, Support and Concerns will be addressed here and here only.

Further documentation can be found in the docs and here. Beta documentation is located within the /do_not_upload/ directory within the download.

For this release, the Italian language is not updated to Project Tools 2.2.2, and the Romanian language is added and noted for 2.2.1.

I hope this release will make you happy

Thanks

Download history
- 2.1.4: 238 downloads
- 2.2.0: 262 downloads
- 2.2.0 (minified): 88 downloads
- 2.2.1: 191 downloads
- 2.2.1 (minified): 56 downloads

ozione · #82 10-06-2012, 09:42 AM

hi, mates!

i have some really big issues with my site since uninstalling the project tools. i asked for help on it's official support forums but no one seems to care.

what i did was a complete uninstallation of the product. by the book. i'm getting these sql errors, so i tried to reinstall the product (no more errors) and uninstall it again. no luck.

the sql error:

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

					SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_projecttools AS phrasegroup_projecttools,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
					FROM vb4_language
					WHERE languageid = 2;

MySQL Error   : Unknown column 'phrasegroup_projecttools' in 'field list'
Error Number  : 1054
Request Date  : Saturday, October 6th 2012 @ 11:43:17 AM
Error Date    : Saturday, October 6th 2012 @ 11:43:17 AM
Script        : http://www.mydomain.com/vb4/project.php?do=issuelist&projectid=2&issuetypeid=&issuestatusid=0&appliesversionid=v1
Referrer      : 
IP Address    : 66.249.71.139
Username      : 
Classname     : vB_Database
MySQL Version :

ANY help would be REALLY appriciated.
thank you.

metalguy639 · #83 10-06-2012, 09:18 PM

Quote:

Originally Posted by ozione

hi, mates!

i have some really big issues with my site since uninstalling the project tools. i asked for help on it's official support forums but no one seems to care.

what i did was a complete uninstallation of the product. by the book. i'm getting these sql errors, so i tried to reinstall the product (no more errors) and uninstall it again. no luck.

the sql error:

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

					SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_projecttools AS phrasegroup_projecttools,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
					FROM vb4_language
					WHERE languageid = 2;

MySQL Error   : Unknown column 'phrasegroup_projecttools' in 'field list'
Error Number  : 1054
Request Date  : Saturday, October 6th 2012 @ 11:43:17 AM
Error Date    : Saturday, October 6th 2012 @ 11:43:17 AM
Script        : http://www.mydomain.com/vb4/project.php?do=issuelist&projectid=2&issuetypeid=&issuestatusid=0&appliesversionid=v1
Referrer      : 
IP Address    : 66.249.71.139
Username      : 
Classname     : vB_Database
MySQL Version :

ANY help would be REALLY appriciated.
thank you.

It looks like the phrasegroups did not uninstall for Project tools. Did you first go to Plugins & Products>Manage Products and click the drop down next to the Project Tools install and tick uninstall? That usually allows you to uninstall any tables found in your database that may cause errors otherwise.

If you did do that and you still get that error you may have to go into your database and drop that table from the database manually. Make sure and I cannot stress enough, make sure you completely back up the database first.

TheSupportForum · #84 10-06-2012, 09:27 PM

Quote:

Originally Posted by metalguy639

It looks like the phrasegroups did not uninstall for Project tools. Did you first go to Plugins & Products>Manage Products and click the drop down next to the Project Tools install and tick uninstall? That usually allows you to uninstall any tables found in your database that may cause errors otherwise.

If you did do that and you still get that error you may have to go into your database and drop that table from the database manually. Make sure and I cannot stress enough, make sure you completely back up the database first.

its nothing to do with that, its the install script for the database it just need a minor change

change all instances of

Code:

) TYPE=MyISAM;;

to

Code:

) ENGINE=MyISAM; ');

or from

Code:

) TYPE=MyISAM;;

to

Code:

) ');

once its reinstalled the product will work, then if uninstalled it will remove that same issue

ozione · #85 10-11-2012, 09:09 AM

hey!
thanks for a reply.

where do i get to change those instances, please?

TheSupportForum · #86 10-11-2012, 09:30 AM

Quote:

Originally Posted by ozione

hey!
thanks for a reply.

where do i get to change those instances, please?

the product xml file

basically this addon will work once you make those changes to it

ozione · #87 10-11-2012, 02:49 PM

thanks for that. the reason i wasn't able to find these strings is that in the included .xml, instances are already changed.

hm...

Christos Teriakis · #88 10-29-2012, 07:23 AM

When you're getting similar errors (phrasegroups missing), then 99% is because you left behind a cron file at includes/cron/. This applies to all mods having cron files which files are trying to load a phrasegroup.

Chris

PitchouneN64ngc · #89 10-29-2012, 09:12 PM

I'll do a 2.1.4 release for the time I could finish 2.2.0 test. It have vB 4.2.0 changes, I think I'll add more fixes in it, not sure (most fixes will go to 2.2.0).

I'll take all feedback between my last post and this one, and seeing if I can fix those quickly

PitchouneN64ngc · #90 10-29-2012, 09:19 PM

Quote:

Originally Posted by deadlySniper

I keep getting this error when I import

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

			INSERT INTO vb_pt_projectpermission
				(usergroupid, projectid, issuetypeid, generalpermissions, postpermissions, attachpermissions)
			VALUES
				(1, 0, 'bug',
				0, 0, 0),(1, 0, 'feature',
				0, 0, 0),(1, 0, 'task',
				0, 0, 0);

MySQL Error   : Duplicate entry '1-0-bug' for key 1
Error Number  : 1062
Request Date  : Monday, September 17th 2012 @ 10:52:29 PM
Error Date    : Monday, September 17th 2012 @ 10:52:40 PM
Script        : http://survivedayz.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://survivedayz.com/forums/admincp/plugin.php?do=productadd
IP Address    : *******
Username      : **********
Classname     : vB_Database
MySQL Version : 5.0.92-log

Did you already installed it before? It failed when you first tried? Did you uninstalled it previously correctly?

Quote:

Originally Posted by metalguy639

Again I ask this...

Has this been updated yet? Seems there is no one working on this anymore and no one seems to be interested in fixing the issues it has.

It's not possible to give specific permission to an user, you need to add this user in a specific usergroup (alone in the selected usergroup) and assign specific permissions in this usergroup.

Quote:

Originally Posted by Hostboard

In April he announced it was going to be released within a week.
We have now seen 6 months of soon.

There is also a known issue with this current release and TapaTalk.

The current fix is:

Code:

Did you installed Project tools mod on your forum?
If it is, please try comment out below in line plugin file mobiquo/functions/get_thread.php at about line 538:
//($hook = vBulletinHook::fetch_hook('showthread_query')) ? eval($hook) : false;

I am also hoping the human verification mod is integrated into this as it currently is not compatable any more. It was with VB 4 but somewhere along the lines VB4's updates broke it.
https://vborg.vbsupport.ru/showthread.php?t=219636

Human Verification mod is integrated in Project Tools 2.2.0. I need to find some time to finish to fully test it, I hope to find some time thursday

I didn't know for an incompatibility with Tapatalk, I'm not using it. I'll check with it to find an automated fix

Quote:

Originally Posted by ozione

hi, mates!

i have some really big issues with my site since uninstalling the project tools. i asked for help on it's official support forums but no one seems to care.

what i did was a complete uninstallation of the product. by the book. i'm getting these sql errors, so i tried to reinstall the product (no more errors) and uninstall it again. no luck.

the sql error:

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

					SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_projecttools AS phrasegroup_projecttools,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
					FROM vb4_language
					WHERE languageid = 2;

MySQL Error   : Unknown column 'phrasegroup_projecttools' in 'field list'
Error Number  : 1054
Request Date  : Saturday, October 6th 2012 @ 11:43:17 AM
Error Date    : Saturday, October 6th 2012 @ 11:43:17 AM
Script        : http://www.mydomain.com/vb4/project.php?do=issuelist&projectid=2&issuetypeid=&issuestatusid=0&appliesversionid=v1
Referrer      : 
IP Address    : 66.249.71.139
Username      : 
Classname     : vB_Database
MySQL Version :

ANY help would be REALLY appriciated.
thank you.

The 'Script' URL in the error message indicates me you are still using some Project Tools file. Please recheck all of your files if they are still existing.

Quote:

Originally Posted by simonhind

its nothing to do with that, its the install script for the database it just need a minor change

change all instances of

Code:

) TYPE=MyISAM;;

to

Code:

) ENGINE=MyISAM; ');

or from

Code:

) TYPE=MyISAM;;

to

Code:

) ');

once its reinstalled the product will work, then if uninstalled it will remove that same issue

AFAIK all database queries are already updated from TYPE to ENGINE. I'll recheck though.

Popa Andrei · #91 10-29-2012, 09:56 PM

if this will be updated to work on vbulletin 5 that will be awseome

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08043 seconds Memory Usage 2,383KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (13)bbcode_code (8)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (15)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (2)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

15 благодарности(ей) от:
Arkool, BCP Hung, beduino, Berndel, Christos Teriakis, erosolmi, KGodel, LoveStream, Mike-D, Muhammad Rahman, nacaruncr, private_ale, Teascu Dorin, Terminal-Access, Trangalleiro

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!