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
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
On Tue, 21 Aug 2001, Olivier M. wrote:
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 ?
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 ...
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 ?
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'
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
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@uklinux.net To: phpmyadmin-devel@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:
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 ?
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 ...
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 ?
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'
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@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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@uklinux.net To: phpmyadmin-devel@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:
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 ?
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 ...
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 ?
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'
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@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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@uklinux.net To: phpmyadmin-devel@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:
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 ?
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 ...
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 ?
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'
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@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Tue, Aug 21, 2001 at 06:27:13PM +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 ...
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...
:)
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).
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 :(
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.
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
you're welcome!
Regards, Olivier
On Tue, 21 Aug 2001, Olivier M. wrote:
On Tue, Aug 21, 2001 at 06:27:13PM +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 ...
yes, but with the newest cvs then please :)
That seems to be fixed in the latest cvs.
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...
:)
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
-
Alain Brissaud -
lance -
Olivier M.