LogOn Error

If you need support with TeamCal Pro (installation, configuration, usage) post your request here.
Post Reply
Mich@el
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 2009-09-01, 15:36

LogOn Error

Post by Mich@el » 2011-02-01, 15:10

Hello George,

i have installed TCP 3.3.005 on an IIS7 with MY SQL V5.067
The installation works fine.

But the default login: Admin PW:root send me an SQL error


Error: A problem was encountered while executing this query:

UPDATE `my_tc_users` SET `username` = 'admin', `password` = 's77dWZwOIYXss', `firstname` = '', `lastname` = 'Admin', `title` = '', `position` = 'Administrator', `group` = '', `phone` = '', `mobile` = '', `email` = 'webmaster@yourserver.com', `notify` = '63', `notify_group` = 'All', `status` = '0', `usertype` = '4', `ut_group` = '', `privileges` = '0', `bad_logins` = '0', `bad_logins_start` = '', `last_pw_change` = '2006-10-06 20:01:18', `birthday` = '00000000', `idnumber` = '', `last_login` = '2011-01-08 06:06:12 EST', `custom1` = '', `custom2` = '', `custom3` = '', `custom4` = '', `custom5` = '', `customFree` = '', `customPopup` = '' WHERE `username` = 'admin'

Error: Fatal database error!


do you have some idea, what can i do ?


thx

Mich@el
User avatar
George
Platinum Boarder
Platinum Boarder
Posts: 406
Joined: 2004-11-29, 21:20
Are you a spam bot?: No
Contact:

Re:LogOn Error

Post by George » 2011-02-02, 07:47

I assume it is one of the two time stamp values. Run this query manually with phpMyadmin and remover the ' EST' from the last_login field. See if that is the culprit.
TeamCal Neo is free for private use but requires licensing for use in a commercial environment:
https://georgelewe.atlassian.net/wiki/s ... eo+License
Mich@el
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 2009-09-01, 15:36

Re:LogOn Error

Post by Mich@el » 2011-02-03, 14:54

Hello George,

thank you very much

it works now

i´have edit the query
form last_login date
to last_login text

greetings

Mich@el
snaker
Junior Boarder
Junior Boarder
Posts: 20
Joined: 2010-04-19, 14:44
Location: Germany - Bavaria

Re:LogOn Error

Post by snaker » 2011-02-28, 09:05

Hi there,

problem occurs here, too. Running the SQL-Query manually works, but is not a final solution cause the problem returns again and again (don't no why/when).
I'm runnin on WS-2K8 x64, with IIS7 and the newest version of PHP and MySQL.

I don't know why some logins add the "CET" (or in the example above "EST" )at the end of the timestamp. Is there a possibility to disable this attatchment? Or maybe reduce it to only 1?

Thx

snaker

EDIT:
It seems so that this the add of "CET" occurs, everytime i edit and save a profile. So this is a problem in the savingprocess in editprofile.php

Btw: i changed the types in the DB like in this thread:
http://lewe.com/index.php?option=com_fi ... 0&catid=17

This solution helped me a year ago, but now (new system, new DB) it creates this error.
edon
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2011-04-11, 12:23

Re:LogOn Error

Post by edon » 2011-04-11, 08:29

So, has anyone found a good solution to this problem?
I've just installed the application and immediatly fell foul of it.
User avatar
George
Platinum Boarder
Platinum Boarder
Posts: 406
Joined: 2004-11-29, 21:20
Are you a spam bot?: No
Contact:

Re:LogOn Error

Post by George » 2011-04-11, 10:31

Try the attached editprofile.php where I made sure no time zone string is submitted to the database update in last_login.

Let me know if that helps.

Best regards
George [file name=editprofile.zip size=7881]http://www.lewe.com/images/fbfiles/file ... rofile.zip[/file]
TeamCal Neo is free for private use but requires licensing for use in a commercial environment:
https://georgelewe.atlassian.net/wiki/s ... eo+License
edon
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2011-04-11, 12:23

Re:LogOn Error

Post by edon » 2011-04-11, 10:52

Thank you,that seems to have done the trick. I'll let you know if anything changes.
snaker
Junior Boarder
Junior Boarder
Posts: 20
Joined: 2010-04-19, 14:44
Location: Germany - Bavaria

Re:LogOn Error

Post by snaker » 2011-04-11, 12:06

Hi, this didn't worked for me, after saving a profile the CET-error occures again :/
edon
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2011-04-11, 12:23

Re:LogOn Error

Post by edon » 2011-04-11, 15:57

Problem could go a little deeper than we thought. Just updated a members Group assignment and got the

`last_login` = '2011-04-11 10:45:03 BST', error

User couldn't login.

Updated his profile and the problem cleared.
User avatar
George
Platinum Boarder
Platinum Boarder
Posts: 406
Joined: 2004-11-29, 21:20
Are you a spam bot?: No
Contact:

Re:LogOn Error

Post by George » 2011-04-12, 08:16

Here is a change in a different file that does addl. good in this. [file name=tcuser.zip size=2748]http://www.lewe.com/images/fbfiles/files/tcuser.zip[/file]
TeamCal Neo is free for private use but requires licensing for use in a commercial environment:
https://georgelewe.atlassian.net/wiki/s ... eo+License
snaker
Junior Boarder
Junior Boarder
Posts: 20
Joined: 2010-04-19, 14:44
Location: Germany - Bavaria

Re:LogOn Error

Post by snaker » 2011-04-12, 08:23

Works like a charme :)
edon
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 2011-04-11, 12:23

Re:LogOn Error

Post by edon » 2011-04-12, 08:48

Superb. Thank you very much.
Post Reply