adrianhudson Posted February 9, 2018 Share Posted February 9, 2018 I have been using SQLite for years. I recently wiped my PC and ever since have had this problem - SQLite statements fail with @error set to 2, "Call Prevented by SafeMode" Unless I include "_SQLite_SafeMode(False) ", a statement such as ... _SQLite_Exec($DB1, "CREATE TABLE IF NOT EXISTS test (col1 INT PRIMARY KEY, col2, col3)") ... will fail with @ERROR = 2 Does anyone know why? I do not get this on my other PC, which is the same version of windows and same sqlite3.dll. test.au3 Link to comment Share on other sites More sharing options...
MattHiggs Posted February 9, 2018 Share Posted February 9, 2018 Is it the same version of AutoIT on both machines as well by any chance? There were some....issues.....I encountered when I installed the newest version of Autoit on my system. I am curious if, after you wiped your computer, you installed the newer version of autoit on your system. Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted February 9, 2018 Moderators Share Posted February 9, 2018 adrianhudson, If you are using the latest AutoIt version 3.3.14.3 then this is a known bug: You will particularly need the Array library. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
adrianhudson Posted February 9, 2018 Author Share Posted February 9, 2018 I did (install the latest version). The working machine is on 3.3.14.0 version and the non-working machine is on 3.3.14.3. I will install the latest version on the working machine and report back. Link to comment Share on other sites More sharing options...
adrianhudson Posted February 9, 2018 Author Share Posted February 9, 2018 Ahh, thanks Melba23. I have downloaded the three files you mention in your other post and voila! Fixed! Many thanks Link to comment Share on other sites More sharing options...
adrianhudson Posted February 9, 2018 Author Share Posted February 9, 2018 M23, Still something a bit wrong. Before I saw your reply about the bugs. on the PC that WAS working I installed latest version. So to fix it I also copied the three fixed files to that machine. This machine fails on _SQLite_Open with @error = 1 (with an autoit that was working on the prior release) Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted February 10, 2018 Moderators Share Posted February 10, 2018 adrianhudson, Obviously no the same problem (that gave @error -2), so I suggest starting a new thread where you post your script so the SQL gurus can take a look. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now