Install did not work (to 2.3.0) -> uninstall failed!

[ong13]

Hi Mike,

I tried to install - it seemed to work, but my screen was blank.
I uploaded "/install" again and tried to uninstall MFH - this fails. I can't even "install" again - as there is no option (which version do you have installed).

I would revert to the no-MFH "by hand" but what SQL are you running to update the database for MFH? What would need to be removed?

Any idea how I could simply skip over the errors in the installatino process (alter table for examle fails because the table has been altered already in the previous trial).

I would like to simply install over an existing version - skipping all errors but continuing.

Olaf

[mkoch227]

If you look at the console, did an error display stating why the uninstall failed?

And all of the SQL used during uninstallation can be found at /install/mods-for-hesk/sql/uninstallSql.php. I recommend only running the sql between lines 63 and 80, replacing $hesk_settings['db_pfix'] with your database prefix. Once those are ran, go back to /install and click on "v1.3.0" to retry the install.

[OCReactive]

In my update to 2.3.0 the files corrupted my modsForHesk_settings.inc.php file, showing as well a blank web (in IE error 500).

I uploaded the original modsForHesk_settings.inc.php file without my modifications and it worked, so I checked my modsForHesk_settings.inc.php file and corrected the syntax to update again my modded file.

You could try that.

[ong13]

Hi Mike

thanks for the quick reply.

I was able to run the sql (needed some more work by hand) - but afterwards the script was able to upgrade from version 1.3.0 to the current as you proposed. No error.

But: Blank screen (FF, opera, IE tells me a 500 internal server error occurred). I did remove my german translation (just in case there is a bug) - same: blank. Maybe I am to quick an the server needs some time to notice the differences ....

Olaf

[mkoch227]

On your server, there is most likely an error_log file in the same folder as your helpdesk installation folder. Does it have an error in there?

[ong13]

Hi,

no, on the server I am working I unfortunately have no access to an error log.

Olaf

[ong13]

Hi

I can also repeat the procedure:
run this SQL (twice!), upload "/install" and run the insatllation - then ... blank.

Code: Select all

ALTER TABLE `hesk_users` DROP COLUMN `autorefresh`;
ALTER TABLE `hesk_tickets` DROP COLUMN `parent`;
ALTER TABLE `hesk_users` DROP COLUMN `can_manage_settings`;
ALTER TABLE `hesk_users` DROP COLUMN `active`;
ALTER TABLE `hesk_users` DROP COLUMN `notify_note_unassigned`;
ALTER TABLE `hesk_users` DROP COLUMN `can_change_notification_settings`;
DROP TABLE `hesk_settings`;
DROP TABLE `hesk_verified_emails`;
DROP TABLE `hesk_pending_verification_emails`;
DROP TABLE `hesk_stage_tickets`;
ALTER TABLE `hesk_service_messages` DROP COLUMN `icon`;
ALTER TABLE `hesk_tickets` DROP COLUMN `latitude`;
ALTER TABLE `hesk_tickets` DROP COLUMN `longitude`;
ALTER TABLE `hesk_stage_tickets` DROP COLUMN `latitude`;
ALTER TABLE `hesk_stage_tickets` DROP COLUMN `longitude`;
ALTER TABLE `hesk_categories` DROP COLUMN `manager`;
ALTER TABLE `hesk_users` DROP COLUMN `permission_template`;
DROP TABLE `hesk_permission_templates`;
DROP TABLE `hesk_denied_ips`;
DROP TABLE `hesk_denied_emails`;
DROP TABLE IF EXISTS `hesk_statuses`;
CREATE TABLE `hesk_statuses` (
  `ID` int(11) NOT NULL,
  `ShortNameContentKey` text NOT NULL,
  `TicketViewContentKey` text NOT NULL,
  `TextColor` text NOT NULL,
  `IsNewTicketStatus` bit(1) NOT NULL DEFAULT b'0',
  `IsClosed` bit(1) NOT NULL DEFAULT b'0',
  `IsClosedByClient` bit(1) NOT NULL DEFAULT b'0',
  `IsCustomerReplyStatus` bit(1) NOT NULL DEFAULT b'0',
  `IsStaffClosedOption` bit(1) NOT NULL DEFAULT b'0',
  `IsStaffReopenedStatus` bit(1) NOT NULL DEFAULT b'0',
  `IsDefaultStaffReplyStatus` bit(1) NOT NULL DEFAULT b'0',
  `LockedTicketStatus` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `hesk_statuses` (`ID`, `ShortNameContentKey`, `TicketViewContentKey`, `TextColor`, `IsNewTicketStatus`, `IsClosed`, `IsClosedByClient`, `IsCustomerReplyStatus`, `IsStaffClosedOption`, `IsStaffReopenedStatus`, `IsDefaultStaffReplyStatus`, `LockedTicketStatus`) VALUES
(0,	'open',	'open',	'#FF0000',	CONV('1', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0),
(1,	'wait_reply',	'wait_staff_reply',	'#FF9933',	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('1', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('1', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0),
(2,	'replied',	'wait_cust_reply',	'#0000FF',	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('1', 2, 10) + 0,	CONV('0', 2, 10) + 0),
(3,	'resolved',	'resolved',	'#008000',	CONV('0', 2, 10) + 0,	CONV('1', 2, 10) + 0,	CONV('1', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('1', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('1', 2, 10) + 0),
(4,	'in_progress',	'in_progress',	'#000000',	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0),
(5,	'on_hold',	'on_hold',	'#000000',	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0,	CONV('0', 2, 10) + 0);

Olaf

[mkoch227]

In my update to 2.3.0 the files corrupted my modsForHesk_settings.inc.php file, showing as well a blank web (in IE error 500).

I uploaded the original modsForHesk_settings.inc.php file without my modifications and it worked, so I checked my modsForHesk_settings.inc.php file and corrected the syntax to update again my modded file.

You could try that.

Olaf, check your modsForHesk_settings.inc.php file. There is a typo in the install sequence that results in a missing semicolon (;) on the last line. So, find:

Code: Select all

$modsForHesk_settings[\'request_location\'] = 0

and replace with

Code: Select all

$modsForHesk_settings[\'request_location\'] = 0;

[ong13]

Hi Mike,

what a real classic. Thank you very much. It's working after I added the semicolon.

Did you see my translation for 2.3.0 ( viewtopic.php?f=19&t=5361&p=23419#p23419 )

Olaf

[mkoch227]

Glad you got it working

And yes, I saw your translation. I'm currently at work at the moment so I can't upload now. Once I get a spare moment I will

[ong13]

Hi

take your time - I need to update again as I missed 2 versions .. I will upload asap.

Olaf