Hi all... this is my first message on this list.
The Problem: I created a wiki web site based on MediaWiki 1.10.1 and MySQL 4.1.22 (with phpMyAdmin 2.8.1 and MySQL client: 4.1.10). It works fine, until some days ago, when I encountered a memory error removing some page.
I check for the query causing the error and tested it directly in phpMyAdmin: same result! "5: Out of memory (Needed 7938020 bytes)"
The SELECT works fine (it returns 3 records), but it result in error with INSERT INTO.
Any hints? What can I ask to ISP that host my web site?
TIA
Giuseppe Briotti
Information following:
Query ------------------------------------------------------------------------- INSERT INTO `wiki_archive` (ar_namespace,ar_title,ar_comment,ar_user,ar_user_text,ar_timestamp, ar_minor_edit,ar_rev_id,ar_text_id,ar_text,ar_flags,ar_len) SELECT page_namespace, page_title, rev_comment, rev_user, rev_user_text, rev_timestamp, rev_minor_edit, rev_id, rev_text_id, '', '', rev_len FROM `wiki_page`,`wiki_revision` WHERE page_id = '424' AND (page_id = rev_page)
Table wiki_archive: ------------------------------------------------------------------------- Field Type Null Default ar_namespace int(11) No 0 ar_title varchar(255) No ar_text mediumblob No ar_comment tinyblob No ar_user int(10) No 0 ar_user_text varchar(255) No ar_timestamp var(14) No ar_minor_edit tinyint(4) No 0 ar_flags tinyblob No ar_rev_id int(10) Sì NULL ar_text_id int(10) Sì NULL ar_deleted tinyint(3) No 0 ar_len int(10) Sì NULL
Index: Key name Type Card. Fields name_title_timestamp INDEX 1 ar_namespace, ar_title, ar_timestamp
Space used: Type Used Data 296 Bytes Index 3.072 Bytes Total 3.368 Bytes
Table wiki_page ------------------------------------------------------------------------- Field Type Null Default page_id int(10) No page_namespace int(11) No 0 page_title varchar(255) No page_restrictions tinyblob No page_counter bigint(20) No 0 page_is_redirect tinyint(3) No 0 page_is_new tinyint(3) No 0 page_random double No 0 page_touched var(14) No page_latest int(10) No 0 page_len int(10) No 0
Index: Key name Type Card. Fields PRIMARY PRIMARY 442 page_id name_title UNIQUE 442 page_namespace, page_title page_random INDEX 442 page_random page_len INDEX 147 page_len
Space used: Type Used Data 28.936 Bytes Index 29.696 Bytes Total 58.632 Bytes
Table wiki_revision ------------------------------------------------------------------------- Field Type Null Default rev_id int(10) No rev_page int(10) No 0 rev_text_id int(10) No 0 rev_comment tinyblob No rev_user int(10) No 0 rev_user_text varchar(255) No rev_timestamp var(14) No rev_minor_edit tinyint(3) No 0 rev_deleted tinyint(3) No 0 rev_len int(10) Sì NULL rev_parent_id int(10) Sì NULL
Index: Key name Type Card. Fields PRIMARY PRIMARY 1274 rev_page, rev_id rev_id UNIQUE 1274 rev_id rev_timestamp INDEX 1274 rev_timestamp page_timestamp INDEX 1274 rev_page, rev_timestamp user_timestamp INDEX 1274 rev_user, rev_timestamp usertext_timestamp INDEX 1274 rev_user_text, rev_timestamp
Space used: Type Used Data 91.496 Bytes Index 142.336 Bytes Total 233.832 Bytes
--
Giuseppe Briotti g.briotti@mclink.it
"Alme Sol, curru nitido diem qui promis et celas aliusque et idem nasceris, possis nihil urbe Roma visere maius." (Orazio)