The buddylist_pending_requests table was not created on install and I'm getting an error each time i view a users's profile page.

I tried creating the table manually based on the SQL in the install file but it says:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{buddylist_pending_requests} (
requester_uid int(11) NOT NULL default' at line 1

Here is the SQL code i am trying to use:

CREATE TABLE {buddylist_pending_requests} (
requester_uid int(11) NOT NULL default '0',
requestee_uid int(11) NOT NULL default '0',
received tinyint(1),
PRIMARY KEY (requester_uid, requestee_uid)
) /*!40100 DEFAULT CHARACTER SET utf8 */;");

My MYSQL version is: 4.1.20
PHP: 4.3.9

Is my MYSQL version not compatible with this module?

Comments

roleychiu’s picture

well i Just created the table manually in phpmyadmin and didn't use the Execute SQL functionality. Seems to work now.

Just seems odd that the readme.txt has the SQL code for 3 of 4 tables (in the case the tables aren't created) and doesn't show the SQL for the 4th table. I had to open the buddylist.install file to find the SQL.