Page 1 of 1

Undefined index: a in D:\web\hesk\index.php on line 43

Posted: Thu Apr 13, 2006 5:02 pm
by Jerry Hartzell
Script URL:
Version of script: 0.93.1
Version of PHP: 5.1.2
Hosting company: private intranet
Have you searched THIS FORUM for your problem: Yes, did not see anything regarding "Undefined Index ~

Methods tried: I have read postings regarding server_path and have tired all the methods that I found. The server is windows 2003 with the path of D:\web\hesk

The install went without issues with D:\web\hesk as the server path.

WHen I try to post a ticket I get the following error:
Can't execute SQL: INSERT INTO `hesk_tickets` ( `id`,`trackid`,`name`,`email`,`category`,`priority`,`subject`,`message`,`dt`,`ip`,`status` ) VALUES ( '','BXTLDZE4P7','Jerry','jhartzell@ecoinc.org','1','3','test','Stuff here',NOW(),'10.18.0.19','1' )

MySQL said:
Incorrect integer value: '' for column 'id' at row 1

Thank you for your time and effort in putting this script togeher.

Jerry

Posted: Thu Apr 13, 2006 5:15 pm
by Klemen

Post MySWL 5 patch

Posted: Thu Apr 13, 2006 5:39 pm
by Jerry Hartzell
I posted the files included in the patch adn recevied the folling with accessing the index.php.

PHP Warning: include_once(../../helpdesk/inc/header.txt) [function.include-once]: failed to open stream: No such file or directory in D:\web\hesk\inc\header.inc.php on line 42 PHP Warning: include_once() [function.include]: Failed opening '../../helpdesk/inc/header.txt' for inclusion (include_path='.;C:\php5\pear') in D:\web\hesk\inc\header.inc.php on line 42 PHP Notice: Undefined index: a in D:\web\hesk\index.php on line 43 PHP Notice: Undefined index: ../helpdesk/site_url in D:\web\hesk\index.php on line 177 PHP Warning: include_once(../../helpdesk/inc/footer.txt) [function.include-once]: failed to open stream: No such file or directory in D:\web\hesk\inc\footer.inc.php on line 32 PHP Warning: include_once() [function.include]: Failed opening '../../helpdesk/inc/footer.txt' for inclusion (include_path='.;C:\php5\pear') in D:\web\hesk\inc\footer.inc.php on line 32

I then deleted the database and reinstalled using the new files and had the same error returned.

Jerry

Posted: Fri Apr 14, 2006 10:47 am
by Klemen
Do you have the header.txt and footer.txt files in your Hesk folder?

Also what is your setting for debug mode in hesk_settings.inc.php? Try testing it with debug mode turned OFF.

Check files and debug setting

Posted: Mon May 01, 2006 2:41 pm
by Jerry Hartzell
Yes the header.txt and footer.txt files are in place. also Debus was set to '0". I changed to "1" and I reevied warning errors.
Warning: include_once(../../helpdesk/inc/header.txt) [function.include-once]: failed to open stream: No such file or directory in D:\web\hesk\inc\header.inc.php on line 42

Warning: include_once() [function.include]: Failed opening '../../helpdesk/inc/header.txt' for inclusion (include_path='.;C:\php5\pear') in D:\web\hesk\inc\header.inc.php on line 42

Warning: include_once(../../helpdesk/inc/footer.txt) [function.include-once]: failed to open stream: No such file or directory in D:\web\hesk\inc\footer.inc.php on line 32

Warning: include_once() [function.include]: Failed opening '../../helpdesk/inc/footer.txt' for inclusion (include_path='.;C:\php5\pear') in D:\web\hesk\inc\footer.inc.php on line 32

Jerry

GOT it

Posted: Mon May 01, 2006 2:57 pm
by Jerry Hartzell
I removed all path information in header.inc.php & footer.inc.php for both the header.txt and footer.txt and all is working fine.

Thank you for your assistance.

Jerry