#2283 accesslog missing 'status' column

Other
closed-invalid
Rob Malda
MySQL (78)
5
2003-02-10
2003-02-07
Jay Bonci
No

Filling my error logs:

DBD::mysql::db do failed: Unknown column 'status'
in 'field list'
at /usr/local/lib/perl/5.8.0/Slash/DB/Utility.pm line 590.

[Thu Feb 6 22:09:27 2003]
[error] :Slash::DB::Utility:/usr/local/lib/perl/5.8.0/Slash/D
B/Utility.pm:580:INSERT INTO accesslog
(bytes,uid,host_addr,status,user_agent,query_string,sec
ure,static,duration,section,ts,subnetid,dat,local_addr,refe
rer,op)
VALUES(
'1531',
'1',
'5775e7822a94362c7ebef451067a06f6',
'200',
'undefined',
'none',
'0',
'yes',
'0.0237801074981689',
'index',
NOW(),
'8804ea62368f79c235a6c1a7c67580e8',
NULL,
'10.20.30.42',
NULL,
'image')

Adding a "mediumint UNSIGNED DEFAULT 200 NOT
NULL" column named status seemed to fix it.

A trivial diff is attached

--jaybonci

Discussion

  • Brian Aker
    Brian Aker
    2003-02-07

    Logged In: YES
    user_id=25967

    Look in your sql/mysql/upgrades file. Any time you do a cvs
    update its good to check that file (I personally leave a
    marker in it so that I know where I last updated).

     
  • Brian Aker
    Brian Aker
    2003-02-07

    • assigned_to: nobody --> cmdrtaco
    • status: open --> open-invalid
     
  • Rob Malda
    Rob Malda
    2003-02-10

    • status: open-invalid --> closed-invalid