Database Error after page edit

Hi.

I have made an edit to my homepage using Studio > Pages > Homepage and in so doing appear to have corrupted my Administrator account in the DB. I can no longer sign in the Administrator account -though I can from other user accounts- and therefore, have lost access to Studio. [Edit: since I was using a different account to test from mobile and that worked - I incorrectly assumed the problem was user-based. In fact it appears to be desktop vs mobile.]

UNA kicked out several emails alerting me of the following error:

Mysql error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= `sys_profiles_conn_subscriptions`.`initiator`WHERE 1 AND `sys_profiles`.`st...' at line 1

I can post or pm more details but I suspect this is a known/recognized problem not requiring the granular, full syntax of the DB query.

This is a sandbox installation, so it's not the end of the world if I need to reinstall and start fresh - but I Have dozens of hours of work in this instance, so I'd like to know if it's recoverable.

  • View
    512
  • More
Replies (5)

    • G

      Okay - I was able to sign in by going directly to [my.domain]/studio So, I have access to the Studio. But now I must fix the DB syntax problem.

      It appears to be specific to login tool. If I try to use my Admin credential from anywhere other than the /studio back-door, I just get a quick flash (reload) of the page and nothing else happens.

      Hope someone has some ideas for me.

      Thanks in advance!

      • Hello @Gabe !

        That's very strange that some actions in the Pages app could corrupt the account's/profile's settings. Could you please PM me with your UNA studio access to check what might be wrong?

        • G

          pm sent:

          Upon further examination, I think the account/profile is not corrupted - rather the Sign In block/module is not communicating with the DB correctly. Interestingly, it works fine on mobile. So this really looks like a server side problem in the block that serves Log In function on Desktop only.

          Edit to Add: since I was using a different account to test from mobile and that worked - I incorrectly assumed the problem with user-based. In fact it appears to be desktop vs mobile.

          • G

            More clues:

            If I clear browser session (clear Cookies + Site Settings + Cache) I can get Una to serve me a login window - only once. I enter my credentials and it LOOKS like it's logging me in (doesn't throw any error dialog) but then I remain Unauthenticated. Then, if I try again to log in (by clicking again on the Unauthenticated User icon in upper right) the page just flashes - the tool is broken.

            Here are some truths:

            • I can reset browser session (as above) and the login tool will work again, as described above .
            • This is behaves consistently in both Firefox and Vivaldi (chromium) browsers.
            • I'm on Pop_OS! (linux) with up-to-date browser versions
            • I discovered this after Vivaldi was behaving poorly (not allowing me to type certain uppercase characters or invoke keyboard copy/paste functions within browser pages). Through Vivaldi support search I found that Vivaldi preferences had become corrupted and need a line removed. This fixed my browser issues, and led me to discover the behaviors described above.

            Based on the last bullet point, I suspect Vivaldi spat some garbage and corrupted the UNA DB, somehow.

            • G

              [EDIT] I marked this as fixed, but in fact it's not fixed. The login dialog works ONCE but the login is not completed. It throws no error, it just returns me to unAuthenticated user status. And after that, the login dialog cannot be invoked again. The page just flashes. So, this is not resolved. [EDIT]

              FIXED. I wish I could tell you how this was resolved, but it's a mystery. I abandoned this damaged instance of Una (it was a test site) for a couple of weeks. When I returned and tried to login from the home page, this time it just worked. I have not performed any updates. Caches had previously been cleared both from Dashboard and manually. So, it's a mystery.

              Login or Join to comment.