I just installed the latest version of this module, and I got the following error:

user warning: 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 ''type' varchar(40) NOT NULL default '', type_key varcha query: CREATE TABLE mysite_content ( myid int(11) NOT NULL default '0', 'type' varchar(40) NOT NULL default '', type_key varchar(80) default NULL, title varchar(255) NOT NULL default '', content blob, PRIMARY KEY (myid), KEY type (type), KEY type_key (type_key) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/designen/public_html/domain/includes/database.mysql.inc on line 120.

it seemed that it just didn't like the quotes around the first mention of 'type', I copied the SQL code and ran it in PHPmyadmin without the quotes and it worked fine. I am running MYSQL 4.0.27.
-alynner

Comments

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Assigned: Unassigned » agentrickard

I must've accidentally loaded a bad file in the last update.

Will fix later today.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Active » Fixed

This may be an issue related to different versions of MySQL. I am unsure.

I have created a 4.7.x.3.5 and 5.x.1.5 release. The only difference between those and the v .4 release is the quotes in the install file.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Fixed » Closed (fixed)
brett.viren’s picture

brett.viren commented

Failure with 3.5 and MySQL 5.0.32 (Debian v -2). The mysite tables where never created. I dug into mysite.install and I think the problem is the use of "{}" to surround the table names. If I enter ths SQL with the "{}" simply removed then the problem went away.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

Wrapping table names in braces {} is a Drupal standard. It allows for table prefixing.

Use curly brackets when referencing table names in your SQL statements. This ensures that Drupal installations that use a database prefix will work correctly. Example: SELECT * FROM {accesslog} WHERE ... instead of SELECT * FROM accesslog WHERE ....

See: http://drupal.org/node/1395

See: http://drupal.org/node/51220

Are you having problems installing other modules?