Flipper FAQs

FAQs Initial steps to perform first query: 1) Add new database server 2) Select "Schema never updated" 3) Select query, SHOW GRANTS for example	APPLICATION NAME Flipper FIRST PUBLISHED December 14, 2008 FOCUS Database client used to query MySQL™ databases SUPPORT support@driventree.com
Q: Why does the application crash when I create a new database? A: With the introduction of iPhone OS 3.0+ we have seen this problem. We are currently investigating the problem Flipper experiences which results in unexpected application behavior (a white screen appears where your list of connections should be) and subsequent crashes when adding a new Database Connection. The good news is that your new connection will be added, so the next time you start Flipper you may continue your work. We have seen this problem on some, but not all of our development devices. This issue with Flipper has our highest priority.
Q: Error Message <db name> - Database Error - Server is using old-style authentication unsupported by Flipper (see help set password) The users password is stored in MySQL with an old style format (short passwords). To fix this, you have to upgrade the password storage in the MySQL database. Keep in mind there are two or more user id's if connecting remotely, one for localhost and the others for the remote connections. Use the set password command from a connected client and set it to the desired password which may be the current password as well. MySQL will convert it to the new password format. Here's an example of the command: SET PASSWORD FOR 'bob'@'%.loc.gov' = PASSWORD('newpass'); or for wide open remote access, use just the percent sign. SET PASSWORD FOR 'bob'@'%' = PASSWORD('newpass'); CAUTION: If you have other clients that require old style passwords for the user you are connecting as, changing them to long passwords will prevent them from connecting. So please use caution when making this change. More help found here
Q: I get a syntax error when I run the "update schema" query A: After creating a connection to a database, it's tempting to jump right in and write a query. If you haven't updated the schema yet, the first thing you'll see in the SQL-iPad is "Update Schema". If you tap on that, Flipper will put that text into the query section and let you run it. The query "update schema" is not a valid MySQL query so you get a syntax error. Here's what you need to do: When you make your first connection to a database, you need to tap the "Schema never updated" button to let Flipper get the schema for you. Once you've done this, when you go back into the query page, you'll see your database and can begin writing queries.
Q: Why can I only retrieve 1000 rows? A: Much like the standard MySQL client, limiting the results to 1000 rows conserves network data transfers, memory and unexpected query results. Since the results are saved on the phone, this also protects the phones memory.