Marco Moock wrote:

> On 14.11.2024 um 20:00 Uhr Retro Guy wrote:
>
>> There is a way to force it, but it's time consuming. If you have a
>> critical group missing critical articles, you can rebuild the entire
>> group with (run as root or www user):
>>
>> php /etc/rslight/scripts/maintenance -reset <group name>
>>
>> This will erase ALL the articles and poll them again according to the
>> quantity you wish to go back from the server in overrides.inc.php:
>
> PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 5 database is locked in /var/www/html/rocksolid/newsportal.php:3202
> Stack trace:
> #0 /var/www/html/rocksolid/newsportal.php(3202): PDOStatement->execute()
> #1 /etc/rslight/scripts/maintenance.php(293): delete_message()
> #2 /etc/rslight/scripts/maintenance.php(74): remove_articles()
> #3 {main}
> thrown in /var/www/html/rocksolid/newsportal.php on line 3202
>
> I've shut down the cronjob systemd stuff during the run.
>
> Is there another way to remove the group entirely and the restart from
> the beginning for that group?
> Or even all articles/groups, without removing settings etc.?
>

You should be able to just run maintenance.php again. Just make sure (as
you did that cron.php cannot run), and it's best if nobody accesses the
site just in case (shut down http server?)

Otherwise, you can use sqlite3 to remove the data from the overview.
It's easy to remove the articles from the group itself, just remove the
<group name>-articles.db3 file. But the articles need to be removed from
articles-overview.db3 and history.db3, which is where the script seems
to have crashed.

I would just try again, else use sqlite3.

DELETE FROM overview WHERE newsgroup=:group
DELETE FROM history WHERE newsgroup=:group

If nothing matters, just delete all your .db3 and .dat files in the
spool dir, and in <spooldir>/section
(/var/spool/rslight/rocksolid/*.dat)

The articles will be re-downloaded as per your setting when cron.php is
run.

On a side note, if you do that maybe you want to separate out some of
your groups into 'sections'. Just my 2 cents :)

--
Retro Guy

On 16.11.2024 um 12:11 Uhr Retro Guy wrote:

> I would just try again, else use sqlite3.
>
> DELETE FROM overview WHERE newsgroup=:group
> DELETE FROM history WHERE newsgroup=:group

history doesn't exist, overview worked.

This worked.
I now ran the cronjob, but no articles in the overview yet, even when
they were downloaded. Did I miss something?

--
kind regards
Marco

Send spam to 1731755492muell@cartoonies.org

Marco Moock wrote:

> On 16.11.2024 um 12:11 Uhr Retro Guy wrote:
>
>> I would just try again, else use sqlite3.
>>
>> DELETE FROM overview WHERE newsgroup=:group
>> DELETE FROM history WHERE newsgroup=:group
>
> history doesn't exist, overview worked.
>
> This worked.
> I now ran the cronjob, but no articles in the overview yet, even when
> they were downloaded. Did I miss something?
>

What group are you working on? I'm on your site and would like to see if
it's there or working or whatever it's doing.

You really should have a history file. /var/spool/rslight/history.db3
Overview is articles-overview.db3

Without the articles in the overview file, it won't work. Are all file
permissions ok?

--
Retro Guy

On 16.11.2024 um 14:24 Uhr Retro Guy wrote:

> What group are you working on? I'm on your site and would like to see
> if it's there or working or whatever it's doing.

It was de.comp.os.linux.misc, but now one article got downloaded, so it
seems to be recovered.

--
kind regards
Marco

Send spam to 1731763480muell@cartoonies.org

On Sat, 16 Nov 2024 14:55:27 +0000, Marco Moock wrote:

> On 16.11.2024 um 14:24 Uhr Retro Guy wrote:
>
>> What group are you working on? I'm on your site and would like to see
>> if it's there or working or whatever it's doing.
>
> It was de.comp.os.linux.misc, but now one article got downloaded, so it
> seems to be recovered.

Glad it's working!

I've just emailed you a pre-built database for
de.comp.os.unix.linux.misc if you want to import it.

--
Retro Guy