[michi]

OK, thanks for all your hard work on this!

One of the three articles now shows up, but it lost its photo attachment (167_0_wo_die_trommeln_sprechen_DVD.jpg). I just edited the article to add the missing image, no big deal.

Cheers,

Michi.

[michi]

Just stumbled across another problem: media/dvd-famoudou-konate-famille-t3244.html#p22114

Note how the post sort of includes itself, and also the missing JPEG image of the DVD cover.

Cheers,

Michi.

[bubudi]

many thanks for all the effort, james!

[bops]

What's all this talk of databases and whatnot? I thought it was all done by elfin magic and pixie dust.

[davidognomo]

What's all this talk of databases and whatnot? I thought it was all done by elfin magic and pixie dust.

[Paul]

What's all this talk of databases and whatnot? I thought it was all done by elfin magic and pixie dust.

Have you met james then?

[James]

Have you met james then?

What's that supposed to mean?

[bops]

Have you met james then?

Yes, and let me tell you, he's a really tall elf.

[michi]

Just stumbled across another problem: media/dvd-famoudou-konate-famille-t3244.html#p22114

Note how the post sort of includes itself, and also the missing JPEG image of the DVD cover.

I reposted that article so it displays correctly. When I tried to delete the old one, I got:

General Error
SQL ERROR [ mysql4 ]

Out of range value for column 'topic_replies_real' at row 1 [1264]

SQL

UPDATE phpbb_topics SET topic_replies_real = topic_replies_real - 1, topic_replies = topic_replies - 1 WHERE topic_id = 3244

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1646
CALL: dbal_mysql->sql_query()

FILE: posting.php
LINE: 1732
CALL: delete_post()

FILE: posting.php
LINE: 314
CALL: handle_post_delete()

It still looks like there might be some inconsistencies in the DB.

On the second attempt, I managed to delete the post.

James, it might be a good idea to run a consistency check on the entire DB. If there are inconsistencies, they could cause damage down the track, with bits progressively falling off the DB...

Cheers,

Michi.

[James]

Hi Michi,

I'm actually sure how to do that

I expect (hope) that any problems will only affect a limited number of posts...

[Dugafola]

there's a thread missing.

it was commentary on bolokada conde playing at Yousouff Koumbasa's compound in Nongo.

[davidognomo]

you mean the yaya?

[Dugafola]

you mean the yaya?

ya!

[davidognomo]

it's here

[michi]

it's here

Yes, it is, but the thread does not show up in when I look through the "Videos" section of the board.

James, it definitely looks like those indexes need rebuilding!

Michi.