Talk:Main Page/Archive 2007 - 2008

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)

Waiheke political history
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)

Waiheke blogs
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

Flashing Weather Graphic
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


 * Well... anything flashing on a page reminds me of an ad. Don't mind it if it's on the "weather" page, but it had ursurped it's place in society and was becoming an annoying child poking its flashiness in on every page. Countrymike 11:19, 5 October 2007 (NZST)

We've fixed it's little red wagon now !!!! Bruced

Editing/Formatting Question
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.


 * Not sure that I know what you mean. Do you have an example page that has been messed up? Countrymike 11:45, 8 October 2007 (NZDT)

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.


 * Image handling in MediaWiki leaves a bit to be desired and it's often the case where things can overlap etc. One trick that I've used quite a lot is to add this syntax  underneath the image or the paragraph that is covered over. Oh, and if you can sign your posts in these Talk pages then I won't think that I'm talking to a computer. Sign a post using 4 tildes, like this: ~ or use the signature image on the toolbar (second one from the right). Countrymike 15:17, 8 October 2007 (NZDT)

Googled Maps API changed
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 ...


 * I'll take a look at it but i'm away on holiday at the moment so will have to wait until next week. Countrymike 09:33, 30 October 2008 (NZDT)
 * I'm offering to help how could I get in touch? Wolfgang 07 November 2008
 * Wolfgang: actually there's nothing that I can do as I don't have access to the server or the code. Looks like we need to change the code on the extension to get this working again. I'll try to have a chat with User:Tihare to see if we can fix this. There has been talk of upgrading the mediawiki to the latest version but not completely sure when this will happen. Countrymike 10:10, 11 November 2008 (NZDT)

Waihekepedia Wiki update 2008-11-19
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

cd /tmp wget http://download.wikimedia.org/mediawiki/1.13/mediawiki-1.13.2.tar.gz mv httpdocs/ httpdocs2008-11-19 tar xvfz /tmp/mediawiki-1.13.2.tar.gz mv mediawiki-1.13.2/ httpdocs root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# chown -R waihekepedia.psaserv httpdocs root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# cp ../httpdocs2008-11-19/LocalSettings.php. mkdir RCS ci -l LocalSettings.php dos2unix LocalSettings.php cp -pr ../httpdocs2008-11-19/mediawiki/ mediawiki root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/mediawiki# rm LocalSettings.php root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/mediawiki#rm -rf test 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 root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs# cp AdminSettings.sample AdminSettings.php cd maintainance php update.php
 * 1) get new version of Mediawiki
 * 1) rename old web site httpdocs
 * 1) unpack new version of Mediawiki
 * 1) move the Mediawiki to the defined place
 * 1) change permissions
 * 1) this is what we've got now:
 * 2) drwxr-x--- 16 waihekepedia psaserv 4096 2008-10-03 06:16 httpdocs
 * 3) drwxr-x--- 20 waihekepedia psaserv 4096 2008-09-18 16:58 httpdocs2008-11-19
 * 4) copy the local settings back
 * 1) put it under version control
 * 1) check the current version into the RCS archive
 * 1) strip dos cr/lf from the file
 * 1) copy old mediawiki images files
 * 1) remove unnecessary old stuff
 * 1) remove test (don't try this at home ...)
 * 1) change permissions on files created by root
 * 1) create the AdminSettings.php
 * 1) modify it (not shown here - the mysql admin password is set in there ...
 * 2) run the update script
 * 1) get some error message for missing extensions like Wikilace
 * 2) 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 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

ci -l NewestPagesBlog.i18n.php ci -l NewestPagesBlog.php 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 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 chown -R waihekepedia.psacln * 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' ); > ?>
 * 1) save old version to RCS
 * 1) download new vesion
 * 1) mv files to the correct location
 * 1) change owner
 * 1) actually it is the same version - it's never been used?
 * 2) activate it

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 root@plesk:/var/www/vhosts/waihekepedia.com/httpdocs/extensions# ln -s magpierss-0.72/ magpierss
 * 1) create symbolic link so that the rss.php runs unchanged

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)