dotProject Forums

Go Back   dotProject Forums > DOTPROJECT VERSION 2 > Customisation Questions 2.x
Register FAQTop Posters Members List Calendar Search Today's Posts Resend Activation Email Mark Forums Read
dotProject Documentation dotProject FAQ Bugs & Feature Requests Language Packs & Themes Download dotProject

Customisation Questions 2.x How do you modify ..... for your own site

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-11, 03:55 PM
bvn13 bvn13 is offline
Junior Member
Return Visitor
dotProject Version: 2.1.5
php Version: 5.2
MySQL Version: 5.1
Operating System Version: Linux
Browser: Opera
 
Join Date: 02-12-11
Posts: 5
Question Error when logging in. Something wrong with sessions... (after upgrade OS)

I have installed openSUSE 12.1 recently. I have CentOS 5.5 on my server before.

Now I have:
1. MySQL 5.5.16-log Source distribution
2. PHP 5.3.8 (cli)

After I have installed all, I do mysql_upgrade. All was going OK.

But when I try to logg in my dotProject site, I see some error. I don't understand, how can I fix it. Please, help me. It seems something wrong with sessions or with new MySQL engine.

I have read this topic... It's unfavourable for me...

Here is my error:

Code:
ERROR: /srv/www/htdocs/dotproject/classes/query.class.php(628): query failed(INSERT INTO `dotp_sessions`(`session_id`,`session_data`,`session_created`) values ('fidplhadteg20soah9antsn5riadrvcrse6n431i3ikbs4gahr11','LANGUAGES|a:7:{s:2:\"es\";a:4:{i:0;s:2:\"es\";i:1;s:10:\"Castellano\";i:2;s:10:\"Castellano\";i:3;s:2:\"es\";}s:5:\"pt_BR\";a:4:{i:0;s:5:\"pt_br\";i:1;s:15:\"Portuguese (BR)\";i:2;s:15:\"PortuguГЄs (BR)\";i:3;s:5:\"pt_BR\";}s:5:\"en_AU\";a:4:{i:0;s:2:\"en\";i:1;s:13:\"English (Aus)\";i:2;s:13:\"English (Aus)\";i:3;s:3:\"ena\";}s:5:\"en_CA\";a:4:{i:0;s:2:\"en\";i:1;s:13:\"English (Can)\";i:2;s:13:\"English (Can)\";i:3;s:3:\"enc\";}s:5:\"en_GB\";a:4:{i:0;s:2:\"en\";i:1;s:12:\"English (GB)\";i:2;s:12:\"English (GB)\";i:3;s:3:\"eng\";}s:5:\"en_NZ\";a:4:{i:0;s:2:\"en\";i:1;s:12:\"English (NZ)\";i:2;s:12:\"English (NZ)\";i:3;s:3:\"enz\";}s:5:\"en_US\";a:5:{i:0;s:2:\"en\";i:1;s:12:\"English (US)\";i:2;s:12:\"English (US)\";i:3;s:3:\"enu\";i:4;s:10:\"ISO8859-15\";}}AppUI|O:6:\"CAppUI\":23:{s:5:\"state\";a:0:{}s:7:\"user_id\";s:1:\"1\";s:15:\"user_first_name\";s:10:\"РРѕР№РєРѕ\";s:14:\"user_last_name\";s:16:\"РСЏСРСЃРРРІ\";s:12:\"user_company\";s:1:\"1\";s:15:\"user_department\";s:0:\"\";s:10:\"user_email\";s:18:\"mail4bvn@gmail.com\";s:9:\"user_type\";s:1:\"1\";s:10:\"user_prefs\";a:12:{s:6:\"LOCALE\";s:5:\"en_AU\";s:7:\"TABVIEW\";s:1:\"0\";s:12:\"SHDATEFORMAT\";s:8:\"%d/%m/%Y\";s:10:\"TIMEFORMAT\";s:8:\"%I:%M %p\";s:7:\"UISTYLE\";s:7:\"default\";s:13:\"TASKASSIGNMAX\";s:3:\"100\";s:10:\"USERFORMAT\";s:4:\"user\";s:12:\"CURRENCYFORM\";s:5:\"en_AU\";s:11:\"TASKLOGNOTE\";s:1:\"0\";s:12:\"TASKLOGEMAIL\";s:1:\"0\";s:11:\"EVENTFILTER\";s:2:\"my\";s:7:\"MAILALL\";s:1:\"0\";}s:12:\"day_selected\";N;s:11:\"user_locale\";s:2:\"en\";s:9:\"user_lang\";a:4:{i:0;s:11:\"en_AU.utf-8\";i:1;s:3:\"ena\";i:2;s:5:\"en_AU\";i:3;s:2:\"en\";}s:11:\"base_locale\";s:2:\"en\";s:3:\"msg\";s:0:\"\";s:5:\"msgNo\";s:0:\"\";s:15:\"defaultRedirect\";s:0:\"\";s:3:\"cfg\";a:1:{s:11:\"locale_warn\";b:0;}s:13:\"version_major\";N;s:13:\"version_minor\";N;s:13:\"version_patch\";N;s:14:\"version_string\";N;s:14:\"last_insert_id\";s:2:\"87\";s:10:\"project_id\";i:0;}','2011-12-02 09:40:15')) - error was: Duplicate entry 'fidplhadteg20soah9antsn5riadrvcrse6n431i' for key 'PRIMARY'
Backtrace:
0 /srv/www/htdocs/dotproject/classes/query.class.php:628 dprint('/srv/www/htdocs/dotproject/classes/query.class.php',628,0,'query failed(INSERT INTO `dotp_sessions`(`session_id`,`session_data`,`session_created`) values (\'fidplhadteg20soah9antsn5riadrvcrse6n431i3ikbs4gahr11\',\'LANGUAGES|a:7:{s:2:\\"es\\";a:4:{i:0;s:2:\\"es\\";i:1;s:10:\\"Castellano\\";i:2;s:10:\\"Castellano\\";i:3;s:2:\\"es\\";}s:5:\\"pt_BR\\";a:4:{i:0;s:5:\\"pt_br\\";i:1;s:15:\\"Portuguese (BR)\\";i:2;s:15:\\"PortuguГЄs (BR)\\";i:3;s:5:\\"pt_BR\\";}s:5:\\"en_AU\\";a:4:{i:0;s:2:\\"en\\";i:1;s:13:\\"English (Aus)\\";i:2;s:13:\\"English (Aus)\\";i:3;s:3:\\"ena\\";}s:5:\\"en_CA\\";a:4:{i:0;s:2:\\"en\\";i:1;s:13:\\"English (Can)\\";i:2;s:13:\\"English (Can)\\";i:3;s:3:\\"enc\\";}s:5:\\"en_GB\\";a:4:{i:0;s:2:\\"en\\";i:1;s:12:\\"English (GB)\\";i:2;s:12:\\"English (GB)\\";i:3;s:3:\\"eng\\";}s:5:\\"en_NZ\\";a:4:{i:0;s:2:\\"en\\";i:1;s:12:\\"English (NZ)\\";i:2;s:12:\\"English (NZ)\\";i:3;s:3:\\"enz\\";}s:5:\\"en_US\\";a:5:{i:0;s:2:\\"en\\";i:1;s:12:\\"English (US)\\";i:2;s:12:\\"English (US)\\";i:3;s:3:\\"enu\\";i:4;s:10:\\"ISO8859-15\\";}}AppUI|O:6:\\"CAppUI\\":23:{s:5:\\"state\\";a:0:{}s:7:\\"user_id\\";s:1:\\"1\\";s:15:\\"user_first_name\\";s:10:\\"РРѕР№РєРѕ\\";s:14:\\"user_last_name\\";s:16:\\"РСЏСРСЃРРРІ\\";s:12:\\"user_company\\";s:1:\\"1\\";s:15:\\"user_department\\";s:0:\\"\\";s:10:\\"user_email\\";s:18:\\"mail4bvn@gmail.com\\";s:9:\\"user_type\\";s:1:\\"1\\";s:10:\\"user_prefs\\";a:12:{s:6:\\"LOCALE\\";s:5:\\"en_AU\\";s:7:\\"TABVIEW\\";s:1:\\"0\\";s:12:\\"SHDATEFORMAT\\";s:8:\\"%d/%m/%Y\\";s:10:\\"TIMEFORMAT\\";s:8:\\"%I:%M %p\\";s:7:\\"UISTYLE\\";s:7:\\"default\\";s:13:\\"TASKASSIGNMAX\\";s:3:\\"100\\";s:10:\\"USERFORMAT\\";s:4:\\"user\\";s:12:\\"CURRENCYFORM\\";s:5:\\"en_AU\\";s:11:\\"TASKLOGNOTE\\";s:1:\\"0\\";s:12:\\"TASKLOGEMAIL\\";s:1:\\"0\\";s:11:\\"EVENTFILTER\\";s:2:\\"my\\";s:7:\\"MAILALL\\";s:1:\\"0\\";}s:12:\\"day_selected\\";N;s:11:\\"user_locale\\";s:2:\\"en\\";s:9:\\"user_lang\\";a:4:{i:0;s:11:\\"en_AU.utf-8\\";i:1;s:3:\\"ena\\";i:2;s:5:\\"en_AU\\";i:3;s:2:\\"en\\";}s:11:\\"base_locale\\";s:2:\\"en\\";s:3:\\"msg\\";s:0:\\"\\";s:5:\\"msgNo\\";s:0:\\"\\";s:15:\\"defaultRedirect\\";s:0:\\"\\";s:3:\\"cfg\\";a:1:{s:11:\\"locale_warn\\";b:0;}s:13:\\"version_major\\";N;s:13:\\"version_minor\\";N;s:13:\\"version_patch\\";N;s:14:\\"version_string\\";N;s:14:\\"last_insert_id\\";s:2:\\"87\\";s:10:\\"project_id\\";i:0;}\',\'2011-12-02 09:40:15\')) - error was: Duplicate entry \'fidplhadteg20soah9antsn5riadrvcrse6n431i\' for key \'PRIMARY\'')
1 /srv/www/htdocs/dotproject/includes/session.php:90 exec()
2 : dPsessionWrite('fidplhadteg20soah9antsn5riadrvcrse6n431i3ikbs4gahr11','LANGUAGES|a:7:{s:2:"es";a:4:{i:0;s:2:"es";i:1;s:10:"Castellano";i:2;s:10:"Castellano";i:3;s:2:"es";}s:5:"pt_BR";a:4:{i:0;s:5:"pt_br";i:1;s:15:"Portuguese (BR)";i:2;s:15:"PortuguГЄs (BR)";i:3;s:5:"pt_BR";}s:5:"en_AU";a:4:{i:0;s:2:"en";i:1;s:13:"English (Aus)";i:2;s:13:"English (Aus)";i:3;s:3:"ena";}s:5:"en_CA";a:4:{i:0;s:2:"en";i:1;s:13:"English (Can)";i:2;s:13:"English (Can)";i:3;s:3:"enc";}s:5:"en_GB";a:4:{i:0;s:2:"en";i:1;s:12:"English (GB)";i:2;s:12:"English (GB)";i:3;s:3:"eng";}s:5:"en_NZ";a:4:{i:0;s:2:"en";i:1;s:12:"English (NZ)";i:2;s:12:"English (NZ)";i:3;s:3:"enz";}s:5:"en_US";a:5:{i:0;s:2:"en";i:1;s:12:"English (US)";i:2;s:12:"English (US)";i:3;s:3:"enu";i:4;s:10:"ISO8859-15";}}AppUI|O:6:"CAppUI":23:{s:5:"state";a:0:{}s:7:"user_id";s:1:"1";s:15:"user_first_name";s:10:"РРѕР№РєРѕ";s:14:"user_last_name";s:16:"РСЏСРСЃРРРІ";s:12:"user_company";s:1:"1";s:15:"user_department";s:0:"";s:10:"user_email";s:18:"mail4bvn@gmail.com";s:9:"user_type";s:1:"1";s:10:"user_prefs";a:12:{s:6:"LOCALE";s:5:"en_AU";s:7:"TABVIEW";s:1:"0";s:12:"SHDATEFORMAT";s:8:"%d/%m/%Y";s:10:"TIMEFORMAT";s:8:"%I:%M %p";s:7:"UISTYLE";s:7:"default";s:13:"TASKASSIGNMAX";s:3:"100";s:10:"USERFORMAT";s:4:"user";s:12:"CURRENCYFORM";s:5:"en_AU";s:11:"TASKLOGNOTE";s:1:"0";s:12:"TASKLOGEMAIL";s:1:"0";s:11:"EVENTFILTER";s:2:"my";s:7:"MAILALL";s:1:"0";}s:12:"day_selected";N;s:11:"user_locale";s:2:"en";s:9:"user_lang";a:4:{i:0;s:11:"en_AU.utf-8";i:1;s:3:"ena";i:2;s:5:"en_AU";i:3;s:2:"en";}s:11:"base_locale";s:2:"en";s:3:"msg";s:0:"";s:5:"msgNo";s:0:"";s:15:"defaultRedirect";s:0:"";s:3:"cfg";a:1:{s:11:"locale_warn";b:0;}s:13:"version_major";N;s:13:"version_minor";N;s:13:"version_patch";N;s:14:"version_string";N;s:14:"last_insert_id";s:2:"87";s:10:"project_id";i:0;}')
3 /srv/www/htdocs/dotproject/classes/ui.class.php:519 session_write_close()
4 /srv/www/htdocs/dotproject/index.php:134 redirect('dotproject=fidplhadteg20soah9antsn5riadrvcrse6n431i3ikbs4gahr11')
<\pre>

