phphelpdesk-help

RE: [Phphelpdesk-help] I get some error when i added division in new user

[<rb...@vo...>]

I had the same problem when I first set up PHP Helpdesk.  Here is the
solution I got from a previous post. You should try reading through the
previous posts.  Usually they have solutions for most problems.

For those of us suffering with the error:

<snip>
>When I am adding a user, I select the available departments for the user
and
>hit Add.
>
>I get the following error.
>In this case I was adding a user called test and I chose one department.
>
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
>If I select multiple departments, I will get the same error repeated like
>so:
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
<snip>

Here is the answer:

Edit your adduser.scp.php file.

Look for a line that ends with ...userdepartments";
Add a space before the " so it reads
...userdepartments ";


-----Original Message-----
From: bw...@it... [mailto:bw...@it...]
Sent: Wednesday, January 30, 2002 9:38 PM
To: php...@li...
Subject: [Phphelpdesk-help] I get some error when i added division in
new user


Dear Sir ,

I try to view some sql statment but i can't solve the sql error problem .

So would you help me to fix sql error problem ??


SQL ERROR: You have an error in your SQL syntax near '='echeung'' at line 1

 <<SQL error.doc>> 
	

[Phphelpdesk-help] I get some error when i added division in new user

[<bw...@it...>]

Dear Sir ,

I try to view some sql statment but i can't solve the sql error problem .

So would you help me to fix sql error problem ??


SQL ERROR: You have an error in your SQL syntax near '='echeung'' at line 1

 <<SQL error.doc>> 
	

[Phphelpdesk-help] MySql error?

[Steve S. <st...@da...>]

Hi folks,

I'm having a little setup problem, hopefully someone can punt me in the 
right direction...

My setup is...  WinXP pro, IIS5, MySql3.23.47-nt, PHP 4.1.1

When I load up the main phphelpdesk page I get the following error showing 
up on the right hand side...

Executed SQL: SELECT events.e_id, events.t_id, events.e_status, 
events.e_assignedto, ticket.t_id FROM events,ticket WHERE events.t_id = 
ticket.t_id ORDER BY events.t_id, events.e_id; (35 rows affected.)
Open Tickets: 4
Assigned to you

otherwise the screen looks normal.  When I log in using Admin it gives a 
bunch more errors listed below...

Executed SQL: SELECT * FROM security WHERE s_user='admin' AND 
s_password='admin'; (1 rows affected.)

Executed SQL: SELECT d_name FROM userdepartments WHERE s_user='admin'; (3 
rows affected.)

Executed SQL: UPDATE security SET s_timestamp_laston='0201241257' WHERE 
s_user='admin'; (1 rows affected.)

Warning: Cannot add header information - headers already sent by (output 
started at c:\inetpub\wwwroot\includes\functions.inc.php:75) in 
c:\inetpub\wwwroot\includes\cookie.inc.php on line 8

Warning: Cannot add header information - headers already sent by (output 
started at c:\inetpub\wwwroot\includes\functions.inc.php:75) in 
c:\inetpub\wwwroot\includes\cookie.inc.php on line 9

Warning: Cannot add header information - headers already sent by (output 
started at c:\inetpub\wwwroot\includes\functions.inc.php:75) in 
c:\inetpub\wwwroot\includes\cookie.inc.php on line 10

Warning: Cannot add header information - headers already sent by (output 
started at c:\inetpub\wwwroot\includes\functions.inc.php:75) in 
c:\inetpub\wwwroot\includes\cookie.inc.php on line 11

Warning: Cannot add header information - headers already sent by (output 
started at c:\inetpub\wwwroot\includes\functions.inc.php:75) in 
c:\inetpub\wwwroot\includes\cookie.inc.php on line 12

Executed SQL: SELECT * FROM security WHERE s_user='admin'; (1 rows affected.)

Executed SQL: SELECT d_name FROM userdepartments WHERE s_user="admin" order 
by d_name; (3 rows affected.)

PHP appears to to functioning properly so I'm not sure if this is a MySql 
configuration error.

Any help would be appreciated
Thanks,

-- 
Steve
st...@da...

[Phphelpdesk-help] problems with mail

[Vicente M. <vm...@oc...>]

