| PitchouneN64ngc |
10-29-2012 09:19 PM |
Quote:
Originally Posted by deadlySniper
(Post 2366246)
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
(Post 2370398)
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
(Post 2370455)
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
(Post 2371134)
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
(Post 2371258)
its nothing to do with that, its the install script for the database it just need a minor change
change all instances of
to
Code:
) ENGINE=MyISAM; ');
or from
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. :) |
More Information