Sqlyog 5.12 B7 & B8 Hangs

[shoyu]

Hello,

If I write:

Code:

select xxx, yyy(

in the command window, le program hangs as soon as I press

Code:

(

.

Cheers.

Shoyu

SQLyog v5.12 b7 and b8.

[peterlaursen]

this is an autocomplete issue. I think it does not if you disable auto-complete? Have you had earlier 5.x versions installed?

I suggest you try this:

Delete (or rename) those items:

1) The TAGS folder in installation Folder

2) The keywords.db file in installation folder

Next install Beta8 again. A new keywords.db will be copied by the installer and the new TAG files will be built next you open a connection.

[Ritesh]

Is yyy a SP? Another person reported the same thing yesterday. Something goes wrong with SP it seems.

[peterlaursen]

I tried creating a SP named 'yyy' and still cannot reproduce.

If you have a SP 'yyy' what parameters does it take?

What is MySQL version? Are you sure that you followed all update instructions when/if updating form a previous version?

[peterlaursen]

I think I found a related issue!

This:

DELIMITER $$;

DROP PROCEDURE IF EXISTS `test`.`yyyyyyyyyy`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `yyyyyyyyyy`(a char)

BEGIN

set @test = a;

END$$

DELIMITER ;$$

creates the procedure. However it does not work with autocomplete UNLESS I MANUALLY REBUILD TAGS.

@shoyu: could I ask you to try 'rebuild tags' from 'powertools menu?

.. however it does not hang here (with that SP definition)

[shoyu]

Hello,

I removed the Tagg folder, the keywords.db and then, I reistalled b8.

Now it works perfectly.

Thank you.

Cheers.

Shoyu.

P.S.: xxx was whatever you want.

[peterlaursen]

I fear it may repeat itself next you build a SP.

Could you try that?

[Ritesh]

Was this BETA 8 installed over an existing SQLyog installation?

[peterlaursen]

@Ritesh

The issue that I reported does also occur with a fresh installation.

The 'rebuild tags' from program start-up does not find procedure 'yyyyyyyyyy' – the 'rebuild tags' from 'powertools' menu does.

[shoyu]

Ritesh wrote on May 11 2006, 01:18 PM:

Was this BETA 8 installed over an existing SQLyog installation?

Hello,

The beta 8 was installed over a 5.1 one.

Cheers.

Shoyu

[Ritesh]

peterlaursen wrote on May 11 2006, 10:54 AM:

I think I found a related issue!

This:

DELIMITER $$;

DROP PROCEDURE IF EXISTS `test`.`yyyyyyyyyy`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `yyyyyyyyyy`(a char)

BEGIN

set @test = a;

END$$

DELIMITER ;$$

creates the procedure. However it does not work with autocomplete UNLESS I MANUALLY REBUILD TAGS.

@shoyu: could I ask you to try 'rebuild tags' from 'powertools menu?

.. however it does not hang here (with that SP definition)

Reproduced.

This happens because for all queries executed from the Query Editor, SQLyog looks for CREATE/ALTER/DROP TABLE, CREATE/ALTER/DROP VIEW etc. to rebuild its Autocomplete cache internally. In the above case the statement starts as CREATE DEFINER and not CREATE PROCEDURE, thus it fails to rebuild the cache. Doing Powertools -> Rebuild Tags… forces SQLyog to rebuild all tags and thus it works.

BTW, which version of MySQL are you using?

CREATE DEFINER=`root`@`localhost` PROCEDURE `my`.`yyyyyyyyyy` ()

does not work with 5.1.6-alpha-nt-max but

CREATE PROCEDURE `my`.`yyyyyyyyyy` ()

does.

[peterlaursen]

I think this was copied from 5.0.21.

BTW you should get rid of 5,1,6. Pretty old version 5.1.9 is out!

The 'DEFINER' thing was added recently as a security enhancement.

[Ritesh]

Working on it.

[Ritesh]

http://www.webyog.com/forums/index.php?sho…view=getnewpost

[peterlaursen]

@Ritesh

do you mean to say that beta9 fixes the issue that I reported?

[peterlaursen]

Nope! it does not. No change!

[Author]

Posts