Warning: Cannot modify header information - headers already sent by (output started at /srv/www/htdocs/dotproject/includes/main_functions.php:682) in /srv/www/htdocs/dotproject/classes/ui.class.php on line 532

Reply With Quote
  #2  
Old 02-12-11, 03:57 PM
bvn13 bvn13 is offline
Junior Member
Return Visitor
dotProject Version: 2.1.5
php Version: 5.2
MySQL Version: 5.1
Operating System Version: Linux
Browser: Opera
 
Join Date: 02-12-11
Posts: 5
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

Oh... I forgot....

dotProject 2.1.5, the latest.

Reply With Quote
  #3  
Old 02-12-11, 06:46 PM
bvn13 bvn13 is offline
Junior Member
Return Visitor
dotProject Version: 2.1.5
php Version: 5.2
MySQL Version: 5.1
Operating System Version: Linux
Browser: Opera
 
Join Date: 02-12-11
Posts: 5
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

hm... when I try to install a new copy of dotproject (new base) the following error has been occured:

Code:
DB setup incomplete - the following errors occured:
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 '(14) NOT NULL, `note_modified_by` int(10) unsigned NOT NULL default '0', PRI' at line 15
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 'TYPE = MyISAM' at line 10

Reply With Quote
  #4  
Old 02-12-11, 10:26 PM
bvn13 bvn13 is offline
Junior Member
Return Visitor
dotProject Version: 2.1.5
php Version: 5.2
MySQL Version: 5.1
Operating System Version: Linux
Browser: Opera
 
