Article ID: 2109, created on Aug 21, 2007, last review on Apr 18, 2012

  • Applies to:
  • Plesk 8.2 for Windows


Clients\Domain search fails in case of using of square brackets like [CLIENT].

The following error is displayed:

<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Invalid pattern string
---------------------- Debug Info -------------------------------
0: C:\SWSoft\Plesk\admin\plib\common_func.php3:199
        com->execute(string 'select COUNT(*) from clients where (pname like
'%St. John Lutheran Church [274-1267]%' or cname like '%St. John Lutheran
Church [274-1267]%') and 1=1', NULL null)
1: C:\SWSoft\Plesk\admin\plib\common_func.php3:199
        db_query(string 'select COUNT(*) from clients where (pname like
'%[274-1267]%' or cname like '%St. John Lutheran Church [274-1267]%') and 1=1')
2: C:\SWSoft\Plesk\admin\plib\class.ClientsList.php:103
3: C:\SWSoft\Plesk\admin\plib\class.cList.php3:94
4: C:\SWSoft\Plesk\admin\plib\class.cList.php3:113

5: C:\SWSoft\Plesk\admin\htdocs\clients\clients.php3:79


Jet fails to search anything with square brackets.


Please download the following file: 

and place them to %plesk_dir%\admin\plib folder.

b23c51a6195823476e308cc12db2be0e 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c c45acecf540ecd42a4bbfb242ce02b1d 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF