SQL errors

Sorry for not answering sooner. I checked and I just cannot see why the table would not have been created.

The error you are getting sounds like the installation failed, you should have gotten a message then.

Also, I suppose you meant that the version was 6.x-1.x-dev (not 0.x).

Note that I use PostgreSQL too. But you did not say which version you have.

Thank you.
Alexis

Forgot to change the status...

DenProg,

I just checked in new code. You will soon be able to download a newer version of 6.x-dev with the fix.

MAKE SURE THE DATE IS Jun 24, 2009

To test with the new version:

1. Go to admin/modules

2. Disable all the PAD File modules (you may need 2 or 3 passes!)

3. Once all the PAD File modules are disabled, click on the "Uninstall" tab at the top

4. Uninstall all the PAD File modules

5. Install the 6.x-dev PAD File tarball

6. Enable the new PAD File

Then let me know whether it still fails.

Thank you.
Alexis

P.S. It looks like you may have an older version of MySQL that does not support VARCHAR(450) and VARCHAR(2000).

Hi Alexis,

I am getting very similar errors here where the 'padfile_descriptions' table is not getting created.
I got this error on the initial installation of the module.

user warning: Duplicate key name 'description' query: CREATE TABLE padfile_descriptions ( `padid` INT NOT NULL, `language` VARCHAR(32) NOT NULL, `keywords` VARCHAR(250) DEFAULT NULL, `desc45` VARCHAR(45) DEFAULT NULL, `desc80` VARCHAR(80) DEFAULT NULL, `desc250` VARCHAR(250) DEFAULT NULL, `desc450` TEXT DEFAULT NULL, `desc2000` TEXT DEFAULT NULL, UNIQUE KEY description (padid, language), INDEX padid (padid), INDEX description (padid, language) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\inetpub\wwwroot\drupal\includes\database.inc on line 517.

I have the following environment:
- Drupal version 6.13
- PAD Files 6.x-1.x-dev (2009-Jun-24)
- MySQL Version 5.1.34-community
- Windows 2008 server / IIS 8

Thanks!

Ah! This time I got it! 8-)

The length problem was in regard to MySQL v4.x or older. 5.x would probably have worked with the previous code.

However, I defined 'description' as an index and a unique key.

I checked in a new fix. Please, get the new -dev version (will show up within 12h) and try again!

If you cannot wait, go to line 345 and delete the text that looks like this:

'description' => array('padid', 'language'),

that appears in the indexes => array(...) definition. That's the culprit.

Thank you.
Alexis Wilke

Hi ,
I updated to the latest version (2009-Jul-14), but am still getting the same error on install:

user warning: Duplicate key name 'description' query: CREATE TABLE padfile_descriptions ( `padid` INT NOT NULL, `language` VARCHAR(32) NOT NULL, `keywords` VARCHAR(250) DEFAULT NULL, `desc45` VARCHAR(45) DEFAULT NULL, `desc80` VARCHAR(80) DEFAULT NULL, `desc250` VARCHAR(250) DEFAULT NULL, `desc450` TEXT DEFAULT NULL, `desc2000` TEXT DEFAULT NULL, UNIQUE KEY description (padid, language), INDEX padid (padid), INDEX description (padid, language) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\inetpub\wwwroot\drupal\includes\database.inc on line 517.

I then looked at 'padfile.install' on line 345 and the 'description' => array('padid', 'language') line was still there, so I deleted it and then the install worked!

Thanks!

shadeblue,

How many 'description' => array('padid', 'language') did you see in padfile.install? One or two?

I kept the one in the Unique Keys and deleted the one in the Indexes...

Would you please confirm that you only deleted the one in the Indexes array and not the one in the Unique Keys?

Thank you.
Alexis

Hi Alexis,

Yes, I only deleted the instance under Indexes.
Here is the snippet from my current padfile.install starting at line 343

    'indexes' => array(
      'padid' => array('padid'),
    ),
    'unique keys' => array(
      'description' => array('padid', 'language'),
    ),

I went back and checked the padfile.install inside the TAR that I has downloaded and it still had 'description' => array('padid', 'language') on line 345.
So I downloaded a new fresh copy today and now 'description' => array('padid', 'language') is no longer included on line 345.
So maybe when I downloaded the TAR it had not fully propagated (even though the description was updated) or maybe my browser decided to use a cached copy, I'm not sure, but it looks like the current published copy is now correct.

Thanks!

shadeblue,

Thank you for the report! Not too sure why the download would have failed. Maybe you tried slightly too soon indeed... I would think the cache would not be a problem since it should check the date automatically.

I will make this version an official version so other MySQL users will not run in this problem.

Alexis