首页 \ 问答 \ 无法在qSqlite中加载Spatialite扩展（QT 5.9）(Could not load Spatialite extension in qSqlite ( QT 5.9))

无法在qSqlite中加载Spatialite扩展（QT 5.9）(Could not load Spatialite extension in qSqlite ( QT 5.9))

 我试图在qSqlite（Qt 5.9）中加载Spatialite作为扩展，我在Qt4.8之前已经完成了，但是我在QT5.9中失败了。 我通过删除“SQLITE_OMIT_LOAD_EXTENSION”更改了sqlite.pri，并通过删除“ #define SQLITE_OMIT_LOAD_EXTENSION 1 ”并添加“ #define SQLITE_ENABLE_LOAD_EXTENSION 1 ”对sqlite.c进行了一些更改。 我还将以下行添加到openDatabase（....）  
#if defined(SQLITE_ENABLE_LOAD_EXTENSION)
| SQLITE_LoadExtension|SQLITE_LoadExtFunc
#endif
 
 现在是“requet.setQuery（”SELECT load_extension（'spatialite'）“，dbProject）;” 函数被识别，但我收到此消息：错误“无法找到指定的过程。\ r \ n无法获取行”如果我查看MSVC14中的调试输出，我可以看到spatialite.dll和所有它的依赖项已被加载。  
 注意：我用我的Spatialite和我从他们的网站下载的mod_spatialite测试了这个。  
 关于这个问题的任何想法？ 提前致谢。 

I am trying to load Spatialite as extension in qSqlite ( Qt 5.9), I have done that before with Qt4.8, but I failed with the QT5.9. I changed the sqlite.pri by removing "SQLITE_OMIT_LOAD_EXTENSION", and I did some change on the sqlite.c by removing the "#define SQLITE_OMIT_LOAD_EXTENSION 1", and adding "#define SQLITE_ENABLE_LOAD_EXTENSION 1". I also add the following lines to openDatabase(....) 
#if defined(SQLITE_ENABLE_LOAD_EXTENSION)
| SQLITE_LoadExtension|SQLITE_LoadExtFunc
#endif
 
Now the "requet.setQuery("SELECT load_extension('spatialite')", dbProject);" function is recognized, but I got this message: error "The specified procedure could not be found.\r\nUnable to fetch row" If I take a look on my debug output in MSVC14, I can see that the spatialite.dll and all its dependencies have been loaded. 
Notice: I tested this with my Spatialite and also the mod_spatialite that I download form their website. 
Any ideas about this problem? Thanks in advance.

原文：https://stackoverflow.com/questions/44427868

更新时间：2021-12-24 19:12

最满意答案

 确保正确定义了ajax_object.cartclass 。  
var ajax_object = {};
ajax_object.cartclass = "testing"; // The class you're trying to listen to.
 
 在那之后你的代码应该正常工作，假设你有一个定义的类ajax_object.cartclass ，它包含一个类add a元素：  
<div class="testing"><a class="add">Test this</a></div>
 
 现在应该有以下工作：  
$('.' + ajax_object.cartclass).on('click','a.add',function(e)
{
   console.log("hey"); // Console will output "hey" now.
   e.preventDefault();
});
 
 你的代码应该在那之后正常工作。  
 这是一个演示 。 

Make sure that ajax_object.cartclass is properly defined. 
var ajax_object = {};
ajax_object.cartclass = "testing"; // The class you're trying to listen to.
 
Your code should work properly after that, assuming you have a defined element of class ajax_object.cartclass which contains an a element of class add: 
<div class="testing"><a class="add">Test this</a></div>
 
The following should now work: 
$('.' + ajax_object.cartclass).on('click','a.add',function(e)
{
   console.log("hey"); // Console will output "hey" now.
   e.preventDefault();
});
 
Your code should work fine after that. 
Here's a Demo.

无法在qSqlite中加载Spatialite扩展（QT 5.9）(Could not load Spatialite extension in qSqlite ( QT 5.9))

最满意答案

相关问答

未捕获的异常：语法错误，无法识别的表达式：＃(uncaught exception: Syntax error, unrecognized expression: #)[2022-09-15]

错误：语法错误，无法识别的表达式：点（。）(Error: Syntax error, unrecognized expression: dot (.))[2023-01-12]

[Rails] jQuery：语法错误，无法识别的表达式([Rails]jQuery: Syntax error, unrecognized expression)[2022-04-22]

未捕获的错误：语法错误，无法识别的表达式：使用.replace为7％(Uncaught Error: Syntax error, unrecognized expression: 7% with .replace)[2024-01-22]

抛出新错误（“语法错误，无法识别的表达式：”msg）;(throw new Error( “Syntax error, unrecognized expression: ” msg );)[2023-07-12]

错误：语法错误，无法识别的表达式：＃jquery(Error: Syntax error, unrecognized expression: # jquery)[2024-03-20]

错误：错误：语法错误，无法识别的表达式：(Error: Error: Syntax error, unrecognized expression:)[2022-05-11]

JQuery语法错误无法识别的表达式(JQuery syntax error unrecognized expression)[2023-03-25]

语法错误，Safari中无法识别的表达式(Syntax error, unrecognized expression in Safari)[2021-10-25]

uncaught语法错误，无法识别的表达式选项：包含(uncaught Syntax error, unrecognized expression option:contains)[2022-03-11]

相关文章

最新问答