LO 6.4.6.2
Windows 10
MYSQL db on hosted server (Siteground)
Added columns to table using MYSQL Workbench
Verified entries with cPanel with phpMyAdmin
Connected Base to db
Cannot see the columns I added.
Help is appreciated.
My mistake … issue fixed
Hello,
If the Connected Base ws open during the addition of column through MYSQL Workbench, did you refresh the display of the database by View
> Refresh Tables
or simply close the database and then reopen it.
Kind regards, Michel
When I (recently) started using LO Base and MySQL, I also noticed the same problem. Sometimes, when I was modifying MySQL tables, LO would crash. After that, before changing MySQL tables, I always close LO first and after changing in MySQL, I restart LO. Since then, I have no problem. However so far I’ve used MySQL locally, not host server.
Michel:
Base was not open when I added the columns using Workbench CE 8.0.