Menu
▾
▴
#5 Cannot update database
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.
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.
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.
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.