Forum:My Latest Activity numbers are off for articles.

I made a wiki changed a few things but somehow I managed to get the amount of articles on the wiki messed up. Under Latest Activity it is showing the amount of articles as 18,446,744,073,709,551,61 and so on. Not sure how to fix it please help.


 * What wiki are you on? I would guess that it'll be ok once you add a few new articles. -- ◄mendel► 19:24, August 22, 2010 (UTC)
 * Some wikis have the same problem, an example. 19:29, August 22, 2010 (UTC)
 * Yes, good example. The page counter was set to 0 when the wiki was created. Soem pages were created, then deleted; and then the mainpage was deleted; this would bring the page count to -1, but the binary representation for that is the same as 18,446,744,073,709,551,615, which the wiki displays. (One more page must have been lost, because the count was 1 less, even.)
 * Adding pages fixed it, but trying to edit those gets me the error

"A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

/*id=20100822195601*/ (SQL query hidden)

from within function "Database::delete". Database returned error "1146: Table 'narutonextgenerationrisefromtheshadows836.page_wikia_props' doesn't exist (10.8.32.28)".
 * This probably means one thing: don't delete your main page. (Why would you? Blanking it should be fine, or going to the history, loading the very first version, and saving that.) -- ◄mendel► 19:58, August 22, 2010 (UTC)
 * I cannot Special:Export the first two pages I created; and while I can successfully edit page 3 and 4, saving my edit (it is indeed saved!) results in the above error. -- ◄mendel► 20:03, August 22, 2010 (UTC)