Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantPlease 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!
peterlaursen
ParticipantDid 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!
peterlaursen
Participant1)
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!
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!
peterlaursen
ParticipantIt should be working with 5.0 too. It simply gets details from SHOW VARIABLES statement.
Can you describe more in details what happens?
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?
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.
peterlaursen
ParticipantYour 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?
peterlaursen
ParticipantI 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!
peterlaursen
Participant1)
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!
peterlaursen
ParticipantIn 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?
peterlaursen
ParticipantWeird!!
* 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.
peterlaursen
ParticipantAnd as I also just wrote in your ticket, note that the path to the tunneller is case-sensitive (the Web is!)
peterlaursen
ParticipantPlease 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.
peterlaursen
ParticipantA '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
-
AuthorPosts