Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+7 votes
83 views
in Q2A Core by

Seems to be related to how IPs are formatted in the qa_iplimits table of your database.

Running query: LOCK TABLES qa_users WRITE, qa_userlogins WRITE, qa_userlevels WRITE, qa_userprofile WRITE, qa_userfields WRITE, qa_messages WRITE, qa_userfavorites WRITE, qa_usernotices WRITE, qa_userevents WRITE, qa_sharedevents WRITE, qa_cookies WRITE, qa_categories WRITE, qa_pages WRITE, qa_widgets WRITE, qa_posts WRITE, qa_blobs WRITE, qa_words WRITE, qa_titlewords WRITE, qa_contentwords WRITE, qa_tagwords WRITE, qa_posttags WRITE, qa_uservotes WRITE, qa_userpoints WRITE, qa_userlimits WRITE, qa_iplimits WRITE, qa_options WRITE, qa_cache WRITE, qa_usermetas WRITE, qa_postmetas WRITE, qa_categorymetas WRITE, qa_tagmetas WRITE ...

5 upgrade step/s remaining...

Skipping upgrading cookies table since it was already upgraded by another Q2A site sharing it.

Running query: ALTER TABLE qa_iplimits MODIFY ip VARBINARY(16) NOT NULL ...

Running query: UPDATE qa_iplimits SET ip = UNHEX(HEX(CAST(ip AS UNSIGNED))) ...

Database query error 1292

Truncated incorrect INTEGER value: '\x028w~'
UPDATE qa_iplimits SET ip = UNHEX(HEX(CAST(ip AS UNSIGNED)))
Q2A version: Version 1.8-2.6

Please log in or register to answer this question.

...