SQL error - missing sql entries

[lonlyboy]

My forum had been down for awhile and I finally got it back up. The downloads extension I had been using was very old. To make things start working I had to manually removed quite a few extensions. I manually removed the _dl_ tables to get the forum back up and running. Thought I got what was needed but now when I try to install the newest version, it doesn't install any SQL tables. Did I miss an SQL entry that tells the extension it needs to reinstall the sql tables?

[oxpus]

Hello,
to be able to help you on futher existing problems you should name the versions of your phpBB from which you have delete the several wextensions and the release number of your latest installed downloads extension.

Well, you can try to drop all extension data from your database using this short article, which was posted for older extension releases:
https://phpbb3.oxpus.net/viewtopic.php?p=6163#p6163

But please post the pphBB version and the download extensions version by execute the following sql statements before deleting more data directly from the database to minimize the existing chaos:

Code: Alles auswählen

select 'Board:',config_value from phpbb_config where config_name = 'version'; 
select 'DL Ext:',config_value from phpbb_config where config_name in ('dl_mod_version','dl_ext_version');

[lonlyboy]

This is what I found. I'm happy to delete any and all reference and start from scratch.

dl_mod_version 6.5.26
dl_ext_version 7.2.12

[oxpus]

Okay, so you can run all sql statements I've linked in my last post.
After this run the followind sql statements to delete the last references from the extension:

Code: Alles auswählen

delete from phpbb_migrations where migration_name like '%oxpus%dlext%';
delete from phpbb_ext where ext_name = 'oxpus/dlext';

After this purge the forum cache and you should be able to install the extension as a new one.

[lonlyboy]

I must have something hanging it up. I keep getting this error, but as far as I know I've never installed another download extensin.

Something went wrong during the request and an exception was thrown. The changes made before the error occurred were reversed to the best of our abilities, but you should check the board for errors.

A module already exists: ACP_DOWNLOADS

[oxpus]

You must delete the existing modules from the acp module System > Administration Control Panel and there under the entry "Extensions".
This shall contains the modul "ACP_DOWNLOADS".
Click on it, delete on the next page all child modules, return and delete the parent modul ACP_DOWNLOADS, too, to reinstall the extension.

An other point to never delete just some table from the database directly and delete an extension without uninstalling it within the aco extensuion management.

[lonlyboy]

I was able to delete the extension listed. Then went back and enabled download mode but then either get a 500 error or the following error. followed by a bunch of lines.


General Error
SQL ERROR [ mysqli ]

Duplicate entry 'oxpus/dlext' for key 'ext_name' [1062]

SQL

INSERT INTO phpbb3_ext (ext_name, ext_active, ext_state) VALUES ('oxpus/dlext', 0, 's:13:\"notifications\";')

BACKTRACE

[oxpus]

You need to run the posted sql statements again to delete the extension.
And please use your table prefix on them.
This step is recommenfed when the installation throws an error.

[lonlyboy]

Unfortunately I'm at the point of giving up. I have tried multiple times. I clean all the sql queries and go to install. I click on install and it hangs for a few seconds and then the page errors out. Then when I go back to the extension page I get all the errors I got initially. For some reason it's not completing the install properly.