Webmastersite.net
Register Log In

mysqli does not work

Comments on mysqli does not work

frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Comments: 106
Posted Aug 30, 2009 - 3:10 PM:

Hi paul,

mysqli seems not working correctly for me. In config.php I have made a comment like this to get wsnlinks installing an running:

...
$dbtype = 'mysql';
//if (function_exists('mysqli_connect')) $dbtype = 'mysqli';
require_once 'databases/'.$dbtype.'.php';
...

My Environment Stats are:

Apache
PHP 5.2.10 with zend engine 2.2.0
Loaded PHP Extensions: date, libxml, openssl, pcre, zlib, bcmath, bz2, calendar, ctype, curl, dba, dbase, dom, session, filter, ftp, gd, gettext, hash, iconv, idn, standard, json, mbstring, mcrypt, mhash, mysql, SimpleXML, SPL, PDO, pdo_sqlite, posix, Reflection, imap, shmop, pdo_mysql, soap, mysqli, SQLite, exif, tidy, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, cgi


Thanx,
Frank
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 01, 2009 - 1:50 AM:

What's your mysql version?

Since it works on everybody else's server, I wonder if your host has a problem with their mysqli extension installation. I'd need access to find out, anyhow: scripts.webmastersite.net/w...nlinks/?section=inspection
frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Comments: 106
Posted Sep 11, 2009 - 5:14 PM:

I must use mySQL V5. The only part I wonder about is I have to code the database host like that: localhost:/tmp/mysql5.sock
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 11, 2009 - 10:02 PM:

Is there some sort of intentional mutliple mysql versions situation going on?

The detection which determines whether wsn uses mysql or mysqli depends on the server not having the mysqli extension installed unless the server is capable of actually using it. mysqli requires MySQL 5, I believe. If a server has multiple mysql versions but defaults to an old one for some reason, that will trick scripts into thinking it has mysqli support when the currently loaded mysql actually doesn't.

If you could tell me what the error message is, I can try to support that. Otherwise I guess I'll disable everybody's mysqli to be safe.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.