Join Date: 02-12-11
Posts: 5
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

Quote:
Originally Posted by bvn13 View Post
hm... when I try to install a new copy of dotproject (new base) the following error has been occured:

Code:
DB setup incomplete - the following errors occured:
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 '(14) NOT NULL, `note_modified_by` int(10) unsigned NOT NULL default '0', PRI' at line 15
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 'TYPE = MyISAM' at line 10
i have fixed that errors.
first - it was a timestamp(14) - i've just remove '(14)'
second - I've just commented 'TYPE = MyISAM'...

The base was created successfully, but an error (first message) has been occured again.

Reply With Quote
  #5  
Old 13-12-11, 01:45 AM
bvn13 bvn13 is offline
Junior Member
Return Visitor
dotProject Version: 2.1.5
php Version: 5.2
MySQL Version: 5.1
Operating System Version: Linux
Browser: Opera
 
Join Date: 02-12-11
Posts: 5
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

Where are the developers? is this project dead?

Reply With Quote
  #6  
Old 13-12-11, 08:03 AM
Karen's Avatar
Karen Karen is offline
Administrator
Utter Fanatic
dotProject Version: 2.1.3
php Version: 5.2
MySQL Version: 5.2
Operating System Version: Linux
Browser: Firefox
 
Join Date: 13-04-04
Posts: 2,443
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

