search

borng / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
1 stars 0 forks source link

Can't "import from DB" #126

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. click Save/Load
2. click Import From DB
3. type name of existing database on server

What is the expected output? What do you see instead?
I expect to see a diagram of my existing database, but I see a plain sheet

What version of the product are you using? On what operating system?
v2.5, on Ubuntu 10.10

Please provide any additional information below.
I can store and retrieve design on the database...

Original issue reported on code.google.com by sardauka...@gmail.com on 4 May 2011 at 2:44

GoogleCodeExporter commented 9 years ago 
Please use Firebug to inspect the Import request; paste the communication log 
(including the response body) into a comment on this issue.

Original comment by ondrej.zara on 6 May 2011 at 6:02

GoogleCodeExporter commented 9 years ago 
I don't use Firefox, hope this works (from Chromium):

Headers:
Request 
URL:http://helper/wwwsql/backend/php-mysql/?action=import&database=betribes_deve
lopment
Request Method:GET
Status Code:200 OK
Request Headers
Accept:*/*
Accept-Charset:ISO-8859-1,utf-8;q=0.7,*;q=0.3
Accept-Encoding:gzip,deflate,sdch
Accept-Language:en-US,en;q=0.8
Connection:keep-alive
Host:helper
Referer:http://helper/wwwsql/
User-Agent:Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/534.24 (KHTML, like 
Gecko) Chrome/11.0.696.57 Safari/534.24
Query String Parameters
action:import
database:betribes_development
Response Headers
Connection:Keep-Alive
Content-Encoding:gzip
Content-Length:469
Content-Type:text/xml
Date:Fri, 06 May 2011 08:26:45 GMT
Keep-Alive:timeout=15, max=100
Server:Apache/2.2.16 (Ubuntu)
Vary:Accept-Encoding
X-Powered-By:PHP/5.3.3-1ubuntu9.5

Content:
<?xml version="1.0"?>

<sql db="mysql">
<datatypes db="mysql">

    <group label="Numeric" color="rgb(238,238,170)">

        <type label="Integer" length="0" sql="INTEGER" re="INT" quote="" />

        <type label="Decimal" length="1" sql="DECIMAL" re="DEC" quote="" />

        <type label="Single precision" length="0" sql="FLOAT" quote="" />

        <type label="Double precision" length="0" sql="DOUBLE" re="DOUBLE" quote="" />

    </group>

    <group label="Character" color="rgb(255,200,200)">

        <type label="Char" length="1" sql="CHAR" quote="'"/>

        <type label="Varchar" length="1" sql="VARCHAR"  quote="'"/>

        <type label="Text" length="0" sql="MEDIUMTEXT" re="TEXT" quote="'"/>

        <type label="Binary" length="1" sql="BINARY" quote="'"/>

        <type label="Varbinary" length="1" sql="VARBINARY" quote="'"/>

        <type label="BLOB" length="0" sql="BLOB" re="BLOB" quote="'"/>

    </group>

    <group label="Date & Time" color="rgb(200,255,200)">

        <type label="Date" length="0" sql="DATE" quote="'" />

        <type label="Time" length="0" sql="TIME" quote="'" />

        <type label="Datetime" length="0" sql="DATETIME" quote="'" />

        <type label="Year" length="0" sql="YEAR" quote="" />

        <type label="Timestamp" length="0" sql="TIMESTAMP" quote="'" />

    </group>

    <group label="Miscellaneous" color="rgb(200,200,255)">

        <type label="ENUM" length="1" sql="ENUM" quote="" />

        <type label="SET" length="1" sql="SET" quote="" />

        <type label="Bit" length="0" sql="bit" quote="" />

    </group>

</datatypes>

</sql>

Original comment by sardauka...@gmail.com on 6 May 2011 at 8:28

GoogleCodeExporter commented 9 years ago 
The resulting XML seems to be empty - it contains only datatype definition; no 
tables are there.

It is now time to debug directly the import script, by pointing your browser to 
http://helper/wwwsql/backend/php-mysql/?action=import&database=betribes_developm
ent and adding some debugging info into the import.php file... and configuring 
your webserver to NOT hide any PHP errors encountered...

Original comment by ondrej.zara on 6 May 2011 at 9:42

GoogleCodeExporter commented 9 years ago 
I'm not a PHP guy, do you mind sending me a version of index.php with debugging 
statements?

Original comment by sardauka...@gmail.com on 6 May 2011 at 9:55

GoogleCodeExporter commented 9 years ago 
Please, run this SQL statement against the "information_schema" database of 
your MySQL's server:

SELECT * FROM TABLES WHERE TABLE_SCHEMA = 'betribes_development'

Are any results returned?

Original comment by ondrej.zara on 6 May 2011 at 10:41

GoogleCodeExporter commented 9 years ago 
SELECT * FROM TABLES WHERE TABLE_SCHEMA = 'betribes_development'\G
*************************** 1. row ***************************
  TABLE_CATALOG: NULL
   TABLE_SCHEMA: betribes_development
     TABLE_NAME: activities
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Compact
     TABLE_ROWS: 5296
 AVG_ROW_LENGTH: 74
    DATA_LENGTH: 393216
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 0
      DATA_FREE: 31457280
 AUTO_INCREMENT: 5194
    CREATE_TIME: 2011-04-12 11:57:13
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
       CHECKSUM: NULL
 CREATE_OPTIONS: 
  TABLE_COMMENT: 
*************************** 2. row ***************************
  TABLE_CATALOG: NULL
   TABLE_SCHEMA: betribes_development
     TABLE_NAME: advertisement_assignments
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Compact
     TABLE_ROWS: 179
 AVG_ROW_LENGTH: 91
    DATA_LENGTH: 16384
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 32768
      DATA_FREE: 31457280
 AUTO_INCREMENT: 195
    CREATE_TIME: 2011-04-12 11:57:13
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
       CHECKSUM: NULL
 CREATE_OPTIONS: 
  TABLE_COMMENT: 
*************************** 3. row ***************************
  TABLE_CATALOG: NULL
   TABLE_SCHEMA: betribes_development
     TABLE_NAME: advertisement_page_types
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Compact
     TABLE_ROWS: 411
 AVG_ROW_LENGTH: 119
    DATA_LENGTH: 49152
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 16384
      DATA_FREE: 31457280
 AUTO_INCREMENT: 1713
    CREATE_TIME: 2011-04-12 11:57:13
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
       CHECKSUM: NULL
 CREATE_OPTIONS: 
  TABLE_COMMENT: 

....

*************************** 67. row ***************************
  TABLE_CATALOG: NULL
   TABLE_SCHEMA: betribes_development
     TABLE_NAME: votes
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Compact
     TABLE_ROWS: 308
 AVG_ROW_LENGTH: 53
    DATA_LENGTH: 16384
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 32768
      DATA_FREE: 31457280
 AUTO_INCREMENT: 341
    CREATE_TIME: 2011-04-12 11:57:13
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: utf8_general_ci
       CHECKSUM: NULL
 CREATE_OPTIONS: 
  TABLE_COMMENT: 
67 rows in set (0.58 sec)

Original comment by sardauka...@gmail.com on 6 May 2011 at 11:36

GoogleCodeExporter commented 9 years ago 
Okay; in the beginning of import.php (function setup_import()), have you 
correctly configured the SERVER, USER and PASSWORD constants?

Original comment by ondrej.zara on 6 May 2011 at 12:15

GoogleCodeExporter commented 9 years ago 
yes, I have - I also set DB to be 'betribes_development'

Original comment by sardauka...@gmail.com on 6 May 2011 at 12:22

GoogleCodeExporter commented 9 years ago 
That seems to be the problem - please leave the "information_schema" value (for 
the DB constant) in place!

Original comment by ondrej.zara on 6 May 2011 at 12:56

GoogleCodeExporter commented 9 years ago 
thanks, works now!

Original comment by sardauka...@gmail.com on 6 May 2011 at 1:09

GoogleCodeExporter commented 9 years ago

Original comment by ondrej.zara on 6 May 2011 at 1:28