I followed the install instructions and get this error after enabling the module:
user warning: You have an error in your SQL syntax near '; ' at line 12 query: CREATE TABLE referral ( uid INT NOT NULL, referral_uid INT NOT NULL, created INT NOT NULL, flag INT default 0, flag_timestamp INT, host VARCHAR(255), http_referer VARCHAR(255), PRIMARY KEY (uid), KEY (referral_uid) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/httpd/vhosts/dowsett.ca/subdomains/richard/httpdocs/includes/database.mysql.inc on line 120.
referral module database table(s) creation was unsuccessful. The tables may need to be installed by hand. See referral.install file for a list of the installation queries.

From what i can tell, the the table didn't get installed automatically. And I see there is the referral.install file that has some tips on how to install manually....but I don't knowSQL that well but have used phpMyAdmin. I tried pointing phpMyAdmin to the referral.install file and that came up with errors and I also tried cutting and pasting the contents o the referral.install file into the "Run SQL query" in phpMyAdmin and it gave errors as well.

I know I am missing something (probably simple)....what has to be done?

Comments

mdowsett’s picture

mdowsett commented

i still can't find a solution to this. I am using PHP 4.3.1 and the minimum requirements are 4.3.3 but everything else is working OK. I am also using MySQL v3.23 - the Drupal minimum requirements say nothing of what version of MySQL you need soI have no idea if this is an issue.

this module and the banner module both show errors that say there is no table installed...but there is no option to install it manually like other modules. This is what leads me to think that it 'should' happen automatically but something with my PHP or MySQL version is restricting the install from happening properly.

pomliane’s picture

pomliane commented
Component: Code » Code: referral
Status: Active » Closed (won't fix)

This version of User Referral is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.