Update 7301 fails

I can confirm I see the PDOException as well.
My site does not break in any apparent way though. Pages still render, and the UI works.
I do get a new column, 'locks', which is filled with null values.

@Shadlington
I'm absolutely not sure about this, but it seems to me like there are two different problems here. Despite the error message, and the column being filled with NULL values, my site continues to function well. This being for a semi-large site that uses Panels for most of the user-facing content, I will stick my neck out and suggest your rendering issues are caused by something else.

Going to the content tab of a panels page throws a warning like: "Theme key "panels_onecol" not found."

This means that the theme registry is somhow missing the themes. Doing a simple cache clear should fix this.

@merlin, update 7301 failed. Since I'm using panels everywhere the whole page was blank. I cleared the cache per your suggestion and everything came back. However, no matter what else I try to do I can not get 7301 to succeed updating.

Same issue here!
can't update panels.
clearing cache doesn't help

I saw this as well, and immediately afterwards my panels were completely blank both in my site and on the panels admin screens.

I cleared all my caches (drush cc all) 3 times (I've heard one cache clear is occasionally insufficient) and everything appears to be working

I'll second Shadlinton, I can no longer add contest to panels via the GUI...this is pretty bad.

Ok, I added issue #1355300: Unable to Add Content to Panels for this add new content to panels issue. I even described a weird work-around that lets you add content.

Wow #7. I always tell people to flush cache 3 times jokingly, but it worked in this instance. Didn't work the 1st time, but I went with it, and it worked.

Same symptoms here, Panels ceased rendering, content couldn't be updated, and update 7301 wouldn't apply.

Same problem here with the update...

Clearing the cache gave me the content editor, then when I tried to add a piece of content, the ajax window disappeared and left my content editor blank. I saved the page, then decided to try clearing the cache again and my newly created content showed up and works as expected.

If you add content, try clearing the cache after saving it.

Panels 7.x 3.x-dev of 27 Nov. Returns the following error when updating database:

The following updates returned messages

panels module

Update #7301
Failed: PDOException: SQLSTATE[HY000]: General error: 1 near "WHERE": syntax error: UPDATE {panels_pane} SET locks= WHERE ( (locks <> ) OR (locks IS NULL ) ) ; Array ( ) in db_add_field() (line 2808 of /usr/home/www/includes/database/database.inc).

Hope it is useful to improve ;)

Update #7301

Failed: DatabaseSchemaObjectExistsException: Das Feld panels_pane.locks kann nicht hinzugefügt werden: Feld bereits vorhanden. in DatabaseSchema_mysql->addField() (Zeile 323 von /.../includes/database/mysql/schema.inc).

And:

Update #7301

Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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: UPDATE {panels_pane} SET locks=; Array ( ) in db_add_field() (Zeile 2808 von /.../includes/database/database.inc).

A problem with the add content interface, that is separate from the schema upgrade, has been identified and hopefully has a fix here #1355300: Unable to Add Content to Panels.

same

The same error remains after both updates for Panel 7.x-3.x-dev dated Nov 29, 2011 and Nov 30, 2011.

panels module
Update #7301
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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: UPDATE {panels_pane} SET locks=; Array ( ) in db_add_field() (line 2808 of /home/h30424/data/www/mmh6.info/includes/database/database.inc).

We are aware of the problem, and as far as anyone can tell, the error message is just cosmetic.

#1355300: Unable to Add Content to Panels comes from a separate problem that was committed at the same time.

18 posts of "me too" is only wasting maintainer time. If you don't have anything more to add, the please use the follow button instead of posting.

The problem is simple, the function AddField trying to update the field with the initial value does not take into account that must be serialized before using this value. Simply apply the function serialize to initial value.

$schema['panels_pane']['fields']['locks'] = array(
    'type' => 'text',
    'size' => 'big',
    'serialize' => TRUE,
    'object default' => array(),
    'initial' => serialize(array()),
  );

I can confirm slayer3's fix works.

Same error. Cleared cache multiple times, reran update, and then got this:

Failed: DatabaseSchemaObjectExistsException: Cannot add field panels_pane.locks: field already exists. in DatabaseSchema_mysql->addField() (line 323 of /includes/database/mysql/schema.inc).

Can someone test this patch on a pre-7301 database?

Patch tested. Works great. Thanks.

Thanks for testing! Committed and pushed.

Okay thx the update work. But now i get these notice:

Notice: Undefined index: access in _menu_translate() (Zeile 778 von /.../includes/menu.inc).
Notice: Undefined index: access in menu_local_tasks() (Zeile 1946 von /.../includes/menu.inc).

I found these http://drupal.org/node/1170358. They talk about that is a cache issue bute when i clear the cache the notice dont go away. any idea?

Those are probably not related. This update didn't make any changes to menu.

Unfortunately it's difficult to tell exactly where those come from; they stem from something putting incorrect data into hook_menu and it's really difficult to spot.

Sometimes it works to get into the code where ti's failing and use dsm() to see what the menu item is that caused it, but it requires some decent PHP and drupal knowledge to do that.

The latest dev seems to have applied 7301 without a problem

What a fuxx ^^ After deactivating many modules and testing and clearing the cache thousend times ... i have the notice gone away ... the notice is gone after deactivating these module: "Views content panes" ... thank god its friday ;-)

Is the translation of that error basically that the panels_node table does not exist?

If that is the case, do the following:

Disable the module 'panels_node'.
Uninstall the module 'panels_node'. (On the modules page there is a tab for "uninstall"). This might give an error that it can't drop the offending table.
Re-enable the module 'panels_node'.

Panels_node module handles its table separately; the reason I suggest that it's just that module is that your error only mentions the one table. If there are other tables you might have to uninstall the Panels module.

Ahh. Hm. That error can probably be ignored, though it might mean that necessary updates to the table may not have been created. You should still go through the uninstall and re-install process to insure the table gets dropped and created correctly.

The uninstall page is a tab on the modules page. It can be found at admin/modules/uninstall.

If for some reason you have those tables and your Drupal install does not believe the modules are installed, then you can look at panels.install and panels_node.install (and other .install files) to find exactly which tables to drop. For the most part, the mysql command show tables like 'panels%'; will show you what you need.