[sorry for the duplicate message, forgot to CC to the list]
That might be it but, the directions dont ask me to run those scripts separately, as far as I can see?
http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki
I followed the Alternative 2, which just asked me to re-run the installer. In that, it says:
- "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema."
--- On Tue, 8/26/08, Eric K <ek79501(a)yahoo.com> wrote:
From: Eric K <ek79501(a)yahoo.com>
Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations
To: "Sullivan, James (NIH/CIT) [C]" <sullivan(a)mail.nih.gov>
Date: Tuesday, August 26, 2008, 7:19 AM
That might be it but, the directions dont ask me to run those scripts separately, as far as I can see?
http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki
I followed the Alternative 2, which just asked me to re-run the installer. In that, it says:
- "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema."
hmmm.
--- On Tue, 8/26/08, Sullivan, James (NIH/CIT) [C] <sullivan(a)mail.nih.gov> wrote:
From: Sullivan, James (NIH/CIT) [C] <sullivan(a)mail.nih.gov>
Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations
To: ek79501(a)yahoo.com, "MediaWiki announcements and site admin list" <mediawiki-l(a)lists.wikimedia.org>
Date: Tuesday, August 26, 2008, 6:44 AM
After upgrading the Mediawiki code did you run:
maintenance/update.php
and
maintenance/refreshLinks.php
?
-Jim
-----Original Message-----
From: Eric K [mailto:ek79501@yahoo.com]
Sent: Monday, August 25, 2008 9:27 PM
To: mediawiki-l(a)lists.wikimedia.org
Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix
of collations
Here's what I found. When Mediawiki upgrades, it doesnt seem to care to
update the table schemes properly. Here's a sample of what I found:
Old table row specs, for mw_image (this is after the upgrade has been applied
from 1.9.3 to 1.13.0):
img_size int(8)
img_width int(5)
img_height int(5)
New table row specs for the same table, mw_image (for a brand new 1.13.0
installation):
img_size int(10)
img_width int(11)
img_height int(11)
The field sizes are different as you can see. New tables have bigger fields but
the old ones still contain short fields after the upgrade is applied.This is
just an example. The bug that I was getting (illegal mix of collations), was
fixed due to the Collation fields being different in the cases for an upgraded
MW and a new MW. I also noticed differences in all the other fields as well
(Default, Type, Binary, Attributes) for tables rows. Sometimes the differences
were significant. Here are some real examples:
- length of data field doubled for example, int(5) to int (10)
- the Type changed in an upgraded version from "varbinary(255)" to
"blob", in a new installation
Usually, Collate was empty for a brand new 1.13.0, while it was latin_bin or
latin1_swedish_ci for an upgraded version.
There must be important reasons why changes were made to the rows as versions
progressed.
So i guess this is something that should be fixed for upgrading? That means,
when an upgrade is being applied, it should update all the row data for each
table as well.
Erik
--- On Sat, 8/23/08, Eric K <ek79501(a)yahoo.com> wrote:
From: Eric K <ek79501(a)yahoo.com>
Subject: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegal mix of
collations
To: mediawiki-l(a)lists.wikimedia.org
Date: Saturday, August 23, 2008, 11:30 AM
Everything works on my wiki, except when I view the logs for a page, I get this
error:
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 "LinkCache::addLinkObj". MySQL returned error
"1267: Illegal mix of collations (latin1_bin,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=' (localhost)".
Any ideas on how to fix this? I can go into myPhPAdmin and manipulate tables if
needed.
thanks
Eric
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Henny Savenije wrote:
> images not showing after upgrade
>
> MediaWiki 1.13.0
> PHP 5.2.5
> MySQL 4.1.22 (client)
> MySQL 5.0.62 (server)
> Apache/2.0.63 (CentOS)
>
> My site with image
>
> Hi I just upgraded 1.12.0 to 1.13.0, I know in the FAQ there is a
> solution FAQ but somehow it doesn't work. Even uploading a new file
> doesn't help either, since it doesn't show up either.
>
> Additionally, I found that somewhere the place where the images
> should be uploaded was changed, it used to be images/ and now it's
> public/ I just copied all the files from images/ to public but that
> doesn't give any joy either.
It didn't change. It is still images on your wiki.
> Does this ring any bell?
>
> I noticed one more thing. In the database now there are zeros added
> to images, users, usergroups and the like
>
> for instance
>
> Dorpspomp_Ruinen_08-07-1.jpg 49099 178 340 [BLOB - 1.1 KB] 8 BITMAP
> image jpeg\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
The problem is not with the images. Mediawiki just doesn't know how to
handle a file of type "image/jpeg����������������������������"
Seems your database corrupted on the update :S
Did you change table options?
What gives a DESCRIBE on those tables?
Hello everybody,
When I search after some terms, which have not been defined yet, or after editing an entry (but not always???), I get the following error message:
Database error
>From MiWiki
For query "sales"
Jump to: navigation, search
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 "1030: Got error 127 from storage engine (localhost)".
Has anybody had this error before? How may I fix it?
Thanks a lot in advance for your help and best regards,
Veronica
P.S: I found a similar message at the The Wikitech-l Archives, but in my case no table name was written, so what shall I do????
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
What would the easiest way be to move a MediaWiki installation from one
server to another? I have installed MySQL and PHP already on the new
server. What I had in mind was to setup the latest MediaWiki
installation on the new server, export all the pages and import them on
the new server. Is there an easier way?
Email Confidentiality Notice and Disclaimer-This email message contains information which may be confidential and/or legally privileged. Unless you are the intended recipient (or have been authorized to receive on behalf of the intended recipient), you may not use, copy or disclose to anyone the message or any information contained in the message or from any attachments that were sent with this email. If you have received this email message in error, please advise the sender by email and delete the message. Thank you.
images not showing after upgrade
MediaWiki 1.13.0
PHP 5.2.5
MySQL 4.1.22 (client)
MySQL 5.0.62 (server)
Apache/2.0.63 (CentOS)
My site with image
Hi I just upgraded 1.12.0 to 1.13.0, I know in the FAQ there is a
solution FAQ but somehow it doesn't work. Even uploading a new file
doesn't help either, since it doesn't show up either.
Additionally, I found that somewhere the place where the images
should be uploaded was changed, it used to be images/ and now it's
public/ I just copied all the files from images/ to public but that
doesn't give any joy either.
Any suggestions?
I noticed something else today, the full URL in the source is <a
href="/mediawiki/index.php/Afbeelding:Dorpspomp_Ruinen_08-07-1.jpg"
class="image" title="Dorpspomp Ruinen 08-07-1.jpg"><img alt=""
src="/mediawiki/skins/common/images/icons/fileicon.png" width="120"
height="120" border="0" /></a>
Does this ring any bell?
I noticed one more thing. In the database now there are zeros added
to images, users, usergroups and the like
for instance
Dorpspomp_Ruinen_08-07-1.jpg 49099 178 340 [BLOB - 1.1 KB] 8 BITMAP
image jpeg\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
Henny (Lee Hae Kang)
-----------------------------
http://www.henny-savenije.pe.kr Portal to all my sites
http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel free
to discover Korea with Hendrick Hamel (1653-1666)
http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean
http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch
http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen
and Eibokken and his first Korean-Dutch dictionary
http://www.cartography.henny-savenije.pe.kr (in English) Korea
through Western Cartographic eyes
http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon
http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures
http://www.british.henny-savenije.pe.kr A British encounter in Pusan (1797)
http://www.genealogy.henny-savenije.pe.kr/ Genealogy
http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies
Database::update ( $ table,
$ values,
$ conds,
$ fname = 'Database::update',
$ options = array()
)
UPDATE wrapper, takes a condition array and a SET array.
Parameters:
string $table The table to UPDATE
array $values An array of values to SET
array $conds An array of conditions (WHERE). Use '*' to update all rows.
string $fname The Class::Function calling this function (for the log)
array $options An array of UPDATE options, can be one or more of
IGNORE, LOW_PRIORITY
Should I pass $values already escaped?
Should I use some function indipendent from the db to escape it?
I can do it with mysql php escaping function, but I think it's no good
to use a DB specific function there... or isn't?
thank you.
-----Original Message-----
From: mediawiki-l-bounces(a)lists.wikimedia.org
[mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Eric
Hello, i'd like to use my own skin as defalut skin nammed vbwikiskin.
In localsetting.php :
I have : $wgDefaultSkin = 'vbwikiskin';
In my file VbWikiSkin.php :
I have : $this->skinname = 'vbwikiskin';
But still the old skin you can see here :
http://www.baldursgateworld.com/wiki/
An idee ? Thanks
_______________________________________________
-----Message d'origine-----
De : Christensen, Courtney [mailto:ChristensenC@BATTELLE.ORG]
Envoyé : lundi 18 août 2008 15:29
À : MediaWiki announcements and site admin list
Objet : [Mediawiki-l] RE: Skin by default / Skin par défaut
Hi Eric,
Just a test, but when you are logged into your wiki and you go to 'My
preferences,' do you see an option for your new skin? If not, then you
haven't set your skin up correctly yet. Also, please let us know more
details about your set-up.
Thanks and Good Luck!
-Courtney
_______________________________________________
Hi, the skin can be see in My preferences (vbWikiSkin (Prévisualiser)).
Moreover, if i am connected the skin is nice. It is just for guests and
google for exemple, there is not any skin. The skin is like this :
http://www.baldursgateworld.com/lacouronne/attachments/information-aide-anno
nces-et-reglements/2266d1219159163-wiki-bug-de-skin-skin.jpg
--------
But guest can see it like this :
http://74.125.39.104/search?q=cache:www.baldursgateworld.com/wiki/index.php/
Accueil
------
2008/8/25 Denny Vrandečić <dvr(a)aifb.uni-karlsruhe.de>
> Yes, sorry, this is my fault, because some internals were changed.
> In order to get that to work, please update also to the current SVN of
> SemanticGoogleMaps.
Yup, tried that and the problem is gone.
Thanks.
Regards,
Martin S
