phpMyAdmin / Bugs / #4883 (ok 4.4.5) Search function breaks when searching for vertain combinations of backslashes and slashes

#4883 (ok 4.4.5) Search function breaks when searching for vertain combinations of backslashes and slashes

Milestone: 4.2.6

Status: fixed

Owner: Madhura Jayaratne

Labels: search (2) input (1)

Priority: Normal

Updated: 2015-05-05

Created: 2015-04-30

Creator: Michael Northcott

Private: No

It seems that from version 4.2.4.1 to present, there is an inability to search all tables of a database for values containing backslash-escaped forward slashes.

For example, I searched for "wp\/", and was given a red error popup telling me that a 500 Internal Server Error had occurred. This issue is making it difficult to find and update old paths in test instances of WordPress in preparation for making them go live, as some WordPress features store JSON data, escaped slashes and all. My workaround at the moment has been full export and reimports of the database after making manual corrections in my text editor.

1 Attachments

pma_error_search.png

Discussion

Michael Northcott - 2015-04-30

Edit: it seems SourceForge changed the string that I indicated that I searched for, but thankfully the image I uploaded still contains the correct string.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michael Northcott - 2015-04-30

Just noticed when I tried this in 4.4.4, I get an error log entry:

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 33554619 bytes) in /srv/apache2/www/w_home.aplus/html/phpMyAdmin/libraries/DbSearch.class.php on line 253

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-05-01

assigned_to: Madhura Jayaratne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-05-01

This seems to work for me. See the attached image. Do you have a large number of tables in this database? And do these tables have large number of columns?

search.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Madhura Jayaratne - 2015-05-01
  
  I think I figured out the problem. Working on a solution now.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-05-01

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/89949d61829b59f5a85151772d171b97140e2a6d

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-05-01

summary: Search function breaks when searching for vertain combinations of backslashes and slashes --> (ok 4.4.5) Search function breaks when searching for vertain combinations of backslashes and slashes

status: open --> resolved
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2015-05-05

Status: resolved --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(ok 4.4.5) Search function breaks when searching for vertain combinations of...

A software tool to bring MySQL to the Web

Group

Searches

Help

#4883 (ok 4.4.5) Search function breaks when searching for vertain combinations of backslashes and slashes

Discussion