I think it was because something was exiting before committing, so this seems to be fixed.
On 7/25/06, Travis Derouin travis@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?