Error when logging in. Something wrong with sessions... (after upgrade OS)

[bvn13]

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:

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

[bvn13]

Oh... I forgot....

dotProject 2.1.5, the latest.

[bvn13]

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

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

[bvn13]

Originally Posted by bvn13

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

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.

[bvn13]

Where are the developers? is this project dead?

[Karen]

Not dead, they are around - but it's been a difficult year with job and personal circumstance changes and lots of competing priorities.

[jb8256]

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

[ajdonnison]

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.