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

Forum Replies Created

Viewing 15 posts - 331 through 345 (of 642 total)
1 2 3 … 22 23 24 … 41 42 43
  • Author
    Posts
  • March 24, 2004 at 10:31 pm in reply to: error no. 1130 #15605
    Shadow
    Member

    See my post in your first topic. There is no need to post a question twice, not even if the first one went to a wrong category.

    March 24, 2004 at 10:18 pm in reply to: error no. 1130 #15603
    Shadow
    Member

    This error means that the computer in which the MySql client is running, does not have the proper access rights to the MySql server. Grant the 'username'@'NT_machine_name' or 'username'@'%' user access to the desired db.

    March 24, 2004 at 10:10 pm in reply to: Insert/Update enum malfunction #15592
    Shadow
    Member

    I thought so! 😀

    March 24, 2004 at 10:08 pm in reply to: Sync error 1065 #15602
    Shadow
    Member

    concat_ws() function was changed in the 4.0.14 version, so this cannot be the reason of the failure of the sync. Can you think of any changes made to the dbs in question?

    March 23, 2004 at 1:54 pm in reply to: Sync error 1065 #15599
    Shadow
    Member

    No. What about sja.log? Should be located in the same directory where sja.exe is placed.

    March 23, 2004 at 12:48 pm in reply to: Sync error 1065 #15597
    Shadow
    Member

    Hmmm, apparently a string containing only spaces (or nothing at all) was passed to the server for some reason. Can you find such query in the history pane?

    March 23, 2004 at 12:45 pm in reply to: Sync error 1065 #15596
    Shadow
    Member

    Take a look at the history pane. You may find answer to your question!

    March 23, 2004 at 12:39 pm in reply to: print function #15595
    Shadow
    Member

    Well, there are better methods to accomplish this task, although printing is not included in SQLyog. You may copy and paste the table structure information from the object pane to notepad and have it printed. Alternatively, you may create a HTML file containing the schema definition of chosen tables (DB -> Create schema in HTML) and then print that file from your browser.

    March 23, 2004 at 12:34 pm in reply to: CSV Immport Error #15594
    Shadow
    Member

    Glad that it works, but I would like to know a bit more about this problem. Versions of MySql and SQLyog? Are the two tables identical? Are they in the same DB? Do they have the same storage type? Did you tamper with my.ini or my.cnf between the two tries?

    March 23, 2004 at 12:30 pm in reply to: Insert/Update enum malfunction #15590
    Shadow
    Member

    What is MySql 4.23? SQLyog 3.7 is still in beta, if you want to take part in testing it, then send an e-mail to Ritesh. (He is not available for the next 2 days, so be patient!)

    March 22, 2004 at 3:03 pm in reply to: Problem with conflicting MySQL versions #15587
    Shadow
    Member

    The problem is that some MySql versions contain incompatible changes. SQLyog uses the 4.0.x client library (there is a separate version for 4.1.1 and up) and one of your server is 3.x. SJA may work under these circumstances as well, but nothing can be guaranteed.

    About the error message: please check the key constraints, you might have different constraints on the two servers.

    March 22, 2004 at 2:56 pm in reply to: Cannot Edit User #15582
    Shadow
    Member

    Then do as Cal has suggested from the hosting control panel!

    March 22, 2004 at 2:53 pm in reply to: Cleaning field data using MySQL #15583
    Shadow
    Member

    Yep, Table -> Import data from CSV, just set fields terminated by to r.

    March 22, 2004 at 2:48 pm in reply to: Security #15577
    Shadow
    Member

    In this case you may delete the root account, although renaming is sufficient. The purpose of this is to make your MySql server more resistant to brute force attacks, since the attacker has to figure out the admin's username first.

    March 17, 2004 at 3:05 pm in reply to: Synchronization on what Port? Secure? #15573
    Shadow
    Member

    You may determine the ports used for accessing the dbs, however those ports must be the ones that the dbs use. (SQLyog connects to the db itself!!!!) You may try tunneling applications, but those won't help too much either – a port must be opened anyway. If it is possible, then use firewall rules to allow only specified machines to connect to that port.

  • Author
    Posts
Viewing 15 posts - 331 through 345 (of 642 total)
1 2 3 … 22 23 24 … 41 42 43