DMXzone Google Maps 2 Support Product Page

Under investigation

DatabaseConnector receiving error. HELP!

Reported 11 Oct 2014 00:41:16
1
has this problem
11 Oct 2014 00:41:16 Leon Boczkowski posted:
Fatal error: require_once(): Failed opening required 'E:\XAMPP\htdocs\mito\dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php' (include_path='.;E:\XAMPP\php\PEAR') in E:\XAMPP\htdocs\mito\dmxDatabaseSources\jobsites.php on line 4
Call Stack
# Time Memory Function Location
1 0.0000 136904 {main}( ) ..\jobsites.php:0

Replies

Replied 13 Oct 2014 08:13:55
13 Oct 2014 08:13:55 Teodor Kuduschiev replied:
Hello Leon,
What is the PHP version you are running on your server and is PDO installed/enabled?
Replied 13 Oct 2014 12:15:28
13 Oct 2014 12:15:28 Leon Boczkowski replied:
I am using Xamp 3.2.1 as a local server to build the site. I am going to assume that I have the PDO installed. I have used XAMP as a testing, page. How do I check to see if the PDO is actually installed? I have been able to see my data bases within Dreamweaver.

Replied 13 Oct 2014 12:19:23
13 Oct 2014 12:19:23 Teodor Kuduschiev replied:
You need to check which PHP version is installed on your XAMP. PHP version as well as PDO can be checked within the php config.
Replied 13 Oct 2014 12:29:02
13 Oct 2014 12:29:02 Leon Boczkowski replied:
would this be located in the php.ini
Replied 13 Oct 2014 12:34:46
13 Oct 2014 12:34:46 Teodor Kuduschiev replied:
Yes, that is exactly where you can check this.
Replied 13 Oct 2014 12:47:17
13 Oct 2014 12:47:17 Leon Boczkowski replied:
Ok I ran a <?php phpinfo ?> test file and received this as the version. PHP Version 5.5.15

PDO

PDO support enabled
PDO drivers mysql, sqlite

pdo_mysql

PDO Driver for MySQL enabled
Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $

pdo_sqlite

PDO Driver for SQLite 3.x enabled
SQLite Library 3.8.4.3
Replied 13 Oct 2014 12:49:43
13 Oct 2014 12:49:43 Leon Boczkowski replied:
I also checked the php.ini file and have this included:


; Whether to pool ODBC connections. Can be one of "strict", "relaxed" or "off"
; php.net/pdo-odbc.connection-pooling
;pdo_odbc.connection_pooling=strict

;pdo_odbc.db2_instance_name

[Pdo_mysql]
; If mysqlnd is used: Number of cache slots for the internal result set cache
; php.net/pdo_mysql.cache_size
pdo_mysql.cache_size=2000

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
; php.net/pdo_mysql.default-socket
pdo_mysql.default_socket="MySQL"
Replied 13 Oct 2014 12:52:28
13 Oct 2014 12:52:28 Leon Boczkowski replied:
Line 1011: ;extension=php_pdo_firebird.dll
Line 1012: extension=php_pdo_mysql.dll
Line 1013: ;extension=php_pdo_oci.dll
Line 1014: ;extension=php_pdo_odbc.dll
Line 1015: ;extension=php_pdo_pgsql.dll
Line 1016: extension=php_pdo_sqlite.dll
Line 1017: ;extension=php_pdo_sqlite_external.dll
Line 1097: [Pdo]
Replied 13 Oct 2014 13:30:27
13 Oct 2014 13:30:27 Leon Boczkowski replied:
Tried again and received:

( ! ) Warning: require_once(E:\XAMPP\htdocs\mito\dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php): failed to open stream: No such file or directory in E:\XAMPP\htdocs\mito\dmxDatabaseSources\jobsites.php on line 4
Call Stack
# Time Memory Function Location
1 0.0000 137496 {main}( ) ..\jobsites.php:0

( ! ) Fatal error: require_once(): Failed opening required 'E:\XAMPP\htdocs\mito\dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php' (include_path='.;E:\XAMPP\php\PEAR') in E:\XAMPP\htdocs\mito\dmxDatabaseSources\jobsites.php on line 4
Call Stack
# Time Memory Function Location
1 0.0000 137496 {main}( ) ..\jobsites.php:0
Replied 13 Oct 2014 13:38:14
13 Oct 2014 13:38:14 Leon Boczkowski replied:
OH SNAAAAAAAP I got it to work!!!!! I spent 3 days trying to get this information from the Connetctor to the map. WAAAAAAAAHOOOOOOOOOOOO!!!!!
This game is frustrating, but soooo rewarding when it works.
But since I have you. What does the database connector actually do? can I sort tables on pages dynamically with it?
Replied 13 Oct 2014 14:34:33
13 Oct 2014 14:34:33 Teodor Kuduschiev replied:
Hello Leon,
So - the problem was with your server config, wasn't it?
What do you mean exactly by: "What does the database connector actually do?" Please go to the database connector page, read the product manual and check tons of the tutorials available. This will answer your question.

Reply to this topic