Question vBActivity and Project Tools Integration

[Mokonzi]

After a tremendous amount of help and support from both Dylan and Fillip H.... I've managed to work out the way of integrating Project Tools into vBActivity.

I believe I've worked out all the bugs and issues I initially had, but please test this on your test board first, and only install after having backed up your database before hand and double checking that it works before setting your board to live.

Any feedback or suggestions would be appreciated.

 

[baghdad4ever]

hi

i install it and i get it work but when i reply i get this error

SELECT COUNT(quiz_id) AS issue_reply
                FROM pt_issuenote
                WHERE userid = 1 && isfirstnote = '0';

MySQL Error   : Unknown column 'quiz_id' in 'field list'
Error Number  : 1054

and this

Invalid SQL:

                SELECT COUNT(taken_id) AS issue_created
                FROM pt_issue
                WHERE submituserid = 64506;

MySQL Error   : Unknown column 'taken_id' in 'field list'
Error Number  : 1054

how to fix this plz?

 

[Mokonzi]

hi

i install it and i get it work but when i reply i get this error

SELECT COUNT(quiz_id) AS issue_reply
                FROM pt_issuenote
                WHERE userid = 1 && isfirstnote = '0';

MySQL Error   : Unknown column 'quiz_id' in 'field list'
Error Number  : 1054

and this

Invalid SQL:

                SELECT COUNT(taken_id) AS issue_created
                FROM pt_issue
                WHERE submituserid = 64506;

MySQL Error   : Unknown column 'taken_id' in 'field list'
Error Number  : 1054

how to fix this plz?

I'm not getting these errors on my install. What versions of Project Tools are you using? The errors there look more like they are to do with vBQuiz than with the integration.