From Karen at #483394-4: BUeditor not setting up properly:

There is all kinds of weird garbage in the BUEditor database. You can't do anything normal with that data because it needs so much escaping it gets garbled and won't work.

I tried doing a copy/paste into the installer with the values to create the data there and that totally failed because I couldn't get the escaping right.

Then I created the .sql file and the two .csv files by exporting from PhpMyAdmin. I couldn't find any way to get the installer to import the sql file (the better alternative) but on a fresh install it would install the csv files.

I don't understand why it worked on a fresh install for me and not for you.

Finding a stable way to import this data is still an issue.

---

Ultimately, we should probably just use whatever API calls BUEditor does to populate this data so we can get rid of those icky .csv and .sql files.

Comments

karens’s picture

karens commented

BUEditor does not have API calls. The way you do it now is to create a csv file and then import it in the UI. And there is no automated way to create the csv export file either.

There is no automated way to do it unless we create one. Those files are icky because the data in them is full of special characters that need special escaping so you can't do this in any 'normal' way.

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented

Oh, ew. :\

Well, it did work for me when I just did a straight:

SELECT * FROM `bueditor_buttons`
INTO OUTFILE '/Users/webchick/Sites/drubb/blah-html.csv'

LOAD DATA INFILE '/Users/webchick/Sites/drubb/blah-html.csv'
REPLACE INTO TABLE `bueditor_buttons`

...from the command line. That weird " stuff gets introduced from PhpMyAdmin when you use the Export tab, it seems.