i have tried adding FontSquirrel to both the dev and non dev 7.26 installs and it's completely making my dev site implode. it looks like FontSquirrel is trying to download all the fonts from it's repository during the installation. i can't understand why this is so with this particular submodule but not with Google's.

here's part of a pages-long ugliness the WOD spewed just now:

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {batch} (bid, timestamp, token, batch) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 39 [:db_insert_placeholder_1] => 1359574511 [:db_insert_placeholder_2] => rwnRdEh6B4bx_sbGLNNu5YwlxRymPdNEkcy16nvBCvY [:db_insert_placeholder_3] => a:13:{s:4:"sets";a:6:{i:0;a:13:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:0;s:5:"start";i:0;s:7:"elapsed";i:0;s:5:"title";s:43:"246 font families contain multiple variants";s:16:"progress_message";s:21:"Importing variants...

this one of those moments i wish i were a coder so i could submit a patch. le sigh.

can someone please, please, pretty please, fix this so it just installs but we do the downloading of fonts manually? i will be forever grateful.

/liza

Comments

Drave Robber’s picture

Drave Robber commented

i wish i were a coder

Well, this is a chance to get started. "Comment out" line 21 of fontyourface.install - where it says:

  // Import/update fonts
  fontyourface_import_fonts('fontsquirrel');

- add two slashes, making it:

  // Import/update fonts
  // fontyourface_import_fonts('fontsquirrel');

That will make the line in question just a comment, and it will not be executed.

Drave Robber’s picture

Drave Robber commented

Additional notes:

  • trying the quick fix in #1 is needed to verify that import fails just on install, not that it fails generally; by the way, have you encountered "MySQL server has gone away" errors in other contexts?
  • Font Squirrel is indeed special in being the only submodule that utilizes batch process to import fonts. Google Fonts API returns just one huge chunk of data with all the fonts, while Font Squirrel gives us a list of font families, and we need to separately request data about each family that happens to contain multiple variants.
Drave Robber’s picture

Drave Robber commented

Re: "MySQL server has gone away" on WAMP:

most people on this forum thread say increasing max_allowed_packet setting in my.ini helps.

Drave Robber’s picture

Drave Robber commented
Category: bug » support
Priority: Critical » Normal
Status: Active » Fixed

With no feedback for some time, I assume a fix or workaround was found.

Feel free to reopen if you have more details.

Status: Fixed » Closed (fixed)

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