MySQL 4.1

[tark]

Originally Posted by raminia

at which line?
where was the error? tell me complete!

Fatal error: Call to undefined function mysql_connect() in C:\dev\www\pixelpost2\includes\functions.php on line 162

And I've got Apache 2.0.49, PHP 5 and MySQL 4.1 ... With MySQL 4.0 system work. :-)

[tark]

Originally Posted by GeoS

I've got next idea - maybe we should use ADODB interface to DB?? I could make PP DB server independent (if we add correct SQL for the most popular of them).

Yeah, it's good idea.

[tark]

Originally Posted by raminia

do you have PHP 5 ?
I think so! I changed the file I provided before. download it again and tell me what happend.

changed function

function start_mysql()
{
	global $pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass, $pixelpost_db_pixelpost;
	mysql_connect($pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass) || die("Error: ". mysql_error());
	$mysql_version = mysql_get_server_info();
	if ((substr($mysql_version,0,3)=="4.1" || substr($mysql_version,0,2)=="5.")& substr(phpversion(),0,1)=="5")
	{
	  // MYSQL 4.1.x OR 5.x
		mysqli_select_db($pixelpost_db_pixelpost) || die("Error: ". mysql_error());
		}
	else
	{ // MYSQL 4.0.x
		mysql_select_db($pixelpost_db_pixelpost) || die("Error: ". mysql_error());
		}
}

and functions mysql_connect, mysql_error and 10 other functions...

[GeoS+]

Originally Posted by tark

and functions mysql_connect, mysql_error and 10 other functions...

And that is a reason why ADODB would be the bast solution

[raminia+]

errors in function call could be a reason to change the DB?
I'dont agree.
report your PHP version plz!

I think you have don something wrong or have not supported unstable versions of PHP or Mysql!

[Rob]

Raminia, you have probably already read this, but...

In PHP 5, MySQL is no longer enabled by default, nor is the MySQL library bundled with PHP. Read this FAQ for details on why.

Note: Windows users will need to enable php_mysql.dll inside of php.ini and either copy libmysql.dll into the Windows system directory, or make it available to the PATH.

This will fix "Unable to load dynamic library './php_mysql.dll'" errors.

For compiling, simply use --with-mysql=[DIR] where [DIR] points to your MySQL installation directory.

This MySQL extension doesn't support full functionality of MySQL versions greater than 4.1.0. For that, use MySQLi.

If you would like to install the mysql extension along with the mysqli extension you have to use the same client library to avoid any conflicts.

Note, it is not just the connect functions, but all of the functions for the MySQL extension that are not supported. In order to support this, I think we need to wrap all of our queries.

What we need is adodb, or our own database class to wrap this...

As for this person, I think all we can say for now is unsupported. If he can though, he can probably enable the MySQL extension and get it to work, especially if he is on a windows box.

[Anonymous]

no I didn't noticed this. Just when I was installing my MYSQL 4 on local machine. I underestand and agree now.

Ramin
(Raminia not logged in)

[raminia+]

wordpress currently uses mysql and php and there is a big challenge there for supporting other databases
Read this:
http://codex.wordpress.org/Using_Alternative_Databases

maybe we should use ezsql too : http://php.justinvincent.com/home/ar...hp?articleId=2

BTW, hosting services usually support the MYSQL and PHP requirements. Is it a big deal?

[GeoS+]

IMHO ADODB is much more powerful and better coz:
- is used by more big PHP & SQL based aplication such as: ACID, PostNuke, Xaraya, phpWiki, Mambo, PHP GACL, TikiWiki, eGroupWare and phpLens App Server
- what is more importent, support more DBs (http://phplens.com/adodb/supported.databases.html)

http://adodb.sourceforge.net/

PS We should use ANSI SQL (& as I looked to SQL code there is more or less as simply and clear as ANSI SQL). This can give us 100% support for all DBs with one common SQL code (only DB creation code can look not the same)

[tark]

Originally Posted by raminia

errors in function call could be a reason to change the DB?
I'dont agree.
report your PHP version plz!

PHP 5.0.3 ;-)

Originally Posted by raminia

I think you have don something wrong or have not supported unstable versions of PHP or Mysql!

Yeah, but i've got MySQL 4.1.10a-nt on WinXP... IMHO it's official version.