#1336 (in 2.6.0) Database "5"
Here's an unusual problem. I sometimes get it where I start
working with a database, but it ends up thinking my database is
named "5" and then I get errors when trying to continue working
with it, because there is no database named "5".
This is with CVS Snapshop 20040711. I tested Safari 1.2.2, where
it occurs, and Firefox 0.9.1+ 20040714, where it does not occur.
Here's the sequence of steps:
New window
Go to PMA
Either log in (cookie auth), or am already logged in
Select database "test" --> The line across the top reads "Server:
fusion > Database: test" and the window titlebar says something
similar. The select menu in the left frame has the database "test"
selected.
Now create new table "blah" with 1 field --> The line across the
top now reads "Server: fusion > Database: 5 > Table: blah", the
window titlebar concurs, and the left frame reloads so that the
item "(Databases) ..." is selected again. I see the usual form
where I can define the fields in my new table, but if I fill in the
form and click Save, I get a MySQL error "#1046 - No Database
Selected"
Selecting the database from the select menu in the left frame and
repeating the series of steps then produces the correct result. It's
only when performing these steps in a new window.
I tried both language=en-iso-8859-1 and language=en-utf-8 with
anywhere-recoding, doesn't seem to matter
I tried both themes, doesn't seem to matter either
In Firefox, the same steps have the correct result, even in a new
window
This is MySQL 4.0.20-standard with PHP 4.3.6 (www.entropy.ch
release #4) on Mac OS X 10.3.4.
I had this problem quite frequently in the early alpha or beta
releases of 2.6.0 but then didn't see it for awhile so I thought it
was fixed so I didn't report it earlier. I guess maybe I just wasn't
creating any new tables there for awhile.
Logged In: YES
user_id=210714
Ryan,
what is the general opinion in the Mac world about the
stability and compatibility standards of Safari 1.2.2 ?
Logged In: YES
user_id=838923
Hmm... Does that mean that you think Safari is doing something wonky
here?
I think the general opinion is that Apple is making a concerted effort to
put out a browser that's really good: Mac-like, standards-compliant, fast,
and everything else you need. And, because it ships with Mac OS X 10.2
and up, a whole lotta Mac users are going to be using it. It should
probably now be considered comparable to Internet Explorer for
Windows, in that both are pre-installed and so will be the choice for most
users.
One of the Safari developers keeps a fairly detailed weblog[1], from
which it can be inferred that the Safari team is trying their best to keep
up with things.
1: http://weblogs.mozillazine.org/hyatt/
Logged In: YES
user_id=210714
I don't deny that they are *trying* their best to keep up. I
don't think we should make a workaround for Safari 1.2.2,
when we don't have any evidence of a problem in other
browsers. Well, maybe, if you can produce a working patch.
Looks like Safari has problems to transport some variables
in the GET or POST method (here it's the db variable).
In the meantime, can you contact the Safari team about this?
Are they open to user feedback?
Logged In: YES
user_id=210714
Ryan,
does this happen also in Safari 1.2.3 ?
Logged In: YES
user_id=838923
Yes, it does still happen in 1.2.3, with the PMA CVS snapshot from
20040803. (Can't test this in 2.6.0-RC1 or newer snaps because of bug
1006514.)
This is nuts. I can't figure it out. The form has a hidden field called "db"
which contains the name of the database. But when it's submitted, the
raw POST data comes across with a "5" in that field. I'm trying to isolate
this now.
Logged In: YES
user_id=838923
I fixed the "database 5" problem. It was so easy. You'll never
guess what it was! I've been trying to think of the wittiest
thing to say at this point, but I'll just let the included patch
speak for itself.
Logged In: YES
user_id=210714
merged, thanks.