Forums > MaxMSP

How do I clear a Max sqlite_exec error?


December 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′)

January 6, 2014 | 5:39 am

bump

January 6, 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"

January 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

February 4, 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>")
Viewing 5 posts - 1 through 5 (of 5 total)

Forums > MaxMSP