I'm in the process of trying to upgrade the scripts on my
Disinfopedia. Right now it's running the Wikipedia scripts which I
downloaded about three months ago. I'm having some trouble and would
appreciate answers to a few questions.
(1) My immediate *reason* for wanting to upgrade is that my web host
says the existing script "has driven the server load to unbearable
proportions and even caused the server to crash which required a
manual reboot." We got a significant upward spike in usage on Sunday,
which probably accounts for the problem. My first question is: Have
changes made during the past three months improved the efficiency of
the scripts in ways that might reduce the server load? If not, maybe
there's no need for me to upgrade the scripts at this time.
(2) I used CVS to install the new scripts at a temporary URL for
testing purposes, but I haven't been able to get them working. I
compared my current database schema to the schema in buildTables.sql,
and it looks like a number of changes have been made, including:
* In table "user," the field "user_newtalk" has been dropped.
* A table "user_newtalk" has been added.
* In table "cur," the fields "cur_ind_title" and
"cur_ind_text" have
been dropped.
* In table "math," the field "math_html_conservative" has been
renamed to "math_html_conservativeness," and a new field
"math_mathml" has been added.
* A table "searchindex" has been added.
I'm assuming that these differences account for the failure of the
current scripts to run my existing database. I could use SQL queries
to add and delete the necessary fields, but I'm nervous about
screwing something up. What's the best way to proceed?
Mil gracias!
--
--------------------------------
| Sheldon Rampton
| Editor, PR Watch (
www.prwatch.org)
| Author of books including:
| Friends In Deed: The Story of US-Nicaragua Sister Cities
| Toxic Sludge Is Good For You
| Mad Cow USA
| Trust Us, We're Experts
--------------------------------