Hi Guys
I’ve run into an error I’ve not seen before. My system suffered a fatal crash. Fortunately, I had recent backups of my important data. I have had to replace the system HDD in my main server and reinstall the operating system. This has meant reinstalling my Alpha Software and the MySql server etc.
I am running Alpha Anywhere Ver 12.4.4.4 Build 4346.4889 on Windows 10 against MySql Server Ver 8.0.
All seems to work OK as I can publish a web page with a grid component and it all displays correctly in the web browser. However, now when I want to create a new web component (say a grid) I cannot get a field list in the sql genie to select the fields I want.
I can select the table but there no available columns to select from under the columns tab.
The SQL Select Statement is set to Select all (i.e. SELECT * FROM dlc_2019_booking) and this works but selects all the fields. I have set up a new connection string and this all works as I can preview all of the data.
In a similar way if I try to create a new report and select the connection string, I get the following:
Unexpected error
MySQL type aW50KDExKQ== not expected in NativeTypeToDataTypeInfo
I would be grateful for some help as to how to resolve this as I don’t want to include all of the fields for every report or component.
Thanks
I’ve run into an error I’ve not seen before. My system suffered a fatal crash. Fortunately, I had recent backups of my important data. I have had to replace the system HDD in my main server and reinstall the operating system. This has meant reinstalling my Alpha Software and the MySql server etc.
I am running Alpha Anywhere Ver 12.4.4.4 Build 4346.4889 on Windows 10 against MySql Server Ver 8.0.
All seems to work OK as I can publish a web page with a grid component and it all displays correctly in the web browser. However, now when I want to create a new web component (say a grid) I cannot get a field list in the sql genie to select the fields I want.
I can select the table but there no available columns to select from under the columns tab.
The SQL Select Statement is set to Select all (i.e. SELECT * FROM dlc_2019_booking) and this works but selects all the fields. I have set up a new connection string and this all works as I can preview all of the data.
In a similar way if I try to create a new report and select the connection string, I get the following:
Unexpected error
MySQL type aW50KDExKQ== not expected in NativeTypeToDataTypeInfo
I would be grateful for some help as to how to resolve this as I don’t want to include all of the fields for every report or component.
Thanks
Comment