Issue: Import from vw3 fails with database error

4.0.0 Gamma 5
=============
- New Feature: Installer adds 1 public area to help get started
- New Feature: Most Wiki Contributions tab for XenForo Members list
- New Feature: Enable/Disable Reporting for Wiki content
- New Feature: Enable/Disable Wiki Subscriptions
- New Feature: Enable/Disable RSS Feeds
- New Feature: Setting for Maximum Contributors Displayed
- Changed: installer adds 1 system area for pre-sets
- Changed: minimum packet requirement based on expected query size
- Fixed Bug: Serious - can't delete subscriptions
- Fixed Bug: missing descriptions of protect options
- Fixed Bug: collaboration prevention blocks wiki moderators
- Fixed Bug: fatal error with reputation enabled in vB
- Fixed Bug: wiki items break "Activity Stream" forum block in vB
- Fixed Bug: phrases missing for wiki block config in vB
- Fixed Bug: fatal error removing book chapters
- Fixed Bug: read more link points to forum home
- Fixed Bug: wiki pages not showing in Activity Stream in vB
- Fixed Bug: Create tab uses options from first area only
- Fixed Bug: Create tab circumvents area's allowed prefixes
- Fixed Bug: Preview button only works once in vB < 4.1.4
- Fixed Bug: URL conflicts between attachments may appear ambiguous
- Fixed Bug: formatting issues on Special:ImageList
- Fixed Bug: message too long error in WYSIWYG mode in XF
- Fixed Bug: moderator auth not showing in vB4
- Fixed Bug: imported attachments from vB3 are empty
- Fixed Bug: pagenav wraps to new line in XF
- Fixed Bug: Settings > Notifications don't do anything
- Fixed Bug: wiki integration shows anyway on some error pages
- Fixed Bug: URLs with ASCII-range special characters are double-encoded
- Fixed Bug: possible editor button conflicts in XF
- Fixed Bug: file browser won't open after canceled upload
- Fixed Bug: AJAX prefix delete doesn't update the list
- Fixed Bug: IMG tags don't work in wiki pages in XF
- Fixed Bug: BB-Codes not translated in pages during VW3 import
- Fixed Bug: VaultWiki TABLE BB-Code overwrites vB4 TABLE on install
- Fixed Bug: text with ASCII-range special characters is double-encoded in XF
- Fixed Bug: subscriptions only use default notification type
- Fixed Bug: changes on Subscribe tab don't save
- Fixed Bug: invalid user ID on Special:Contributions
- Fixed Bug: AJAX prefix edit form breaks after first dialog
- Fixed Bug: database error entering BB-Code tag for prefix
- Fixed Bug: no permission to tag wiki pages in vB4
- Fixed Bug: reverting permissions redirects to non-existent page
- Fixed Bug: file browser won't open in some browsers
- Fixed Bug: area's content-related options don't save
- Fixed Bug: user subscription preferences don't change default view
- Fixed Bug: improper new line rendering for wiki index
- Fixed Bug: after AJAX area edit, area doesn't reappear in the list
- Fixed Bug: phrase missing for wiki disabled state
- Fixed Bug: temporary tables not removed by uninstall
- Fixed Bug: database error reverting CSS in vB4
- Fixed Bug: invalid argument for pre-Gamma-4 wiki activity block if never edited
  

4.0.0 Gamma 4
=============
- New Feature: Lite Mode
- New Feature: Add First Post when Starting Discussion
- New Feature: Use Wiki Sidebar Blocks as Forum Widgets
- New Feature: Synonyms for Page Sections
- New Feature: Check page existence with [VAR]id|Search for Title[/VAR]
- New Feature: Language Icons Automatically Select
- New Feature: File Health Check / Suspect File Versions
- Changed: compatibility with [bd] Widget Framework
- Changed: compatibility with dbSEO
- Changed: reduced up to 3 queries in vB
- Fixed Bug: can only choose Special for new pages
- Fixed Bug: empty subscription mails in XF
- Fixed Bug: subscription mails don't use user language
- Fixed Bug: database error hard-deleting soft-deleted comments
- Fixed Bug: page can be too long for editor switch in XF
- Fixed Bug: bb-code options cache doesn't update in XF
- Fixed Bug: cache doesn't rebuild if not currently loaded
- Fixed Bug: extra line breaks in plainChildren blocks in XF
- Fixed Bug: subscription mark is too large in XF
- Fixed Bug: can't update text via URL Conflicts admin page
- Fixed Bug: regression - wiki link previews don't work
- Fixed Bug: list preview can be longer than list
- Fixed Bug: 1 extra query due to common specials not cached
- Fixed Bug: some caches never load from datastore
- Fixed Bug: PLAIN doesn't work in wiki pages in XF
- Fixed Bug: missing link to RSS feeds
- Fixed Bug: CSS changes never apply in vB3
- Fixed Bug: forum RSS feeds broken in XF
- Fixed Bug: regression - all section edits are mismatches
- Fixed Bug: empty sub-forum lists on forum list in XF
  

