unlock the front page :-( ... everyone put it on your watchlist, turn email changes on in your prefs ... use the wiki way instead of the old way. Countrymike 06:56, 3 September 2007 (NZST)
the email link on this page is bouncing back messages Counting The Beat
Thanks Counting - I'll get onto finding out why ASAP Bruced 15:22, 11 September 2007 (NZST)
Anyone want to write/contribute to a political history of Waiheke, the workings of the former County Council, amalgamation and further issues?
I can suggest a few for sure, Dr Vexation , Tihare , Scuttlefish , and of course a man who is an absolute passionate flamin' expert on the topic, the venerable Hackademic, and of course for a spot of wiki discours I'd chat with Countrymike. Bruced 21:22, 18 September 2007 (NZST)
See Political History for a start Bruced 21:29, 18 September 2007 (NZST)
Can we have a listing/linking of blogs written by Waihekeans?
Good idea. I've created a blogs page - just add any you know of. hackademic 11:57, 20 September 2007 (NZST)
Except Bruce beat me to it! hackademic
Heehehehehee it's called Blogs Bruced
And beat you to a homepage news item tsk tsk old man !! Bruced
Um...it was kind of ok for a while .. but now it's just annoying. It's kind of one of the early rules of web design - not to have too many flashing things around when people are trying to read ... not to mention that I don't know what a kts is or a NW 115, and every page? theres a link to the weather which should be enough, eh? Countrymike 14:02, 21 September 2007 (NZST)
Geee where did it go? ... that annoying weather thing ? CountryMike I cant agree that there was too many flashing things on the page because the weather thing was the only flashing thing on an otherwise static page so I think the "early rules of web design" argument doesnt stand - have removed it anyhow - it was ugly and it's mother had dressed it funny !! Bruced
We've fixed it's little red wagon now !!!! Bruced
Hi, I have a question around firefox... which is what I use mostly. It seems that firefox displays pages differently to IE. I get a page looking ok with firefax then when it gets "tidied up" using IE, firfox ends up a mess... Is there something obvious I should know.
I have just been testing it here at work.. its all fine with Firefox here, At home I have photos on top of others and things like , you have to edit and move pictures way down the page to get it looking ok... maybe its a caching thing.. odd.
Unfortunately exactly one day after I had created the Maps category and worked on all the maps on this site Google has revoked support for the way the gmap tags works on this site: Discussion about the issue This is the message displayed in the Error Console:
Error: G_MAP_TYPE is not defined Sourcefile: http://www.waihekepedia.com/index.php?title=Map Line: 42
Fortunately the discussion above also contains what has to be done to get things running again. Could one of the site admins please get active ...
User:Tihare and User:Wolfgang Fahl did the following today to fix the GoogleMaps API problem and upgrade the server:
Problem 11:00:51
need to upgrade Wiki on Waihekepedia
Diagnosis
see http://www.mediawiki.org/wiki/Upgrading
Therapy
do the mysql backups as recommended download to luna
19.11.2008 10:44 9.882.889 waihekepedia2008-11-19.sql 19.11.2008 10:52 15.206.248 waihekepedia2008-11-19.xml -rw-r--r-- 1 root root 63371235 2008-11-19 10:59 waihekepedia2008-11-19.tgz
Problem 11:25:33
need new version of Mediawiki
Diagnosis
follow instructions [http://www.mediawiki.org/wiki/Upgrading
Therapy
#get new version of Mediawiki cd /tmp wget http://download.wikimedia.org/mediawiki/1.13/mediawiki-1.13.2.tar.gz # rename old web site httpdocs mv httpdocs/ httpdocs2008-11-19 # unpack new version of Mediawiki tar xvfz /tmp/mediawiki-1.13.2.tar.gz # move the Mediawiki to the defined place mv mediawiki-1.13.2/ httpdocs # change permissions root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# chown -R waihekepedia.psaserv httpdocs # this is what we've got now: # drwxr-x--- 16 waihekepedia psaserv 4096 2008-10-03 06:16 httpdocs # drwxr-x--- 20 waihekepedia psaserv 4096 2008-09-18 16:58 httpdocs2008-11-19 # copy the local settings back root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# cp ../httpdocs2008-11-19/LocalSettings.php . # put it under version control mkdir RCS # check the current version into the RCS archive ci -l LocalSettings.php # strip dos cr/lf from the file dos2unix LocalSettings.php # copy old mediawiki images files cp -pr ../httpdocs2008-11-19/mediawiki/ mediawiki # remove unnecessary old stuff root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/mediawiki# rm LocalSettings.php # remove test (don't try this at home ...) root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/mediawiki#rm -rf test # change permissions on files created by root root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# chown -R waihekepedia.psaserv LocalSettings.php root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# chown -R waihekepedia.psaserv RCS # create the AdminSettings.php root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# cp AdminSettings.sample AdminSettings.php # modify it (not shown here - the mysql admin password is set in there ... # run the update script cd maintainance php update.php # get some error message for missing extensions like Wikilace # wait a while ...
Problem 11:50:00
Followup problems due to missing extensions / wrong version of extensions
Diagnosis
root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/maintenance# php update.php
Warning: putenv(): Safe Mode warning: Cannot set environment variable 'TZ' - it's not in the allowed list in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 100 Warning: include(): Unable to access /var/www/vhosts/waihekepedia.com/httpdocs/extensions/WikiLace.php in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 105 Warning: include(/var/www/vhosts/waihekepedia.com/httpdocs/extensions/WikiLace.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 105 Warning: include(): Unable to access /var/www/vhosts/waihekepedia.com/httpdocs/extensions/WikiLace.php in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 105 Warning: include(/var/www/vhosts/waihekepedia.com/httpdocs/extensions/WikiLace.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 105 Warning: include(): Failed opening '/var/www/vhosts/waihekepedia.com/httpdocs/extensions/WikiLace.php' for inclusion (include_path='.:/var/www/vhosts/waihekepedia.com/httpdocs:/var/www/vhosts/waihekepedia.com/httpdocs/includes:/var/www/vhosts/waihekepedia.com/httpdocs/languages') in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 105 Warning: include(extensions/flashmp3.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 106 Warning: include(extensions/flashmp3.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 106 Warning: include(): Failed opening 'extensions/flashmp3.php' for inclusion (include_path='.:/var/www/vhosts/waihekepedia.com/httpdocs:/var/www/vhosts/waihekepedia.com/httpdocs/includes:/var/www/vhosts/waihekepedia.com/httpdocs/languages') in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 106 Warning: include(extensions/gmaps.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 107 Warning: include(extensions/gmaps.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 107 Warning: include(): Failed opening 'extensions/gmaps.php' for inclusion (include_path='.:/var/www/vhosts/waihekepedia.com/httpdocs:/var/www/vhosts/waihekepedia.com/httpdocs/includes:/var/www/vhosts/waihekepedia.com/httpdocs/languages') in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 107 Warning: include(extensions/mp3.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 108 Warning: include(extensions/mp3.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 10 Warning: include(): Failed opening 'extensions/mp3.php' for inclusion (include_path='.:/var/www/vhosts/waihekepedia.com/httpdocs:/var/www/vhosts/waihekepedia.com/httpdocs/includes:/var/www/vhosts/waihekepedia.com/httpdocs/languages') in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 108 Warning: include(extensions/youTube.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 10 Warning: include(extensions/youTube.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 109 Warning: include(): Failed opening 'extensions/youTube.php' for inclusion (include_path='.:/var/www/vhosts/waihekepedia.com/httpdocs:/var/www/vhosts/waihekepedia.com/httpdocs/includes:/var/www/vhosts/waihekepedia.com/httpdocs/languages') in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 109 Warning: include_once(extensions/rss.php): failed to open stream: No such file or directory in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 110 Warning: include_once(): Failed opening 'extensions/rss.php' for inclusion (include_path='.:/var/www/vhosts/waihekepedia.com/httpdocs:/var/www/vhosts/waihekepedia.com/httpdocs/includes:/var/www/vhosts/waihekepedia.com/httpdocs/languages') in /var/www/vhosts/waihekepedia.com/httpdocs/LocalSettings.php on line 110 MediaWiki 1.13.2 Updater Going to run database updates for waihekepedia Depending on the size of your database this may take a while! Abort with control-c in the next five seconds...0 ...have ipb_id field in ipblocks table. ...have ipb_expiry field in ipblocks table. ...already have interwiki table ...indexes seem up to 20031107 standards ...hitcounter table already exists. ...have rc_type field in recentchanges table. ...have user_real_name field in user table. ...querycache table already exists. ...objectcache table already exists. ...categorylinks table already exists. Already have pagelinks; skipping old links table updates. ...have rc_ip field in recentchanges table. ...image primary key already set. ...have rc_id field in recentchanges table. ...have rc_patrolled field in recentchanges table. ...logging table already exists. ...have user_token field in user table. The watchlist table is already set up for email notification. Adding missing watchlist talk page rows... ok ...user table does not contain old email authentication field. ...page table already exists. ...have log_params field in logging table. logging table has correct log_title encoding. ...have ar_rev_id field in archive table. ...have page_len field in page table. revision timestamp indexes already up to 2005-03-13 ...rev_text_id already in place. ...have rev_deleted field in revision table. ...have img_width field in image table. ...have img_metadata field in image table. ...have user_email_token field in user table. ...have ar_text_id field in archive table. ...page_namespace is already a full int (int(11)). ...ar_namespace is already a full int (int(11)). ...rc_namespace is already a full int (int(11)). ...wl_namespace is already a full int (int(11)). ...qc_namespace is already a full int (int(11)). ...log_namespace is already a full int (int(11)). ...have img_media_type field in image table. ...already have pagelinks table. No img_type field in image table; Good. Already have unique user_name index. ...user_groups table already exists. ...user_groups is in current format. ...have ss_total_pages field in site_stats table. ...user_newtalk table already exists. Creating transcache table...ok ...have iw_trans field in interwiki table. ...trackbacks table already exists. Making wl_notificationtimestamp nullable... ok Adding timestamp key on logging table... ok Adding ipb_range_start field to table ipblocks...ok Setting page_random to a random value on rows where it equals 0...changed 0 rows Adding user_registration field to table user...ok Creating templatelinks table... Populating... Done. Please run maintenance/refreshLinks.php for a more thorough templatelinks update. Creating externallinks table...ok Creating job table...ok Adding ss_images field to table site_stats...ok Creating langlinks table...ok Creating querycache_info table...ok Creating filearchive table...ok Adding ipb_anon_only field to table ipblocks...ok Checking for additional recent changes indices... ...index `rc_ns_usertext` not found; adding...done. ...index `rc_user_text` not found; adding...done. Adding user_newpass_time field to table user...ok Creating redirect table...ok Creating querycachetwo table...ok Adding ipb_enable_autoblock field to table ipblocks...ok Checking for backlinking indices... Checking if pagelinks index pl_namespace includes field pl_from... ...index pl_namespace on table pagelinks has no field pl_from; adding ...backlinking indices updated Adding rc_old_len field to table recentchanges...ok Adding user_editcount field to table user...ok Creating page_restrictions table...ok Migrating old restrictions to new table...ok Adding log_id field to table logging...ok Adding rev_parent_id field to table revision...ok ...have pr_id field in page_restrictions table. Adding rev_len field to table revision...ok Adding rc_deleted field to table recentchanges...ok Adding log_deleted field to table logging...ok Adding ar_deleted field to table archive...ok Adding ipb_deleted field to table ipblocks...ok Adding fa_deleted field to table filearchive...ok Adding ar_len field to table archive...ok Adding ipb_block_email field to table ipblocks...ok Checking for categorylinks indices... Checking if categorylinks index cl_sortkey includes field cl_from... ...index cl_sortkey on table categorylinks has no field cl_from; adding ...categorylinks indices updated Adding oi_metadata field to table oldimage...ok Adding usertext,timestamp key on archive table... ok Adding usertext,timestamp key on image table... ok Adding usertext,timestamp key on oldimage table... ok Adding ar_page_id field to table archive...ok Adding img_sha1 field to table image...ok Creating protected_titles table...ok Adding ipb_by_text field to table ipblocks...ok Creating page_props table...ok Creating updatelog table...ok Creating category table...ok Populating category table, printing progress markers. For large databases, you may want to hit Ctrl-C and do this manually with maintenance/ populateCategory.php. Category population complete. Done populating category table. Adding ar_parent_id field to table archive...ok Adding user_last_timestamp field to table user_newtalk...ok Populating rev_parent_id column ...doing rev_id from 1 to 200 ...doing rev_id from 200 to 399 ...doing rev_id from 399 to 598 ...doing rev_id from 598 to 797 ...doing rev_id from 797 to 996 ...doing rev_id from 996 to 1195 ...doing rev_id from 1195 to 1394 ...doing rev_id from 1394 to 1593 ...doing rev_id from 1593 to 1792 ...doing rev_id from 1792 to 1991 ...doing rev_id from 1991 to 2190 ...doing rev_id from 2190 to 2389 ...doing rev_id from 2389 to 2588 ...doing rev_id from 2588 to 2787 ..doing rev_id from 2588 to 2787 ...doing rev_id from 2787 to 2986 ...doing rev_id from 2986 to 3185 ...doing rev_id from 3185 to 3384 ...doing rev_id from 3384 to 3583 ...doing rev_id from 3583 to 3782 ...doing rev_id from 3782 to 3981 ...doing rev_id from 3981 to 4180 ...doing rev_id from 4180 to 4379 ...doing rev_id from 4379 to 4578 ...doing rev_id from 4578 to 4777 ...doing rev_id from 4777 to 4976 ...doing rev_id from 4976 to 5175 ...doing rev_id from 5175 to 5374 ...doing rev_id from 5374 to 5573 ...doing rev_id from 5573 to 5772 ...doing rev_id from 5772 to 5971 ...doing rev_id from 5971 to 6170 ...doing rev_id from 6170 to 6369 ...doing rev_id from 6369 to 6568 rev_parent_id population complete ... 6250 rows [4058 changed] protected_titles table has correct pt_title encoding. Checking filearchive indices... ...filearchive indices updated Updating password hash format...done Deleting old default messages (this may take a long time!)...Done Checking site_stats row...ok. Purging caches...done. Done.
Therapy
root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# cp -pr ../../httpdocs2008-11-19/extensions/* .
Problem 11:55:05
main page fails
Diagnosis
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "". MySQL returned error "1146: Table 'waihekepedia.cur' doesn't exist (localhost)".
mysql> select page_title,page_id,page_namespace from page where page_title like 'Front%'; +-----------------+---------+----------------+ | page_title | page_id | page_namespace | +-----------------+---------+----------------+ | FrontPageBoxOne | 1611 | 10 | +-----------------+---------+----------------+
mysql> select count(*), ar_namespace from archive group by 2; +----------+--------------+ | count(*) | ar_namespace | +----------+--------------+ | 262 | 0 | | 3 | 1 | | 2 | 2 | | 14 | 6 | | 1275 | 8 | +----------+--------------+
mysql> select count(*),page_namespace from page group by 2; +----------+----------------+ | count(*) | page_namespace | +----------+----------------+ | 434 | 0 | | 49 | 1 | | 31 | 2 | | 38 | 3 | | 6 | 4 | | 1 | 5 | | 276 | 6 | | 2 | 7 | | 1 | 8 | | 3 | 10 | | 1 | 11 | | 2 | 12 | | 39 | 14 | +----------+----------------+ https://elearning.mat.univie.ac.at/physikwiki/index.php/Benutzer:Peter.reisinger@univie.ac.at/MYSQL SELECT text.old_text FROM page,revision,text where page.page_title="LV-Uebersicht/WS07_08/Videos" && page.page_namespace=200 && page.page_id=revision.rev_page && revision.rev_text_id=text.old_id ORDER BY revision.rev_text_id DESC LIMIT 0 , 1; SELECT text.old_text FROM page,revision,text where page.page_title="FrontPageBoxOne" && page.page_namespace=200 && page.page_id=revision.rev_page && revision.rev_text_id=text.old_id ORDER BY revision.rev_text_id DESC LIMIT 0 , 1;
Therapy
exchange mainpage for the time being remove {{:Recent Pages}} by creating a copy of FrontPageBoxOne template as FrontPageBoxTwo and linking that to the mainpage
Problem 12:02:23
need new gmaps plugin
Diagnosis
http://www.mediawiki.org/wiki/Extension:Google_Maps/Installation
Therapy
wget http://emiller.info/maps/GoogleMaps-0.9.3.zip unzip to extensions directory change permissions change LocalSettings.php check in old gmaps.php to RCS remove old gmaps.php
RCS file: RCS/LocalSettings.php,v
retrieving revision 1.2
diff -r1.2 LocalSettings.php
107c107,110
< include("extensions/gmaps.php");
---
> # old GoogleMaps file
> #include("extensions/gmaps.php");
> $wgGoogleMapsKey = "ABQIAAAAOOuhOGIbrJKMrqpyEDs5ARTowFD0ZkrWbaBDtb_Ki1YlnoUgmBQtFvCGEps07muPB3utXsOzAgZ3kA";
> require_once( "extensions/GoogleMaps/GoogleMaps.php" );
113c116
< $wgMaxUploadSize = '8MB';?>
\ No newline at end of file
---
> $wgMaxUploadSize = '8MB';?>
Problem 13:12:26
Recent Pages don't work any more
Diagnosis
http://www.mediawiki.org/wiki/Extension:Newest_Pages_Blog
http://nusunt.eu/download/mw_newestpageblog_1.1.zip
http://dev.nomadicscribe.net/mediawiki/downloads/NewestPagesBlog_php.txt http://dev.nomadicscribe.net/mediawiki/downloads/NewestPagesBlog.i18n_php.txt
Therapy
# save old version to RCS ci -l NewestPagesBlog.i18n.php ci -l NewestPagesBlog.php # download new vesion root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# wget http://dev.nomadicscribe.net/mediawiki/downloads/NewestPagesBlog.i18n_php.txt root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# wget http://dev.nomadicscribe.net/mediawiki/downloads/NewestPagesBlog_php.txt # mv files to the correct location root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# mv NewestPagesBlog.i18n_php.txt NewestPagesBlog.i18n.php root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# mv NewestPagesBlog_php.txt NewestPagesBlog.php #change owner chown -R waihekepedia.psacln * # actually it is the same version - it's never been used? # activate it root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# rcsdiff LocalSettings.php =================================================================== RCS file: RCS/LocalSettings.php,v retrieving revision 1.3 diff -r1.3 LocalSettings.php 115c115,117 < $wgMaxUploadSize = '8MB';?> --- > $wgMaxUploadSize = '8MB'; > require_once( 'extensions/NewestPagesBlog.php' ); > ?>
Problem 13:25:46
Recent Pages looks differently
Diagnosis
need to change parameters according to: http://dev.nomadicscribe.net/mediawiki/downloads/NewestPagesBlog.readme.txt
Therapy
add limit and namespace
Problem 14:20
RSS extension may need update. pages with RSS seem to be broken see: Waiheke Radio
Diagnosis Try upgrading: http://www.mediawiki.org/wiki/Extension:RSS
Countrymike 14:21, 19 November 2008 (NZDT)
Therapy
check in old rss extension version
root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# ci -l rss.php RCS/rss.php,v <-- rss.php enter description, terminated with single '.' or end of file: NOTE: This is NOT the log message! >> . initial revision: 1.1 done
create new content of rss.php from http://www.mediawiki.org/wiki/Extension:RSS page
# create symbolic link so that the rss.php runs unchanged root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# ln -s magpierss-0.72/ magpierss
Problem 16:20
Recent Pages do not work as before
Diagnosis
FrontPageBoxOne is now working again
Therapy
Delete other version and use the old one again Wolfgang Fahl 16:39, 19 November 2008 (NZDT)