Hi,
we work step by step on the Update from 1.4.7 to 1.5.8
What we found now was due the update this failure:
--------------
** Rebuilding recentchanges table:
Loading from page and revision tables...
A database error has occurred
INSERT rev_timestamp 5000 INTO `wik_recentchanges`
(rc_timestamp,rc_cur_time,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type)
SELECT
rev_timestamp,rev_timestamp,rev_user,rev_user_text,page_namespace,page_title,rev_comment,rev_minor_edit,0,page_is_new,page_id,rev_id,0,
IF(page_is_new != 0, 1, 0) FROM `wik_page`,`wik_revision` WHERE
(rev_timestamp > 20060503074223) AND (rev_page=page_id)
Function: rebuildRecentChangesTablePass1
Error: 1064 You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'5000 INTO `wik_recentchanges` (rc_timestamp,rc_cur_time,rc_user
(localhost)
................
Any ideas whats going wrong?
Regards
Show replies by date
J.D. wrote:
we work step by step on the Update from 1.4.7 to
1.5.8
What we found now was due the update this failure:
That script doesn't work in 1.5, don't use it. (There's very little if any
reason to ever use it anyway.)
-- brion vibber (brion @
pobox.com)
On 10/05/06, Brion Vibber <brion(a)pobox.com> wrote:
That script doesn't work in 1.5, don't use it.
(There's very little if any
reason to ever use it anyway.)
We might consider removing it, then, or fixing it.
Rob Church
Rob Church wrote:
On 10/05/06, Brion Vibber <brion(a)pobox.com>
wrote:
That script doesn't work in 1.5, don't
use it. (There's very little if any
reason to ever use it anyway.)
We might consider removing it, then, or fixing it.
That would be silly, considering 1.5 is obsolete.
-- brion vibber (brion @
pobox.com)