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

Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 7,398 total)
  • Author
    Posts
  • in reply to: #27172
    peterlaursen
    Participant

    Please read:

    http://webyog.com/faq/content/23/76/en/i-h…ght=very%20long

    We will not change anything! It is not true that 'many mysql hosts etc ..' anymore – 3-4 years ago it happened frequently, but now the situation is very rare! Ask your webhost for a user name that complies with MySQL standards!

    in reply to: #27166
    peterlaursen
    Participant

    Did you try? You will see easily what it does if you try!

    It will keep a *stuck* tab in the 'register servers' page expanded. It is a page display setting/option only and nothing else!

    in reply to: #27155
    peterlaursen
    Participant

    1)

    Please understand that this kind of report is not usable for us! You need to describe things a reproducable way! This is words only. I can also give you a lot of words but it won't bring either of us anywhere ..

    Could you attach a structure-only dump (an importable SQL dump please!) from both hosts to reproduce this? You may create a ticket if you want privacy. Please zip the files into one archive (you are not allowed to attach .sql files here).

    2)

    And in principle you should always check with latest version (now 7.02 final and 7.1 beta2) before reporting a bug. We cannot possibly fix issues in old versions anyway. If there is some bug in an old version we basically also do not care much (as we cannot do anything about it). We will reproduce in latest version and fix in next version. That is all we can!

    in reply to: #27153
    peterlaursen
    Participant

    .. but the PATH to the log file you must enter yourself. From 5.1.6 that can also be fetched automatically.

    Anyway you can just enter correct details yourself!

    in reply to: #27152
    peterlaursen
    Participant

    It should be working with 5.0 too. It simply gets details from SHOW VARIABLES statement.

    Can you describe more in details what happens?

    in reply to: #27150
    peterlaursen
    Participant

    “However, if you lay out a query “nicely” in PHP, I end up with loads of t, etc., in it”

    Doesn't that depend on the editor/IDE you are using when developing?

    in reply to: #27145
    peterlaursen
    Participant

    … and once you have created the VIEW you can query it (almost) just like you would query a TABLE – with the most important exception that not all VIEWs are updateable (for those the underlying table(s) must be updated). That exception has effect for DELETE, INSERT and UPDATE statements, but for SELECT queries it is always true that a VIEW behaves like a table. You may even write a complex query using JOIN's and UNION's and 'mix' VIEWs and TABLEs in the statement.

    in reply to: #27144
    peterlaursen
    Participant

    Your understanding is basically OK, except for one detail!

    You shall not save the VIEW as an SQL file (you can do that too of course!), you should EXECUTE the CREATE VIEW … statement – just like you execute a SELECT – or whatever – SQL statement. Once that is done you will see the view in the VIEWs folder in SQLyog Object Browser. You wil also see in SQLyog HISTORY tab that SQLyog executes the statement

    Code:
    select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'some_database' and `TABLE_TYPE` = 'VIEW';

    .. to 'ask' the server for information about VIEWs in `some_database` database when populating the VIEWs folder.

    They do not store in SQLyog, because *nothing really* (except for SQLyog's own program settings) store in SQLyog. Data (and metadata) are stored on the server – not with the client. Understanding MySQL as a *database server* that is accessed through *client(s)*, and where all communication client>>server is SQL is 'another world' than working with Access.

    Was that explanation enough?

    in reply to: #27142
    peterlaursen
    Participant

    I have 'three' mobile broadband too (www.3.dk) and it works for me.

    The network device I use with this connection is this one: http://en.wikipedia.org/wiki/Huawei_E220 . I can connect through WLAN too from public hotspots with this device installed – but of course I should not dial-up to 3-network if I want to use WLAN!

    in reply to: #27139
    peterlaursen
    Participant

    1)

    99.9% that this is an issue with ZoneAlarm. We had so many reports over time that even when it tells it is switched off it is still blocking! Please try uninstall it totally! Sometimes it will work fine next time you install it …

    2)

    Please use the XP 'search' interface to locate the sqlyog.ini! There *IS* an “Application Data” folder (for every user and for “all users”) in XP. It may have a localised name though. Definitely if you have saved connections you also have a sqlyog.ini!

    in reply to: #27137
    peterlaursen
    Participant

    In versions up to 6.05 .ini is in installation folder

    In versons from 6.06 ini is in user's 'AppData' folder. normally (and wiht English folder names):

    2K/XP/2003: C:Documents and SettingUsersUserApplication DataSQLyog

    Vista/2008: C:UsersUserAppDataRoamingSQLyog

    But it really looks like it is something on your system that is denying SQLyog network access. What 'security programs' do you have except for firewall?

    in reply to: #27134
    peterlaursen
    Participant

    Weird!!

    * Would you mind check spelling, case-sensitvity again?

    * Copy the complete URL from the browser once connected into SQLyog.

    * Try copy the 'sqlyog.ini' file from the old computer to the new one.

    in reply to: #27132
    peterlaursen
    Participant

    And as I also just wrote in your ticket, note that the path to the tunneller is case-sensitive (the Web is!)

    in reply to: #27131
    peterlaursen
    Participant

    Please first read and understand the error message “Could not connect to the tunneling URL”. The tunnelling URL is something like “http://www.myfancyserver.biz/tunnelfolder/SQLyogTunnel.php).

    1) Did you upload the tunneler (SQLyogTunnel.php) to your server? Do you enter the correct file name and path? Can you connect to it from a browser when specifying the same path?

    2) Is there a webserver running (like Apache, IIS etc) running at all on the host (there must be for HTTP tunneling to be functional)?

    Please read the 'getting started' paragraph in the program help about HTTP tunnelling! Are you sure that you understood?

    If the above is all OK then two things more:

    3)

    One more thing you should try is the different 'HTML-content-types' for HTTP tunneling. This setting is available from connection manager .. HTTP .. advanced. Also here refer to the program help file for details.

    4)

    Some server directive may disallow connection to the file if it is in some special folder. Sometimes that is the case with the 'webroot' folder. Also redirection may happen (with Apache mod_rewrite extension for instance). Try creating an empty folder on the server, copy the tunneller there and turn off global server directives for that folder (with Apache you put an empty .htaccess file there) – and specify THAT path of course.

    in reply to: #27130
    peterlaursen
    Participant

    A 'command box' will popup when a SJA scheduled task is running because SQL is a command line program.

    It workaround is to let SJA run wiith privileges of another user than the one that is currently logged on.

    You may use a system user like 'NT AUTHORITYSYSTEM'.

    See: http://webyog.com/faq/content/27/34/en/why…ot-running.html

Viewing 15 posts - 2,761 through 2,775 (of 7,398 total)