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

Forum Replies Created

Viewing 15 posts - 406 through 420 (of 642 total)
1 2 3 … 27 28 29 … 41 42 43
  • Author
    Posts
  • December 18, 2003 at 10:16 am in reply to: Error No 1043 – Bad handshake #15314
    Shadow
    Member

    Did you fix the mysql db that stores the access rights?

    December 18, 2003 at 7:31 am in reply to: Error No 1043 – Bad handshake #15312
    Shadow
    Member

    Perhaps kengaun should run the script that fixes the privileges…

    December 17, 2003 at 9:50 am in reply to: Error No 1043 – Bad handshake #15310
    Shadow
    Member

    From what version did you upgrade? Have you checked MySql's website for known bugs regarding this issue?

    This problem seems to be with Mysql and not SQLyog…

    December 15, 2003 at 2:17 pm in reply to: Important Features MISSING! #15353
    Shadow
    Member

    1. You have grossly overlooked something! 😀

    Type in a select statement with a WHERE clause to find the rows you want to update, then hit F8 – Select for update.

    2. You are right about the Cancel problem.

    3. SQLyog is a db admin tool and not an end-user front end, therefore it was not designed to handle problems arising from concurrent data manipulation. That's why I think there is absolutely no need for a “recheck DB before write” button.

    4. Better searching in the I/U window might be useful, but apparently this function is not a priority (similar request was submitted before).

    December 13, 2003 at 7:55 am in reply to: Data sync wipes data out! #15349
    Shadow
    Member

    As far as I'm concerned, no. DB1 is the 'master', therefore DB2 is completely synced with it. Ritesh has already promised a two-way sync to be implemented in the future.

    You may want to check MySql's built-in replication function! The user commented version of MySql manual contains an example of setting up a db as master and slave in the same time.

    December 13, 2003 at 7:47 am in reply to: Connect Problem please Help #15351
    Shadow
    Member
    Quote:
    Error No. 1130

    Host 'IP-Adress' is not allowed to connect to this MySQL server

    Means that your machine is not allowed to connect to the MySql db. If you have controll over the MySql db, then the host access rights must be edited. Otherwise you need to ask the operator to grant your machine sufficient rights.

    December 12, 2003 at 3:32 pm in reply to: connecting to MS SQL-server #15346
    Shadow
    Member

    SQLyog was designed to handle MySql servers ONLY. You'll need to find other tools to connect to MS SQL Servers. DBDesigner4 may be a good solution. It was designed to work with MySql as well, but other DBs were added later. And it is a visual editor.

    December 9, 2003 at 12:05 pm in reply to: Handshake error #15344
    Shadow
    Member

    See this topic!

    December 9, 2003 at 9:43 am in reply to: How do you? #15335
    Shadow
    Member

    What I wanted to point out by saying that SQLyog is an admin tool was that it can be used to enter loads of data through its GUI, but it's not really convenient regardless of the support (no support in this case) of MySql functions. You can still write your own SQL statements in its SQL window and have them executed. If it had form designer and report building capabilities, then yes, I would complain about not supporting MySql functions in the data entry tool. Its stated primary objective is to be the best tool for managing dbs. As time passes, it may acquire end-user friendly functions, of course. However, I believe an improved sync engine is more important.

    Regarding the support of non-standard defauld values (functions, etc.). I would say it is MySql's task to implement this absolutely useful feature. Workarounds can be devoleped (by storing parametrized queries in SQLyog, for example), but they could not be used outside of SQLyog. If the developers of SQLyog decided to create a full end-user tool, then they should consider incorporating this function, as well.

    December 8, 2003 at 1:06 pm in reply to: SQLyog "Not Responding" during ODBC import #15296
    Shadow
    Member

    Sorry, I mixed sja with ODBC import 🙄

    Anyway, it's good to hear that Max is going to be a multithreaded version!

    December 8, 2003 at 1:04 pm in reply to: Insert/Update Version 3.01 #15338
    Shadow
    Member

    I'm bit messy today… I wanted to give you a link where you can

    get additional info.

    December 8, 2003 at 1:02 pm in reply to: Insert/Update Version 3.01 #15337
    Shadow
    Member

    I have bad news for you, this is a known issue of v3.0. Consider upgrading! The problem is that I don't know whether v3.11 has the same issue or not 😕

    December 8, 2003 at 12:55 pm in reply to: How do you? #15333
    Shadow
    Member

    Later on, when you insert new rows into an existing table (or update rows) then you may be able tos specify functions as the value of the field. phpMyAdmin must have some kind of a workaround to allow this feature. SQLyog's insert/update window does not allow functions to be used, but it's an admin tool rather than an end-user-data-entry tool.

    December 8, 2003 at 12:49 pm in reply to: How do you? #15332
    Shadow
    Member

    An excerpt from MySql's manual:

    Quote:
    A DEFAULT value has to be a constant, it cannot be a function or an expression.

    (6.5.3 CREATE TABLE Syntax)

    I beleive that answers your question.

    December 5, 2003 at 8:26 am in reply to: SQLyog "Not Responding" during ODBC import #15294
    Shadow
    Member

    If task manager says that an application is not responding, it doesn't necessarily mean the app has stopped working. Task manager merely points out that the app does not respond to GUI events. It would be nice if SQLyog created a separate thread to deal with the progress report of sja and would not just sit there and wait for the sync to be completed.

  • Author
    Posts
Viewing 15 posts - 406 through 420 (of 642 total)
1 2 3 … 27 28 29 … 41 42 43