4.0.0 Gamma 3
=============
- New Feature: Setting to Turn Wiki Sidebar On/Off
- New Feature: Disable Individual Wiki Content-Types
- New Feature: Headline Links
- Changed: updated to YUI 3.15.0
- Changed: moderation controls use standards (XF)
- Changed: animated section jumps
- Fixed Bug: XSS vulnerability (vB)
- Fixed Bug: island pages inaccessible if pretty URLs on (vB)
- Fixed Bug: collapse doesn't work for table of contents (vB)
- Fixed Bug: uncached templates (vB)
- Fixed Bug: top control doesn't jump to top
- Fixed Bug: special page headlines don't use icons
- Fixed Bug: editor double-encodes UTF-8 chars (XF)
- Fixed Bug: Legacy code not parsed (XF)
- Fixed Bug: search results not styled (vB4)
- Fixed Bug: bb_attach.gif is missing
- Fixed Bug: comments not imported from VW3
- Fixed Bug: video & image buttons missing from editor (vB)
- Fixed Bug: imported areas have comments disabled
- Fixed Bug: island URLs break after upgrade from VW3
- Fixed Bug: no permission to add attachments to comments (vB4)
- Fixed Bug: page list eats up memory
- Fixed Bug: autolink discovery slow for long page lists
- Fixed Bug: database error viewing Special:MostContributions
- Fixed Bug: install hangs on attach storage error
- Fixed Bug: changing area root corrupts childlist cache
- Fixed Bug: some integration types missing (vB)
- Fixed Bug: vw_path needs index for path
- Fixed Bug: template meta tags not working correctly (vB)

Invalid SQL:
SELECT `username` AS `username`,`userid` AS `userid` FROM `vb_user` WHERE  `username` LIKE 'Dr.Overflow'  OR LIKE 'Μαρακι'  OR LIKE 'geodon'  OR LIKE 'alfeios'  OR LIKE 'thiseas'  LIMIT 5;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE 'Μαρακι'  OR LIKE 'geodon'  OR LIKE 'alfeios'  OR LIKE 'thiseas'  LIM' at line 1
Error Number  : 1064
Request Date  : Monday, May 26th 2014 @ 09:36:01 AM
Error Date    : Monday, May 26th 2014 @ 09:36:01 AM
Script        : [url]http://www.supa.gr/forums/admincp/wiki_cp.php?panel=impex&do=import&step=11&nostyle=1[/url]
Referrer      : [url]http://www.supa.gr/forums/admincp/wiki_cp.php?panel=impex&do=import&step=10&nostyle=1[/url]
IP Address    : 194.219.40.61
Username      : Dr.Overflow
Classname     : vB_Database
MySQL Version : 5.5.37-cll-lve

	public function like($input, $keywords = null)
	{
		list($field, $keywords) = $this->like_format($input, $keywords);

		$out = array();
		$pre = ' ';

		if ($field)
		{
			$pre .= $this->wrap($field) . ' ';
		}

		foreach ($keywords AS $keyword_info)
		{
			$like = "LIKE '";

			if (!empty($keyword_info['left']))
			{
				$like .= '%';
			}

			$like .= $keyword_info['keyword'];

			if (!empty($keyword_info['right']))
			{
				$like .= '%';
			}

			$like .= "' ";

			$out[] = $like;
		}

		return $pre . implode(' OR ', $out);
	}

	public function like($input, $keywords = null)
	{
		list($field, $keywords) = $this->like_format($input, $keywords);

		$out = array();

		foreach ($keywords AS $keyword_info)
		{
			$like = ' ';

			if ($field)
			{
				$like .= $this->wrap($field) . ' ';
			}

			$like .= "LIKE '";

			if (!empty($keyword_info['left']))
			{
				$like .= '%';
			}

			$like .= $keyword_info['keyword'];

			if (!empty($keyword_info['right']))
			{
				$like .= '%';
			}

			$like .= "' ";

			$out[] = $like;
		}

		return implode(' OR ', $out);
	}