Hi

on the page Activity publisher templates
I got this message:
Optionally, you can purge activity records by number per user. However, this feature currently requires MYSQL 5 which you do not have on this system. Please upgrade to MYSQL 5 or higher in order to use this feature.

but it is weird because I have mysql 5 - this is output of my phpinfo

mysql

MySQL Support	enabled
Active Persistent Links	0
Active Links	1
Client API version	5.0.51a
MYSQL_MODULE_TYPE	external
MYSQL_SOCKET	/var/run/mysqld/mysqld.sock
MYSQL_INCLUDE	-I/usr/include/mysql
MYSQL_LIBS	-L/usr/lib -lmysqlclient

Directive	Local Value	Master Value
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	no value	no value
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

mysqli

MysqlI Support	enabled
Client API library version	5.0.51a
Client API header version	5.0.51a
MYSQLI_SOCKET	/var/run/mysqld/mysqld.sock

Directive	Local Value	Master Value
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	no value	no value
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.reconnect	Off	Off

thanks for the answer
Igorik

Comments

Scott Reynolds’s picture

in your settings.php there is a line like this

$db_url = "mysql://UNAME:PASS@db_url";

change it to use mysqli:

"mysqli://UNAME:PASS@db_url";
igorik’s picture

I changed it to

$db_url = "mysqli://UNAME:PASS@db_url";

and it works.
Thanks Scott

Scott Reynolds’s picture

Title: Activity log purge say that I haven't mysql 5 but I have » Activity log purge should check mysql verision instead of mysqli

Updated title. I forget how to do this right now but I know its possible

Scott Reynolds’s picture

Status: Active » Closed (fixed)

This code has been removed.