Menu

#1542 (ok 4.3) Better error reporting in Designer; can get stuck Processing

Next_release
fixed
None
1
2014-12-05
2014-08-25
No

Using Designer, I can cause it to get stuck on "Processing Request" without returning the MySQL error message to the user. It should catch the MySQL message and display it instead of getting stuck on the Processing Request message.

I discovered this when I had referencing ID values that were not in the referenced table, but the problem exists for other failure modes as well (for instance, trying to create a relation where the proper columns are not indexed).

The easiest way to reproduce my use case is to look at the attached .sql -- basically, main references an id 0 in reference which doesn't exist; this causes a problem creating the relation, but phpMyAdmin stops as "Processing Request" and doesn't do anything more. In my example data, EMPTYing the two tables allows one to create the relation, confirming that the problem is the improper id values.

1 Attachments

Discussion

  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
     
  • Madhura Jayaratne

    • summary: Better error reporting in Designer; can get stuck Processing --> (ok 4.3) Better error reporting in Designer; can get stuck Processing
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Madhura Jayaratne

    • Group: Needs_decision --> Next_release
     
  • Marc Delisle

    Marc Delisle - 2014-12-05
    • Status: resolved --> fixed
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.