Hello I have modified the code of addjob.scp.php and now when I open a
ticket always send the email ap...@my...
<mailto:ap...@my...> . Is only when open a ticket and I want that
the message was sent by my...@my... <mailto:my...@my...> 
 
Thank
 
 

[Phphelpdesk-help] Re: PHPHelpdesk

[Joseph H. <jo...@jo...>]

the demo doesn't allow it, however, you can assign the "hr" user rights to
assign tickets.


----- Original Message -----
From: "Stefan Barry" <ste...@vi...>
To: <jo...@ne...>
Sent: Tuesday, January 15, 2002 1:03 PM
Subject: PHPHelpdesk


> Hi,
>
> I was wondering whether you could help me with PHPHelpdesk.
> I'm currently running PHPhelpdesk and I was wondering...
> how can I assign a request via department.
>
> i.e For example your demo, illustrates three different
> departments on the home page of PHPhelpdesk - if I select
> Human resources and complete the request form, how can I
> assign that request to a particular user?  Will an
> administrator or user have to assign themselves to the
> request or is it possible to automatically assign a
> particular request to a user?
>
> Any suggestions would be grately appreciated.
>
> Thanks,
> Stefan.
>
>

[Phphelpdesk-help] Pop Location.

[Mike M. <mme...@br...>]

We are looking at using this software for our Network Operations Center,
and being that I am a PHP/MySQL newbie I had a couple questions.

1. The Pop Location area in the new ticket submission. Is there a way to
add that to the database similar to the "Category" listing. (Without a
major rewrite of the database/software?) We want to administer the list of
names for the Pops being that each of the contacts we have for each
customer may call the same pop two diffrent things. :-)

2. I also wanted to see if there was a way to have e-mail sent out to a
default account "ANY"time a new ticket was entered.

3. Another question is concerning when updates are made to the tickets.
Is there a way to send notification each time a ticket is updated to keep
the customers informed of any changes. Even including when a ticket is
assigned and reassigned.

I appreceiate any and all help that you can give me! This software
rocks!!! Thanks!

------------------------------------------------------
Mike Mentges
Manager/Net-Admin
ComNet Network Operations Center
mailto:mme...@br...
"The airplane takes off against the wind not with it"
------------------------------------------------------

[Phphelpdesk-help] Problem with Adduser granting privilege

[V D. <kan...@ho...>]

<html><div style='background-color:'><DIV>Hi All,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I have problem in adding users. Well I am able to add the user but the privileges are not working. If I select just Register new tickets and view department tickets in the permission section. While loging with that newly added user, the options such as add jod, Modify user, delete user, delete department, preference, help and logout are displayed.</DIV>
<DIV>&nbsp;</DIV>
<DIV>So pls can anybody give me a solution to alter the privilege section?????</DIV>
<DIV>&nbsp;</DIV>
<DIV>Even a small help would be highly appreciated.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Regards</DIV>
<DIV>Durga.</DIV></div><br clear=all><hr>Chat with friends online, try MSN Messenger: <a href='http://go.msn.com/bql/hmtag1_etl_EN.asp'>Click Here</a><br></html>

[Phphelpdesk-help] Help Desk!

[Dave M. <da...@un...>]

Hello,

I installed phphelpdesk on my server but when i run it i get the =
following error:


SQL ERROR: Table 'phphelpdesku.events' doesn't exist

Warning: Supplied argument is not a valid MySQL result resource in =
/includes/functions.inc.php on line 26

Warning: Supplied argument is not a valid MySQL result resource in =
/includes/functions.inc.php on line 35
Open Tickets: 0
Assigned to you: 0


-------------------------------------------------------------------------=
----------------------------------

I really don't know what to change on the code can you please tell me =
what i'm doing wrong.


Thank you,


David Montalvo
Web Specialist
Unreal Studio
3 Buckskin La.
Selden, NY 11784
http://www.unrealstudio.com
da...@un...
Phone:516-848-0038
Fax:775-261-0944t

[Phphelpdesk-help] need help with the desk

[Shahid I. <sh...@cy...>]

Hi
i like your desk very much!!
I just like to know if i want to include the ticket number in the email =
that the system sends out to the user at the time of adding job, how can =
i do that?
Also, when adding jobs, i also would like to add the computer ID as =
well, how can i do that?
feel free to point me to files and code that i need to tweak.

