Hmm, that seemed to have only changed the error. Initially, I created the
table and inserted the values based off of what you just sent me, and it was
telling me that there was a duplicate entry '8-1movedto2', which I thought
might have been the result of a typo considering the values in the insert
command 8 & 1movedto2 were right next to each other. I doulbe-checked and I
had typed it in exactly as you had written me. As a test, I dropped the
table and recreated it without manually inserting the values, which resulted
in this interesting tidbit:
A database error has occurred
Query: UPDATE `page` SET page_latest = '2',page_touched =
'20051019193728',page_is_new = '0',page_is_redirect = '',page_len
= '14'
WHERE page_id = '1'
Function: Article::updateToRevision
Error: 1366 Incorrect integer value: '' for column 'page_is_redirect' at
row
1 (localhost)
I'm not sure, but it seems to me that the field page_is_redirect was
created to take an integer value (0 or 1) as a true/false switch to
determine if the page was a redirect or not. Why then would the
MW1.5installer try to push no values into the field? Even when the
table was
created, it was set with a default of 0.
Very confused but appreciative of your help,
-Evan
On 10/19/05, Maurice Joseph <teamspike(a)spikesource.com> wrote:
Evan;
Unfortunately, I don't have access to a MySQL 5 installation. Is MW
compatible
with Mysql 5? I didn't see anything in the documentation about MySQL
version
compatiblity. Can you install Mysql 4.x instead?
You can try performing the insert directly in the database. I extracted
this
sql from my local install of MW 1.5rc4.
1. Login to mysql
- mysql -u username -p<password> <dbname> e.g. mysql -u mjoseph
-psillyrabbit test
2. execute this command:
CREATE TABLE mw_page (
page_id int(8) unsigned NOT NULL auto_increment,
page_namespace int(11) NOT NULL default '0',
page_title varchar(255) binary NOT NULL default '',
page_restrictions tinyblob NOT NULL,
page_counter bigint(20) unsigned NOT NULL default '0',
page_is_redirect tinyint(1) unsigned NOT NULL default '0',
page_is_new tinyint(1) unsigned NOT NULL default '0',
page_random double unsigned NOT NULL default '0',
page_touched varchar(14) binary NOT NULL default '',
page_latest int(8) unsigned NOT NULL default '0',
page_len int(8) unsigned NOT NULL default '0',
PRIMARY KEY (page_id),
UNIQUE KEY name_title (page_namespace,page_title),
KEY page_random (page_random),
KEY page_len (page_len)
) TYPE=InnoDB;
3. execute this command:
INSERT INTO mw_page VALUES
(1,8,'1movedto2','sysop',0,0,0,0.239185610622,'20050709001117',937,14);