Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#397 Invalid database for SQLite

4.0.3
closed-rejected
nobody
SQLite (25)
5
2014-03-23
2014-03-21
michalzuber
No

Adminer is saying "Invalid database." for mmssms.db, SMS/MMS database from Android (/data/data/com.android.providers.telephony/databases/mmssms.db)

File output for the file:
$ file Downloads/mmssms.db
Downloads/mmssms.db: SQLite 3.x database, user version 60

The head ouput of the file:
$ head Downloads/mmssms.db
tablethreadsthreadsCREATE TABLE threads (_id INTEGER PRIMARY KEY AUTOINCREMENT,date INTEGER DEFAULT 0,message_count INTEGER DEFAULT 0,recipient_ids TEXT,snippet TEXT,snippet_cs INTEGER DEFAULT 0,read INTEGER DEFAULT 1,type INTEGER DEFAULT 0,error INTEGER DEFAULT 0,has_attachment INTEGER DEFAULT 0,unread_count INTEGER DEFAULT 0,alert_expired INTEGER DEFAULT 1,reply_all INTEGER DEFAULT -1,group_snippet TEXT,message_type INTEGER DEFAULT 0,display_recipient_ids TEXT)33�7tablecanonical_addressescanonical_addressesCREATE TABLE canonical_addresses (_id INTEGER PRIMARY KEY AUTOINCREMENT,address TEXT)�`�'tablewpmwpmCREATE TABLE wpm (_id INTEGER PRIMARY KEY AUTOINCREMENT,thread_id INTEGER,body TEXT,date INTEGER,date_sent INTEGER DEFAULT 0,read INTEGER DEFAULT 0,type INTEGER,locked INTEGER DEFAULT 0,href TEXT,si_id TEXT,created INTEGER,si_expires INTEGER,action INTEGER,seen INTEGER DEFAULT 0,deletable INTEGER DEFAULT 0,hidden INTEGER DEFAULT 0)�G�qtablecmascmasCREATE TABLE cmas (_id INTEGER PRIMARY KEY AUTOINCREMENT,sms_id INTEGER,thread_id INTEGER,service_category INTEGER,category INTEGER,response_type INTEGER,severity INTEGER,urgency INTEGER,certainty INTEGER,identifier INTEGER,alert_handling INTEGER,expires INTEGER,language INTEGER,expired INTEGER DEFAULT 1)i!!�tablesr_pendingsr_pendingCREATE TABLE sr_pending (reference_number INTEGER,a##�tableattachmentsattachmentsCREATE TABLE attachments (sms_id INTEGER,content_url TEXT,offset INTEGER)�1�ItablerawrawCREATE TABLE raw (_id INTEGER PRIMARY KEY,date INTEGER,reference_number INTEGER,count INTEGER,sequence INTEGER,destination_port INTEGER,address TEXT,pduCREATE TABLE sms (_id INTEGER PRIMARY KEY AUTOINCREMENT,thread_id INTEGER,address TEXT,person INTEGER,date INTEGER,date_sent INTEGER DEFAULT 0,protocol INTEGER,read INTEGER DEFAULT 0,status INTEGER DEFAULT -1,type INTEGER,reply_path_present INTEGER,subject TEXT,body TEXT,service_center TEXT,locked INTEGER DEFAULT 0,error_code INTEGER DEFAULT 0,seen INTEGER DEFAULT 0,deletable INTEGER DEFAULT 0,hidden INTEGER DEFAULT 0,group_id INTEGER,group_type INTEGER,delivery_date INTEGER,app_id INTEGER DEFAULT 0,msg_id INTEGER DEFAULT 0,callback_number TEXT,reserved INTEGER DEFAULT 0,pri INTEGER DEFAULT 0,teleservice_id INTEGER DEFAULT 0,link_url TEXT)GwtabledrmdrmCREATE TABLE drm (_id INTEGER PRIMARY KEY,_data TEXT)9 WtableraterateCREATE TABLE rate (sent_time INTEGER)!WindexpartIndex1partCREATE INDEX partIndex1 ON part (mid)�Q�tablepartpart CREATE TABLE part (_id INTEGER PRIMARY KEY,mid INTEGER,seq INTEGER DEFAULT 0,ct TEXT,name TEXT,chset INTEGER,cd TEXT,fn TEXT,cid TEXT,cl TEXT,ctt_s INTEGER,ctt_t TEXT,_data TEXT,text TEXT)B!]indexaddrIndex1addCREATE INDEX addrIndex1 ON addr (msg_id)��{tableaddraddrCREATE TABLE addr (_id INTEGER PRIMARY KEY,msg_id INTEGER,contact_id INTEGER,address TEXT,type INTEGER,charset INTEGER)HmindexpduIndex1pduCREATE INDEX pduIndex1 ON pdu (thread_id,locked)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�<�_tablepdupduCREATE TABLE pdu (_id INTEGER PRIMARY KEY AUTOINCREMENT,thread_id INTEGER,date INTEGER,date_sent INTEGER DEFAULT 0,msg_box INTEGER,read INTEGER DEFAULT 0,m_id TEXT,sub TEXT,sub_cs INTEGER,ct_t TEXT,ct_l TEXT,exp INTEGER,m_cls TEXT,m_type INTEGER,v INTEGER,m_size INTEGER,pri INTEGER,rr INTEGER,rpt_a INTEGER,resp_st INTEGER,st INTEGER,tr_id TEXT,retr_st INTEGER,retr_txt TEXT,retr_txt_cs INTEGER,read_status INTEGER,ct_cls INTEGER,resp_txt TEXT,d_tm INTEGER,d_rpt INTEGER,locked IN������threads�pdusmssms!3canonical_addresses�plication/vnd.wap.multipart.relatedpersonal��A�'pp_id INTEGUW6R�58523925B2-6E35-71E3-A8F0-68B599B83CA8application/vnd.wap.multipart.relatedpersonal��AVR8kHlEa-eoclSxN�roid_metadataandro.H-:,3+0*-)((310/�����'+421908580617�j527�j 527�j��!/3/�5C/5b�!/3/�5text/plain3e393fac10845.txtj<3e393fac10845.txt>3e393fac10845.txtUzivatel 0907245322 sa momentalne nachadza priblizne:Nove Zamky(vzdialenost 6.6 km)!�'image/jpeg3.jpg<3.jpg>3.jpg/data/data/com.android.providers.telephony/app_parts/PART_1388066439984_3.jpg!�'image/jpeg2.jpg<2.jpg>2.jpg/data/data/com.android.providers.telephony/app_parts/PART_1388066439939_2.jpg!�'image/jpeg1.jpg<1.jpg>1.jpg/data/data/com.android.providers.telephony/app_parts/PART_1388066439842_1.jpg�-�9�application/smilSMIL<SMIL>SMIL<smil>

Discussion

  • Jakub Vrána
    Jakub Vrána
    2014-03-23

    Try opening this database by PHP itself. If it doesn't work, Adminer couldn't do much about it.

     
  • Jakub Vrána
    Jakub Vrána
    2014-03-23

    • status: open --> closed-rejected