Recently i tried to upgrade my very old xhelp module and after some local tests i upgrade my big website to xhelp 0.8 (trabis).
I have no error in local but in the website with more than 13,000 users i found these errors:
1- in xhelp/checkemail.php
Fatal error: Call to a member function getVar() on a non-object in /home/**USER**/public_html/modules/xhelp/class/notificationService.php on line 712
2- in modules/xhelp/admin/staff.php?op=clearOrphanedStaff
I have a blank page and I found that it is because of these lines in staff.php:
function clearOrphanedStaff()
{
$hMember =& xoops_gethandler('member');
$hStaff =& xhelpGetHandler('staff');
$users =& $hMember->getUserList();
$staff =& $hStaff->getObjects();
I found that getUserList function should be used with a criteria when the total members are large.
3- in ticket.php i have these mysql errors:
0.000068 - SELECT * FROM xhelp_staffroles WHERE (deptid = '8' AND roleid IN ())
Error number: 1064
Error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1
0.000043 - SELECT * FROM xhelp_staff WHERE uid IN ()
Error number: 1064
Error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
which im sure it is not related to xhelp 0.8 because i had this error with 0.79 too
It seems it is also related to number of members but i need to know how can i fix this too?
thank you for your help.
I have 14 departments and 14 emails assign to them.
xoops version is 2.5.5
I hope trabis could find some time for this great module.
Edit (on 2012-05-22):
Today i tried to register at xuups.com and write these bugs in the authors website, but it seems there is an error in the website. i received these erros in registeration:
Sorry, you have to agree to our disclaimer to get registered.
ERROR: Invalid email
ERROR: Invalid Username
Username is too short. It must be more than 3 characters.
ERROR: You must provide a password.
Invalid confirmation code!