Posts:
1
Registered:
7/14/11
|
|
|
|
unknown database questdebug, while trying to debug a stored proc
Posted:
Jul 14, 2011 7:19 AM
|
|
|
Hi,
I'm ending up in the following error
unknown database questdebug
when I tried to debug a sample procedure. I'm able to successfully execute them though. only the debug doesn't work.
I'm using Toad for MySql 5.0.0.345
I suspected the debug mode uses an instance of the database, so I created an instance called questdebug to see the error change to something else. The new error is now
Table 'questsoftware.debugbreakpoints' does not exist.
Did anyone encounter these problems. and how did you work around them. I suspect the installation should create this debug database, which for some reason did not create.
Any help would be appreciated.
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: unknown database questdebug, while trying to debug a stored proc
Posted:
Jul 14, 2011 9:45 AM
in response to: developer123
|
|
|
There are a couple of objects that needs to be created on the server for debugging to work. Toad should create these automatically though the first time you try to load the debugger.
What version of MySQL are you using?
|
|
|
Posts:
12
Registered:
2/20/11
|
|
|
|
Re: unknown database questdebug, while trying to debug a stored proc
Posted:
Oct 23, 2011 4:44 PM
in response to: Mauritz
|
|
|
Hi ..
I just had the same problem.
I'm using Toad for mySQL v 5.0.0.3.4.5 with mySQL v 5.1.50.
the quest debug tables have not been created.
Did I miss a specific step during the setup?
any help much appreciated.
(Hoping I don't have to wait too long for an answer) :-)
TIA
Fred
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: unknown database questdebug, while trying to debug a stored proc
Posted:
Oct 23, 2011 5:14 PM
in response to: dbyy
|
|
|
These should be created automatically. One thing I would try is to download the 6.0.1 version of Toad for MySQL and see if that works for you.
|
|
|
Posts:
12
Registered:
2/20/11
|
|
|
|
Re: unknown database questdebug, while trying to debug a stored proc
Posted:
Oct 24, 2011 7:40 PM
in response to: Mauritz
|
|
|
Hi Mauritz,
thanks for your quick response.
Is there no script available that I can run independently?
And why has the database no been created in the first place?
And as it relates to your suggestion to install version 6.0.1...
I tried to install v 6.0.1 on the same machine (with Toad4mysql vers. 5.0.0.3.4.5)
but the installation stops after the first user dialog and v6.0.1 does not get installed :-(
Do I have to uninstall v 5.x first?
And what happened with my named scripts and reports that I have created in v 5.x when I uninstall it?
I know... many many questions :-)
Maybe there is a simple answer to those 2 questions.
Thanks
Fred
|
|
|
Posts:
121
Registered:
4/5/10
|
|
|
|
Re: unknown database questdebug, while trying to debug a stored proc
Posted:
Oct 25, 2011 1:53 PM
in response to: dbyy
|
|
|
You can keep your 5.0 and install 6.0 side-by-side to it.
For installation issue. Please try silent install.
1.Download the .exe installer to your local drive, say c:\temp 2.For windows 7 and Vista users, make sure you open command window with admin privilege. You can type "cmd" in start menu, and right click "run as Administrater" to invoke it. 3. Run the silent install command
"ToadforMySQL<version>.exe" /S /L*v "c:\temp\installLog.txt" 4. Wait about 15 minutes and check the log file to confirm the install complete successful.
After 6.0 is installed, you can launch it and choose to migrate settings from version 5.0 so that all you preference is kept.
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: unknown database questdebug, while trying to debug a stored proc
Posted:
Oct 25, 2011 2:11 PM
in response to: Kiki
|
|
|
If for some reason the install does not complete please let us know what the contents of the installLog.txt file is so we can hopefully fix it.
|
|
|
Posts:
12
Registered:
2/20/11
|
|
|
|
Re: unknown database questdebug, while trying to debug a stored proc
Posted:
Oct 25, 2011 9:03 PM
in response to: Mauritz
|
|
|
Hi
I just installed version 6.0.1 according to the instructions from Kiki in te previos postign and it appears to me it work. I could launch the new version (on one of my computers).
I will trying to debug a SP (questdebug database) tomorrow and will keep you posted.
Thanks for the help
Fred
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
