XF 2.1 emoji support

[Orit]

Hello
I'm trying to run the emoji support script from here: https://xenforo.com/docs/xf2/unicode/#emoji-and-unicode-support
but keep receiving the error:
php: command not found

I can see the function in the cli folder.
What could be the problem?
(Our site was upgraded from vBulletin a few years back)

Thanks!

 

[Chris D]

It's saying it can't find php as a command on your server.

You will need to locate the full path to the PHP executable on your server and prepend that to the command. If you're unsure how to locate it you may need to consult with your host, or the documentation for your operating system or hosting control panel.

 

[Orit]

Thank you Chris
we finally got round to this.
unfortunately a specific column failed and when trying to add emojis we get an error:
XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x98\x80\xF0\x9F...' for column xx.xf_search_index.message at row 1 in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
5. XF\Db\AbstractAdapter->insert() in src/XF/Search/Source/MySqlFt.php at line 96
6. XF\Search\Source\MySqlFt->index() in src/XF/Search/Search.php at line 40
7. XF\Search\Search->index() in src/XF/Behavior/Indexable.php at line 46
8. XF\Behavior\Indexable->XF\Behavior\{closure}() in src/XF.php at line 291
9. XF::triggerRunOnce() in src/XF/Mvc/Dispatcher.php at line 156
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
12. XF\App->run() in src/XF.php at line 391
13. XF::runApp() in index.php at line 20

Is there a way to manually convert the column?

Thanks!

 

[Orit]

It's saying it can't find php as a command on your server.

You will need to locate the full path to the PHP executable on your server and prepend that to the command. If you're unsure how to locate it you may need to consult with your host, or the documentation for your operating system or hosting control panel.

Unfortunately a specific column failed and when trying to add emojis we get an error:
XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x98\x80\xF0\x9F...' for column XXX.xf_search_index.message at row 1 in src/XF/Db/AbstractStatement.php at line 230.

Is there a way to manually convert the column?

I've disabled fullUnicode in the config file and since converting the db I receive continuous server errors:

• LogicException: Job XF:Notifier: createForJob must be overridden
• src/XF/Service/AbstractNotifier.php:26

Stack Trace​

#0 [internal function]: XF\Service\AbstractNotifier::createForJob(Array)
#1 src/XF/Job/Notifier.php(26): call_user_func(Array, Array)
#2 src/XF/Job/Manager.php(253): XF\Job\Notifier->run(G)
#3 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#4 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#5 job.php(42): XF\Job\Manager->runQueue(false, 8)
#6 {main}

How can we resolve this?

Thanks!