Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#69 SQL error when used with latest version of LXR

v1.0 (example)
closed-fixed
nobody
5
2008-06-13
2008-01-24
David Multer
No

Versions:
- LXR 0.9.5
- CodeStriker 1.9.4

1. Configure Codestriker to work with LXR and MySQL.
2. Create a code review topic that referenced a particular source file that has been cross indexed by LXR.
3. HTML output will include an error due to a failed MySQL statement. It is unable to find the "symbols" table in the LXR database.

I don't know when it changed, but the current version of LXR uses "lxr_" prefixes on all tables.

The following file:
lib/Codestriker/Http/Render.pm

Must be modified to refer to "lxr_symbols" instead of just "symbols":
134: $dbh->prepare_cached('SELECT count(symname) FROM lxr_symbols where symname = ?');

Discussion

  • David Sitsky
    David Sitsky
    2008-06-13

    • status: open --> open-fixed
     
  • David Sitsky
    David Sitsky
    2008-06-13

    Logged In: YES
    user_id=208928
    Originator: NO

    Thanks for the report - this has now been fixed. I've updated my local copy of LXR to 0.9.5. I've made sure that older LXR databases will still work.

    This will be out in the next Codestriker release - 1.9.5.

     
  • David Sitsky
    David Sitsky
    2008-06-13

    • status: open-fixed --> closed-fixed