By Jonathan Furness on
For users of Drupal 4.4.0 running Mac OS 10.3 Server.
I have just done an Apple software update from 10.3.2 to 10.3.3 - it apparently has some modifications to MySQL.
Just noticed that this update has had an affect on the node_counter table, causing the totalcount field to display a huge number, 2161727821137838080, rather than just 32!
What's going on? I can't understand why the update would have modified the data, or how it managed to translate 32 to be 2161727821137838080?
Fellow Mac OS X users, beware. Backup your SQL databases before performing this update.
Comments
Check Apple Knowledge base article 107851
Apple KB article 107851 - About the Mac OS X Server 10.3.3 Update.
The Software update program links right to this article so everyone doing this update should be able to read it.
It warns of possible MySQL problems, and offers instructions on what to do with your MySQL databases.
same problem with 10.2 to 10.3
I have the same problem, but i don't use statistics so I haven't bothered to reset the tables.
My problem came from an OSX Server 10.2 to 10.3 upgrade, not from 10.3.2 to 10.3.3, so I'm not sure if your problem is the same one linked in the kb.
The kb issue only affected datetime entries, not date or time entries, if I understood the issue correctly.
What tables/fields do I need to reset to zero out the counters? Anyone know?
node_counters
The table you need to edit is the node_counters table
There is a field showing totalcount that needs modifying.
J
===========
Jonathan Furness
ULTRALAB
teacher, developer, webmaster
http://www.jonathansblog.net
thanks!
thanks!