You got 500phtml error >enabled debug mode as recommended here >saw SQLSTATE error. What to do next?

SQLSTATE errors indicate that something is wrong in the way script communicates with your database. This document lists most common SQLSTATE errors reported by Oxwall community members and ways to deal with them.

Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 1' at line 1

• Reported to happen when: signing in using Facebook Connect.
• Status: Oxwall Software bug. Fix planned for 1.6
• Caused by: special symbols in user's name on Facebook. Example: Öliya
• Link to discussion on Oxwall forum: http://www.oxwall.org/forum/topic/3834?&page=2

Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'table_name” doesn't exist.

• Reported to happen during: installation, core update, plugin updates.
• Status: Varies.
• Caused by:
  • * server side issue.
  • * corrupted plugin/core archives
  • * upload was not finished completely/successfully
  • * mismatching versions of core and plugins.
• Solution:
  • * contact hosting company to find out whether they had any downtimes on their end
  • * reinstall or run update again
  • * contact plugin developer
  • * check whether your server meets our requirements
  • * make sure that all of your plugins are up to date.
• Links to various discussions on Oxwall forum:
  • * http://www.oxwall.org/forum/topic/8625
  • * http://www.oxwall.org/forum/topic/9298?&page=1
  • * http://www.oxwall.org/forum/topic/7751
  • * http://www.oxwall.org/forum/topic/14969
  • * http://www.oxwall.org/forum/topic/8138
  • * http://www.oxwall.org/forum/topic/3306
  • * http://www.oxwall.org/forum/topic/8056