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
    243
  • More
Replies (4)

    • 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.

            Login or Join to comment.