Not dead, they are around - but it's been a difficult year with job and personal circumstance changes and lots of competing priorities.
__________________
I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams

Please do not use Private Messages to ask support questions.
------
IMPORTANT - READ THIS PLEASE: http://forums.dotproject.net/showthread.php?p=35045
dotProject Admin & Development Blog - http://blogs.sakienvirotech.com/dotProject
DOCUMENTATION SITE - http://docs.dotproject.net
Like Crime Fiction - http://www.austcrimefiction.org
Reply With Quote
  #7  
Old 31-03-12, 12:11 AM
jb8256 jb8256 is offline
Junior Member
New Participant
dotProject Version: 2.1.5
php Version: 5.3
MySQL Version: Nothing Selected
Operating System Version: Linux
Browser: Firefox
 
Join Date: 31-03-12
Posts: 1
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

Hello,

I seem to have exactly the same problem as bvn13 (no surprise because I have the same system ) and just like him/her I am stuck. Any news ?

Greetings
Joachim

Reply With Quote
  #8  
Old 02-04-12, 03:09 PM
ajdonnison's Avatar
ajdonnison ajdonnison is offline
Administrator
Utter Fanatic
dotProject Version:
php Version:
MySQL Version:
Operating System Version:
Browser:
 
Join Date: 13-04-04
Posts: 2,251
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

