Failed to open a row set error

[varakal]

My system went down and had to move to a new system. So I installed crystal reports and created DSN's. But when I tried to see the output it is giving the following error:

Failed to open a row set.
Details: HYTOO:[MySQL][ODBS 3.51 Driver]mysqld-3.23.49-log]Unknown table 'ticket_dup' in filed list.

Table ticket_dup exists, and has rows in it. Can someone tell me what the problem can be.
Thanks.

 

[varakal]

I think I found something. See the below query

SELECT `ticket_dup`.`id`, `ticket_dup`.`status_name` FROM `cedarzilla`.`ticket_dup` ticket_dup1
WHERE ticket_dup1.`status_name` = 'CLOSED' AND ticket_dup1.`type` = 'Change' AND ticket_dup1.`internal` <> '1'
ORDER BY ticket_dup1.`id`

In the above query, it renamed ticket_dup as ticket_dup1 (alias) but didnt modify the same at selecting columns. I am using Crystal Report 9.0. I couldnt even able to modify sql query. Any one has any ideas?

 

[Katy44]

Try going into your Database Expert, and seeing if the table is named 'ticket_dup1'. If it is, rename it to 'ticket_dup'.
It seems like the table has been accidentally aliased.

 

[varakal]

With Show SQL Query, I cannot change the query. I used the reset, but it is changing the whole sql modifications that I did earlier.

 

[Katy44]

I meant the Database Expert - from the Database menu. You should be able to change stuff in there.

 

[varakal]

The table is not renamed to ticket_dup1. It is the case that sql query has aliased the ticket_dup to ticket_dup1, but not everywhere.

 

[Katy44]

WOuld it be relatively simple to delete those fields from the report canvas, and then put them back on?

 

[varakal]

well.. thats not simple.. it does mean that recreating the whole report.. i think thats not the way to do.

 

[Katy44]

What happens when you choose 'Verify Database' from the Database menu?

 

[varakal]

I fixes up all the tables.