[peterlaursen]

A small 'test case, would have been nice .. and “it doesn't work, for some odd reason” does not tell much.  What EXACTLY happens.  We cannot advice from the knowledge on what does not happen – we need to know what does happen!

If the INSERT statements are in the form ('full inserts')

INSERT INTO tablename (col1,col2,..,coln) values (val1,val2,..,valn) 

.. it should work. The short form 

INSERT INTO tablename values (val1,val2,..,valn) 

won't if structure was changed

But why do'nt you not just ALTER TABLE form SQLyog when you need to add columns ???

[peterlaursen]

You must log on to

http://www.webyog.com/CustomerArea

you will have to ask the purchase department which email adress they used when purchasing.  because this email you'll need to use for the first logon and we'll asend the password to that email.

We cannot give those details to anybody else than to those who bought and paid, of course.

there is of course 'backdoors' that we can use, if things got 'locked up' somehow.  For instance if nobody remembers that email.

Please then create a ticket!

[peterlaursen]

We have a similar report on SQLyog and heavy flickering with Vista and ALTER TABLE.

It is definitely something we should look into next wek!

[peterlaursen]

You are welcome!  MySQL user management can be demanding, so we will absolutely consider any 'smart' option that could be implemented in SQLyog.

Basically I am just trying to understand details of your explanation.  

I have never seen this before.

I think I and Manoj will have to sit on this next week.

We will probably create a test case and create a priority ticket with MySQL to get an authoritative answer what is supported and documented behaviour and what is n

t.

The concern is of course that we will not create an implementation that gets broken with the next MySQL server update (and especially not with a security related subject like User management).  And that could happen if we implement support for a (now) functional but unsupported and undocumented behaviour.  Also the MySQL developers use the MySQL documentation and they have no obligation to support undocumented features/behaviours for the future.

 

[peterlaursen]

You will need to write a little SQL.

You can

Code:

SELECT from `the_table` where `the_column` like '%the_phrase_to_search%'

if 'the_phrase_to_search' is 'cs' then it will find 'pcs800', pcs900', 'qcs1111' .. any string containming the substring 'cs'.  the ” % ” character is a SQL 'wildcard'

There is an option to paste a SELECT SQL statement template from the table context menu

If you want to search in more columns just use logical OR

Code:

SELECT from `the_table` where `the_first_column` like '%the_phrase_to_search%' OR `the_second_column` like '%the_phrase_to_search%'

'quick filters' are coming soon (in 5.3 or 5.31 probably), so that you can just right-click a cell and select a search option from here.

[peterlaursen]

I certainly know how to use wildcards in host names.

I also know about the db, table, columns, routines .. specific privileges

But the last documents that you refer to also says:

Quote:

The Db, Table_name, and Column_name columns cannot contain wildcards or be blank

However you write:

“In that table the “Db” field is given the value “main_books”

And that is what confuses me!  “main_books” contains a wildcard!

I'll re-read the material and discuss internally with developers here.

[peterlaursen]

I think we have now 4 of those:

Code:

HTTP/1.1 405 Method Not Allowed
Allow: OPTIONS, TRACE, GET, HEAD

You should enable the POST method in webserver (IIS) configuration.

It seems not to be enabled by default.

[peterlaursen]

Got your ticket reading

“Nope, still don't work here.

What ports are involved in this? I'll have to check firewall issues..

Thanks for trying

-nicmar”

Only port 80 is involved in HTTP-tunnelling.

– Peter

[peterlaursen]

I replied to your PM this

“We can connect to the tunneller without problems.

Just try 'localhost' as MySQL host”

and you can create a ticket too – it is just a little 'hidden away'.

You can try clicking on 'about us' on http://www.webyog.com (only one way to do so!) and use the two caramels above your nose … 😛

[peterlaursen]

You can create a ticket, post your details (we only need a 'silly' test database) and let us try.

details:

– User

– password

– URL to the tunneller

… but it looks most like a server issue.

and you are perfectly sure that the URL is correct?  Can you access it from a browser?

[peterlaursen]

OK

First we started to understand we thought that your user management 'style' was undocumented and unsupported by MySQL.  

We also checked 'MySQL Administrator' and it does not support wildcards in user management either.

This http://dev.mysql.com/doc/refman/5.0/en/adding-users.html does not say much.

Do you have any additional docs on 'User management with wildcards' like this.

We have tested it briefly and it works as you describe it.

“when the Host field is left empty in the mysql.db table mysql references the mysql.host table.”  

Yes – it does!  Is it documented?  You know about that?

But still we do not know why you need to escape the wildcard.  

We do not need to do that to achieve the same (if we understand right).

Maybe you have some scripts/applications that we do not know about?

The short answer is that if we shall support it it must be officially supported by MySQL, and will of course take some time too.  

But it is very nice actually in situations where you have a complicated user configuration with your server.  

MySQL does not provide 'roles' and managing hundreds of users – if they each need specific privileges – can be tiresome!

We will study this more in detail and would appreciate links to any docs and guidelines (official or unoffical) that you may be able to provide.

[peterlaursen]

1)

With next release 'execute current query' will work if cursor is positioned after the conluding ” ; ” if there is a single query only.

Comments (if there) must be before this conluding ” ; “.

These

Code:

— comment
show databases;

Code:

show databases
— comment;

will work

this will not

Code:

show databases;
— comment

It also won't work with DELIMITER.  If there is a DELIMITER cursor will still need to be positioned inside the query.

2)

You can try out Notification Services with the ENTERPRISE TRIAL.

If you upgrade to MySQL 5.1 (or 5.2) you can sechedule an event.

Which is preferable depends on the situation and your requirements.  Events do not require a client to connect, but there is no notification/email option.  Actually they can be combined: an event running – say every 30 minutes – can prepare data for a Notifications Service job

[peterlaursen]

Thanks …

We will discuss this, but my first response is that I think it is a server issue.  On Linux there can be a problem having both extensions functional at the same time.  On Windows there is not such problem.

So probably php reported that php_mysqli() was there but it may not have worked properly because of a conflict with php_mysql().

My guess only!

[peterlaursen]

Yes .. free upgrade is for one year.

Please read:

http://webyog.com/faq/30_129_en.html

Our new license policy took effect when we released version 5.0 November 2005 – and that was clearly stated on our website. Before that we used the common shareware concept of 'major' and 'minor' number versions. However, what is a 'major' and a 'minor' program version? Would you be more happy if if we renamed 5.22 to 6.0 ?

However we belive the current solution is much more fair and transparent. We cannot just assign a number arbitrarily and start billing for upgrades. Customers are guaranteed free upgrades for a year no matter what features are added to the program in the period

When version 5.0 was introduced we also lowered the price around 50% (from 97$ to 47% for for a commercial license).

[peterlaursen]

no no .. not picky at all.

We will go detailed through this last post of your tomorrow.

I do not understand everything right now!

[Author]

Posts