PHP Warning: SQLite3::loadExtension() [<a href='sqlite3.loadextension'>sqlite3.loadextension</a>]: Die angegebene Prozedur wurde nicht gefunden. in D:\wwwroot\spatiallite_orig.php on line 16
Does anyone have an idea what I can do???
PHP Warning: SQLite3::exec() [<a href='sqlite3.exec'>sqlite3.exec</a>]: not authorized in D:\wwwroot\spatiallite_orig.php on line 19
I tried the load_extension() query before, but without the 'sqlite3_modspatialite_init' parameter. Got the same result.
Regards,
Sebastian
--
You received this message because you are subscribed to a topic in the Google Groups "SpatiaLite Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/spatialite-users/Bks_1cTu6KE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to spatialite-users+unsubscribe@googlegroups.com.
To post to this group, send email to spatialite-users@googlegroups.com.
Visit this group at http://groups.google.com/group/spatialite-users.
For more options, visit https://groups.google.com/d/optout.
--enable-dynamic-extensions
' support.--
You received this message because you are subscribed to a topic in the Google Groups "SpatiaLite Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/spatialite-users/Bks_1cTu6KE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to spatialite-use...@googlegroups.com.
To post to this group, send email to spatiali...@googlegroups.com.
windows – apache 2.4
– php 5.6.34 nts fast cgi x86.
Di seguito la nostra configurazione
php.ini
extension=php_sqlite3.dll
[sqlite3]
sqlite3.extension_dir = "C:/Program Files (x86)/Spatialite"
All’interno di tale directory sono presenti le dll mod_spatialite-4.4.0-RC0-win-amd64.7z compreso quindi mod_spatialite.dll
Otteniamo l’errore:
SQLite3::loadExtension(): Unable to open extensions outside the defined directory in C:\Apache24\htdocs\testSpatiaLite\index.php on line 18
<html>
<head>
<title>Testing SpatiaLite on PHP</title>
</head>
<body>
<h1>testing SpatiaLite on PHP</h1>
<?php
// connecting some SQLite DB
// we'll actually use an IN-MEMORY DB
// so to avoid any further complexity;
// an IN-MEMORY DB simply is a temp-DB
$db = new SQLite3('db/dbtestspatialtite.db');
// loading SpatiaLite as an extension
$db->loadExtension('mod_spatialite.dll');
// enabling Spatial Metadata
// using v.2.4.0 this automatically initializes SPATIAL_REF_SYS
// and GEOMETRY_COLUMNS
$db->exec("SELECT InitSpatialMetadata()");
// reporting some version info
$rs = $db->query('SELECT sqlite_version()');
while ($row = $rs->fetchArray())
{
print "<h3>SQLite version: $row[0]</h3>";
}
$rs = $db->query('SELECT spatialite_version()');
while ($row = $rs->fetchArray())
{
print "<h3>SpatiaLite version: $row[0]</h3>";
}