We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Dealing with SQLSTATE errors. | Forum

Alia Team
Alia Dec 24 '13

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

This topic lists most common SQLSTATE errors reported by 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:

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

        Reported to happen when: installation, core update, plugin updates.
        Status: Varies.
        Caused by: Server side issue OR corrupted plugin/core files OR upload was
        not finished completely/successfully OR mismatching versions of core and
        Solution: reinstall or run update again. Contact host to find out whether they
        had any downtimes on their end. 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:

Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2145871224’ for key “PRIMARY”

        Screen shot of the exact error message:
        Reported to happen when: using “Newsfeed” plugin.
        Caused by: duplicate entries in database ( known to happen on sites with lots of data).
        Solution: truncate ow_newsfeed_action_set database table.
        Link to the solution on Oxwall forum:

Message: SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes

        Reported to happen when: sending mass mailing.
        Status: Server configuration. Not a bug.
        Caused by: the length of the  request exceeding the MySQL limit of  max_allowed_packet. The limit is set to1M by default.
        Solution: Increase max_allowed_packet value. Root access required. If you don't have root access, contact your host. If you do have root
        access: http://forums.cpanel.net/...d_packet-361521.html
        Link to the solution on Oxwall forum:

Message:SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine. Unknown: write failed: No space left on device (28) File: Unknown Line: 0

        Reported to happen when: loging in as any user.
        Status: Server configuration. Not a bug.
        Caused by: no space left.
        Solution: clean up unneeded files. Example: clear the /tmp folder to free up hard drive space on the server root.
        Links to discussions on Oxwall forum:

Message:SQLSTATE[28000] [1045] Access denied for user 'user@localhost(using password: YES)

        Reported to happen when: software installation is completed.
        Status: Server configuration. Not a bug.
        Caused by: incorrect permissions given to user over the certain database.
        Solution: granting the user all privileges to the database.
        Links to discussions on Oxwall forum:

This topic is sticky
This topic is locked