thank

Re: [Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing

[Karl P. <fk...@gm...>]

Thanks for the config files. I checked both and didn't find any difference
between them. I tried downgrading, but I would have broken a couple
of dependencies. I'll give it another shot on the weekend.

Thanks

Karl

----- Original Message -----
From: "Andrew" <ajw...@ro...>
To: "Karl Paukner" <fk...@gm...>
Sent: Thursday, December 13, 2001 11:42 PM
Subject: Re: [Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing


> There is a config file for php, /etc/php.ini  ... Debian tends to
> be more security concious than Redhat, which I use, so maybe there
> is a setting in there that the Debian people have set differently
> than mine.  I'll attach my php.ini file so you can compare.  It's
> probably related to the error_reporting flag.
>
> If this solves it, please let me know, so I can add this to
> the documentation for other Debian users.
>
> Thanks;
> Andrew
>
>
>
>
> On Thursday 13 December 2001 02:31, Karl Paukner wrote:
> > I'm using Debian 3.0 Woody, msyql 3.23.43, PHP 4.1.0RC2.
> > I've got the feeling it could be php. I will try to downgrade.
> >
> > Thanks,
> >
> > Karl
> >
> > ----- Original Message -----
> > From: "Andrew" <ajw...@ro...>
> > To: "-fkp-" <fk...@gm...>
> > Sent: Thursday, December 13, 2001 3:30 AM
> > Subject: Re: [Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing
> >
> > > Karl;
> > >
> > > I'm not sure what the solution is at this point. but I'm curious, what
> > > operating system and what version of PHP are you using?  In the
> > > mean time I'll try and look into this problem.
> > >
> > > Andrew
> > >
> > > On Tuesday 11 December 2001 19:14, you wrote:
> > > > Hello, I just installed phphelpdesk and I'm getting the same error
msg
> > > >
> > > >    Fatal error: Cannot redeclare showsummary()
> > > >    in /www/devel/helpdesk/includes/functions.inc.php on line 61
> > > >
> > > > Is there a patch out or can somebody point me in the right
direction?
> > > >
> > > > TIA
> > > >
> > > > Karl
> > > >
> > > > ---------------------------
> > > > FROM: Andrew
> > > > DATE: 11/28/2001 17:15:53
> > > > SUBJECT: RE:  [Phphelpdesk-help] PHPHelpDesk and Debian Testing
> > > >
> > > > There is code in the functions script that prevents it from being
> >
> > included
> >
> > > > more than once .. Maybe the current CVS version is not what you
> > > > have installed .. Check your includes/functions.inc.php file .. The
> >
> > first
> >
> > > > few lines of my version look like this:
> > > >
> > > > <?php   // Global Functions
> > > >
> > > > if( isset( $FUNCTIONS ) ) {
> > > >     return;
> > > > }
> > > >
> > > > $FUNCTIONS=1;
> > > >
> > > >
> > > > These lines prevent the rest of the file from being imported more
than
> > > > once.
> > > >
> > > > I have a nagging suspicion that there are a lot of little bug fixes
> > > > like this
> > > > that are not in the most recent release .. I will talk to Joe, to
> >
> > project
> >
> > > > leader, and we will look into making a new release which includes
these
> > > > fixes.  Also, someone from the list says he will send me some
patches,
> >
> > so I
> >
> > > > would like to include those also.
> > > >
> > > > Hope this helps;
> > > > Andrew
> > > >
> > > > On Wednesday 28 November 2001 15:21, you wrote:
> > > > > Hello.  I am running PHPHelpDesk 0.6.16, installed on Debian Woody
> >
> > with
> >
> > > > > apache 1.3.19 and php4.0.5.  Everything was running smoothly until
I
> > > > > (foolishly, it turns out) updated to the following relevant
packages:
> > > > >
> > > > > apache-1.3.22-2
> > > > > apache-common-1.3.22-2
> > > > > apache-dev-1.3.22-2
> > > > > apache-perl-1.3.22-2
> > > > > libapache-dbi-perl-0.88-5
> > > > > libapache-request-perl-0.33-1
> > > > > libapache-session-perl-1.53-4
> > > > > libapache-mod-perl-1.26-1
> > > > > php4-4.0.100-1
> > > > > php4-cgi-4.0.100-1
> > > > > php4-mysql-4.0.100-1
> > > > > php4-pear-4.0.100-1
> > > > >
> > > > > After this, I started receiving "apache: PHP Fatal error:  Cannot
> > > >
> > > > redeclare
> > > >
> > > > > showsummary() in /var/www/helpdesk/includes/functions.inc.php on
line
> >
> > 61"
> >
> > > > > in my syslog.  It looks like php is barfing on
> >
> > includes/functions.inc.php
> >
> > > > > being included in most of the scripts in the system.  I seem to
have
> > > > > fixed my problem when I commented out
> > > > > "include("includes/functions.inc.php");"
> > > >
> > > > at
> > > >
> > > > > the top of each script that had it and added it to the top of
> >
> > index.php.
> >
> > > > > Now, I would believe this is a problem with the compile-time
options
> >
> > used
> >
> > > > > in the Debian packaging of PHP, but I'm wondering if there isn't a
> >
> > better
> >
> > > > > way to fix the problem than what I did.  Any suggestions?
> > > > >
> > > > > Oh, and by the way, this is an excellent piece of software!  We're
> >
> > using
> >
> > > > > this to replace the paper trouble ticket system that we've had in
> >
> > place
> >
> > > > > since we've been running.
> > > > >
> > > > > Edward Barrett
> > > >
> > > > _______________________________________________
> > > > Phphelpdesk-help mailing list
> > > > Php...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
>

Re: [Phphelpdesk-help] email server question

[Kevin M. S. <sh...@cg...>]

> 2. //$g_mailservername = "mail.servername.com";
> 3. //$g_mailservername = "192.168.123.100"; //IP address

> I've tried them all with no luck (well except no. 4). I am running Windows 2000 and IIS 5.

Number 2 or 3 should work. (preferablly #2)

Since your using windows, I have to ask:
Is your SMTP set to the proper outgoing machine in your php.ini file?
the value should be set like such 
SMTP = outgoing.mailserver.com

The default most likely looks like this:
------
[mail function]
; For Win32 only.
SMTP = localhost

------


This is typically the same machine you set your "outgoing SMTP" in outlook
or other mail client.

I hope this helps.


-k

RE: [Phphelpdesk-help] email server question

[Pim v. S. <pim...@gm...>]

Hi John,

Sending mail through a POP3 server is not possible. You must send it via a
SMTP mailserver. The server running phphelpdesk must be able to send mail
and need to know the smtp server it can send mail to.
In the configuration you give the name of the domain the mail is coming
from. It is used in the "From:" header field and nothing more. It does not
say anything about how to send mail. That is something the operating system
must be able to do.

Regards,

Pim van Stam


-----Oorspronkelijk bericht-----
Van: php...@li...
[mailto:php...@li...]Namens
JFe...@ao...
Verzonden: donderdag 13 december 2001 22:16
Aan: php...@li...
Onderwerp: [Phphelpdesk-help] email server question


What context do I use to email the tickets through my POP3 server? I know
how to edit the general.conf.php file; however, I'm not sure what it wants.
For
example:

1. //$g_mailservername = "http://mail.servername.com";
2. //$g_mailservername = "mail.servername.com";
3. //$g_mailservername = "192.168.123.100"; //IP address
4. //$g_mailservername = "please//helpme.iam.lost";

I've tried them all with no luck (well except no. 4). I am running Windows
2000 and IIS 5.

Thanks,
John

_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

[Phphelpdesk-help] email server question

[<JFe...@ao...>]

What context do I use to email the tickets through my POP3 server? I know how to edit the general.conf.php file; however, I'm not sure what it wants. For
example:

1. //$g_mailservername = "http://mail.servername.com";
2. //$g_mailservername = "mail.servername.com";
3. //$g_mailservername = "192.168.123.100"; //IP address
4. //$g_mailservername = "please//helpme.iam.lost";

I've tried them all with no luck (well except no. 4). I am running Windows 2000 and IIS 5.

Thanks,
John

Re: [Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing

[Karl P. <fk...@gm...>]

I'm using Debian 3.0 Woody, msyql 3.23.43, PHP 4.1.0RC2.
I've got the feeling it could be php. I will try to downgrade.

Thanks,

Karl

Andrew, sorry I replied to your email and not to the list.

----- Original Message -----
From: "Andrew" <ajw...@ro...>
To: "-fkp-" <fk...@gm...>
Sent: Thursday, December 13, 2001 3:30 AM
Subject: Re: [Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing


> Karl;
>
> I'm not sure what the solution is at this point. but I'm curious, what
> operating system and what version of PHP are you using?  In the
> mean time I'll try and look into this problem.
>
> Andrew
>
>
>
> On Tuesday 11 December 2001 19:14, you wrote:
> > Hello, I just installed phphelpdesk and I'm getting the same error msg
> >
> >    Fatal error: Cannot redeclare showsummary()
> >    in /www/devel/helpdesk/includes/functions.inc.php on line 61
> >
> > Is there a patch out or can somebody point me in the right direction?
> >
> > TIA
> >
> > Karl
> >
> > ---------------------------
> > FROM: Andrew
> > DATE: 11/28/2001 17:15:53
> > SUBJECT: RE:  [Phphelpdesk-help] PHPHelpDesk and Debian Testing
> >
> > There is code in the functions script that prevents it from being
included
> > more than once .. Maybe the current CVS version is not what you
> > have installed .. Check your includes/functions.inc.php file .. The
first
> > few lines of my version look like this:
> >
> > <?php   // Global Functions
> >
> > if( isset( $FUNCTIONS ) ) {
> >     return;
> > }
> >
> > $FUNCTIONS=1;
> >
> >
> > These lines prevent the rest of the file from being imported more than
> > once.
> >
> > I have a nagging suspicion that there are a lot of little bug fixes like
> > this
> > that are not in the most recent release .. I will talk to Joe, to
project
> > leader, and we will look into making a new release which includes these
> > fixes.  Also, someone from the list says he will send me some patches,
so I
> > would like to include those also.
> >
> > Hope this helps;
> > Andrew
> >
> > On Wednesday 28 November 2001 15:21, you wrote:
> > > Hello.  I am running PHPHelpDesk 0.6.16, installed on Debian Woody
with
> > > apache 1.3.19 and php4.0.5.  Everything was running smoothly until I
> > > (foolishly, it turns out) updated to the following relevant packages:
> > >
> > > apache-1.3.22-2
> > > apache-common-1.3.22-2
> > > apache-dev-1.3.22-2
> > > apache-perl-1.3.22-2
> > > libapache-dbi-perl-0.88-5
> > > libapache-request-perl-0.33-1
> > > libapache-session-perl-1.53-4
> > > libapache-mod-perl-1.26-1
> > > php4-4.0.100-1
> > > php4-cgi-4.0.100-1
> > > php4-mysql-4.0.100-1
> > > php4-pear-4.0.100-1
> > >
> > > After this, I started receiving "apache: PHP Fatal error:  Cannot
> >
> > redeclare
> >
> > > showsummary() in /var/www/helpdesk/includes/functions.inc.php on line
61"
> > > in my syslog.  It looks like php is barfing on
includes/functions.inc.php
> > > being included in most of the scripts in the system.  I seem to have
> > > fixed my problem when I commented out
> > > "include("includes/functions.inc.php");"
> >
> > at
> >
> > > the top of each script that had it and added it to the top of
index.php.
> > > Now, I would believe this is a problem with the compile-time options
used
> > > in the Debian packaging of PHP, but I'm wondering if there isn't a
better
> > > way to fix the problem than what I did.  Any suggestions?
> > >
> > > Oh, and by the way, this is an excellent piece of software!  We're
using
> > > this to replace the paper trouble ticket system that we've had in
place
> > > since we've been running.
> > >
> > > Edward Barrett
> >
> > _______________________________________________
> > Phphelpdesk-help mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
>

Re: [Phphelpdesk-help] RE: Phphelpdesk and Debian Testing

[Karl P. <fk...@gm...>]

Thanks for your reply. The lines are in functions.inc.php.
Is there anything else I can check?

THX

Karl

----- Original Message ----- 
From: "Mark E. Nottage" <mno...@po...>
To: <php...@li...>
Sent: Wednesday, December 12, 2001 9:05 PM
Subject: [Phphelpdesk-help] RE: Phphelpdesk and Debian Testing


As Andrew commented previously:

--------------------------------------------------------
Check your includes/functions.inc.php file .. The first
few lines of my version look like this:

<?php   // Global Functions

if( isset( $FUNCTIONS ) ) {
    return;
}

$FUNCTIONS=1;

--------------------------------------------------------

Did you do that?

MN

_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

[Phphelpdesk-help] RE: Phphelpdesk and Debian Testing

[Mark E. N. <mno...@po...>]

As Andrew commented previously:

--------------------------------------------------------
Check your includes/functions.inc.php file .. The first
few lines of my version look like this:

<?php   // Global Functions

if( isset( $FUNCTIONS ) ) {
    return;
}

$FUNCTIONS=3D1;

--------------------------------------------------------

Did you do that?

MN

RE: [Phphelpdesk-help] Database Schema Documentation?

[Pim v. S. <pim...@nl...>]

 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Roy,

The "documentation" is in the installation root in "empty.mysql".
This scripts builds the database on installation.
It gives an overview of the structure of the database.

With regards,

Pim van Stam

> -----Oorspronkelijk bericht-----
> Van: php...@li...
> [mailto:php...@li...]Namens 
> Roy Rapoport
> Verzonden: dinsdag 11 december 2001 10:49
> Aan: php...@li...
> Onderwerp: [Phphelpdesk-help] Database Schema Documentation?
> 
> 
> 
> Howdy, folks.
> 
> I must be missing it due to the late night, but can anyone 
> point me in the
> direction of the documentation of how the database is laid 
> out and what
> each table is used for? I'm assuming there's a more succinct 
> version of
> this documentation than "pore through the sourcecode"? :)
> 
> This relates to a question:  We're using PHPH to track time spent
> for clients.  Pursuant to this, I need to have a report that 
> shows me, between
> any given two dates, how much time each person's spent on a 
> given company.
> That report does not currently seem to exist, right? I'm 
> happy to create
> it, assuming I'm not recreating the wheel :)
> 
> -roy
> 
> 
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

-----BEGIN PGP SIGNATURE-----
Version: PGP 7.0.4

iQA/AwUBPBdk+Y5pIpBZNFf7EQIkLQCeMfnXLIu31AGSSL7oPT9jh/8D/QsAoLJf
9QFJjb7WY/xj/EvMGJQZYGoQ
=BTfR
-----END PGP SIGNATURE-----

Re: [Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing

[Karl P. <fk...@gm...>]

I maybe should mention that I'm using the stable release and cvs with
the same results.

Karl

----- Original Message ----- 
From: "-fkp-" <fk...@gm...>
To: <php...@li...>
Sent: Wednesday, December 12, 2001 12:14 AM
Subject: [Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing


> Hello, I just installed phphelpdesk and I'm getting the same error msg
> 
>    Fatal error: Cannot redeclare showsummary()
>    in /www/devel/helpdesk/includes/functions.inc.php on line 61
> 
> Is there a patch out or can somebody point me in the right direction?
> 
> TIA
> 
> Karl

[Phphelpdesk-help] Re: PHPHelpDesk and Debian Testing

[-fkp- <fk...@gm...>]

Hello, I just installed phphelpdesk and I'm getting the same error msg

   Fatal error: Cannot redeclare showsummary()
   in /www/devel/helpdesk/includes/functions.inc.php on line 61

Is there a patch out or can somebody point me in the right direction?

TIA

Karl

---------------------------
FROM: Andrew
DATE: 11/28/2001 17:15:53
SUBJECT: RE:  [Phphelpdesk-help] PHPHelpDesk and Debian Testing

There is code in the functions script that prevents it from being included
more than once .. Maybe the current CVS version is not what you
have installed .. Check your includes/functions.inc.php file .. The first
few lines of my version look like this:

<?php   // Global Functions

if( isset( $FUNCTIONS ) ) {
    return;
}

$FUNCTIONS=1;


These lines prevent the rest of the file from being imported more than once.

I have a nagging suspicion that there are a lot of little bug fixes like
this
that are not in the most recent release .. I will talk to Joe, to project
leader, and we will look into making a new release which includes these
fixes.  Also, someone from the list says he will send me some patches, so I
would like to include those also.

Hope this helps;
Andrew



On Wednesday 28 November 2001 15:21, you wrote:
> Hello.  I am running PHPHelpDesk 0.6.16, installed on Debian Woody with
> apache 1.3.19 and php4.0.5.  Everything was running smoothly until I
> (foolishly, it turns out) updated to the following relevant packages:
>
> apache-1.3.22-2
> apache-common-1.3.22-2
> apache-dev-1.3.22-2
> apache-perl-1.3.22-2
> libapache-dbi-perl-0.88-5
> libapache-request-perl-0.33-1
> libapache-session-perl-1.53-4
> libapache-mod-perl-1.26-1
> php4-4.0.100-1
> php4-cgi-4.0.100-1
> php4-mysql-4.0.100-1
> php4-pear-4.0.100-1
>
> After this, I started receiving "apache: PHP Fatal error:  Cannot
redeclare
> showsummary() in /var/www/helpdesk/includes/functions.inc.php on line 61"
> in my syslog.  It looks like php is barfing on includes/functions.inc.php
> being included in most of the scripts in the system.  I seem to have fixed
> my problem when I commented out "include("includes/functions.inc.php");"
at
> the top of each script that had it and added it to the top of index.php.
> Now, I would believe this is a problem with the compile-time options used
> in the Debian packaging of PHP, but I'm wondering if there isn't a better
> way to fix the problem than what I did.  Any suggestions?
>
> Oh, and by the way, this is an excellent piece of software!  We're using
> this to replace the paper trouble ticket system that we've had in place
> since we've been running.
>
> Edward Barrett

[Phphelpdesk-help] Database Schema Documentation?

[Roy R. <rs...@ae...>]

Howdy, folks.

I must be missing it due to the late night, but can anyone point me in the
direction of the documentation of how the database is laid out and what
each table is used for? I'm assuming there's a more succinct version of
this documentation than "pore through the sourcecode"? :)

This relates to a question:  We're using PHPH to track time spent for
clients.  Pursuant to this, I need to have a report that shows me, between
any given two dates, how much time each person's spent on a given company.
That report does not currently seem to exist, right? I'm happy to create
it, assuming I'm not recreating the wheel :)

-roy

Re: [Phphelpdesk-help] customize addjob

[Ed B. <eba...@ta...>]

I cut'n'pasted something similar into my addjob.scp.php and vj_closejob.scp=
.php files to give me this functionality.  if you replace

$mailto =3D "$t_useremail";

with=20

$mailto =3D getuseremailaddress($Company);

and you've set each school's/department's email address to the principal's =
email address, it should do what you want.  The getuseremailaddress() =
function is below.  I'm a PHP/MySQL newbie, so it's probably not the =
fastest way to do it, but it works for me.

Edward Barrett

-- start of getuseremailaddress() --
function getuseremailaddress($ticketdept) {
        $querydeptintname =3D "SELECT s_user from userdepartments ";      =
// This gets me
        $querydeptintname .=3D "WHERE d_name=3D'$ticketdept' ORDER BY =
s_user;";     // Internal name of group so I can find email in next query
        $mysql_result =3D query($querydeptintname);
        $row =3D mysql_fetch_array($mysql_result);
        $queryemail =3D "SELECT s_email from security "; // This gets me
        $queryemail .=3D "WHERE s_user=3D'$row[0]';";      // The email of =
the group
        $mysql_result =3D query($queryemail);
        $row =3D mysql_fetch_array($mysql_result);
        $email =3D $row[0];
        return $email;
}
-- end of getuseremailaddress() --
>>> <JFe...@ao...> 12/08/01 03:16PM >>>
Hello,
  I work for a medium sized school system and I am trying to customize =
phphelpdesk to better suit our needs. I have setup my departments to =
represent each school. I would like to automatically send an email to each =
principal of the school/department whenever a ticket is opened for thier =
school. I don't want this to be a user available option. Just something =
that happens behind the scenes. Here's what I've done so far:
--snip--

--
F. Edward Barrett
Network Specialist, Traverse Area District Library
http://tadl.tcnet.org

[Phphelpdesk-help] customize addjob

[<JFe...@ao...>]

Hello,
  I work for a medium sized school system and I am trying to customize phphelpdesk to better suit our needs. I have setup my departments to represent each school. I would like to automatically send an email to each principal of the school/department whenever a ticket is opened for thier school. I don't want this to be a user available option. Just something that happens behind the scenes. Here's what I've done so far:

1. Bought a PHP book

2. Created a column called " t_adminemail " in the TABLE " ticket " inside my database. It is indentical to the " t_useremail " used in the file addjob.scp.php

3. What I need to know now is how to write a statement that is something like this: 

IF $l_deparmtent = Jones High School, THEN $mailto=pri...@jo...

IF $l_deparmtent = Smith Elementary School, THEN $mailto=pri...@sm...

See what I'm trying to do? I'm very new to PHP so any help is greatly appreciated. Please remember to reply in newbie language since I'm not a programmer by default. 

I also want to Thank everyone who has helped to create this terrific tool. Our school's are not wealthy and a free option was our only hope. Thank you very much!

Sincerely,
John Ferrell

Re: [Phphelpdesk-help] upload in phphelpdesk

[alister a. <ali...@ut...>]

At 06:43 AM 12/7/2001, a.a...@re... wrote:


>you must create a directory files in phphelpdesk with chmod 777

You *never* want to do this.  That's a really bad thing to do, as it means 
the files on your system can be modified by anyone with a login to your 
system.  644 for files and 755 for directories is always enough.  644 means 
owner can read and write, group and everyone else can only read.  755 means 
owner can read, write, and execute, everyone else can read and execute.  If 
you are using groups, you might use 664 for files and 775 for directories, 
but 777 is definitely wrong - it is a gaping hole to give these rights 
anywhere on your system that you remotely care about.

Regards,

Alister


>you must create a field in table events :  e_file with varchar 30 and null
>
>delete your upload.php or not
>
>copy   vj_showticket.scp.php,  vj_upload.scp.php  and  viewjobs.scp.php to 
>phphelpdesk/scripts
>
>
>in vj_upload.scp.php at line 9,  set the path of your 
>web         (  /usr/local/httpd/htdocs/phphelpdesk/files )
>
>thats all.
>
>sorry for my bad english ;-)
>
>
>my email: <https://sourceforge.net/sendmessage.php?touser=395241>adelineas 
>at users.sourceforge.net
>
>
>
>
>
>Andreas Assenmacher
>Dümmen GmbH & Co. KG
>Systemadministrator
>(+49) 2843 92 99 63
>
>CONFIDENTIALITY NOTICE
>This mail contains information which is confidential and may also be
>privileged. It is for exclusive use of the intended recipient(s). If you are
>not the intended recipient(s), please note that any distribution, copying or
>use of this mail or the information in it is strictly prohibited.
>If you have received this mail in error, please notify us immediately by 
>phone on
>+49 (0)2843 9299 - 63 and then destroy this mail and any copies of it.
>Thank you!


--

Alister Air          Ph 9514 1277
IT Manager           Fx 9514 1656
Faculty of Science, University of Technology Sydney

"I will never apologise for the United States of America.
I don't care what the facts are." George H Bush, 1988,
after the U.S. warship Vincennes shot down an Iranian
airliner in a commercial corridor, killing 290 civilians.

[Phphelpdesk-help] Mysql definition

[<HCD...@sm...>]

Hi,

I really find your software to be interesting especially it conforms with a
requirement to keep track of problem escalation more efficiently.  I already
installed and configure apache-php and mysql, notice that you don't have any
details on the database especially on how many tables to be created, what
are the variables to be included, and so more. My concern on what will be
the data structure that will be used on this software.


Hope for your response.


Regards. 




______________________________________ 
The information transmitted through this mail is intended solely for the
addressee and may be legally privileged. Any disclosure, copying,
dissemination or any action taken or omitted, to be taken in reliance on it,
by persons or entities other than the intended recipient is prohibited. 
Smart Communications, Inc.
http://www.smart.com.ph

[Phphelpdesk-help] Netscape

[Micheal P. <mi...@ca...>]

Has there been any updates/fixes to allow Netscape to view the jobs?

--

Micheal Patterson
Network Administration
Cancer Care Network