Hi, I've run into a weird issue where once I log out as a backend user and try to log back in, I get this error:

SQLSTATE[42S01]: Base table or view already exists.

The mysql table being referred to in the message is for a blog plugin (based on the RainLab.Blog plugin so I could learn).

After signing out, I'm redirected to the backend login screen at : myapp.com/backend/backend/auth/signin

Using correct credentials always results in the above error is a Flash message. However, I'm automatically signed in to last logged backed user if I just visit this : myapp.com/backend (and never to the actual login screen - seems that the session is not being cleared)

Any help will be much appreciated!!?

Last updated 8 years ago

UPDATE - FIXED!

It turns out that I had hurriedly messed up the version.yaml for my Blog plugin. I had made these errors (if you care to know) in version.yaml:

1. Wrong sequence of table creation while creating pivot tables
2. Wrong sequence of version numbers used
3. Missed creating a table

All this while I was sleepy and trying to "wrap" things up.

Sorry if you spent any time figuring this out.

Totally helped me out. Thanks!

Thank you! Went through 18 different version files in builder plugin and fixed my issue!

Glad this was helpful!