iPhone 4 (Jailbroken, iOS 4.0) SMS Mailbox Full?

[SilentEcho13]

I have a 32gb iPhone 4 running iOS 4.0, recently jailbroken. I initially had the missing FaceTime and mms but installed the fix from cydia.

Today I synced my phone and I keep getting the "SMS mailbox full" prompt asking me to delete messages.

I went on and deleted atleast 1000 messages but I still get the error. A respring, reset, and a power cycle don't seem to fix the problem.

I'm able to send messages and people receive them, but I can't receive any responses.

I have sent nowhere near 75000 messages either.

Is there anything I can do to fix this issue?

Thank you!

screenshot:

[piston597]

Try a dfu restore, and don't back up from the old backup, maybe theres a problem there.

[SilentEcho13]

Upon SSHing into the phone, the sms folder, i saw a file called "sms.db.sg1bak" that wasn't there before. I tried deleting it, but it didn't help :/

I can't afford to restore at the moment either

[SilentEcho13]

I can definitely give that a shot.

I have my database opened in SQLite Database Browser for OSX right now actually, and I have 92,316 rows...lol

How can I vacuum the database?