#453 Fatal Error when editing pages

Database
closed
nobody
5
2014-07-29
2005-04-10
No

1.3.11rc3. Every time I edit a page on my wiki I see
the following php error. Note that the page edit works
so this appears to be only a cosmetic issue. I'm using
the Crao theme, haven't tested with any others. This
is a locked wiki.

Fatal Error:

lib/WikiDB/backend/PearDB.php:1014: Error:
wikidb_backend_peardb_mysql: fatal database error

* DB Error: already exists
* (INSERT INTO session (sess_id, sess_data,

sess_date, sess_ip) VALUES
('3be461cae757d35b1e206a7fa012b014',
'wiki_user|O:10:\"_adminuser\":11:{s:7:\"_userid\";s:14:\"AdminUser\";s:6:\"_level\";i:10;s:6:\"_prefs\";O:15:\"userpreferences\":4:{s:6:\"_prefs\";a:13:{s:6:\"userid\";O:15:\"_userpreference\":3:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;s:6:\"userid\";s:14:\"PhilHollenback\";}s:6:\"passwd\";O:15:\"_userpreference\":2:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;}s:9:\"autologin\";O:20:\"_userpreference_bool\":2:{s:13:\"default_value\";b:0;s:5:\"_init\";b:0;}s:5:\"email\";O:21:\"_userpreference_email\":4:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;s:13:\"emailVerified\";i:1;s:5:\"email\";s:17:\"philiph@pobox.com\";}s:11:\"notifyPages\";O:22:\"_userpreference_notify\":2:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;}s:5:\"theme\";O:21:\"_userpreference_theme\":2:{s:13:\"default_value\";s:4:\"Crao\"

Fatal error: wikidb_backend_peardb_mysql: fatal
database error DB Error: already exists (INSERT INTO
session (sess_id, sess_data, sess_date, sess_ip) VALUES
('3be461cae757d35b1e206a7fa012b014',
'wiki_user|O:10:\"_adminuser\":11:{s:7:\"_userid\";s:14:\"AdminUser\";s:6:\"_level\";i:10;s:6:\"_prefs\";O:15:\"userpreferences\":4:{s:6:\"_prefs\";a:13:{s:6:\"userid\";O:15:\"_userpreference\":3:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;s:6:\"userid\";s:14:\"PhilHollenback\";}s:6:\"passwd\";O:15:\"_userpreference\":2:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;}s:9:\"autologin\";O:20:\"_userpreference_bool\":2:{s:13:\"default_value\";b:0;s:5:\"_init\";b:0;}s:5:\"email\";O:21:\"_userpreference_email\":4:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;s:13:\"emailVerified\";i:1;s:5:\"email\";s:17:\"philiph@pobox.com\";}s:11:\"notifyPages\";O:22:\"_userpreference_notify\":2:{s:13:\"default_value\";s:0:\"\";s:5:\"_init\";b:0;}s:5:\"theme\";O:21:\"_userpreference_theme\":2:{s:13:\"default_value\";s:4:\"Crao\";
in /home/phil/public_html/lib/WikiDB/backend/PearDB.php
on line 1014

Discussion

  • Reini Urban
    Reini Urban
    2005-05-17

    Logged In: YES
    user_id=13755

    You print some chars before the header, which causes PHP
    sessions to fail.

    lib/main.php:85 looks like the problem.

     
  • Logged In: NO

    This is philiph - for some reason there's no submit button when I log in
    as myself.

    The echo " "; on line 85 isn't the problem - I added that much later
    when debugging a different problem. This message occurs without
    that line being there.

     
    • status: open --> closed
     
  • Closing very old bugs.