-
Word "POLUCHENO".
2004-12-23 18:36:31 UTC in PHP SysInfo
-
World "Получено" (Received) It is written with a mistake. 'и' instead of 'e'.
2004-12-23 18:34:04 UTC in PHP SysInfo
-
Logged In: YES
user_id=218271
CREATE TABLE `test` (
`EMPLOYEE_ID` int(11) NOT NULL default '0',
KEY `EMPLOYEE_ID` (`EMPLOYEE_ID`),
CONSTRAINT `test_ibfk_1` FOREIGN KEY
(`EMPLOYEE_ID`) REFERENCES
`human_resources`.`employee` (`EMPLOYEE_ID`)
) TYPE=InnoDB.
2004-07-02 17:07:19 UTC in phpMyAdmin
-
Logged In: YES
user_id=218271
explode wold fail because function PMA_SQP_parse
splits 'human_resources.employee' to three arrays:
[31] => Array ( [type] => quote_backtick [data] =>
`human_resources` )
[32] => Array ( [type] => punct_qualifier
[data] => . )
[33] => Array ( [type] => quote_backtick [data]
=> `employee` )
but explode is applied to thirst one, second one, and third.
2004-07-02 16:28:13 UTC in phpMyAdmin
-
Logged In: YES
user_id=218271
PHP Version 4.3.7.
2004-07-02 16:21:55 UTC in phpMyAdmin
-
Logged In: YES
user_id=218271
trace (human_resources)
trace2 Array ( [0] => human_resources ) trace (employee)
trace2 Array ( [0] => employee )
2004-07-02 16:21:22 UTC in phpMyAdmin
-
Logged In: YES
user_id=218271
i fix this bug :)
in file 'sqlparser.lib.php' at line 1497:
if ($seen_references) {
$identifier = str_replace('`','',$arr[$i]['data']);
if ($in_bracket) {
$foreign[$foreign_key_number]['ref_index_list'][] =
$identifier;
} else {
// identifier can be table or db.table
if (isset($arr[$i+1]['data']) && $arr[$i+1]['data'] == ".") {...
2004-07-02 15:29:36 UTC in phpMyAdmin
-
Logged In: YES
user_id=218271
My further researches have shown that the information on
base human_resources is eaten with function
PMA_SQP_analyze as after performance PMA_SQP_parse
($show_create_table) the information still remains, however
after performance PMA_SQP_analyze she vanishes:
after PMA_SQP_parse:
Array ( [raw] => CREATE TABLE `test` ( `EMPLOYEE_ID` int
(11) NOT NULL...
2004-07-02 14:53:42 UTC in phpMyAdmin
-
Logged In: YES
user_id=218271
Array ( [constraint] => test_ibfk_1 [index_list] => Array ( [0]
=> EMPLOYEE_ID ) [ref_table_name] => employee
[ref_index_list] => Array ( [0] => EMPLOYEE_ID ) )
Array ( [EMPLOYEE_ID] => Array ( [constraint] =>
test_ibfk_1 [foreign_db] => test [foreign_table] => employee
[foreign_field] => EMPLOYEE_ID ) )
2004-07-02 14:52:01 UTC in phpMyAdmin
-
Logged In: YES
user_id=218271
Similarly the mistake in function PMA_getForeigners. As she
generates a wrong name of the database (test insteed
human_resources).
I insert command 'printf($foreigners);' after line 90 in
file 'tbl_select.php':
Array ( [EMPLOYEE_ID] => Array ( [constraint] =>
test_ibfk_1 [foreign_db] => test [foreign_table] => employee
[foreign_field] => EMPLOYEE_ID...
2004-07-02 14:37:35 UTC in phpMyAdmin
