2 Oct
2005
2 Oct
'05
4:30 p.m.
SHOW FULL TABLES now returns 'VIEW' instead of 'view'
should phpMyAdmin recognice both? or cause 'view' was only used in BETA
drop support for 'view' and now only support 'VIEW' (beside this that at
the moment PMA only supports 'view' and reports an error on MySQL 5.0.13)
--
Sebastian Mendel
www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com
www.sf.net/projects/phpdatetime www.sf.net/projects/phptimesheet
3 Oct
3 Oct
8:50 a.m.
HI Sebastian,
It should recognize both, IMO. Are you working on this?
Marc
Sebastian Mendel a écrit :
SHOW FULL TABLES now returns 'VIEW' instead of
'view'
should phpMyAdmin recognice both? or cause 'view' was only used in BETA
drop support for 'view' and now only support 'VIEW' (beside this that at
the moment PMA only supports 'view' and reports an error on MySQL 5.0.13)
4 Oct
4 Oct
1:21 a.m.
Marc Delisle schrieb:
Sebastian Mendel a écrit :
no, i just stumbled over, as upgrading my MySQL
--
Sebastian Mendel
www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com
www.sf.net/projects/phpdatetime www.sf.net/projects/phptimesheet
SHOW FULL TABLES now returns 'VIEW'
instead of 'view'
should phpMyAdmin recognice both? or cause 'view' was only used in BETA
drop support for 'view' and now only support 'VIEW' (beside this that at
the moment PMA only supports 'view' and reports an error on MySQL 5.0.13)
It should recognize both, IMO. Are you working on this?
4:36 p.m.
Sebastian Mendel a écrit :
Marc Delisle schrieb:
Initial testing indicates that changing line 40 in
tbl_properties_table_info.php to
if (PMA_MYSQL_INT_VERSION >= 50000 && !isset($showtable['Type'])
&&
isset($showtable['Comment']) && strtolower($showtable['Comment'])
==
'view') {
might be enough, please confirm.
Marc
Sebastian Mendel a écrit :
no, i just stumbled over, as upgrading my MySQL
SHOW FULL TABLES now returns 'VIEW'
instead of 'view'
should phpMyAdmin recognice both? or cause 'view' was only used in BETA
drop support for 'view' and now only support 'VIEW' (beside this that at
the moment PMA only supports 'view' and reports an error on MySQL 5.0.13)
It should recognize both, IMO. Are you working on this?
5 Oct
5 Oct
2:50 a.m.
Marc Delisle wrote:
Sebastian Mendel a écrit :
i would prefer
strtoupper( $showtable['Comment'] ) == 'VIEW'
as in most cases $showtable['Comment'] will be UPPERcase
and doing an strtoupper() on an UPPERcase string is faster than doing
strtolower on an UPPERcase string (at least on Windows by 50%)
beside the fact that it looks 'more correct' as it normally and
correctly would be 'VIEW' and not 'view'
and possible leave a comment hinting that fact for MySQL 5.0.<12
db_details_structure.php: line #197, #443
--
Sebastian Mendel
www.sebastianmendel.de
www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet
Marc Delisle schrieb:
Initial testing indicates that changing line 40 in
tbl_properties_table_info.php to
if (PMA_MYSQL_INT_VERSION >= 50000 && !isset($showtable['Type'])
&&
isset($showtable['Comment']) && strtolower($showtable['Comment'])
==
'view') {
might be enough, please confirm. Sebastian Mendel a écrit :
no, i just stumbled over, as upgrading my MySQL
SHOW FULL TABLES now returns 'VIEW'
instead of 'view'
should phpMyAdmin recognice both? or cause 'view' was only used in BETA
drop support for 'view' and now only support 'VIEW' (beside this
that at
the moment PMA only supports 'view' and reports an error on MySQL
5.0.13)
It should recognize both, IMO. Are you working on this?
8:40 a.m.
Sebastian Mendel a écrit:
Marc Delisle wrote:
Agreed and merged!
Marc
Sebastian Mendel a écrit :
i would prefer
strtoupper( $showtable['Comment'] ) == 'VIEW'
as in most cases $showtable['Comment'] will be UPPERcase
and doing an strtoupper() on an UPPERcase string is faster than doing
strtolower on an UPPERcase string (at least on Windows by 50%)
beside the fact that it looks 'more correct' as it normally and
correctly would be 'VIEW' and not 'view'
and possible leave a comment hinting that fact for MySQL 5.0.<12
db_details_structure.php: line #197, #443
Marc Delisle schrieb:
Initial testing indicates that changing line 40 in
tbl_properties_table_info.php to
if (PMA_MYSQL_INT_VERSION >= 50000 && !isset($showtable['Type'])
&&
isset($showtable['Comment']) && strtolower($showtable['Comment'])
==
'view') {
might be enough, please confirm. Sebastian Mendel a écrit :
> SHOW FULL TABLES now returns 'VIEW' instead of 'view'
>
> should phpMyAdmin recognice both? or cause 'view' was only used in
> BETA
> drop support for 'view' and now only support 'VIEW' (beside this
> that at
> the moment PMA only supports 'view' and reports an error on MySQL
> 5.0.13)
It should recognize both, IMO. Are you working on this?
no, i just stumbled over, as upgrading my MySQL
3 Oct
3 Oct
9:03 a.m.
Hi
On Sun 2. 10. 2005 22:19, Sebastian Mendel wrote:
SHOW FULL TABLES now returns 'VIEW' instead of
'view'
should phpMyAdmin recognice both?
Yes, people will be using beta versions for long time and would complain
if we do not detect it (especially when it worked before).
--
Michal Čihař | http://cihar.com
6841
days inactive
6844
days old
6 comments
3 participants
participants (3)
-
Marc Delisle -
Michal Čihař -
Sebastian Mendel