21 Aug
2001
21 Aug
'01
12:38 p.m.
I have a problem when editing the result of a select query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
Thought I'd post it here as I know you are close to release ...
Also a suggestion - in the right hand frame when you click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
Also - any chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
Regards
Lance
21 Aug
21 Aug
1:53 p.m.
On Tue, Aug 21, 2001 at 04:38:56PM +0100, lance wrote:
I have a problem when editing the result of a select
query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
well, which query exactely ?
Also a suggestion - in the right hand frame when you
click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
don't see exactely what you mean. would you like a kind of db_details-light
page ?
Also - any chance of the 'drop database'
option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
that is a _good_ idea. also got the same problem here with my own
customers...
a link "reset database" which would remove all the tables at once
would also be practical (is somewhere in the feature requests tracker
as far as I can remember) : often requested by users here.
these 2 things are not too complex, maybe it can be done before the
end of the week...
Regards,
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
2:27 p.m.
On Tue, 21 Aug 2001, Olivier M. wrote:
Just the main database page is now too big, so the properties could by
default be not shown , but under a bullet and link - database properties
like the bullet and link for 'Print view'
:)
On Tue, Aug 21, 2001 at 04:38:56PM +0100, lance
wrote:
using SELECT in the interface and then editing one of the resulting
records, when you save it doesnt redisplay but says sql error.
I'll set up a database to demonstrate it if you want ...
I have a problem when editing the result of a
select query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
well, which query exactely ? Also a suggestion - in the right hand frame when
you click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
don't see exactely what you mean. would you like a kind of db_details-light
page ?
Also - any
chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
that is a _good_ idea. also got the same problem here with my own
customers...
a link "reset database" which would remove
all the tables at once
would also be practical (is somewhere in the feature requests tracker
as far as I can remember) : often requested by users here.
or maybe call it - 'drop all tables' - like phorum tech support tell my
users to do - but they only see 'drop database' and do that instead :(
these 2 things are not too complex, maybe it can be done before the
end of the week...
Great - I must take a look at the code and see if I can help with anything
..
Regards
Lance
2:34 p.m.
I think it's the quote/select bug (solved now in the cvs) : is your table key a
varchar or char ?
If so, you should try the cvs and tell us what happens.
Alain.
----- Original Message -----
From: "lance" <lance(a)uklinux.net>
To: <phpmyadmin-devel(a)lists.sourceforge.net>
Sent: Tuesday, August 21, 2001 7:27 PM
Subject: Re: [Phpmyadmin-devel] Problem with rc4
On Tue, 21 Aug 2001, Olivier M. wrote:
Just the main database page is now too big, so the properties could by
default be not shown , but under a bullet and link - database properties
like the bullet and link for 'Print view'
:)
On Tue, Aug 21, 2001 at 04:38:56PM +0100, lance
wrote:
using SELECT in the interface and then editing one of the resulting
records, when you save it doesnt redisplay but says sql error.
I'll set up a database to demonstrate it if you want ...
I have a problem when editing the result of a
select query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
well, which query exactely ? Also a suggestion - in the right hand frame when
you click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
don't see exactely what you mean. would you like a kind of db_details-light
page ?
Also -
any chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
that is a _good_ idea. also got the same problem here with my own
customers...
a link "reset database" which would
remove all the tables at once
would also be practical (is somewhere in the feature requests tracker
as far as I can remember) : often requested by users here.
or maybe call it - 'drop all tables' - like phorum tech support tell my
users to do - but they only see 'drop database' and do that instead :(
these 2 things are not too complex, maybe it can be done before the
end of the week...
Great - I must take a look at the code and see if I can help with anything
...
Regards
Lance
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
8:36 p.m.
On Tue, 21 Aug 2001, Alain Brissaud wrote:
I think it's the quote/select bug (solved now in
the cvs) : is your table key a
varchar or char ?
If so, you should try the cvs and tell us what happens.
Hmm - I downloaded the cvs to try it but get an error with the select :-
Call to undefined function: is_defined() in sql.php3 on line 15
BTW descending is missing its 'c' in the select query frame .
Regards
Lance
Alain.
----- Original Message -----
From: "lance" <lance(a)uklinux.net>
To: <phpmyadmin-devel(a)lists.sourceforge.net>
Sent: Tuesday, August 21, 2001 7:27 PM
Subject: Re: [Phpmyadmin-devel] Problem with rc4
On Tue, 21 Aug 2001, Olivier M. wrote:
Just the main database page is now too big, so the properties could by
default be not shown , but under a bullet and link - database properties
like the bullet and link for 'Print view'
:)
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Tue, Aug 21, 2001 at 04:38:56PM +0100, lance
wrote:
using SELECT in the interface and then editing one of the resulting
records, when you save it doesnt redisplay but says sql error.
I'll set up a database to demonstrate it if you want ...
I have a problem when editing the result of a
select query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
well, which query exactely ? Also a suggestion - in the right hand frame when
you click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
don't see exactely what you mean. would you like a kind of db_details-light
page ?
Also -
any chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
that is a _good_ idea. also got the same problem here with my own
customers...
a link "reset database" which would
remove all the tables at once
would also be practical (is somewhere in the feature requests tracker
as far as I can remember) : often requested by users here.
or maybe call it - 'drop all tables' - like phorum tech support tell my
users to do - but they only see 'drop database' and do that instead :(
these 2 things are not too complex, maybe it can be done before the
end of the week...
Great - I must take a look at the code and see if I can help with anything
...
Regards
Lance
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
8:40 p.m.
On Tue, 21 Aug 2001, Alain Brissaud wrote:
I think it's the quote/select bug (solved now in
the cvs) : is your table key a
varchar or char ?
If so, you should try the cvs and tell us what happens.
OK - I realised it should just be && !defined
How does such a bug get into the cvs version ??
The original bug does seem to have been fixed in the cvs version.
The table key was indeed a char .
Regards
Lance
Alain.
----- Original Message -----
From: "lance" <lance(a)uklinux.net>
To: <phpmyadmin-devel(a)lists.sourceforge.net>
Sent: Tuesday, August 21, 2001 7:27 PM
Subject: Re: [Phpmyadmin-devel] Problem with rc4
On Tue, 21 Aug 2001, Olivier M. wrote:
Just the main database page is now too big, so the properties could by
default be not shown , but under a bullet and link - database properties
like the bullet and link for 'Print view'
:)
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Tue, Aug 21, 2001 at 04:38:56PM +0100, lance
wrote:
using SELECT in the interface and then editing one of the resulting
records, when you save it doesnt redisplay but says sql error.
I'll set up a database to demonstrate it if you want ...
I have a problem when editing the result of a
select query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
well, which query exactely ? Also a suggestion - in the right hand frame when
you click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
don't see exactely what you mean. would you like a kind of db_details-light
page ?
Also -
any chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
that is a _good_ idea. also got the same problem here with my own
customers...
a link "reset database" which would
remove all the tables at once
would also be practical (is somewhere in the feature requests tracker
as far as I can remember) : often requested by users here.
or maybe call it - 'drop all tables' - like phorum tech support tell my
users to do - but they only see 'drop database' and do that instead :(
these 2 things are not too complex, maybe it can be done before the
end of the week...
Great - I must take a look at the code and see if I can help with anything
...
Regards
Lance
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
2:52 p.m.
New subject: [Phpmyadmin-devel] Problem with rc4 - $cfgAllowUserDropDatabase
On Tue, Aug 21, 2001 at 06:27:13PM +0100, lance wrote:
:)
voila Sir, feature implemented in current CVS.
Extract of the docs:
$cfgAllowUserDropDatabase boolean
Defines whether standard users (non administrator) are allowed to delete
their own database or not. If set as FALSE, the link "Drop Database" will
not be shown, and even a "DROP DATABASE mydatabase" will be rejected.
Quite
practical for ISP's with many customers.
If you could try it and tell me it if it works fine, that would be nice!
(looks ok on my test server).
ok, this is already a more complex operation. anybody on the list willing
to work on it ? (I can't, have to work on my university stuff tonight :/)
Would simply need a confirmation page (with list of all tables which are
going to be deleted), with one or two checkboxes "are you sure",
and a function which would simply DROP TABLE ***** for each table.
you're welcome!
Regards,
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
using SELECT in the interface and then editing one of
the resulting
records, when you save it doesnt redisplay but says sql error.
I'll set up a database to demonstrate it if you want ...
yes, but with the newest cvs then please :)
Just the main database page is now too big, so the
properties could by
default be not shown , but under a bullet and link - database properties
like the bullet and link for 'Print view'
Well, this kind of stuff (redesign of the properties pages, etc) is planed
for next release (PMA 3.0): it's quite a lot of work, and would need to
re-think lots of pages.
Also - any chance of the 'drop database'
option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
that is a _good_ idea. also got the same problem here with my own
customers... a link
"reset database" which would remove all the tables at once
would also be practical (is somewhere in the feature requests tracker
as far as I can remember) : often requested by users here.
or maybe call it - 'drop all tables' - like phorum tech support tell my
users to do - but they only see 'drop database' and do that instead :( these 2 things
are not too complex, maybe it can be done before the
end of the week...
Great - I must take a look at the code and see if I can help with anything
8:46 p.m.
New subject: [Phpmyadmin-devel] Problem with rc4 - $cfgAllowUserDropDatabase
On Tue, 21 Aug 2001, Olivier M. wrote:
:)
voila Sir, feature implemented in current CVS.
Extract of the docs:
$cfgAllowUserDropDatabase boolean
Defines whether standard users (non administrator) are allowed to delete
their own database or not. If set as FALSE, the link "Drop Database"
will
not be shown, and even a "DROP DATABASE mydatabase" will be rejected.
Quite
practical for ISP's with many customers.
If you could try it and tell me it if it works fine, that would be nice!
(looks ok on my test server).
Seems to work great - thanks :)
Regards
Lance
On Tue, Aug 21, 2001 at 06:27:13PM +0100, lance
wrote:
That seems to be fixed in the latest cvs.
using SELECT in the interface and then editing
one of the resulting
records, when you save it doesnt redisplay but says sql error.
I'll set up a database to demonstrate it if you want ...
yes, but with the newest cvs then please :) Also - any
chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
that is a _good_ idea. also got the same problem here with my own
customers...
8419
days inactive
8419
days old
7 comments
3 participants
participants (3)
-
Alain Brissaud -
lance -
Olivier M.