Manual talk:Cur table

From mediawiki.org
(Redirected from Talk:Cur table)
Latest comment: 18 years ago by Brion VIBBER in topic Directly replacing text in the DB?

why is comment tinyblob?

Why not? --Brion VIBBER 23:10, 10 Sep 2004 (UTC)

Now recentchanges?[edit]

Is the cur table now named recentchanges (rc_)?

No. That's a different table. --brion 21:11, 1 Apr 2005 (UTC)


Directly replacing text in the DB?[edit]

If I want to customize MW, can I alter system messages across the board by running a replace query on the cur table?

i.e.

UPDATE cur SET cur_text = replace(cur_text, 'x', 'y');

This seems logical to me, but in practice the changes to do not seem to take effect until each message is individually edited through the Wiki itself.

Because loading each individual message from the database is expensive, they are cached in a single blob. If you're not using memcached or another cache backend, this will be in the objectcache table with a key of 'dbname:messages' where dbname is your database name. You'd need to manually clear that when making changes.
You should also take care to update cur_timestamp and cur_touched to avoid other potential cache oddities. --brion 01:43, 23 May 2005 (UTC)Reply

Thanks Brion. ^_^ Where you say "You'd need to manually clear that when making changes", is this simply a matter of deleting that row from the objectcache table? And cur_timestamp and cur_touched are only important for rolling back changes through the Wiki front end aren't they? If I want my changes to be permanent it won't matter will it?

1.5[edit]

Where do I find the current article text in MediaWiki 1.5?

where to find articles in 1.5 schema[edit]

nobody knows. this documentation is outdated. im sorry im complaining so much but its true. the meta-wiki needs a Major reorganization. it would be a great-exercise in chaos management that im sure would be useful in herding the Wikipedians as well.