Thread: vBActivity and Project Tools Integration

After a tremendous amount of help and support from both @Dylan and @Belazor ... 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.

 0 Comment(s)

hi

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

Code:

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

Code:

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?

 0 Comment(s)

Originally Posted by baghdad4ever

hi

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

Code:

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

Code:

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.

 0 Comment(s)