User Tools
faq:sqlstate-erros
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
faq:sqlstate-erros [2013/12/24 09:59] Alia created |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ======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 | ||
faq/sqlstate-erros.1387879187.txt.gz · Last modified: 2015/09/15 09:10 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
