When I click in pattern tab, I get following exception :
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {menu_links} WHERE menu_name = :menu_name AND module = :module AND link_path = :path; Array ( [:menu_name] => management [:module] => system [:path] => admin ) in toolbar_get_menu_tree() (line 279 of C:\Program Files\EasyPHP 3.0\www\CMS\MM02\modules\toolbar\toolbar.module).
This error occured on server, but I saved all that and install on local and I get same error, so I think there is a problem in files or DB.
In fact I have more details in local :
PDOException: There is already an active transaction in _drupal_session_write() (line 206 of C:\Program Files\EasyPHP 3.0\www\CMS\MM02\includes\session.inc).
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 9281142154eb7b797c08bd8.34816782 ) in lock_release_all() (line 269 of C:\Program Files\EasyPHP 3.0\www\CMS\MM02\includes\lock.inc).
It's not my first drupal website and I never got such an error. I have that error only for that tab, nothing else.
After on local, I installed the new version 7.1.0 but nothing change.
How to get rid of that problem?
Comments
Comment #1
Dave ReidBoth errors do not seem to indicate a problem in Pathauto at all but seems to be a problem with your database.
Comment #2
sahuni CreditAttribution: sahuni commentedwell, after investigation, I found that problem comes from entity_token module, which is needed for Rules. I installed these modules 1 week ago.
Without entity_token, it's OK.
Searching more, I found that it works also with entity_token and new token version : token-7.x-1.0-beta7.
For good measure, I updated also pathauto with new version : pathauto-7.x-1.0.
But I must say that activing patterns tab must be something very hard for Drupal, at the limit of failure.
The page appears quickly, but needs 30 seconds to finish it's job.
If I remove entity_token, it's much better. So I think a problem persists.
Do you think I must post on Entity project issue queue?
Comment #3
Dave ReidThe maintainers of entity_token are well aware that it creates way too many tokens and basically overwhelms the token tree UI to the point where PHP runs out of memory or freezes browsers trying to process the tree table - and have not given any indication that they will change that (or remove the dependency for rules). We're doing as much as we can from within Token to increase performance but that's all we can control.
Comment #5
molave CreditAttribution: molave commentedHello,
Same thing happened to me just now. I have the following modules installed:
Rules (7.x-2.0)
Entity token (7.x-1.0-rc1)
Token (7.x-1.0-beta7)
So I installed module Pathauto (7.x-1.0) for the first time. The process went okay. But after installing (and clearing the cache) I could not access the Patterns tab...
Patterns- does not display...and only get the Uncaught Exception error as described above.
Just to get Pathauto to work, I'm going to remove Rules, and then remove Entity token. But obviously this is not a solution. I will do this on a dev site only.
Anyone have another idea?
Thanks
Comment #6
Technician CreditAttribution: Technician commentedI have same problem. Installed modules: Pathauto (7.x-1.0), Token (7.x-1.0rc1), Entity tokens (7.x-1.0-rc1), Rules (7.x-2.0).
I think that error not in pathauto module. Because when i try change Code Fields in Display Suite (they use tokens also), i get exactly the same exception message:
Comment #7
bneel CreditAttribution: bneel commentedSet max_allowed_packet=100M in your my.ini
Than restart mysql.
Comment #8
Technician CreditAttribution: Technician commentedThank you! It helps.
Comment #9
seren10pity CreditAttribution: seren10pity commentedSame problem since Drupal core update from 7.12 to 7.14.
It included several updates on Locale module, also in database if I remember well. SoI think it can come from that, maybe token or pathauto needs to be upgrated to fit the new locale database configuration ; but I'm not able to invertigate further in the code of the modules to see exactly what causes problems.
Hope it helps ;)
Comment #10
jasom CreditAttribution: jasom commented#7 worked, thank you. Just to document issue: my site is on localhost (xampp)
Comment #11
Dave ReidRestoring status.
Comment #12
vegantriathleteFor anybody who comes across this thread, I have written a blog post that explains the steps I took to address this on AWS RDS.
Comment #13
fietserwinOr, if you e.g. are at shared hosting and cannot change this parameter: try #1281408: Add a compressing serializer decorator.
Comment #14
loophole080 CreditAttribution: loophole080 commentedgood work around here: https://www.drupal.org/node/1203018#comment-7573659