Forums > MaxMSP

How do I clear a Max sqlite_exec error?


Dec 30 2013 | 9:51 am

Just the other day I started getting the error messages below when Max loads (before opening any patches). My guess is that they are innocuous, but I’d like to know what I need to do to clear whatever is causing them. (And I’d be interested to know why something like this would happen).

ta.

sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N""
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) VALUES ("used for "N"", "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"",’1904-01-01 01:00:4294967236′,’536677c6707409a12c839dfa3cfea11c’)
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_alexH"
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) VALUES ("x_alexH", "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_alexH",’1904-01-01 01:00:4294967236′,’3813aaa180b8f3f66bd0268e74978dd9′)
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_andrew"
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) VALUES ("x_andrew", "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_andrew",’1904-01-01 01:00:4294967236′,’def773f75476a7d72b4424dbbbb6b020′)
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_ben2"
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) VALUES ("x_ben2", "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_ben2",’1904-01-01 01:00:4294967236′,’6b4dbed9a6218f3ecdcff8a1df7ea7b1′)
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_joshI"
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) VALUES ("x_joshI", "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_joshI",’1904-01-01 01:00:4294967236′,’a675e5c205206511a1b3887ac7a87b81′)
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_ryan"
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) VALUES ("x_ryan", "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_ryan",’1904-01-01 01:00:4294967236′,’72b51c3f2c01539bcaa9c9897c4c8c0d’)
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_tash"
sqlite_exec: 1 (near "N": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) VALUES ("x_tash", "Macintosh HD:/Users/Shared/maxX6/Groovit6App/old_media/used for "N"/x_tash",’1904-01-01 01:00:4294967236′,’5e3f06652be03bad4b6ab3c6a07a7313′)

Jan 06 2014 | 5:39 am

bump

Jan 06 2014 | 6:21 am

I’ve been getting them too since 6.1.5. I noticed in the 6.1.6 notes that that might have been cleared up but the errors are still there.

My errors go like:
"sqlite_exec_query: SELECT file_id FOM files WHERE path_id_ext = #### AND vailidity = 0"

then the next line will say:
"sqlite_exec: 18 (string or blob too big)"

then it starts getting into filenames like:
"sqlite_exec_query: SELECT file_id FOM files WHERE filename = *.mxe/*.exe"

Jan 26 2014 | 4:02 am

Same error here since I’ve upgraded to Max 6.1.6. The errors which I get are:

