Gabe

  •  ·  Standard
  • 1 followers
  • 312 views
Friends
Empty
Add new...
 
 
·
Added a discussion

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.

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.

  • 133
  • 1
·
Added a discussion

I recently did a first-time install of v14.0 and I'm learning the CMS. Wherever I should see "Persons" (in menu or page header) I'm actually seeing:

_bx_persons_menu_item_title_entries_home

I've been pouring through the HTML files in /template/ directory and can't find it. Once I find it, I'll try to use my rudimentary HTML skills to apply a fix - I would welcome any help I can get with that too.

  • 379
  • 1
Gabe Discussions
Database Error after page edit
Persons menu header - HTML error