Oxwall Software Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======Dealing with SQLSTATE errors======

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.

<code php>
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
</code>

  * 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

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

  * 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
Oxwall Software Documentation

User Tools

Site Tools

Page Tools
