Hello,
I'm getting the following errors when using phpMyAdmin:
Notice: Uninitialized string offset: 0 in
/home/y/share/htdocs/phpMyAdmin/db_details_structure.php on line 450
Notice: Uninitialized string offset: 0 in
/home/y/share/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 1396
Has anyone encounterd these errors.
Michael Mulvihill
mikem(a)yahoo-inc.com
Do you uh, Yahoo!?
www.yahoo.com
Hello,
i'm getting the following error:
Notice: Uninitialized string offset: 0 in
/home/y/share/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 1396
not sure what is going on...any info would be great.
Hi list.
Firstly, the bad news. My text editor crashed while I was working on my
new SQL parser, very badly. Totally trashed the file. However, I managed
to recover nearly the entire file from the coredump. And the part that I
didn't get back I was busy rewriting anyway. I'm gonna learn vi instead of
using nano from now on.
Now the good news:
The parser is almost 100% ready to roll now.
TODO:
* detect basic errors in query
* make sure other query types are all formatted quickly
- verified working: SELECT, INSERT, DELETE, CREATE, DROP
- todo: ALTER, UPDATE, ?
* integrate with main PMA source
* optimize more! (is profiling possible in PHP ?)
* PHP3 compatibility ?
URL:
http://games.techbc.ca/~robbat2/sqlparse.php
Notes:
I have completely redone data.php from the MySQL lex.h in the source code,
along with some modifications.
This code hits some servers heavily for resources, I'm not sure why yet.
(This is why it needs the optimizations).
I still want a few more testcases to try out:
1. insert/select queries with nested calls to functions
2. update and alter queries
Known Bugs:
If you have a table/field name that is a function name, and it is not
escaped using the backticks, then the formatting WILL be wrong. There is
no workaround for this. MySQL will reject the query anyway, so I think we
should just document this.
If I get thru these issues this week, then I will see about getting the
code into the CVS tree by next weekend.
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639
Salut Marc,
----- Forwarded message from Marc Delisle <lem9(a)users.sourceforge.net> -----
Modified Files:
sql.php3
Log Message:
patch 565627
Index: sql.php3
===================================================================
RCS file: /cvsroot/phpmyadmin/phpMyAdmin/sql.php3,v
retrieving revision 1.108
retrieving revision 1.109
[....]
! mysql_free_result($cna_all_result);
[...]
----- End forwarded message -----
because of this line (mysql_free_result), I now get lots of warnings
when a page calls sql.php3... :
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/ admin/www/mysql2/sql.php3 on
line 346
Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in
/home/admin/www/mysql2/libraries/ob.lib.php3 on line 53
Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in
/home/admin/www/mysql2/header.inc.php3 on line 23
Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in
/home/admin/www/mysql2/header.inc.php3 on line 24
Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in
/home/admin/www/mysql2/header.inc.php3 on line 25
Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in
/home/admin/www/mysql2/header.inc.php3 on line 26
Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in
/home/admin/www/mysql2/header.inc.php3 on line 28
If I comment the line, everything looks good... :) Same setup
as usual (php 4.2.1, mysql 3.23.44, unix). Is this function
really backward compatible?
Regards,
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
Hi List,
The new SQL parser is functional now, and very capable as well as fast.
Again I am looking for hints and ideas about PHP3 incompatibilites if
there are any in my code (I'm not sure).
http://games.techbc.ca/~robbat2/sqlparse.php
If there is some long and convoluted but still valid query that you want
me to test my code on, please send it my way. Check out the LARGE_* query
tests before you do though.
I'd like suggestions on how to make it even faster on the huge query sets,
like the SQL_MS_SQL* tests that I have in the test harness.
The current code now uses absoltely NO Regex or PCRE functions, and does
nearly everything via strings with a few arrays.
I'd also like suggestions on what we want the indenting to look like, so
that I can code it in as well. Any specific preferences?
The only thing that remains in my code is more SQL validator, which is
mainly for the structure, like missing brackets/quotes etc. I don't think
I will do validation of the keywords or number of function arguments.
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639
Hi,
you are welcome to try this first release candidate for version 2.3.0.
Some improvements:
- new page layout for table and db properties
- centralized db for support tables
- can specify a different charset for MySQL and HTML
- utf-8 charset support
- schema output in PDF
- operators in field selection
- translation feedback page
- print view for SQL results
- EXPLAIN support
- generate PHP code from a query
- full database search
- IP-based Allow/Deny
- foreign table display field
- support for some MyISAM table options
- XML export
Some bug fixes:
CURDATE did not work in the function list
javascript error with Mozilla and Opera
a mysql error when dropping fields
alter table was not working on a replicate
bookmark error when the table no longer exists
bad limit of the number of characters for numeric fields
problem with headers in Apache 2
See http://www.phpmyadmin.net.
Marc Delisle, for the team.
On Fri, 21 Jun 2002, Michal Cihar wrote:
> Could you give somewhere also source of data.php? It seems to be
> required for make it work. I want to test this code on some complicated
> queries.
Please send me the queries as well to add to my test system.
The data.php is on the source page as well now.
> Here are few possible speedups (not tested, just an ideas which came as I saw that):
Thanks.
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639