Problem upgrading to MediaWiki 1.6.5 - 'job' table SQL

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem upgrading to MediaWiki 1.6.5 - 'job' table SQL

James Grimwood
Hello,

I've come across a problem when upgrading my wiki from 1.5.4...

Not having commandline php on this machine I resorted to running the web-based
setup script again however, when updating the database, the following error
appears:

-----------------------
PHP 5.0.5-pl3-gentoo installed
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.
Neither Turck MMCache nor eAccelerator are installed, can't use object caching
functions
Found GNU diff3: /usr/bin/diff3.
Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you
enable uploads.
Found GD graphics library built-in.
Installation directory: /home/james/public_html/wiki
Script URI path: /wiki
Environment checked. You can install MediaWiki.
Generating configuration file...
Database type: mysql
Attempting to connect to database server as piku...success.
Connected to 5.0.16-log
Database piku exists
There are already MediaWiki tables in this database. Checking if updates are
needed...
...hitcounter table already exists.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...logging table already exists.
...validate table already exists.
...user_newtalk table already exists.
...transcache table already exists.
...trackbacks table already exists.
...externallinks table already exists.
Creating job table...Query "CREATE TABLE `mw_job` (
 job_id int(9) unsigned NOT NULL auto_increment,
 job_cmd varchar(255) NOT NULL default '',
 job_namespace int NOT NULL,
 job_title varchar(255) binary NOT NULL,
 job_params blob NOT NULL default '',
 PRIMARY KEY job_id (job_id),
 KEY (job_cmd, job_namespace, job_title)
 ) TYPE=InnoDB
" failed with error code "Specified key was too long; max key length is 1024
bytes (localhost)".
-------------------------------

What can I do to fix this?

Thanks.

--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
Code & Projects - http://www.piku.org.uk
Photos          - http://www.piku.co.uk
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Problem upgrading to MediaWiki 1.6.5 - 'job' table SQL

Rob Church
On 22/05/06, James <[hidden email]> wrote:
> Hello,
>
> I've come across a problem when upgrading my wiki from 1.5.4...
>
> Not having commandline php on this machine I resorted to running the web-based
> setup script again however, when updating the database, the following error
> appears:

<snipped>

See http://bugzilla.wikimedia.org/show_bug.cgi?id=4445 for possible
workarounds to the problem.


Rob Church
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Problem upgrading to MediaWiki 1.6.5 - 'job' table SQL

Hans Voss
I ran into the same problem (with the key for the job table) installing
1.6.6 only in my case the database reported only 500 bytes for the key. I
went into the tables.sql file and removed the offending key.

Does anyone know how this will affect the wiki?

On 5/23/06, Rob Church <[hidden email]> wrote:

>
> On 22/05/06, James <[hidden email]> wrote:
> > Hello,
> >
> > I've come across a problem when upgrading my wiki from 1.5.4...
> >
> > Not having commandline php on this machine I resorted to running the
> web-based
> > setup script again however, when updating the database, the following
> error
> > appears:
>
> <snipped>
>
> See http://bugzilla.wikimedia.org/show_bug.cgi?id=4445 for possible
> workarounds to the problem.
>
>
> Rob Church
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>



--
----
Met vriendelijke groeten / With kind regards
Hans Voss
---------------------------------------
google talk enabled
I am looking for people to invite to Gmail. I have 96 invitations left.
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Problem upgrading to MediaWiki 1.6.5 - 'job' table SQL

James Grimwood
In reply to this post by Rob Church
On Tuesday 23 May 2006 17:47, Rob Church wrote:

> On 22/05/06, James <[hidden email]> wrote:
> > Hello,
> >
> > I've come across a problem when upgrading my wiki from 1.5.4...
> >
> > Not having commandline php on this machine I resorted to running the
> > web-based setup script again however, when updating the database, the
> > following error appears:
>
> <snipped>
>
> See http://bugzilla.wikimedia.org/show_bug.cgi?id=4445 for possible
> workarounds to the problem.

Thanks. I found that bug entry by accident while looking for something else on
Meta. As far as I can tell, it's all working again now.

--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
Code & Projects - http://www.piku.org.uk
Photos          - http://www.piku.co.uk
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l