Update shows as successful but unable to login or log ticket

Sampler · Post by **Sampler** » Wed Sep 09, 2009 1:21 pm

Script URL: n/a (on an internal dev server)
Version of script: 2.1 (downloaded today)
Hosting company: n/a (personal server)
URL of phpinfo.php: n/a
URL of session_test.php: n/a
What terms did you try when SEARCHING for a solution:
"Can't execute SQL" then tried "Update"
Write your message below:
Hello

I've tried updating my HESK install today from 0.94.1 to 2.1, have copied over the old HESK system to my dev server, made sure it was running fine and then applied the update.

The update finished with the page prompting me to delete the /install/ directory, which I did then proceeded to the login page.

Here's where I started having issues, the passwords in the database are still plain text and why I'm assuming why they don't work - I simply get "error - wrong password".

Testing to see if I could log a ticket also gives "Can't execute SQL" when you hit submit - a new browser window popups with the error on.

I've had a look at several threads with similar errors but they all seem to have errord mid update whilst mine has completed fully.

Additionally is there an option to specify the SMTP server used? I tried adding this to my 0.94 install:
viewtopic.php?t=2469
but it didn't work, simply ignored it and carried on using the local sendmail function of the server.

Sampler · Post by **Sampler** » Wed Sep 09, 2009 2:06 pm

Hi

I've gone back and redone the installation but changing the hesk_settings.inc.php line to saying 0.94.1 nstead of 0.94 like it said and it's overcome the login and ticket submission errors.

Still require SMTP integration though as Mail Marshal keeps blacklisting the support emails so no-one gets them.

Sampler · Post by **Sampler** » Wed Sep 09, 2009 2:22 pm

Tried the SMTP mod in the link in the first post and again doesn't appear to work.

The confirmation email was never recieved on my test post and the notification emails to admins were sent via the boxes local SMTP mailer by the looks of things

Post by **Klemen** » Wed Sep 09, 2009 7:15 pm

Glad you corrected the first error, it was because the database wasn't updated properly.

As for the problems with e-mail unfortunately this is not something I can help with. HESK uses standard PHP mail commands and it's up to you (or the server administrator) to ensure those are working properly.

Sampler · Post by **Sampler** » Thu Sep 10, 2009 8:07 am

The PHP sendmail function works fine on the server - our issue is that using the webservers SMTP means mails go out of the company and then back in via our mail filter and then into our exchange server.

For some reason our mail filter (MailMarshal) keeps deciding to blacklist the mails even though we've whitelisted the address. (we have raised the issue with them aswell).

What we were hoping to do is direct Hesk to use our Exchange server by directly entering the SMTP settings for it into Hesk and this bypassing the mails travelling through the mail filter - we don't want to adjust the SMTP settings for the entire server as the other websites running on it can utilise the local SMTP service and do not need to go via our Exchange server.

I appreciate it's asking alot but if you could give a quick look over the code on the link in the first post and see if there's anything that looks out of place, I'm sure manually configuring SMTP is a feature many would enjoy having in future versions of Hesk.

Thank you