Data Studio
4.6K members online now
4.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I have created few basic reports, but none of them are displaying any reports, they are all giving following errors:

 

System error 

Error Details

There`s a query error.

Error ID: 7d8ad845

 

 

No matter how simple report is, it will still not generate it. 

 

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I also have this problem, even trying to show a simple table, adding some columns is fine, but adding others causes it to go throw an error like:

Error Details

There`s a query error.

Error ID: 22041248

 

The columns it most appears to have issue with is Currency Fields (GBP) but again it seems intermittent 

 

Re: MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
If I remove the currency fields, would that fix it?

What is the solution?

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

In regards to my previous post, I have found that I get errors in columns that contain NULL's when they are aggregated.

Changing the dataset to have a default value of '0' solved my issues, hope that helps someone

 

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

That's what i found as well, however a fix still seems necessary, null values should definitely be possible!