Can't DROP INDEX `username`; check that it exists

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
User avatar
darb
Joomla! Hero
Joomla! Hero
Posts: 2042
Joined: Thu Jul 06, 2006 12:57 pm
Location: Stockholm Sweden

Can't DROP INDEX `username`; check that it exists

Post by darb » Fri Sep 03, 2021 3:42 pm

Hi

I tried a Bitnami Joomla 3.9.28-1 image on a local machine and then updated it to Joomla 3.10.1 and got this error message. https://bitnami.com/stack/joomla/installer

"
Warning
JInstaller: :Install: Error SQL Can't DROP INDEX `username`; check that it exists
Files Update: SQL error file DB function failed with error number 1091
Can't DROP INDEX `username`; check that it exists
SQL =

ALTER TABLE `#__users` DROP INDEX `username`;

Before you update Joomla, ensure that the installed extensions are available for the new Joomla version.
You are strongly advised to make a backup of your installation before you start updating."

Anything to worry about ?

Cheers!
Last edited by toivo on Fri Sep 17, 2021 9:27 pm, edited 1 time in total.
Reason: mod note: moved from 4.x Migrating and Upgrading
Top
User avatar
ltheme
Joomla! Guru
Joomla! Guru
Posts: 666
Joined: Wed Dec 04, 2013 2:43 pm
Location: US
Contact:
Contact ltheme

Re: Can't DROP INDEX `username`; check that it exists

Post by ltheme » Fri Sep 17, 2021 1:15 pm

Hi,

It means you have issue with database record, just fix it before run your update. You can go to Admin > Extension > Database, click "Fix" and recheck.
Steve (Mr.) - Fan of Joomla! CMS over 10 years
https://ltheme.com/joomla-templates/ <= 250+ Joomla! templates
https://agethemes.com/free-joomla-templates/ <= Joomla! templates on marketplace
^Compatible with Joomla! 3.x, Joomla! 4.x and Joomla! 5.x
Top
User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4189
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Can't DROP INDEX `username`; check that it exists

Post by abernyte » Fri Sep 17, 2021 2:47 pm

In Joomla 4 it is Admin > System > Maintenance > Database > Update Structure
"Those who expect to reap the blessings of freedom must, like men, undergo the fatigue of supporting it." Thomas Paine
Top
User avatar
ltheme
Joomla! Guru
Joomla! Guru
Posts: 666
Joined: Wed Dec 04, 2013 2:43 pm
Location: US
Contact:
Contact ltheme

Re: Can't DROP INDEX `username`; check that it exists

Post by ltheme » Fri Sep 17, 2021 2:50 pm

abernyte wrote: ↑
Fri Sep 17, 2021 2:47 pm
 In Joomla 4 it is Admin > System > Maintenance > Database > Update Structure
@darb is running in Joomla 3.10.x
Steve (Mr.) - Fan of Joomla! CMS over 10 years
https://ltheme.com/joomla-templates/ <= 250+ Joomla! templates
https://agethemes.com/free-joomla-templates/ <= Joomla! templates on marketplace
^Compatible with Joomla! 3.x, Joomla! 4.x and Joomla! 5.x
Top
User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4189
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Can't DROP INDEX `username`; check that it exists

Post by abernyte » Fri Sep 17, 2021 2:53 pm

He is in the J4 board...I am confused.... :D
"Those who expect to reap the blessings of freedom must, like men, undergo the fatigue of supporting it." Thomas Paine
Top
sozzled
I've been banned!
Posts: 13639
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Can't DROP INDEX `username`; check that it exists

Post by sozzled » Fri Sep 17, 2021 3:06 pm

abernyte wrote: ↑
Fri Sep 17, 2021 2:53 pm
He is in the J4 board ... I am confused ...
... and discussing a third party-sourced version of the Joomla distribution package ... :-\
Top
User avatar
darb
Joomla! Hero
Joomla! Hero
Posts: 2042
Joined: Thu Jul 06, 2006 12:57 pm
Location: Stockholm Sweden

Re: Can't DROP INDEX `username`; check that it exists

Post by darb » Fri Sep 17, 2021 4:36 pm

pls move it to j 3 forum then mods :)
Top
Locked

Return to “Migrating and Upgrading to Joomla! 3.x”