Error while trying to upgrade Elgg 1.8.3 to 1.8.4

I followed the instruction on the documentation

i get the following error:

Unknown column 'ip_address' in 'field list'

QUERY: INSERT DELAYED into elgg18_system_log
(object_id, object_class, object_type, object_subtype, event,
performed_by_guid, owner_guid, access_id, enabled, time_created, ip_address)
VALUES
('1666','ElggMetadata','metadata', 'admin_notice_id', 'create',
111, 111, 0, 'yes', '1335806853', '86.56.139.236')


  • Hiya - I'm having the same problem. Part of the issue is that it this is the error that appear on upgrade.php!

  • Upgrade 2012012000-1.8.3-ip_in_syslog-87fe0f068cf62428 should have added the IP address field to the system log table. This error is caused by upgrade 2012041800-1.8.3-dont_filter_passwords-c0ca4a18b38ae2bc, which adds an admin notice about the password changes.

    Can both of you please do two things:

    1. Check your system_log table to see if there is an ip_address field. (There shouldn't be).
    2. Look in the datalists table, find the version entry, and let me know the value. (SELECT * FROM elgg_datalists WHERE name = 'version')
    3. Look in the datalists table, find the processed_upgrades entry, and let me know the value. (SELECT * FROM elgg_datalists WHERE name = 'processed_upgrades')
    4. Try running upgrade.php again and see if it changes anything.
    Thanks.
  • Hello,

    I've a problem that is nearly the same :

    137 for record at pos 1948092

    QUERY: ALTER TABLE elgg_system_log ADD ip_address VARCHAR(15) NOT NULL AFTER time_created

     

    DatabaseException Object
    (
    [message:protected] => 137 for record at pos 1948092

    QUERY: ALTER TABLE elgg_system_log ADD ip_address VARCHAR(15) NOT NULL AFTER time_created
    [string:Exception:private] => exception 'DatabaseException' with message '137 for record at pos 1948092

    QUERY: ALTER TABLE elgg_system_log ADD ip_address VARCHAR(15) NOT NULL AFTER time_created' in xxxxx/engine/lib/database.php:261

    when I look at the things Brett asked :

    1- no ip_address field

    2- value is: 2011123101

    3- value is: a:36:{i:0;s:14:"2008100701.php";i:1;s:14:"2008101303.php";i:2;s:14:"2009022701.php";i:3;s:14:"2009041701.php";i:4;s:14:"2009070101.php";i:5;s:14:"2009102801.php";i:6;s:14:"2010010501.php";i:7;s:14:"2010033101.php";i:8;s:14:"2010040201.php";i:9;s:14:"2010052601.php";i:10;s:14:"2010060101.php";i:11;s:14:"2010060401.php";i:12;s:14:"2010061501.php";i:13;s:14:"2010062301.php";i:14;s:14:"2010062302.php";i:15;s:14:"2010070301.php";i:16;s:14:"2010071001.php";i:17;s:14:"2010071002.php";i:18;s:14:"2010111501.php";i:19;s:14:"2010121601.php";i:20;s:14:"2010121602.php";i:21;s:14:"2010121701.php";i:22;s:14:"2010123101.php";i:23;s:14:"2011010101.php";i:24;s:61:"2011021800-1.8_svn-goodbye_walled_garden-083121a656d06894.php";i:25;s:61:"2011022000-1.8_svn-custom_profile_fields-390ac967b0bb5665.php";i:26;s:60:"2011030700-1.8_svn-blog_status_metadata-4645225d7b440876.php";i:27;s:51:"2011031300-1.8_svn-twitter_api-12b832a5a7a3e1bd.php";i:28;s:57:"2011031600-1.8_svn-datalist_grows_up-0b8aec5a55cc1e1c.php";i:29;s:61:"2011032000-1.8_svn-widgets_arent_plugins-61836261fa280a5c.php";i:30;s:59:"2011032200-1.8_svn-admins_like_widgets-7f19d2783c1680d3.php";i:31;s:14:"2011052801.php";i:32;s:60:"2011061200-1.8b1-sites_need_a_site_guid-6d9dcbf46c0826cc.php";i:33;s:62:"2011092500-1.8.0.1-forum_reply_river_view-5758ce8d86ac56ce.php";i:34;s:54:"2011123100-1.8.2-fix_friend_river-b17e7ff8345c2269.php";i:35;s:53:"2011123101-1.8.2-fix_blog_status-b14c2a0e7b9e7d55.php";}

    4- nothing changed

    Many thanks for your help

  • I find that if the settings.php file exists within the engine directory the update fails to run and displays the following: "An unrecoverable error has occurred and has been logged." If I remove the settings.php file it defaults to an install.

  • I am having the same problem. What is the best thing to do to get my site up and running?

     

    Here is the information Brett asked for:

    1. no ip_address in system_log

    2. mysql> select * from datalists where name = 'version';
    +---------+------------+
    | name    | value      |
    +---------+------------+
    | version | 2011123101 |
    +---------+------------+

    3. mysql> select * from datalists where name = 'processed_upgrades';

    | processed_upgrades | a:36:{i:0;s:14:"2008100701.php";i:1;s:14:"2008101303.php";i:2;s:14:"2009022701.php";i:3;s:14:"2009041701.php";i:4;s:14:"2009070101.php";i:5;s:14:"2009102801.php";i:6;s:14:"2010010501.php";i:7;s:14:"2010033101.php";i:8;s:14:"2010040201.php";i:9;s:14:"2010052601.php";i:10;s:14:"2010060101.php";i:11;s:14:"2010060401.php";i:12;s:14:"2010061501.php";i:13;s:14:"2010062301.php";i:14;s:14:"2010062302.php";i:15;s:14:"2010070301.php";i:16;s:14:"2010071001.php";i:17;s:14:"2010071002.php";i:18;s:14:"2010111501.php";i:19;s:14:"2010121601.php";i:20;s:14:"2010121602.php";i:21;s:14:"2010121701.php";i:22;s:14:"2010123101.php";i:23;s:14:"2011010101.php";i:24;s:61:"2011021800-1.8_svn-goodbye_walled_garden-083121a656d06894.php";i:25;s:61:"2011022000-1.8_svn-custom_profile_fields-390ac967b0bb5665.php";i:26;s:60:"2011030700-1.8_svn-blog_status_metadata-4645225d7b440876.php";i:27;s:51:"2011031300-1.8_svn-twitter_api-12b832a5a7a3e1bd.php";i:28;s:57:"2011031600-1.8_svn-datalist_grows_up-0b8aec5a55cc1e1c.php";i:29;s:61:"2011032000-1.8_svn-widgets_arent_plugins-61836261fa280a5c.php";i:30;s:59:"2011032200-1.8_svn-admins_like_widgets-7f19d2783c1680d3.php";i:31;s:14:"2011052801.php";i:32;s:60:"2011061200-1.8b1-sites_need_a_site_guid-6d9dcbf46c0826cc.php";i:33;s:62:"2011092500-1.8.0.1-forum_reply_river_view-5758ce8d86ac56ce.php";i:34;s:54:"2011123100-1.8.2-fix_friend_river-b17e7ff8345c2269.php";i:35;s:53:"2011123101-1.8.2-fix_blog_status-b14c2a0e7b9e7d55.php";} |

     

    4. Running upgrade.php again gave the same error

     

    Thanks!

  • Ok, I have the same error as the OP:

     

    [Tue May 01 11:17:28 2012] [error] [client xxx.xxx.xxx.xxx] Exception #1335885448: exception 'DatabaseException' with message 'Unknown column 'ip_address' in 'field list'\n\n QUERY: INSERT DELAYED into elgg_system_log\n\t\t\t\t(object_id, object_class, object_type, object_subtype, event,\n\t\t\t\tperformed_by_guid, owner_guid, access_id, enabled, time_created, ip_address)\n\t\t\tVALUES\n\t\t\t\t('2281','ElggMetadata','metadata', 'admin_notice_id', 'create',\n\t\t\t\t50, 50, 0, 'yes', '1335885448', 'xxx.xxx.xxx.xxx')' in /opt/elgg/engine/lib/database.php:261\nStack trace:\n#0

     

  • Thanks for the details. I've added a ticket describing the problem here: http://trac.elgg.org/ticket/4487. The fix will be included in the next version of Elgg.

    When I add the fix, I'll ping this thread so you can patch your copy to get up and running. If you are upgrading directly from 1.8.3 to 1.8.4 you can delete the follow file and upgrade.php should work:

    engine/lib/upgrades/2012041800-1.8.3-dont_filter_passwords-c0ca4a18b38ae2bc.php

    This upgrade adds an admin notice about passwords. The notice says:

    Password handling has been updated to be more secure and flexible. This change may prevent a small number of users from logging in with their existing passwords. If a user is unable to log in, please advise him or her to reset their password, or reset it as an admin user.

  • I was unable to duplicate this on an upgrade, but found a possible reason and committed a fix. For anyone having this problem, please post a stack trace (look in your error logs) to the ticket above. Thanks.

Feedback and Planning

Feedback and Planning

Discussions about the past, present, and future of Elgg and this community site.