sqlite_exec: 1 (near "Additional": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "vadAlma:/Applications/Max 6.1/packages/Quintet.net/patchers/Tutorials/TEMPLATE-FOR-AudioExtension/>> put in "Additional inputs"" 
sqlite_exec: 1 (near "Additional": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) 						VALUES (">> put in "Additional inputs"", "vadAlma:/Applications/Max 6.1/packages/Quintet.net/patchers/Tutorials/TEMPLATE-FOR-AudioExtension/>> put in "Additional inputs"",'2040-02-06 06:28:16','f58c34320620cd99f68803a0e6c08637')
sqlite_exec: 1 (near "Audio": syntax error)
sqlite_exec_query: SELECT DISTINCT path_id, signature FROM paths WHERE fullpath LIKE "vadAlma:/Applications/Max 6.1/packages/Quintet.net/patchers/Tutorials/TEMPLATE-FOR-AudioExtension/>> put in "Audio-Extensions"" 
sqlite_exec: 1 (near "Audio": syntax error)
sqlite_exec_query: INSERT INTO paths (pathname, fullpath, date_modified, signature) 						VALUES (">> put in "Audio-Extensions"", "vadAlma:/Applications/Max 6.1/packages/Quintet.net/patchers/Tutorials/TEMPLATE-FOR-AudioExtension/>> put in "Audio-Extensions"",'2040-02-06 06:28:16','7c36dff48256eb2d77e39a24ce39eed4')

Thanks,
Ádám

Feb 04 2016 | 6:36 am

Hi !
This started happening to me a few days ago, in Max 7.1 (both 32 and 64 bits).
Errors don’t show up right away, but after let’s say 5 to 10 seconds.
They seem harmless as well (everything is working so far) but I’m also curious about how to get rid of them.
Any idea? Do you think a reinstall would do the trick?
Thanks in advance
Julien

sqlite_exec: 1 (unrecognized token: "'utilisateur/""")
sqlite_exec_query: SELECT DISTINCT _id, _signature FROM _paths WHERE _fullpath = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/""
sqlite_exec: 1 (unrecognized token: "'utilisateur/""")
sqlite_exec_query: UPDATE _things SET _status = 'orphan' WHERE _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/""
sqlite_exec: 1 (unrecognized token: "'utilisateur/""")
sqlite_exec_query: SELECT _id, _modified, _tags FROM _things WHERE _name = "Max-PW-Bach-User" AND _filename = "Max-PW-Bach-User" AND _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/""
sqlite_exec: 1 (near "'utilisateur/"",'": syntax error)
sqlite_exec_query: INSERT INTO _things (_name, _filename, _path, _kind, _type, _typedesc, _created, _modified, _added, _used, _tags, _status, _package) 					 VALUES ("Max-PW-Bach-User","Max-PW-Bach-User","/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"",'folder','fold','','2015-07-08 10:44:13','2015-11-13 03:02:08','2016-02-04 15:28:54
',0,'','','')
sqlite_exec: 1 (unrecognized token: "'utilisateur/"", "ee48f9830f314f1ce2361afe50a0adfa")")
sqlite_exec_query: INSERT INTO _paths (_fullpath, _signature) VALUES ("/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"", "ee48f9830f314f1ce2361afe50a0adfa")
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User"")
sqlite_exec_query: SELECT DISTINCT _id, _signature FROM _paths WHERE _fullpath = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User"
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User"")
sqlite_exec_query: UPDATE _things SET _status = 'orphan' WHERE _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User"
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User"")
sqlite_exec_query: SELECT _id, _modified, _tags FROM _things WHERE _name = "sbcl-cores" AND _filename = "sbcl-cores" AND _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User"
sqlite_exec: 1 (near "'utilisateur/"/Max-PW-Bach-User",'": syntax error)
sqlite_exec_query: INSERT INTO _things (_name, _filename, _path, _kind, _type, _typedesc, _created, _modified, _added, _used, _tags, _status, _package) 					 VALUES ("sbcl-cores","sbcl-cores","/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User",'folder','fold','','2015-07-08 10:44:38','2015-11-24 15:55:08','2016-02-04 15:28:54
',0,'','','')
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User"")
sqlite_exec_query: SELECT _id, _modified, _tags FROM _things WHERE _name = "temp" AND _filename = "temp" AND _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User"
sqlite_exec: 1 (near "'utilisateur/"/Max-PW-Bach-User",'": syntax error)
sqlite_exec_query: INSERT INTO _things (_name, _filename, _path, _kind, _type, _typedesc, _created, _modified, _added, _used, _tags, _status, _package) 					 VALUES ("temp","temp","/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User",'folder','fold','','2015-07-08 10:45:34','2015-11-05 02:04:21','2016-02-04 15:28:54
',0,'','','')
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User", "1fa10edc5a79dae1985a78e749fe433e")")
sqlite_exec_query: INSERT INTO _paths (_fullpath, _signature) VALUES ("/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User", "1fa10edc5a79dae1985a78e749fe433e")
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User/sbcl-cores"")
sqlite_exec_query: SELECT DISTINCT _id, _signature FROM _paths WHERE _fullpath = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/sbcl-cores"
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User/sbcl-cores"")
sqlite_exec_query: UPDATE _things SET _status = 'orphan' WHERE _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/sbcl-cores"
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User/sbcl-cores"")
sqlite_exec_query: SELECT _id, _modified, _tags FROM _things WHERE _name = "pw+fun+iter+pmc+profile+cmi.core" AND _filename = "pw+fun+iter+pmc+profile+cmi.core" AND _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/sbcl-cores"
sqlite_exec: 1 (near "'utilisateur/"/Max-PW-Bach-User/sbcl-cores",'": syntax error)
sqlite_exec_query: INSERT INTO _things (_name, _filename, _path, _kind, _type, _typedesc, _created, _modified, _added, _used, _tags, _status, _package) 					 VALUES ("pw+fun+iter+pmc+profile+cmi.core","pw+fun+iter+pmc+profile+cmi.core","/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/sbcl-cores",'file','','','2015-10-31 13:16:24','2015-10-31 13:16:24','2016-02-04 15:28:54
',0,'','','')
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User/sbcl-cores", "6d7e25dcd4a9773ed452796614a7b74a")")
sqlite_exec_query: INSERT INTO _paths (_fullpath, _signature) VALUES ("/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/sbcl-cores", "6d7e25dcd4a9773ed452796614a7b74a")
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User/temp"")
sqlite_exec_query: SELECT DISTINCT _id, _signature FROM _paths WHERE _fullpath = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/temp"
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User/temp"")
sqlite_exec_query: UPDATE _things SET _status = 'orphan' WHERE _path = "/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/temp"
sqlite_exec: 1 (unrecognized token: "'utilisateur/"/Max-PW-Bach-User/temp", "<null>")")
sqlite_exec_query: INSERT INTO _paths (_fullpath, _signature) VALUES ("/Volumes/Data/Desktop/Pédagogie_FM_PWGL/install-PLIM/copier-dans "/Utilisateurs/nom_d'utilisateur/"/Max-PW-Bach-User/temp", "<null>")
Feb 05 2017 | 2:49 pm

Hello Julien,
I got almost the same error:
sqlite_exec: 7 (out of memory)
sqlite_exec_query: UPDATE _things SET _status = ‘orphan’ WHERE _path = "./Max6/patches/Patches_Claudio/PEDAGOGIE"
Did you find a solution ?
I wrote a email to cycling support and I’m waiting for his return …
Merci !
Claudio

Feb 05 2017 | 3:34 pm

Hi Claudio
No unfortunately it’s been a while I didn’t see this one. I didn’t do anything particular to get rid of it,
so I guess it went away after an udpate or reinstall …
I think this has to do with the File Preferences, because yours points also to personal folders apparently,
maybe check these (reselect the folder in the File Prefs for instance). Anyway, this was never a real problem to me.
Julien

Feb 06 2017 | 1:29 am

Hi Julien,
thank you for your quick reply. I try to reinstall MAX. It looks like not a big problem for me too, but when I receive red messages in Max monitor, I fell uncomfortable !
Claudio

Feb 09 2017 | 10:10 am

Hello,
finally I figure it out, thanks to the cycling support !
The problem was the character in some text comments. When I saved the patch, every new saved, the size of the file became bigger and bigger (start from 5Mo to 130Mo !) . I used this character "•"
I install again Max following this instructions https://cycling74.com/support/faq_maxcrash/#.WJyiZxBYMfI and now it works fast and properly.
I think the problem starts from the 7.3 version.
So for now it’s better to not use strange characters , waiting for a new MAX version …
I hope that my English commentary is clear (sorry) …
Claudio

Viewing 9 posts - 1 through 9 (of 9 total)

Forums > MaxMSP