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


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