How do I clear a Max sqlite_exec error?

Dec 30, 2013 at 9:51am

How do I clear a Max sqlite_exec error?

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

#276978
Jan 6, 2014 at 5:39am

bump

#277514
Jan 6, 2014 at 6:21am

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”

#277519
Jan 26, 2014 at 4:02am

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

#279167

You must be logged in to reply to this topic.