After my update the systems spits out the error

The following updates returned messages
draggableviews module
Update #7202

Failed: PDOException: SQLSTATE[HY000]: General error: 1 near "SHOW": syntax error: SHOW COLUMNS FROM `draggableviews_structure` WHERE Field = 'parent'; Array ( ) in draggableviews_update_7202() (line 101 of /www/htdocs/.../sites/all/modules/draggableviews/draggableviews.install).

CommentFileSizeAuthor
#2 fix-7202-update-1751530-2.patch748 bytesistryker

Comments

istryker’s picture

istryker commented

Change 


  if (!count(db_query("SHOW COLUMNS FROM `draggableviews_structure` WHERE Field = 'parent'")->fetchALL())) {

to 


  if (!db_field_exists('draggableviews_structure', 'parent')) {

And let me know if that solves your problem

istryker’s picture

istryker commented
Title: Updating from 7.x-2.0 to 7.x-2.x-dev leads to error on D7SQlite system » Updating from 7.x-2.0 to 7.x-2.x-dev leads to error (on D7SQlite system)
Status: Active » Needs review
StatusFileSize
new fix-7202-update-1751530-2.patch748 bytes

Here is the patch. Includes spelling correction.

Wolfgang Reszel’s picture

Wolfgang Reszel commented

Well, this patch fixes also update problems with MySQL.

istryker’s picture

istryker commented
Assigned: headkit » Unassigned
Status: Needs review » Postponed

@Wolfgang_Reszel - I assume the patch has your approval then.

Patch #2 (minus the extra white-spaces) committed in latest dev.

istryker’s picture

istryker commented
Status: Postponed » Fixed

Changed status to incorrectly

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.