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

I am in a situation where the 8000 characters allowed are not sufficient for posting content. I tried to increase the 8000 to 20000 but get the mysql error notice:

1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

When I change VARCHAR to TEXT, what are the consequences? Will q2a get any problems with that?

---

EDIT: I changed 'content' from VARCHAR to MEDIUMTEXT now and it seems to work.

With MediumText you get: max. ~16MB – 16,777,215 character – around 4,194,303 utf-chars

If you need to do the same, after the DB changes, you need to edit file qa-db-maxima.php:

@define('QA_DB_MAX_CONTENT_LENGTH', 500000); // before 8000 (varchar)

 

Q2A version: 1.6.2
by
edited by
This question is still open, can somebody tell me if it will slow down q2a? Will changing qa_posts field "content" from "varchar(8000)" to "Mediumtext" slow down q2a?

Okay, found it myself: http://stackoverflow.com/a/24156661/1066234

1 Answer

+1 vote
by
I guess you should create a clone of your site on localhost to be sure, but recalling the code on db read and write functions I think you will have no problem.

but of course you will have to edit 'qa-db-install.php' file each time you want to update your Q2A to be sure that it wont overright previous change and trim content.
by
Thanks for the hint with the update problem!
...