after seeing this post ( https://xenforo.com/community/threads/2-3-4-2-3-5-mysql-query-error-1406.228818/) i decided to tinker around with the db to see if anything changed. then this happened.
XF\Db\Exception: MySQL statement prepare error [1267]: Illegal mix of collations...
ran the upgrade script and got stuck with this error:
XF\Db\InvalidQueryException: xf_oauth_request: MySQL query error [1071]: Specified key was too long; max key length is 1000 bytes in src\XF\Db\AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in...
I need a sample database query line ( UPDATE tablename SET settings = REPLACE(value,' sample',' sample2'); ) something similar to this. I need to change from "0" in user_id column to actual username id example "14326". The problem with this is columns. it needs to pull column from username to...
I'm trying to port over my vbulletin qr code bbcode and its not working. Can someone get this to work? thanks
html replacment:
<img src="https://qrcode.kaywa.com/img.php?s=5&d=https%3A%2F%2F{param}" alt="qrcode" />
in xen when you scan image it will return as https://{param}
I'm testing the app out. so I manually ran the cron job. The only thing it created is a folder with a metadata.txt but no individual data tables sql. am I missing something ?
after the upgrade, I noticed that the download button is grayed out with a a no permission to download attached. I spent quite a time trying to figure it out. all permission is set to download as a admin, even checked as a member. not sure what else to look for, even clearing cache and...
moved vb over to xen, How can I resolve character issue ? see image. I already made corrective fix but there's lingering issue with characters in the post.