[PitchouneN64ngc]

Originally Posted by deadlySniper

I keep getting this error when I import

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?

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.

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:

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

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:

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.

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

) TYPE=MyISAM;;

to

) ENGINE=MyISAM; ');

or from

) TYPE=MyISAM;;

to

) ');

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.