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

 

Hi,
 
I wanted to replace some strings in queries' title and content and run the following SQL queries in phpMyAdmin:
 
update qa_posts set title = replace(title, 'xxx', 'yyy');
update qa_posts set content = replace(title, 'xxx"', 'yyy');
 
After that the error appeared when I tried to open a question with replaced strings:
 
Notice: Undefined index: content in /path/to/qa-include/qa-theme-base.php on line 1914
 
I tried to repair tables but the MySQL engine is InnoDB and it doesn't support the repair feature through phpMyAdmin, so I restored the database.
 
The question is how to replace strings in title and content properly?

Please log in or register to answer this question.

...