Email Verifications

[xyzzy]

HESK version: 2.7.2 - HESK is up to date
Mods for HESK Version: 3.0.1 - Mods for HESK is up to date
PHP version: 5.4.45 (MySQLi)
MySQL version: 5.5.51-38.2

When i enable the Customer Email Verifications
Require customers to verify email option, i do get the msg at addig new ticket:
Error: Can't execute SQL Please notify webmaster
Is that any known issue or need somehow info that i can provide ?

[mkoch227]

Turn on debug mode in your helpdesk settings, and then try again. You'll still get an error, but the failing SQL query will appear on-screen. Copy and paste the error here.

[xyzzy]

hi mike

Error:

Can't execute SQL: INSERT INTO `lihelpdesk_stage_tickets` ( `trackid`, `name`, `email`, `category`, `priority`, `subject`, `message`, `dt`, `lastchange`, `articles`, `ip`, `language`, `openedby`, `owner`, `attachments`, `merged`, `status`, `latitude`, `longitude`, `html`, `user_agent`, `screen_resolution_height`, `screen_resolution_width`, `due_date`, `history` , `custom1`, `custom2`, `custom3`, `custom4`, `custom5`, `custom6`, `custom7`, `custom8`, `custom9`, `custom10`, `custom11`, `custom12`, `custom13`, `custom14`, `custom15`, `custom16`, `custom17`, `custom18`, `custom19`, `custom20`, `custom21`, `custom22`, `custom23`, `custom24`, `custom25`, `custom26`, `custom27`, `custom28`, `custom29`, `custom30`, `custom31`, `custom32`, `custom33`, `custom34`, `custom35`, `custom36`, `custom37`, `custom38`, `custom39`, `custom40`, `custom41`, `custom42`, `custom43`, `custom44`, `custom45`, `custom46`, `custom47`, `custom48`, `custom49`, `custom50` ) VALUES ( 'QY9-LVR-ZZW1', 'test3', 'testing@gmail.com', '1', '3', 'ewf', '<p>eewf</p>', NOW(), NOW(), NULL, '91.93.54.175', 'English', '0', '0', '', '', '0', 'E-0', 'E-0', '1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36', 1080, 1920, NULL, '
2017-01-06 18:15:51 | submitted by test3
' , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )
MySQL said:
Unknown column 'custom21' in 'field list'

[mkoch227]

I see what the issue is now. Columns custom21-custom50 are missing on the stage_tickets table. I'll try to get a release out tonight that fixes the issue.