Download & Extend

Upgrading filefield from D5 to D6 mysql error: ALTER TABLE content_field_file DROP warning

Project:FileField
Version:6.x-3.1
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

After upgrading from drupal 5 to drupal 6, I upgraded filefield version 5.x-2.4 to filefield 6.x-3.1 and ran update.php. I received the following warning:

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 '' at line 1 query: ALTER TABLE content_field_file DROP in C:\Apache2\htdocs\mysite\includes\database.mysql-common.inc on line 322.

Any ideas as to what the issue could be? From the install file it looks like it's trying to "Drop the list and description columns"?

Comments

#1

I'm getting the same errors after attempting to upgrade from/to the same versions. Also, when I run update.php the progress bar hangs at 13% (Remaining 34 of 38).

#2

Status:active» postponed (maintainer needs more info)

I haven't been able to reproduce these problems. Possibly it was corrected in subsequent versions of CCK? FileField hasn't changed its upgrade script at all since the 3.1 version.

#3

Status:postponed (maintainer needs more info)» closed (fixed)

Closing after lack of response.