warning message when module is enable.

user warning: Specified key was too long; max key length is 1000 bytes query: CREATE TABLE links_node ( lid INT(10) UNSIGNED NOT NULL DEFAULT '0', nid INT(10) UNSIGNED NOT NULL DEFAULT '0', link_title VARCHAR(255) NOT NULL DEFAULT '', weight INT(4) NOT NULL DEFAULT '0', clicks INT(10) UNSIGNED NOT NULL DEFAULT '0', module VARCHAR(100) NOT NULL, PRIMARY KEY (lid, nid, module), UNIQUE INDEX node_link_ix1 (nid, module, link_title, lid), UNIQUE INDEX node_link_ix2 (link_title, nid, module, lid), UNIQUE INDEX node_link_ix3 (nid, module, lid, weight) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /usr/local/apache/htdocs/sitename.com/drupal470b6/includes/database.mysql.inc on line 120.

Comments

syscrusher’s picture

syscrusher commented
Assigned: Unassigned » syscrusher
Status: Active » Reviewed & tested by the community

Good day, and sorry you are getting an error report. Fortunately, this bug is easily fixed.

The links.install module was recently created from the links.mysql file (which is now obsoleted). Unfortunately, the person who contributed links.install had an outdated version of links.mysql to work from, and when I committed the code, I didn't notice the error. All that needed to change was that {links_node}.module alters from VARCHAR(100) to VARCHAR(60).

Unfortunately, your table didn't correctly create in the initial install, so you'll need to drop and recreate the table. I'd recommend uninstalling the module, dropping {links}, {links_node}, and {links_monitor}, and reinstalling from scratch. Since you didn't get a {links_node} table in the first place, I'm assuming you don't have any existing data in the tables.

Again, sorry about the problem, and thanks for reporting the bug. I've committed the fix to CVS now.

Scott

RayZ’s picture

RayZ commented
Status: Reviewed & tested by the community » Fixed

If you have already had the links.module installed, there is one more step you'll probably need to do to get links.install to create the tables. After disabling the links.module and dropping the existing tables as Scott mentioned, you'll probably also need to delete the row corresponding to the links.module from the system table, otherwise drupal thinks the links module has already been installed and won't run the links.install file.

Marking as fixed, since I see that the updated install file has been committed.

coupet’s picture

coupet commented
Status: Fixed » Active

parse message when module is enable

Parse error: parse error, unexpected '%' in /usr/local/apache/htdocs/tsitename.com/drupal470b6/modules/links/links.install on line 134

This is the latest cvs and after enabling links only.

syscrusher’s picture

syscrusher commented
Status: Active » Fixed

Fixed in latest CVS drop. Thanks for reporting the bug.

Scott

coupet’s picture

coupet commented

Great! works perfectly! Thanks for excellent contrib.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)