0 Replies Latest reply on Feb 4, 2010 4:08 AM by tonychinnery

    Problem with temporary table

    tonychinnery

      I have a problem with a site created with Dreamweaver using the InterAKT 3 extension.The page is:

       

      http://www.iovendocasa.it/pagine/registrdomicilio.php

       

      This page, and the rest of the site worked for years, until my host was sold to another firm and the site transferred to another server.

       

      The form, on completing the fields with asterisk, take the server to a script:

       

      /pagine/emailRegistrdomicilio.php


      which now generates an error message :

       

      Errore interno.

       

      tNG_fields.getFakeRecordset:
      SQL error: Error creating temporary table:
      MySQL server has gone away
      SQL:
      CREATE TEMPORARY TABLE KT_fakeRS_20100204 (KT_fakeField TEXT) (FIELDS_FAKE_RS_ERROR)
      • tNG_custom.executeTransaction
        • STARTER.Trigger_Default_Starter
        • tNG_custom.doTransaction
          • tNG_custom.prepareSQL
          • AFTER.Trigger_SendEmail*
      • tNG_custom.getRecordset
      • tNG_custom.getFakeRsArr
      • tNG_custom.getLocalRecordset
      • tNG_custom.getFakeRecordset*

       

      I tried creating a simple script on the server to test creating temporary tables, which works:

       

      http://www.iovendocasa.it/temporary-table-testing.php

       

      So its not a problem with creating temporary tables. I've no idea how to solve this problem. Any help would be appreciated

       

      Tony