1
wadew
xhelp 0.78
  • 2010/3/1 14:44

  • wadew

  • Just popping in

  • Posts: 2

  • Since: 2010/3/1 1


System Overview - XOOPS 2.4.4
php version - 5.3.0
MySQL - 5.1.36-community

When I try to view a ticket as just a registered user - I get this error message:
0.012123 SELECT t.*, (UNIX_TIMESTAMP() - t.posted) as elapsed, (UNIX_TIMESTAMP() - t.lastUpdated) as lastUpdate FROM xhelp_tickets t INNER JOIN xhelp_status s ON t.status s.id WHERE (t.id IN () AND t.status IN (1,2))
Error number1064
Error message
You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ') AND t.status IN (1,2))' at line 2


Any ideas?

2
Burning
Re: xhelp 0.78
  • 2010/3/1 15:00

  • Burning

  • Theme Designer

  • Posts: 1163

  • Since: 2006/8/22


hi'

Have you tried XHelp version updated by Spanish community ?
Download link

3
wadew
Re: xhelp 0.78
  • 2010/3/1 15:14

  • wadew

  • Just popping in

  • Posts: 2

  • Since: 2010/3/1 1


I sure did - I get the same error and it messes up the header "Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\modules\xhelp\index.php on line ###"
about 100 times.

So that didn't work.

4
aixos
Re: xhelp 0.78
  • 2010/3/18 17:26

  • aixos

  • Just popping in

  • Posts: 79

  • Since: 2004/12/31


Hi,

version is to xhelp 0.79

not work in PHP 5.3.0

work in

Quote:

Versión de XOOPS XOOPS 2.4.4

Versión de PHP 5.2.13

Versión de mySQL 5.1.41

5
aixos
Xhelp 0.79 ES Utf8 with grafics jpgraph
  • 2010/3/20 9:35

  • aixos

  • Just popping in

  • Posts: 79

  • Since: 2004/12/31


Hi,

Download link:
Xhelp 0.79 ES Utf8 with grafics jpgraph

Works in XOOPS 2.4.4 well
by Spanish community

6
Anonymous
Re: xhelp 0.78
  • 2010/6/3 12:09

  • Anonymous

  • Posts: 0

  • Since:


During testing Xhelp 0.79 ES Utf8 with grafics jpgraph with:
Apache version 2.2.14
PHP version 5.3.1
MySQL version 5.0.90-community

I got this error when access to modules/xhelp/index.php?op=staffViewAll :

0.000036 - SELECT * FROM `users` 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



7
ghia
Re: xhelp 0.78
  • 2010/6/3 13:30

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Did you assign staff members?

8
btesec
Re: xhelp 0.78
  • 2010/6/3 22:10

  • btesec

  • Friend of XOOPS

  • Posts: 623

  • Since: 2007/2/20


I think what is meant is that a user should be able to assign/select a user name To whom the ticket is intended for, instead of assigning a ticket to a department. I think it should be enabled so it provides flexibility for end users, probably at the admin side so admins can choose which option to provide ie. either Department or a username and/or both so user can choose to assign a ticket to a user or a department.

9
ghia
Re: xhelp 0.78
  • 2010/6/3 22:58

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


I think most times users are not aware of the staff members in a department. But they know their problem is eg for facturation. All staff members or department leader get the incoming request and can then assign the problem to the member that is best fit or has most time to resolve it. From then on replies go directly to the staff member.

10
Anonymous
Re: xhelp 0.78
  • 2010/6/5 22:54

  • Anonymous

  • Posts: 0

  • Since:


in xhelp 0.79 we need to update the db from modules/xhelp/admin/upgrade.php?op=checkTables

This is may fix some errors.

Login

Who's Online

248 user(s) are online (145 user(s) are browsing Support Forums)


Members: 0


Guests: 248


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits