I think it was because something was exiting before committing, so
this seems to be fixed.
On 7/25/06, Travis Derouin <travis(a)wikihow.com> wrote:
For some reason the page_counter field isn't
updating on our wiki
anymore. I'm logging queries to the database, and the queries are
getting through to increment the field, but field isn't changing at
all.
1861 Init DB wikidb_16
1861 Query BEGIN
1848 Quit
1861 Query SHOW STATUS LIKE 'Thread%'
1861 Query SELECT /* Title::newFromID */
page_namespace,page_title FROM `page` WHERE page_id = '18102'
LIMIT 1
1861 Query SELECT /* LinkCache::addLinkObj */
page_id FROM `page` WHERE page_namespace = '0' AND page_title =
'Fix-a-Stuck-Pixel-on-an-LCD-Monitor' LIMIT 1
1861 Query UPDATE page SET page_counter =
page_counter + 1 WHERE page_id = 18102
1861 Quit
Incrementing it from the command line though does work.
Doing a select sum(page_counter) from page; always shows the same
result and the page_counter fields for the individual pages show the
same value despite being reloaded.
Any ideas?