You may want to check the nightly snapshot for the latest version, there were a few issues in 2.1.5 that have since been resolved.
Reply With Quote
  #9  
Old 12-12-13, 01:36 AM
Rakoth Rakoth is offline
Junior Member
Return Visitor
dotProject Version: 2.1.6
php Version: Nothing Selected
MySQL Version: Nothing Selected
Operating System Version: Other
Browser: Safari
 
Join Date: 17-10-12
Posts: 3
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

I'm having the same problem with OS X 10.9, MySQL 5.6.14 and dotProject 2.1.8.

..../classes/query.class.php(628): query failed(INSERT INTO `dotp_sessions`(`session_id`,`session_data`,`sessi on_created`)......

Any Ideas?

Reply With Quote
  #10  
Old 19-12-13, 10:09 AM
cyberhorse's Avatar
cyberhorse cyberhorse is offline
Development Team Member
Utter Fanatic
dotProject Version:
php Version:
MySQL Version:
Operating System Version:
Browser:
 
Join Date: 19-04-04
Posts: 1,585
Default Re: Error when logging in. Something wrong with sessions... (after upgrade OS)

You can try deleting everything from the sessions table (dotp_sessions) when the system isn't used by anyone and see if that alone resolves your issue.
__________________
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +10. The time now is 09:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.