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.
Post Reply
User avatar
darb
Joomla! Ace
Joomla! Ace
Posts: 1848
Joined: Thu Jul 06, 2006 12:57 pm
Location: Stockholm Sweden
Contact:

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

User avatar
ltheme
Joomla! Guru
Joomla! Guru
Posts: 631
Joined: Wed Dec 04, 2013 2:43 pm
Location: US
Contact:

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/ <= 120+ Joomla! templates
https://ltheme.com/free-one-page-joomla-templates/ <= 80+ Landing Joomla templates
^Compatible with Joomla! 3.x and Joomla! 4

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4063
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

User avatar
ltheme
Joomla! Guru
Joomla! Guru
Posts: 631
Joined: Wed Dec 04, 2013 2:43 pm
Location: US
Contact:

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/ <= 120+ Joomla! templates
https://ltheme.com/free-one-page-joomla-templates/ <= 80+ Landing Joomla templates
^Compatible with Joomla! 3.x and Joomla! 4

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4063
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

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 10891
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 ... :-\
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
darb
Joomla! Ace
Joomla! Ace
Posts: 1848
Joined: Thu Jul 06, 2006 12:57 pm
Location: Stockholm Sweden
Contact:

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 :)


Post Reply

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