I was using guestbook5.x-1.1 and upgrade to 5.x-2.x-dev version .
While I tried to upgrade the database , am facing this error message=>

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 '>rid' at line 1 query: UPDATE permission SET perm = 'administer advanced forum, view forum statistics, administer advanced profile, use PHP for title patterns, administer autoassignrole, administer blocks, use PHP for block visibility, edit own blog, administer content with blog api, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, see printer-friendly version, maintain buddy list, view buddy lists, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, administer filters, rate content, use PHP for fivestar target, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, access site guestbook, access user guestbooks, moderate all guestbooks, post in site guestbook, post in user guestbooks, create images, edit images, edit own images, view original images, administer images, view imagefield uploads, send invitations, send mass invitations, track invitations, withdraw accepted invitations, view invite statistics, view own invite statistics, administer job queue, view queued jobs, administer menu, access content, administer content types, administer nodes, create group_post content, create groups content, create page content, create story content, create uprofile content, edit group_post content, edit groups content, edit own group_post content, edit own groups content, edit own page content, edit own story content, edit own uprofile content, edit page content, edit story content, edit uprofile content, revert revisions, view revisions, administer meta tags, edit meta tags, administer organic groups, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, administer private messages, create new folder, administer search, search content, use advanced search, use service links, access statistics, view post access counter, access administration pages, administer site configuration, select different theme, administer taxonomy, access tellafriend form, access user profiles, administer access control, administer users, change own username, edit own usernode, edit usernodes, admin userpoints, view userpoints, access all views, administer views, administer voting api, override node priority, override term priority, override profile priority' WHERE rid = role->rid in /home/content/g/u/r/gurukool/html/includes/database.mysql.inc on line 174.

Though this is still in dev version , anybody have any idea ?
thanks and regards.

CommentFileSizeAuthor
#1 guestbook-DRUPAL-5--2.permission-update.patch1.52 KBsun
2.PNG16.37 KBalakesh
1.PNG20.56 KBalakesh

Comments

sun’s picture

Title: error in SQL syntax » Database update to 2.x fails
Status: Active » Fixed
StatusFileSize
new1.52 KB

Sorry, this means that you need to re-assign the (previously called "administer all guestbooks") "moderate all guestbooks" permission for your users. Attached patch fixes the error. Committed to all branches.

alakesh’s picture

Hats off to you..

Status: Fixed » Closed (fixed)

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