Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 2,527 total)
1 2 3 … 130 131 132 … 167 168 169
  • Author
    Posts
  • November 19, 2003 at 9:15 am in reply to: SJA v1 errors in Win9x #15252
    Ritesh
    Member

    In Windows, SJA is available only with SQLyog.

    SQLyog 3.62 contains the most updated version of SJA i.e. 1.1.

    November 19, 2003 at 1:20 am in reply to: synchronizing tables #15153
    Ritesh
    Member

    A similar problem existed in ver 3.6 and 3.61 but has been resolved in 3.62. Are you sure that you are running 3.62?

    November 18, 2003 at 12:13 pm in reply to: synchronizing tables #15151
    Ritesh
    Member

    BTW, which version of SQLyog are you running and the MySQL versions of your source and target server?

    November 18, 2003 at 12:01 pm in reply to: synchronizing tables #15150
    Ritesh
    Member

    I made some changes in tables “tblweborders” and “tblwebquoteitems” for the target database and ran the sync tool. This is the output given by SJA.

    Code:
    SQLyog Job Agent Version 1.1
    Copyright (c) Webyog. All Rights Reserved.

    Sync started at Tue Nov 18 17:25:06 2003

    Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
    =========================  =======  =======  ========  =======  =======
    `tblemaillist`                 705      705         0        0        0  
    `tblorderstatus`                13       13         0        0        0  
    `tblorderstatushistory`        110      110         0        0        0  
    `tblsurvey`                     58       58         0        0        0  
    `tblweborderitems`              94       94         0        0        0  
    `tblweborders`                  43       43         0       10        0  
    `tblwebquoteitems`           25207    25207         0       13        0  
    `tblwebquotes`                1801     1801         0        0        0  
    `tblwebupgradeitems`             0        0         0        0        0

    Total time taken – 4 sec(s)

    Can you send me the SQL script of the target database with some modified data?

    November 18, 2003 at 9:04 am in reply to: synchronizing tables #15149
    Ritesh
    Member

    I have received it.

    Will revert back soon.

    November 18, 2003 at 9:02 am in reply to: Cannot update fields in v3.62 #15241
    Ritesh
    Member

    We are looking into the matter. Give us some time.

    November 17, 2003 at 2:30 pm in reply to: Cannot update fields in v3.62 #15239
    Ritesh
    Member

    Send them to [email protected]. It will be nice if you can send a script of the table.

    November 14, 2003 at 5:01 am in reply to: Invalid character in XMl Export #15234
    Ritesh
    Member

    Thanks for the information 😀

    November 13, 2003 at 4:48 pm in reply to: Export data lower-cases foreign key table names #15228
    Ritesh
    Member

    SQLyog exports the “Create Table…” stmts. returned by the MySQL server. It does not modify anything before dumping it into the export file.

    November 13, 2003 at 4:45 pm in reply to: "Text" fields and Insert/Update window #15231
    Ritesh
    Member

    In the Tools->Preference, uncheck “Truncate Columns To Max Data Size…”

    November 12, 2003 at 6:20 am in reply to: Relationships not imported #15219
    Ritesh
    Member
    Quote:
    that I have to download the max binary and install for it. Is this correct?

    correct 😀

    A complete documentation on how to start MySQL with InnoDB support can be found at http://www.innodb.com

    November 12, 2003 at 6:13 am in reply to: Global LOCK priveledges? #14944
    Ritesh
    Member

    SQLyog logs all the queries in the History window.

    Can you tell me which query is returning the error?

    November 12, 2003 at 6:12 am in reply to: Error 1130 #14884
    Ritesh
    Member

    There is no difference between XP and 2k.

    Are you sure you have given the correct permission tothe XP host as you have given to the 2k host?

    November 11, 2003 at 9:06 am in reply to: Relationships not imported #15215
    Ritesh
    Member

    You have to configure MySQL for InnoDB. After the server has been configured you can cconvert the table handlers to InnoDB using “Change Table Type To…” option.

    A very good tutorial on managing FK using SQLyog can be found at http://www.weberdev.com

    November 11, 2003 at 5:27 am in reply to: Relationships not imported #15213
    Ritesh
    Member

    SQLyog does not support FK in ODBC Import. This feature is planned for SQLyog Max.

    You cannot create relationships on tables with MyISAM table handlers. You have to use InnoDB Table handlers. For more information on InnoDB visit http://www.innodb.com

    HTH

  • Author
    Posts
Viewing 15 posts - 1,951 through 1,965 (of 2,527 total)
1 2 3 … 130 131 132 … 167 168 169