6 Replies Latest reply: Jul 26, 2013 5:54 AM by matthew stuart RSS

    No tables found in database

    matthew stuart Community Member

      Last night I had a number of apps to udate (mainly CS6), so I set the 'update all' running and went to bed. I got up this morning to find all had updated fine as expected. However, since this morning I am consistely getting an error telling me that I have no tables in my database and can't therefore create recordsets etc...

       

      I didn't look to see if DWCS6 was one of the apps that required an update, but I can't seem to get it to always load the database tables when try to I create a recordset. It's very hit and miss, but unfortunately more miss at the mo'.

       

      Is anyone else experiencing this? I'm wondering if the update has broken something!

        • 1. Re: No tables found in database
          hyadav Employee Hosts

          Are you using CS6 or the CC version, if you are not sure go to help>About Dreamweaver and share the version ?

          • 2. Re: No tables found in database
            matthew stuart Community Member

            I have both, but for this particular project, I am still using CS6.

            • 3. Re: No tables found in database
              bgupta16 Employee Hosts

              Are you able to test the connection to the database within Dreamweaver?

              What file types are you working on?

              Have you setup the website locally on testing server? Which tool are you using?

              Please post a screenshot of the error message.

              • 4. Re: No tables found in database
                hyadav Employee Hosts

                I have the updated version of CS6 and i can see the DB tables at my DW, did you made any changes or did you change the site something like that?

                • 5. Re: No tables found in database
                  matthew stuart Community Member

                  When it losses connection, I am unable to connect to the DB regardless of whether I am testing the connection, creating a new recordset, copying recordsets that are months old, or using the bindings panel to drag a binding onto the page. When it looses connection, I get a http error in the recordset in the bindings panel.

                   

                  Everything was fine prior to the update, and nothing has changed apart from the update to the CS6/CC software.

                   

                  I can launch DW and have it work prefectly with any DB in any site, and then for no reason, it looses the connection. The connection will not work again until I quit DW and restart it. Outside of DW, I can see all databases, and I can see the contents of each. I am able to interact with MySQL databases create new tables and records, update them and delete them, but DW still won't connect until I restart it.

                   

                  As this has only started happening imediately after I updated the software, it would indicate a bug to me... and I have been reporting numerous bugs for DWCS6 with Adobe engineers.

                  • 6. Re: No tables found in database
                    matthew stuart Community Member

                    I've also just discovered that if I edit a recordset, then click OK, a duplicate set of code for it created! I have had to create a copy of the file to ensure I have a version to go back to should it all go wrong!

                     

                    I haven't fully tested yet, but it seems that the duplication of the recordset code happens when I try to add ORBER BY to the select query