[julientarta]

(Configuration : PHP5 & MySQL 4)

Hello everyone,

I know this topic has been discussed several times here, but I believe my problem is different.

After filling the database form with the correct information, I reach step 2 with success :

Database connection established...

Found database...

'../libs/dbconnect.php' was updated successfully.

There were no errors, continue onto the next step...

But when I click on the Next button, I find this :

Creating database tables...

    SQL/DB Error -- [

       1. Error establishing a database connection!Are you sure you have the correct user/password?
       2. Are you sure that you have typed the correct hostname?
       3. Are you sure that the database server is running?

    ]

I've checked my database and the tables were not created. Still, database informations are correct.

Anyone ever experienced this problem ? Where's my mistake ?

Thanks for your help !

Julien

[spatiban]

I would guess the database userid you are using may not have DBO privileges for creating tables. Check and make sure the user has DBO/DBA Privileges.

Also check the dbconnect.php has right database name, userid and other paramters with no typos.

[jjmusicpro]

I am getting the same error

Creating database tables...

SQL/DB Error -- [
Error establishing a database connection!
Are you sure you have the correct user/password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
]

[nick1162]

I'm also having the same problem a quick check of the error logs produced this:

Could it have anything to do with gloabal variables?

PHP Notice: Use of undefined constant EZSQL_DB_PASSWORD - assumed 'EZSQL_DB_PASSWORD' in libs/db.php on line 521

PHP Notice: Use of undefined constant EZSQL_DB_NAME - assumed 'EZSQL_DB_NAME' in libs/db.php on line 521

PHP Notice: Use of undefined constant EZSQL_DB_HOST - assumed 'EZSQL_DB_HOST' in libs/db.php on line 521

PHP Notice: Undefined variable: error_no in libs/db.php on line 110

Thanks for any help!!
Nick

[jjmusicpro]

someone please help

[jjmusicpro]

So now there are three of us with the same problem....anyone help!

[dealerpix]

hey everyone. I too am having this issue. I have found that the issue is likely found in libs/db.php in the mysql_persistent connect function. Supposedly you can change true to false on line 2, but in doing this, I am still having this issue. I read up about this on myql's website, and it seems that not all db might support this, at least from what I have read. If someone could just offer a manual way to import the db tables into ours, that should take care of this, though the mysql_persistent issue could cause problems in just generally using the script.

[dealerpix]

And I know it isn't my db. We are running more than a few complex scripts via php and mysql that are not having issues. Here is where mysql's website discusses this - http://www.mysql.com/news-and-events...000000086.html

[jjmusicpro]

Can someone post a manual way to put the tables and data into the database?

[lowparts]

Getting the same error message as above. I have triple checked that I'm using the right admin login/pass for the phpmyadmin. Details are below...if I'm missing any info, please let me know.

Thanks,
Jeremy

Details:
Version 9.0
info.php: http://www.lowparts.com/news/info.php
Ran Smarty_Test.php and results are...

System  Linux localhost.localdomain 2.6.9-023stab033.1-enterprise #1 SMP Mon Oct 23 22:21:51 MSD 2006 i686  
Build Date  Nov 9 2005 09:23:03  
Configure Command  './configure' '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-pear=/usr/share/pear' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba'  
Server API  Apache 2.0 Handler  
Virtual Directory Support  disabled  
Configuration File (php.ini) Path  /usr/local/Zend/etc/php.ini  
Scan this dir for additional .ini files  /etc/php.d  
additional .ini files parsed  /etc/php.d/bcmath.ini, /etc/php.d/dba.ini, /etc/php.d/dom.ini, /etc/php.d/gd.ini, /etc/php.d/imap.ini, /etc/php.d/ldap.ini, /etc/php.d/mbstring.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/ncurses.ini, /etc/php.d/odbc.ini, /etc/php.d/pgsql.ini, /etc/php.d/snmp.ini, /etc/php.d/soap.ini, /etc/php.d/xmlrpc.ini, /etc/php.d/xsl.ini  
PHP API  20031224  
PHP Extension  20041030  
Zend Extension  220040412  
Debug Build  no  
Thread Safety  disabled  
IPv6 Support  enabled  
Registered PHP Streams  php, file, http, ftp, compress.bzip2, compress.zlib, https, ftps  
Registered Stream Socket Transports  tcp, udp, unix, udg, ssl, sslv3, sslv2, tls