| View previous topic :: View next topic |
| Author |
Message |
hothead
Apprentice
Joined: 02 Jul 2004
Posts: 277
Location: /dev/core
|
 Posted: Sat Dec 24, 2005 2:51 am Post subject: mediawiki mysql problem 'Creating categorylinks table' |
 |
|
Hi,
I'm trying to set up wikipedia for offline use on my laptop.
Unfortunately I run into a problem when generating the
mediawiki config file through the web interface ( http://localhost/mediawiki/config/)
Any suggestion?
| Code: |
PHP 4.4.0-pl1-gentoo: ok
PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
Have XML / Latin1-UTF-8 conversion support.
PHP is configured with no memory_limit.
Have zlib support; enabling output compression.
Turck MMCache not installed, can't use object caching functions
Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.
Found GD graphics library built-in.
Installation directory: /var/www/localhost/htdocs/mediawiki
Script URI path: /mediawiki
Connected as root (automatic)
Connected to database... 4.1.14-log; enabling MySQL 4 enhancements
Database MEDIAWIKIDB exists
There are already MediaWiki tables in this database. Checking if updates are needed...
Granting user permissions...
...linkscc table already exists.
...hitcounter table already exists.
...querycache table already exists.
...objectcache table already exists.
Creating categorylinks table...Query "CREATE TABLE categorylinks ( cl_from int(8) unsigned NOT NULL default '0', cl_to varchar(255) binary NOT NULL default '', cl_sortkey varchar(255) binary NOT NULL default '', cl_timestamp timestamp NOT NULL, UNIQUE KEY cl_from(cl_from,cl_to), KEY cl_sortkey(cl_to,cl_sortkey(128)), KEY cl_timestamp(cl_to,cl_timestamp) )" failed with error code "".
|
_________________
Got a question? - http://justfuckinggoogleit.com/ |
|
| Back to top |
|
 |
cantao
Apprentice
Joined: 07 Jan 2004
Posts: 166
|
| Posted: Wed Feb 01, 2006 3:36 am Post subject: |
|
|
Same problem here, still trying to figure out a solution...
Cheers, Cantão! |
|
| Back to top |
|
|
cantao
Apprentice
Joined: 07 Jan 2004
Posts: 166
|
| Posted: Thu Feb 02, 2006 12:41 am Post subject: Solved :) |
|
|
The root of all evil is UTF8.
I guess I've managed to fix the problem by setting -utf8 as a use flag to mysql and re-emerging it. Proceed with the usual etc-update stuff. It's very important because it will change /etc/mysql/my.cnf in order to turn off UTF8 in mysql.
Just to be sure, I've destroyed the MediaWiki databases and recreated it from zero.
Worked like a charm 
Cheers, Cantão! |
|
| Back to top |
|
|
andrew.pierson
n00b
Joined: 25 Oct 2004
Posts: 7
|
| Posted: Tue May 09, 2006 10:19 pm Post subject: Did it from the top |
|
|
This works fine until you want to add math support, with only seems to work with utf8. (If anyone knows a way to get it working with latin1, please post!)
However, you can get things running with utf8 by manually changing /var/www/localhost/htdocs/mediawiki/maintenance/tables.sql before going to the wiki config screen from
| Code: | | "...KEY cl_sortkey(cl_to,cl_sortkey(128)..." |
to
| Code: | | "...KEY cl_sortkey(cl_to,cl_sortkey(78)..." |
If you forget, just clear your cache. (Restarting apache is one way to do this.)
Hope this gives you more options, which is what Gentoo is all about!
I got this information from http://bugzilla.wikipedia.org/show_bug.cgi?id=1322 on post #11. Thank you, Dmytro Mykhaylov! |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
