Database Error: TABLE FULL (wp_options & wp_postmeta)
-
I’ve searched the Internet, the forums, and the bug reports for 3 days to try to find an answer but couldn’t.
Had a clean install of 2.3.0 with MySQL on a Windows Server.
Worked perfectly with the theme and all plugins for 2 weeks. Then suddenly this error occured. (about 100 posts are up)
Error: upon editing or publishing I get a Database Error that two Tables are Full
WordPress database error: [The table ‘wp_postmeta’ is full]
INSERT INTO wp_postmeta (…) VALUES (…)WordPress database error: [The table ‘wp_options’ is full]
UPDATE wp_options SET option_value = ‘a:424:{i:1192930370;a:1:{s:8:\”do_pings\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:2: …lots of data here…’
WHERE option_name = ‘cron’Actions Taken:
- Deactivated all plugins – errors still there
- Backed up the database, upgraded to 2.3.1 from 2.3.0, first deactivating all plugins – errors still there
- Opened up the DB (have a dedicated server) using MySQL Administrator and looked at the schema. No table is even 50% capacity and the two tables in the error wp_postmeta and wp_options are at 144kb and 1.1MB respectively
The Table Types are InnoDB and I’m not sure if that would be an issue since the default size should be 2TB on a Windows server:
http://dev.mysql.com/doc/refman/5.0/en/full-table.htmlI wouldn’t think that a table could fill up after a blog is up for two weeks. The site itself is fine. These errors only occur when trying to write or edit a page or post.
The issue wouldn’t seem to be the theme or any plugin based on the tests I have done above, but who knows.
I’ve searched everywhere for an answer because I don’t like to waste anyone’s time. There does appear to be a lot of data in the ‘cron’ row of the [wp_options] table but I don’t know if that is normal.
Thank you for your professional help.
-
Same problem here. Have less than 200 posts. Nothing is anywhere near my capacity but after two weeks I’m no longer able to see my list of published pages because I get an WordPress database error [MySQL client ran out of memory]
The topic ‘Database Error: TABLE FULL (wp_options & wp_postmeta)’ is closed to new replies.