Blank Page After I input SQL Info

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
blackops
Posts: 4
Joined: Mon Apr 07, 2008 8:48 am

Blank Page After I input SQL Info

Post by blackops »

I keep getting a blank page after I enter my sql info. Connection to the SQL server is fine. Did session test, that passed. I did get this error in my apache logs though. Have no idea what it means, also got an error saying the .js file wasnt in the install folder.

[Mon Apr 7 02:44:42 2008] [error] PHP Warning: require_once(inc/header.inc.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in /usr/local/www/data-dist/intts/production/inc/common.inc.php on line 356
[Mon Apr 7 02:44:42 2008] [error] PHP Fatal error: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'inc/header.inc.php' (include_path='.:') in /usr/local/www/data-dist/intts/production/inc/common.inc.php on line 356

Have any ideas?
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

Are you trying to enter MySQL user "root" without a password? If yes, try this (I don't recommend using root user though):
viewtopic.php?t=1816&highlight=root
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
blackops
Posts: 4
Joined: Mon Apr 07, 2008 8:48 am

Post by blackops »

Nope, I just have a standard user name and password i created within mysql. Hesk even has its own database on the server. It's really weird what could be causing this error?
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

Try with this install.php file (upload it to your "install" folder over the original one):
http://www.phpjunkyard.com/extras/install_noe.zip

Any luck?
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
blackops
Posts: 4
Joined: Mon Apr 07, 2008 8:48 am

Post by blackops »

Not yet, Now I actually get the error displayed as a page.


Warning: require_once(inc/header.inc.php) [function.require-once]: failed to open stream: No such file or directory in /usr/local/www/data-dist/intts/production/inc/common.inc.php on line 356

Fatal error: require_once() [function.require]: Failed opening required 'inc/header.inc.php' (include_path='.:/usr/local/include/php/main') in /usr/local/www/data-dist/intts/production/inc/common.inc.php on line 356

Still doesn't seem to want to go past step 4.
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

First try renaming install folder to something else and see if you can login to admin panel using default password admin (just in case tables DID install).

If that doesn't work rename the folder back to install, upload this file and see what it says:
http://www.phpjunkyard.com/extras/install_noe2.zip
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
blackops
Posts: 4
Joined: Mon Apr 07, 2008 8:48 am

Post by blackops »

Hey,

I tried all your suggestions and go this new error after installing that new install file.

Couldn't execute SQL: CREATE TABLE `hesk_attachments` ( `att_id` mediumint(8) unsigned NOT NULL auto_increment, `ticket_id` varchar(10) NOT NULL default '', `saved_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `size` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`att_id`), KEY `ticket_id` (`ticket_id`) ) ENGINE=MyISAM. Please make sure you delete any old installations of Hesk before installing this version!

I checked my databases and no tables where even created, this is really weird.
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

Try logging into your admin panel, does it work?

If not, can you try manually executing this code in your database (for example using phpMyAdmin) and see if you get any errors:

Code: Select all

CREATE TABLE `hesk_attachments` (
  `att_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ticket_id` varchar(10) NOT NULL default '',
  `saved_name` varchar(255) NOT NULL default '',
  `real_name` varchar(255) NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`att_id`),
  KEY `ticket_id` (`ticket_id`)
) ENGINE=MyISAM
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
r.meulendijks
Posts: 4
Joined: Thu Jul 10, 2008 7:39 pm

blank page after putting sql info in SOLVED

Post by r.meulendijks »

Look in your PHP.INI where the extension_path normaly is ./

this must be the path to your ext folder in the PHP installation

default : C:\Program Files\PHP\ext :wink:


restart IIS after changing this
Post Reply