Install Will Not Create MySql Table.....Again....Sorry

[rubys2u@gmail.com]

Script URL: http://rubyimage.com/rids/support/install/install.php
Version of script: 0.94.1 @ October 25, 2007
Hosting company: AIT
URL of phpinfo.php: http://rubyimage.com/rids/support/phpinfo.php
URL of session_test.php: http://rubyimage.com/rids/support/sessi ... n_test.php
What terms did you try when SEARCHING for a solution: database, tables, MySQL

Write your message below:

I know you're about tired of this same issue and I promise I tried all the fixes I could find in the forum but the script will just not create the tables in MySQL. I started with the blank screen issue after step 3 and went from there....

I tried the following:

Downloaded and tried all the suggestions related to:
install_debug
install_noe
install_noe2
hesk_root_mysql

I also deleted lines relate to [pass] in the install.php and the hesk_settings.inc.php . That got me closer to anything else where it finally connected to my database but still does not create tables. I get this:

Checking link...OK, db_success is: 1
Selecting database...DONE, db_success is: 1
Checking existing tables...DONE, tables_exist is 0
Saving settings...OK
Installing tables...

Then it goes no further. Ack! I would really like this to work. I'll buy ya a beer!!!!!!

[Klemen]

Strange. Can you try manually executing this SQL code in phpMyAdmin?

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;

CREATE TABLE `hesk_categories` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `cat_order` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

INSERT INTO `hesk_categories` VALUES (1, 'Default', 10);

CREATE TABLE `hesk_replies` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `replyto` varchar(10) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `message` text NOT NULL,
  `dt` datetime default NULL,
  `attachments` text,
  PRIMARY KEY  (`id`),
  KEY `replyto` (`replyto`)
) TYPE=MyISAM;

CREATE TABLE `hesk_std_replies` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(70) NOT NULL default '',
  `message` text NOT NULL,
  `reply_order` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `hesk_tickets` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `trackid` varchar(10) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `category` smallint(5) unsigned NOT NULL default '1',
  `priority` enum('1','2','3') NOT NULL default '3',
  `subject` varchar(70) NOT NULL default '',
  `message` text NOT NULL,
  `dt` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastchange` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(20) NOT NULL default '',
  `status` enum('0','1','2','3') default '1',
  `lastreplier` enum('0','1') NOT NULL default '0',
  `archive` enum('0','1') NOT NULL default '0',
  `attachments` text,
  `custom1` varchar(255) NOT NULL default '',
  `custom2` varchar(255) NOT NULL default '',
  `custom3` varchar(255) NOT NULL default '',
  `custom4` varchar(255) NOT NULL default '',
  `custom5` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `trackid` (`trackid`),
  KEY `archive` (`archive`)
) TYPE=MyISAM;

CREATE TABLE `hesk_users` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `user` varchar(20) NOT NULL default '',
  `pass` varchar(20) NOT NULL default '',
  `isadmin` char(1) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `signature` varchar(255) NOT NULL default '',
  `categories` varchar(255) NOT NULL default '',
  `notify` char(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

INSERT INTO `hesk_users` VALUES (1, 'Administrator', 'admin', '1', 'Your name', 'you@yourwebsite.com', 'Best regards,\r\n\r\nYour name\r\nYour website\r\nhttp://www.yourwebsite.com', '', '1');

Then delete install folder and see if it works.