Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
  • Register
Welcome to the Q&A for Question2Answer.

If you have questions about the platform, click here to ask and please use English.

If you just want to try Q2A, please use the demo, which also grants admin access.

Apr 29: Q2A 1.5.2

what can I do with mysql?

0 votes

My site is down and I find something in error_log that:

[08-Sep-2011 00:05:52] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
[08-Sep-2011 00:05:52] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
[08-Sep-2011 00:05:52] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
[08-Sep-2011 00:05:52] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
[08-Sep-2011 00:05:52] PHP Fatal error:  Allowed memory size of 73400320 bytes exhausted (tried to allocate 122880 bytes) in /home/xautlin1/public_html/qa-include/qa-install.php on line 194
[08-Sep-2011 00:06:09] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_users.frm'
[08-Sep-2011 00:06:09] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
[08-Sep-2011 00:06:09] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
[08-Sep-2011 00:06:09] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
[08-Sep-2011 00:06:09] Question2Answer MySQL query error 1033: Incorrect information in file: './xautlin1_qa/qa_options.frm'
asked Sep 8, 2011 in Q2A Core by anonymous
The fatal error looks like it could be to do with an ereg overflow due to the new limits on php 5+ restrictions which are set to low (php preg_replace() can cause this), try adding this to the index.php:

if ( @ini_get('pcre.backtrack_limit') <= 950000 )
@ini_set('pcre.backtrack_limit', 950000);
if ( @ini_get('pcre.recursion_limit') <= 350000 )
@ini_set('pcre.recursion_limit', 350000);

I can't see the full text for the other errors in your post however.

1 Answer

0 votes
This will be some kind of corruption or other problem inside MySQL. I recommend Googling 'mysql error 1033' and seeing what you can find.
answered Sep 27, 2011 by gidgreen