#5 Cannot update database

open
nobody
None
5
2004-03-18
2004-03-18
No

Hello,

I've been running 'Tavi for a long time; now at v0.25.
Recently, people started getting strange errors when
trying to access the wiki, as if it was unable to write to
mywiki_rate. I then disabled rate limiting, which allowed
the site to be browsed normally.

However, it seems the underlying problem didn't go
away. Other attempts to write to the DB still create
errors, e.g. "LOCK TABLES avisynth_pages WRITE,
avisynth_interwiki WRITE, avisynth_sisterwiki WRITE,
avisynth_links WRITE" when editing a page.

Any ideas? I run several other mysql-intensive apps off
this web account but they all seem to be doing fine.

Discussion

  • Richard Berg

    Richard Berg - 2004-03-30

    Logged In: YES
    user_id=495068

    Further notes: downgrading to 0.22 changes the error
    message but doesn't help. Copying the tables and pointing
    Tavi to the new copies doesn't help. My ISP insists they
    have done DB tests with no errors and I'm inclined to agree.

     
  • Richard Berg

    Richard Berg - 2004-03-30

    Logged In: YES
    user_id=495068

    Further notes: downgrading to 0.22 changes the error
    message but doesn't help. Copying the tables and pointing
    Tavi to the new copies doesn't help. My ISP insists they
    have done DB tests with no errors and I'm inclined to agree.

     
  • Richard Berg

    Richard Berg - 2004-04-02

    Logged In: YES
    user_id=495068

    Some poking around revealed that (1) MySQL 4.xx requires a
    new permission to LOCK (2) voila, looks like my DB is now
    running 4.xx. (Unfortunately, in my case, the ISP refused to
    re-grant the permission.) This can be closed, except to say:
    Caveat Webmeisters.

     

Log in to post a comment.