PHPJunkyard support forum

grueter6 wrote:thanks for the help!

Error:
IF EXISTS (SELECT 1 FROM syscolumns WHERE id = object_id('hesk_users') AND name='autorefresh') ALTER TABLE `hesk_users` DROP COLUMN `autorefresh`;

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS (SELECT 1 FROM syscolumns WHERE id = object_id('hesk_users') AND name=' at line 1

If I have "No previous version" in stating the error appears:
Warning: Cannot modify header information - headers already sent by (output started at ......../install/install_functions.inc.php:628) in ........./install/freshInstall.php on line 51

I have now manually called every installer now works the login

confignsk wrote:Hesk 2.5.5
1.6.1 Mods

Problem: When you add an attachment, the images become just a gray background, and zip files when unpacking an error.

The original 2.5.5, does not break the attachment.
Tell me what's the problem?

confignsk wrote:On a freshly installed 2.5.5, installed mods 1.7

selected conditions: No previous version

when creating a new ticket, gets results:

Error:

Can't execute SQL
Please notify webmaster at support@domain.com

mkoch227 wrote:Turn on debug mode, run it again, and send me the full error that appears

Error:

Can't execute SQL: SELECT * FROM `hesk_denied_ips` WHERE `RangeStart` <= '1421990099' AND `RangeEnd` >= '1421990099'
MySQL said:
Table 'garantia_hesk405.hesk_denied_ips' doesn't exist

Error: Your account is currently inactive. Contact an administrator for more information.

vbdesign wrote: MySQL said:
Table 'garantia_hesk405.hesk_denied_ips' doesn't exist

confignsk wrote:key 'statuses' doesn't exist in table 'hesk_tickets'

confignsk wrote:When you install a custom date field, on the client side, after the date of the field, there is nothing. As if on this site ended.

And still attached files, files or images are downloaded, but not open. But if these files are downloaded from the ftp, they work great.

It turns out, the problem is when to pull through the page.

mkoch227 wrote: I can reproduce the date issue on my side and will look into a fix shortly. For the attached files, I am able to download the file without any problems. Is this a file attached to a ticket or a note? Is this on the staff side, or on the client side? Also, what file type are you attaching? (I tested with a .docx file)

confignsk wrote: Files problem
dead attachments
http://zakaz.atlantokna.ru/ticket.php?t ... =32456&f=1

daggas66 wrote:I'm having trouble installing v1.7.0 on HESK 2.5.5.
Clean install of HESK then when installing Mods (no previous version) I get the following debug error...

Error:

Can't execute SQL: CREATE TABLE `tcs1_statuses` ( `ID` INT NOT NULL, `ShortNameContentKey` TEXT NOT NULL, `TicketViewContentKey` TEXT NOT NULL, `TextColor` TEXT NOT NULL, `IsNewTicketStatus` BIT NOT NULL DEFAULT 0, `IsClosed` BIT NOT NULL DEFAULT 0, `IsClosedByClient` BIT NOT NULL DEFAULT 0, `IsCustomerReplyStatus` BIT NOT NULL DEFAULT 0, `IsStaffClosedOption` BIT NOT NULL DEFAULT 0, `IsStaffReopenedStatus` BIT NOT NULL DEFAULT 0, `IsDefaultStaffReplyStatus` BIT NOT NULL DEFAULT 0, `LockedTicketStatus` BIT NOT NULL DEFAULT 0, PRIMARY KEY (`ID`))
MySQL said:
Table 'tcs1_statuses' already exists


I've obviously done something wrong during installation if the tables already exist.

DROP TABLE `tcs1_statuses`;
ALTER TABLE `tcs1_users` DROP COLUMN `autorefresh`;
DROP TABLE `tcs1_denied_ips`;
DROP TABLE `tcs1_denied_emails`;
ALTER TABLE `tcs1_tickets` DROP COLUMN `parent`;
ALTER TABLE `tcs1_users` DROP COLUMN `active`;
ALTER TABLE `tcs1_users` DROP COLUMN `can_manage_settings`;
ALTER TABLE `tcs1_users` DROP COLUMN `default_notify_customer_email`;
ALTER TABLE `tcs1_users` DROP COLUMN `notify_note_unassigned`;
ALTER TABLE `tcs1_users` DROP COLUMN `can_change_notification_settings`;
ALTER TABLE `tcs1_notes` DROP COLUMN `edit_note`;
ALTER TABLE `tcs1_notes` DROP COLUMN `number_of_edits`;
ALTER TABLE `tcs1_attachments` DROP COULUMN `note_id`;
DROP TABLE `tcs1_settings`;
DROP TABLE `tcs1_verified_emails`;
DROP TABLE `tcs1_pending_verification_emails`;
DROP TABLE `tcs1_stage_tickets`;