Issue: Incorrect string value:

Issue Tools
- View Changes

February 1, 2017 5:21 PM

Alfa1

Distinguished Member

Incorrect string value:

Code:

Importing edits to wiki pages
An exception occurred: Mysqli statement execute error : Incorrect string value: '\xB1-meth...' for column 'section' at row 1 in [path]/library/Zend/Db/Statement/Mysqli.php on line 214
#0: Zend_Db_Statement_Mysqli->_execute() in [path]/library/Zend/Db/Statement.php at line 297
#1: Zend_Db_Statement->execute() in [path]/library/Zend/Db/Adapter/Abstract.php at line 479
#2: Zend_Db_Adapter_Abstract->query() in [path]/library/Zend/Db/Adapter/Abstract.php at line 574
#3: Zend_Db_Adapter_Abstract->insert() in [path]/library/XenForo/DataWriter.php at line 1638
#4: XenForo_DataWriter->_insert() in [path]/library/XenForo/DataWriter.php at line 1627
#5: XenForo_DataWriter->_save() in [path]/library/vw/XenForo/DataWriter.php at line 352
#6: vw_XenForo_DataWriter->_save() in [path]/library/XenForo/DataWriter.php at line 1419
#7: XenForo_DataWriter->save() in [path]/vault/core/controller/dm/xf.php at line 415
#8: vw_DM_Controller_XF->save() in [path]/vault/core/controller/import/handle/vw3/revision/vw.php at line 343
#9: vw_Import_Handle_VW3_Revision_Controller->add_edit() in [path]/vault/core/controller/import/handle/vw3/revision/vw.php at line 272
#10: vw_Import_Handle_VW3_Revision_Controller->do_edit() in [path]/vault/core/controller/import/handle/vw3/revision/vw.php at line 152
#11: vw_Import_Handle_VW3_Revision_Controller->do_edits() in [path]/vault/core/controller/import/steps/vw3/vw.php at line 466
#12: vw_Import_Steps_VW3_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#13: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#14: vw_Progress_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#15: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#16: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 35
#17: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/impex/vw.php at line 108
#18: vw_CP_ImpEx_Controller->import() in [path]/vault/core/controller/cp/impex/vw.php at line 33
#19: vw_CP_ImpEx_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 118
#20: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/XenForo/FrontController.php at line 351
#21: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
#22: XenForo_FrontController->run() in [path]/admin.php at line 13

Issue Details

Issue Number 4899

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.16

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 22, 2017 2:17 PM

pegasus

VaultWiki Team

You would not be able to search the database for non-ascii characters except in page titles. The page text is in a compressed format.

If you made a PHP script like:

Code:

if (!empty($_POST['test']))
{
$test_text = trim(strval($_POST['test']));

if (mb_check_encoding($test_text, 'ASCII'))
{
die('The text contains only ASCII characters.');
}
else
{
die('The text contains some non-ASCII characters.');
}
}

$form = '&lt;html&gt;&lt;head&gt;&lt;/head&gt;&lt;body&gt;&lt;form action="" method="post"&gt;&lt;textarea name="test" cols="50" rows="20" style="display:block"&gt;&lt;/textarea&gt;&lt;input type="submit" value="Test"&gt;&lt;/form&gt;&lt;/body&gt;&lt;/html&gt;';

header('Content-Type: text/html');
header('Content-Length: ' . strlen($form));

echo $form;
exit;

It's a really basic form. You can copy and paste a large text in, and it will tell you if it contains any non-ASCII characters.

+ Reply

All times are GMT -4. The time now is 5:46 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Incorrect string value:

Issue Tools