Hi Danilo,

monday will be fine, thank you for the prompt reply and follow-up.

Kind Regards,

Dennis

Hi Danilo,

You were right, we were using the "first" 01.09.09 . We downloaded this update through snowcovered and weren't aware of a "second" 01.09.09 .

I've downloaded and installed the rel.91 version and tested the website. (not on the website I gave to you by e-mail, that is still running on the first 01.09.09)

After working with the website extensively for a bit we did not encounter any "exception errors" anymore that stopped the entire website from working for 5 minutes, as described earlier.

We encounter 2 problems atm:

1) a problem inserting single quotes into fields, which gives this error:

DotNetNuke.Services.Exceptions.ModuleLoadException: hashControls must contain the control to add Parameter name: hashControls[lblFilterkitchenid10_376] ---> System.ArgumentNullException: hashControls must contain the control to add Parameter name: hashControls[lblFilterkitchenid10_376] at Dna2.Modules.ReportGrid.ControlInjector.InjectControls(Panel& pnlContent, String html, Hashtable hashControls) at Dna2.Modules.ReportGrid.ParametersController.InjectHTML(ReportGridInfo objReport, Page page, PlaceHolder ph, QueryVariables vars, String strRefreshText, Boolean bCompact) at Dna2.Modules.ReportGrid.ViewReportGrid.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace --- 

2) Recordsets get mixed up through various instances of ReportGrid, like the resultset of one ReportGrid ending up in the instance of another. Refreshing the page makes the correct resultset appear.

We think those 2 errors described above are related, as the second one only seems to occur when the first one does... I am not sure of this.

So bottom line, we only encounter 2 problems now while inserting records with single quotes, and no exceptions anymore (which is great).

Though I haven't been able to test the website for a long period of time, so I am not 100% sure.

Do you want me to install r91 on the testwebsite I gave you or leave it as it is?

Thank you,

Kind regards,

Dennis

Hi,

If I add a freetext user parameter to a query which fills a ReportGrid.

And then insert a value with a single quote in that freetext field.

Values like: 'sdmqflj or sqdfqlsdj'dsqf

Sometimes the record gets added correctly but most of the time an error occurs or the ReportGrid gets mixed up, with different columns or values.

It's not "if you do this, then this happens".

I have updated the component on the testwebsite, if you want, you can try it out there, just fill in 'qsdf 10 times in the field "name" and press update update update, and check "overzicht" and you'll see it suddenly go wrong.

Kind regards,

Dennis

Hi,

The update to that newer version of 01.09.09 solved the biggest issue.

We'll let our customer use the website again, and keep an eye for errors or any other misbehaviours, and will let you know if so.

So for now, we are happy with the product and are looking forward to seeing the Forms Builder improvements.

kind regards,

Dennis

Hi Adam, thanks for your question!

There is some differences between ReportGrid & ReportChart. The Grid just execute the SQL and display it as it is.
The Chart module integrate a parser which traslate the recordset data for the chart component. This is a critical part of the process of displaying a chart and when something goes wrong, you got the error you reported. This is normally caused by a wrong layout of the query, which expects to have data in a certain order and of a certain type. The order of fields is fixed (X, Y1, Y2) and the datatype is specified by the section "Axis Settings" > "Axis Type".

I can see from the error that the Axis Settings, specify that the axis are Text and Linear (X and Y respectively). The datatype(s) probably doesn't match.

Please check the mentioned settings. Also If you like, you can send us the query and the export of the XML data and will fix it for you.

Kind Regards,
D.