Support

Home Forums Event Espresso Premium Missing Staff Post WP & EE Update 3.1.37.5.P

Missing Staff Post WP & EE Update 3.1.37.5.P

Posted: September 14, 2015 at 9:26 am

Viewing 37 reply threads


Kyle Mathews

September 14, 2015 at 9:26 am

I am through the process of updating WP from 3.4 -> 4.3, and also updating EE to 3.1.37.5.P. After adjusting all the EE settings my Post update staging site and production are looking almost identical.

The only exception is missing/incomplete entries under the Staff Manager section of EE. I am not sure where this staff information lives, and I can not find any doc that would point me in the right direction. Im confused on how the update process would effect the info pertaining to the EE Staff section and why some entires would be incomplete and some would be missing.

Any help is much appreciated.


Kyle Mathews

September 14, 2015 at 10:02 am

Plugins:
Event Espresso
Event Espresso – Calendar
Event Espresso – Members Addon
Event Espresso – Multi Event Registration
Event Espresso – Recurring Events


Josh

  • Support Staff

September 14, 2015 at 1:49 pm

Hi Kyle,

It may help if you can give an example of what data is incomplete or missing. Is it the staff name, address, something else?

Also, can you go to Event Espresso > General Settings and look under the Advanced settings section, and check to see if the option for “Use the Staff Manager?” is set to Yes?


Kyle Mathews

September 14, 2015 at 3:19 pm

Josh –

Context: Productions site (server A, DB A) Pre Upgrade (server B, DB B) Post Upgrade (server B, DB C)

When comparing the production and pre upgrade site with my post upgrade site, all of which originated from production’s code base and DB.

The Staff Manager section for the Upgrade site has a mixture of the following; missing staff members completely, and has staff members missing images and or bio information when compared with the prod and pre upgrade site.

So when you go to an event on the front end, an event does not have all the staff listed that should be there and or has missing bios and images for the staff assigned to the event.

So I am trying to figure out what part of the upgrade would have affect either the site or the DB where the staff members are located. OR what EE config post upgrade I missed that would somehow reveal the missing staff/information

Thanks in advance for the help


Kyle Mathews

September 14, 2015 at 3:20 pm

And yes, use the Staff Manager?” is set to Yes? Which is how I am able to going into the list of staff and search for known staff to determine they are missing.


Josh

  • Support Staff

September 14, 2015 at 3:37 pm

Hi Kyle,

Can you check and compare the _events_personnel tables between the two databases? That’s where all of the data for Staff information is stored.


Kyle Mathews

September 15, 2015 at 3:58 pm

Update: The records in the wp_events_personnel are identical between Prod and Pre Upgrade. I thought that perhaps phpMyAdmin was altering the structure of the serialized data during either the export or import so I switched to Sequel Pro with no change in the end result. So as of today I took a full export of Production and imported into my Pre Upgrade environment to remove the upgrade variable from the equation.

Its as if the copy of the production wp_events_personnel table is not being read by the EE plugin. If I go into WP-admin and edit a staff member via the GUI it rewrites the data to the DB and then in works. But the import of the prod data is not being read (for the most part).

Here is what I see:
Prod – wp_events_personnel- meta : Results in correct output in both Front End and Events Admin Section of WP
a:10:{s:5:”phone”;s:0:””;s:7:”twitter”;s:0:””;s:5:”image”;s:47:”/wp-content/uploads/2013/04/Sonja-Krane_web.jpg”;s:7:”website”;s:0:””;s:11:”description”;s:1092:”Managing Editor, Journal of the American Chemical Society, ACS <p/>
<p/>
Sonja Krane received her Bachelor\\'s degree in Biochemistry from the University of California, Los Angeles. After working as a medicinal chemist at a biotech start-up, she moved on to study the isolation and characterization of biologically-active natural products at Columbia University in New York City, where she was awarded a Ph.D. with distinction in 2004.<p/>
<p/>
Following a post-doctoral fellowship in the Department of Chemistry at the University of Pennsylvania, Sonja joined the ACS Publications Division as Managing Editor of the Journal of the American Chemical Society (JACS). In this position, Sonja has assisted in streamlining the operations of the journal\\'s editorial offices by facilitating a primarily electronic workflow for the 12,000+ annual manuscript submissions. She supports the strategic development of JACS, implementing ideas that allow JACS to remain at the forefront of international chemistry journals.”;s:12:”organization”;s:0:””;s:5:”title”;s:0:””;s:8:”industry”;s:0:””;s:4:”city”;s:0:””;s:7:”country”;s:0:””;}

Pre Upgrade – wp_events_personnel- meta : Results in correct output in both Front End and Events Admin Section of WP
a:10:{s:5:”phone”;s:0:””;s:7:”twitter”;s:0:””;s:5:”image”;s:47:”/wp-content/uploads/2013/04/Sonja-Krane_web.jpg”;s:7:”website”;s:0:””;s:11:”description”;s:1092:”Managing Editor, Journal of the American Chemical Society, ACS <p/>
<p/>
Sonja Krane received her Bachelor\\'s degree in Biochemistry from the University of California, Los Angeles. After working as a medicinal chemist at a biotech start-up, she moved on to study the isolation and characterization of biologically-active natural products at Columbia University in New York City, where she was awarded a Ph.D. with distinction in 2004.<p/>
<p/>
Following a post-doctoral fellowship in the Department of Chemistry at the University of Pennsylvania, Sonja joined the ACS Publications Division as Managing Editor of the Journal of the American Chemical Society (JACS). In this position, Sonja has assisted in streamlining the operations of the journal\\'s editorial offices by facilitating a primarily electronic workflow for the 12,000+ annual manuscript submissions. She supports the strategic development of JACS, implementing ideas that allow JACS to remain at the forefront of international chemistry journals.”;s:12:”organization”;s:0:””;s:5:”title”;s:0:””;s:8:”industry”;s:0:””;s:4:”city”;s:0:””;s:7:”country”;s:0:””;}

Prod – wp_events_personnel- meta : Results in correct output in both Front End and Events Admin Section of WP
a:10:{s:5:”phone”;s:0:””;s:7:”twitter”;s:0:””;s:5:”image”;s:64:”http://acsoncampus.acs.org/wp-content/uploads/2015/09/Dale50.jpg&#8221;;s:7:”website”;s:0:””;s:11:”description”;s:3463:”<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>

<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>

<p>Poulter\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the “isoprenoid” fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies – Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>

<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>”;s:12:”organization”;s:0:””;s:5:”title”;s:0:””;s:8:”industry”;s:0:””;s:4:”city”;s:0:””;s:7:”country”;s:0:””;}

Pre Upgrade – wp_events_personnel- meta : Results in NO output in both Front End and Events Admin Section of WP. All I see is the Data from the ‘name’ field of the table. Also I edited the ‘meta’ field in the DB to remove the absolute path of his image and saw no change on the website
a:10:{s:5:”phone”;s:0:””;s:7:”twitter”;s:0:””;s:5:”image”;s:38:”/wp-content/uploads/2015/09/Dale50.jpg”;s:7:”website”;s:0:””;s:11:”description”;s:3463:”<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>

<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>

<p>Poulter\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the “isoprenoid” fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies – Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>

<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>”;s:12:”organization”;s:0:””;s:5:”title”;s:0:””;s:8:”industry”;s:0:””;s:4:”city”;s:0:””;s:7:”country”;s:0:””;}

I hope this all makes sense, and I am trying to present this info as clear as possible.


Josh

  • Support Staff

September 16, 2015 at 7:45 am

Hi Kyle,

The info you posted about what’s in the serialized data is helpful. I suspect some of the more recent security fixes in WordPress core are silently tripping up on the description content within those serialized arrays, due to the inclusion of the  character. While I don’t know how those got added, if you can remove them it will likely help.

So one way to remove those is go in and edit the staff entry directly in the db, carefully removing each  character, then update the string character count index. For example, if you remove ten ’s, and the index is 3443, you update the index to 3443.

The other way you can update those is copy the description into a text file, remove the description string completely, update the index to 0 for that string, then save. Then you should be able to go into the Event Espresso staff editor, paste in the description, and remove the  characters, then save.


Kyle Mathews

September 16, 2015 at 1:47 pm

Josh –

Here is the problem I am seeing. It appears the EE Staff is not picking up updates to the DB, when the GUI for a particular staff member is blank (no info due to an issue with the sterilized data from prod import). Below are the steps that led me to this conclusion

Step 1 (fresh import of Prod DB into Pre upgrade site) Info from wp_events_personnel > meta field which results in no staff member on site, and the WP-Admin GUI is blank for this particular staff member

a:10:{s:5:"phone";s:0:"";s:7:"twitter";s:0:"";s:5:"image";s:38:"/wp-content/uploads/2015/09/Dale50.jpg";s:7:"website";s:0:"";s:11:"description";s:3459:"<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>
<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>
<p>Poulter\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the “isoprenoid” fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies - Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>
<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>
";s:12:"organization";s:0:"";s:5:"title";s:0:"";s:8:"industry";s:0:"";s:4:"city";s:0:"";s:7:"country";s:0:"";}

Step 2 Copy the description and img location from the meta field above, and paste into Staff Manager GUI in WP-Admin. This gives me what I want, the staff member is listed on the site. Then check what that data looks like in the DB wp_events_personnel > meta field after the add via the WP-Admin GUI

a:10:{s:5:"phone";s:0:"";s:7:"twitter";s:0:"";s:5:"image";s:38:"/wp-content/uploads/2015/09/Dale50.jpg";s:7:"website";s:0:"";s:11:"description";s:3508:"s:3459:\&quot;<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>
<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>
<p>Poulter\\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the “isoprenoid” fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies - Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>
<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>";s:12:"organization";s:0:"";s:5:"title";s:0:"";s:8:"industry";s:0:"";s:4:"city";s:0:"";s:7:"country";s:0:"";}

So now I want to test that if I am able to update the the DB with the correct serialized data, will EE pick up the DB change. So I return the meta field to the info that come over from the prod db import

Step 3, paste in the following into the meta field for the staff member we have been working with. Outcome is no information for the staff member on the site, and no description or image in the WP-Admin GUI

a:10:{s:5:"phone";s:0:"";s:7:"twitter";s:0:"";s:5:"image";s:38:"/wp-content/uploads/2015/09/Dale50.jpg";s:7:"website";s:0:"";s:11:"description";s:3459:"<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>
<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>
<p>Poulter\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the “isoprenoid” fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies - Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>
<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>
";s:12:"organization";s:0:"";s:5:"title";s:0:"";s:8:"industry";s:0:"";s:4:"city";s:0:"";s:7:"country";s:0:"";}

Step 4 Now instead of editing this staff member via the WP-Admin GUI, I am going to take the serialized data that was created via the GUI entry (step 2) and paste it into the the meta field in the DB. I would expect that since I have entered the working data that the website should show this user, but it does not.

a:10:{s:5:"phone";s:0:"";s:7:"twitter";s:0:"";s:5:"image";s:38:"/wp-content/uploads/2015/09/Dale50.jpg";s:7:"website";s:0:"";s:11:"description";s:3508:"s:3459:\&quot;<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>
<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>
<p>Poulter\\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the “isoprenoid” fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies - Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>
<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>";s:12:"organization";s:0:"";s:5:"title";s:0:"";s:8:"industry";s:0:"";s:4:"city";s:0:"";s:7:"country";s:0:"";}

So this leads me to believe the only way to get this working is not by taking a copy of the prod DB where the site runs fine, but to have to go in and reenter the description for all 410 staff members. PLEASE tell me I am wrong


Josh

  • Support Staff

September 16, 2015 at 3:47 pm

I think it’s more that the newer version of WordPress isn’t allowing those metakey fields that contain the  characters to be displayed/used. If you can clean up the meta key values so that they no longer have the  characters in them, that should fix the issue you’re seeing.

You can even try cleaning up one of them as a test.


Kyle Mathews

September 17, 2015 at 7:50 am

Josh –

A couple of clarifications. My last post was conducted on a staging environment that had not been upgraded in any way. It is an exact copy of production in both environment, code and database. Yet it does no function the same way. Also I tired editing out the  characters and adjusting the character count, with no luck.

Using the following string from Prod where it works fine as a base even though by my count the character count for the description field is off. Bellow you can see it says 3459, but I get 3451 when I count the characters in the description string below. But like I said this is what is working in production.
——————————————
a:10:{s:5:”phone”;s:0:””;s:7:”twitter”;s:0:””;s:5:”image”;s:38:”/wp-content/uploads/2015/09/Dale50.jpg”;s:7:”website”;s:0:””;s:11:”description”;s:3459:”<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>
<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>
<p>Poulter\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the “isoprenoid” fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies – Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>
<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>
“;s:12:”organization”;s:0:””;s:5:”title”;s:0:””;s:8:”industry”;s:0:””;s:4:”city”;s:0:””;s:7:”country”;s:0:””;}
—————————————-

I then used text edit to remove  (16qty) characters and adjust the description char count from 3459 to 3435 results in this string, which still does not produce the results on the front end. See string below
———————————–
a:10:{s:5:”phone”;s:0:””;s:7:”twitter”;s:0:””;s:5:”image”;s:38:”/wp-content/uploads/2015/09/Dale50.jpg”;s:7:”website”;s:0:””;s:11:”description”;s:3435:”<p>John A. Widtsoe Distinguished Professor and Chair, Department of Chemistry, University of Utah</p>
<p>C. Dale Poulter (born August 29, 1942) received a B.S. in 1964 from Louisiana State University and a Ph.D. in 1967 under the direction of W.G. Dauben at the University of California at Berkeley. He was an NIH Postdoctoral Fellow with S. Winstein at the University of California at Los Angeles between 1967 and 1969. Poulter joined the faculty of the Department of Chemistry at the University of Utah in 1969 and is currently the John A. Widtsoe Distinguished Professor of Chemistry. He served as Chair of the Department of Chemistry from 1995 to 2000. Poulter also holds appointments as Research Professor of Medicinal Chemistry and Adjunct Professor of Biochemistry at the University of Utah. He is also Honorary Professor at the University of Queensland. Poulter served as Associate Editor of the <cite>Journal of Organic Chemistry</cite>, Associate Editor of <cite>Organic Letters</cite>, and Senior Editor of the <cite>Journal of Organic Chemistry</cite>. In 2001 he became the Editor-in-Chief of <cite>The Journal of Organic Chemistry</cite>. In addition to his editorial duties, Professor Poulter has served on the Editorial Advisory Boards of <cite>Chemical Reviews</cite> (1996-2001), <cite>Bioorganic and Medicinal Chemistry</cite> (1993-present), <cite>Journal of Organic Chemistry</cite> (1987-1990), <cite>Journal of Bioorganic Chemistry</cite> (1983-1990), and <cite>Journal of the American Chemical Society</cite> (1983-1986).</p>
<p>Poulter\'s research interests are in the areas at the interface between organic chemistry and biology where he pioneered the use of genetics and molecular biology to construct bacterial and yeast strains to produce recombinant enzymes. He established the mechanisms for biosynthesis of the major metabolic intermediates in the isoprenoid biosynthetic pathway and, in collaboration with Jim Sacchettini, discovered the €œisoprenoid€ fold found in enzymes that catalyze the major carbon-carbon forming reactions in the pathway. Poulter also pioneered the development of 2-dimensional NMR techniques to study the structure of biological macromolecules. He is a founding scientist of two biotechnology companies – Acacia Biosciences, Inc. (with Jasper Rine) and Echelon Biosciences, Inc. (with Glenn Prestwich).</p>
<p>Poulter has been invited to present over 400 lectures, including the Gassman Lectureship (Minnesota), the Willsmore Lectureship (Melbourne), the Hirschman Lectureship (Oberlin), the Ross Lectureship (Darthmouth), the AstraZeneca Lectureship (Montreal), the Green Lectureship (Wisconsin), and the Ingersoll Lectureship (Vanderbilt). He was an Alfred P. Sloan Fellow and has received the Ernest Guenther Award (American Chemical Society (ACS)), Distinguished Research Award (University of Utah), Arthur C. Cope Scholar Award (ACS), the Rosenblatt Prize (University of Utah), the Repligen Award (ACS), and the James Flack Norris Award (ACS). He was elected a Fellow of the American Association for the Advancement of Science (1994), a Fellow of the American Academy of Arts and Sciences (2005), and a Fellow of the American Chemical Society (2009). He is a member of the National Academy of Sciences (2009).</p>
“;s:12:”organization”;s:0:””;s:5:”title”;s:0:””;s:8:”industry”;s:0:””;s:4:”city”;s:0:””;s:7:”country”;s:0:””;}
———————————————-


Josh

  • Support Staff

September 17, 2015 at 12:50 pm

My last post was conducted on a staging environment that had not been upgraded in any way. It is an exact copy of production in both environment, code and database. Yet it does no function the same way.

Maybe there’s something getting altered when you migrate the data? So both the staging and production are using the exact same version of WordPress? If you don’t mind me asking, which minor point release are they running?


Kyle Mathews

September 21, 2015 at 9:22 am

Josh –
I have used both phpMyAdmin in the cPanel and also Sequel Pro to export and import the data. Thinking that perhaps PHPMyAdmin was affecting the import/export. There was no change when I switched to Sequel Pro.

Currently I am running WordPress 3.4.1. in all environments.


Josh

  • Support Staff

September 23, 2015 at 11:52 am

Hi Kyle,

We received your database exports. Can you let us know which database of the two is used by the site that has the issues?


Kyle Mathews

September 23, 2015 at 11:55 am

Josh –

I also put this in a follow up email

acs_post = staging – site that has issue displaying the information in the meta field of event_personal
Acsoncampus = prod


Kyle Mathews

September 23, 2015 at 2:01 pm

Josh –

I know the token was for only 30min of support, but I am not sure if that has started already. Let me know how I can monitor the status of this. So far the only contact that has been made was the request for DB backups.


Josh

  • Support Staff

September 23, 2015 at 2:42 pm

Hi Kyle,

I can give you an update here. We’ve looked into this for the past few hours. It’s definitely an issue with the serialized data, and at this point it seems like the breakage is happening between the time the data is exported from production and imported to staging. The meta data between the two databases have differences in them. I can post some examples if you’d like, but I think you can spot the differences if you compare the two databases.

Also, with WP_DEBUG activated on staging, you’ll see an error like this in the staff editor when there’s an issue with that entry’s meta data:

Notice: unserialize() [function.unserialize]: Error at offset 1555 of 1661 bytes in

It’s also not the case where you’ll need to update all of the 312 entries (I’m not sure where you got the 410 number, mysql says there are 312 rows in the table).

I’ll update this thread when I have more information.


Josh

  • Support Staff

September 23, 2015 at 3:10 pm

I can also confirm that the serialized data within the records in the wp_events_personnel are not identical between the production db export and staging db export you sent. There are differences in the character count and within the content of the serialized data.


Josh

  • Support Staff

September 24, 2015 at 10:12 am

Hi Kyle,

Can you what you have set for DB_CHARSET and DB_COLLATE in the production site’s wp-config.php file? Does that match up with what you have set up on your staging sites?

Along with that, when you go to export the data from production, and import onto a staging site, do the data types match?


Kyle Mathews

September 24, 2015 at 11:01 am

I’m not sure where you got the 410 number, mysql says there are 312 rows in the table

Thanks I was originally going off the ID, but I do see the same 312 records you see.

I can also confirm that the serialized data within the records in the wp_events_personnel are not identical between the production db export and staging db export you sent.

I have made edits to the staging DB via the GUI and Sequel Pro and those were represent in that export. If you would like to provide a specific record I can see if that is a diff that is a result of my edit.

Can you what you have set for DB_CHARSET and DB_COLLATE in the production site’s wp-config.php file?

define(‘DB_CHARSET’, ‘utf8’);
define(‘DB_COLLATE’, ”);

Along with that, when you go to export the data from production, and import onto a staging site, do the data types match?

I have received no indication of a data type mismatch via phpadmin or Sequel Pro during any of my import/exports


Josh

  • Support Staff

September 24, 2015 at 1:37 pm

Hi Kyle,

At this point all I can advise you is that it’s an issue with your serialized data. Here’s the relevant code (from edit_staff.php) where Event Espresso 3 queries the database and loops through the data to get a staff record to edit:

$id=$_REQUEST['id'];
$results = $wpdb->get_results("SELECT * FROM ". EVENTS_PERSONNEL_TABLE ." WHERE id =".$id);
foreach ($results as $result){
	$staff_id= $result->id;
	$name=stripslashes_deep($result->name);
	$role=stripslashes_deep($result->role);
	$email=stripslashes_deep($result->email);
	$meta = unserialize($result->meta);
}

That last line, $meta = unserialize($result->meta); runs PHP’s unserialize function on the serialized data from the meta column. When this code tries to load a staff entry from your exported/imported _events_personnel table, and if the row in question has broken serialized data, that line of code throws this PHP notice like this when debugging is enabled:

Notice: unserialize() [function.unserialize]: Error at offset 1365 of 1485 bytes in /wp-content/plugins/event-espresso/includes/admin-files/staff-management/edit_staff.php on line 12

And when that happens, the staff image and/or staff description doesn’t load up. The data still there, but it’s in a state that can’t be unserialized and thereafter loaded into the EE staff editor or a page with staff info. If you’ve activated WP_DEBUG on your staging site, you’ll have noted that the notice only displays on the entries where it also doesn’t load the image/description in the editor.


Kyle Mathews

September 24, 2015 at 1:56 pm

How do the the events described in the post above from September 16, 2015 at 1:47 pm fit into your scenario?

Short ver: If I am taking the serialized string that was created from entering the information via the WP-Admin GUI, and pasting it back into the db why is it not working.


Josh

  • Support Staff

September 24, 2015 at 2:39 pm

You can turn on WP_DEBUG and view that entry in the editor. When you view the entry with WP_DEBUG set to true, does it throw the unserialize() error?


Kyle Mathews

September 25, 2015 at 11:20 am

It appears that the support token I purchased has not been used. I would like to speak with someone at support. I would like to go over my findings before making the decision to manually edit the broken staff in the GUI for EE Staff?


Josh

  • Support Staff

September 25, 2015 at 1:55 pm

Hi Kyle,

It turns out Event Espresso support staff spent well over the 30 minutes of allotted time investigating and troubleshooting the copies of the databases you sent, and we communicated with you our findings. I intentionally left the priority support minutes on your account for the purpose of keeping your account open to access the secure Priority support token form.

If you would like to go over your findings before making the decision to manually edit the broken serialized staff data, you can report what you’ve found here and we’ll follow up with you as soon as possible.


Kyle Mathews

September 28, 2015 at 11:35 am

Josh –

My first questions deals with what seems to be the larger issue. Why is are serialized strings that work in production not working in stage? I believe I have found the issue to be a result of line endings when editing the string. But the only reason I have to edit the string is because what is in the Prod DB is not working in stage

My example for this is ID 240
Prod Staff ID 240 Debg True
Stage Staff ID 240 from Prod Import

I have found no tool to edit these serialized strings that won’t appear to cause issues with line endings. The only thing I can do is edit a staff member via the WP EE GUI.

Is this line ending issue something your team has seen before and have found a way to fix?


Josh

  • Support Staff

September 28, 2015 at 1:10 pm

Hi Kyle,

I chatted with the dev team about this, since I didn’t know off-hand whether they have seen the issue you describe here.

The feedback I got was this is something that could happen if you’re doing a search and replace during the data migration from production to staging. They recommend this tool for doing any search and replaces:

https://interconnectit.com/products/search-and-replace-for-wordpress-databases/


Kyle Mathews

September 28, 2015 at 1:17 pm

I found that tool listed in other forum post and used it to adjust the character count and img location for the records that had a absolute URL. But there is still the issue described in my post from September 17, 2015 at 7:50 am (paragraph 2) where the description character count that works in prod is not accurate and will not work in stage. So when I edit it in Sequel pro and I believe there is an issue with line endings.


Josh

  • Support Staff

September 29, 2015 at 10:48 am

So to review, the issue described in my post from September 17, 2015 at 7:50 am (paragraph 2) was this:

Using the following string from Prod where it works fine as a base even though by my count the character count for the description field is off. Bellow you can see it says 3459, but I get 3451 when I count the characters in the description string below. But like I said this is what is working in production.

A close look at the data you posted shows 4 line breaks within the serialized string. If two characters are counted per line ending, this adds 8 to the total.


Kyle Mathews

September 29, 2015 at 11:22 am

At this point all I can advise you is that it’s an issue with your serialized data

redacted – Event Espresso support team – LOC


Josh

  • Support Staff

September 29, 2015 at 11:36 am

Hi Kyle,

It could be the line breaks. Can you go in to the staff editor on production, remove the line breaks from the UI editor for staff ID 240, save, then copy the serialized meta data for staff ID 240 from production db. Then you copy to the matching entry in the staging db.

After you do the above, does the error persist?


Kyle Mathews

September 29, 2015 at 2:30 pm

Josh –

I have been trying to figure our all the variables to this equation since you posted your last message. Here is what I have deduced.

When a staff members description contains single quotes, non-breaking spaces or certain other characters the plugin runs into problems during the HTML encoding or serialization functions.

In the text and code below you can see what I am talking about Queen’s
Prod UI description ————————–

<p>Editor-in-Chief, Crystal Growth & Design</p>
<p>Dr. Robin D. Rogers is Canada Excellence Research Chair in Green Chemistry and Green Chemicals at McGill University in Montreal, Canada and the Founding Editor-in-Chief of the American Chemical Society journal Crystal Growth & Design. He obtained both his B.S. in Chemistry (1978, Summa Cum Laude) and his Ph.D. in Chemistry (1982) at The University of Alabama before starting his professorial career at Northern Illinois University in DeKalb, IL where he rose through the ranks to become Presidential Research Professor. In 1996, he returned to UA as a Professor where he held various titles including Distinguished Research Professor, Robert Ramsay Chair of Chemistry, and Director of the Center for Green Manufacturing. In 2007 he was also Chair of Green Chemistry and Co-Director of QUILL at The Queen’s University of Belfast in Northern Ireland (UK) before returning full time to UA from 2009-2014. Since 2009, he has been an Honorary Professor at the Chinese Academy of Sciences Institute for Process Engineering in Beijing, China.</p>
<p>Rogers holds 21 issued patents and has published over 760 papers on a diverse array of topics. His research interests cover the use of ionic liquids and Green Chemistry for sustainable technology through innovation and include: Materials (advanced polymeric and composite materials from biorenewables), Separations (novel strategies for separation and purification of value added products from biomass), Energy (new lubricant technologies and selective separations), and Medicine (elimination of waste while delivering improved pharmaceutical performance).</p>
<p>He has been cited over 31,000 times and has a Hirsch index of 83. Rogers was named in the 2014 Thomson Reuters Highly Cited Researchers List ranking among the top 1% most cited in chemistry. In 2006, Rogers was named a Fellow of the Royal Society of Chemistry and in 2009 was selected to the inaugural class of American Chemical Society Fellows. In 2010, he was named a Chinese Academy of Sciences Visiting Senior Scientist for the Institute for Process Engineering, Beijing, China. He was elected a Fellow of the American Association for the Advancement of Science in 2012 and that same year named an ACS Division of Industrial & Engineering Chemistry Fellow.</p>
<p>In 2005 he was awarded the US Presidential Green Chemistry Challenge Award (Academic Division) for work related to the use of ionic liquids in sustainable technology. This technology was licensed later that year to BASF. He was awarded the American Chemical Society Separations Science & Technology award in 2011 and in 2012, he was named recipient of the Paul Walden Award given by the DFG-SPP 1191 Priority Program on Ionic Liquids.</p>

Prod Serialized String Queen’s—————————

a:10:{s:5:"phone";s:0:"";s:7:"twitter";s:0:"";s:5:"image";s:74:"http://acsoncampus.acs.org/wp-content/uploads/2012/09/Robin-D.-Rogers1.jpg";s:7:"website";s:0:"";s:11:"description";s:2761:"Editor-in-Chief, Crystal Growth & Design

Dr. Robin D. Rogers is Canada Excellence Research Chair in Green Chemistry and Green Chemicals at McGill University in Montreal, Canada and the Founding Editor-in-Chief of the American Chemical Society journal Crystal Growth & Design. He obtained both his B.S. in Chemistry (1978, Summa Cum Laude) and his Ph.D. in Chemistry (1982) at The University of Alabama before starting his professorial career at Northern Illinois University in DeKalb, IL where he rose through the ranks to become Presidential Research Professor. In 1996, he returned to UA as a Professor where he held various titles including Distinguished Research Professor, Robert Ramsay Chair of Chemistry, and Director of the Center for Green Manufacturing. In 2007 he was also Chair of Green Chemistry and Co-Director of QUILL at The Queen’s University of Belfast in Northern Ireland (UK) before returning full time to UA from 2009-2014. Since 2009, he has been an Honorary Professor at the Chinese Academy of Sciences Institute for Process Engineering in Beijing, China.

Rogers holds 21 issued patents and has published over 760 papers on a diverse array of topics. His research interests cover the use of ionic liquids and Green Chemistry for sustainable technology through innovation and include: Materials (advanced polymeric and composite materials from biorenewables), Separations (novel strategies for separation and purification of value added products from biomass), Energy (new lubricant technologies and selective separations), and Medicine (elimination of waste while delivering improved pharmaceutical performance).

He has been cited over 31,000 times and has a Hirsch index of 83. Rogers was named in the 2014 Thomson Reuters Highly Cited Researchers List ranking among the top 1% most cited in chemistry. In 2006, Rogers was named a Fellow of the Royal Society of Chemistry and in 2009 was selected to the inaugural class of American Chemical Society Fellows. In 2010, he was named a Chinese Academy of Sciences Visiting Senior Scientist for the Institute for Process Engineering, Beijing, China. He was elected a Fellow of the American Association for the Advancement of Science in 2012 and that same year named an ACS Division of Industrial & Engineering Chemistry Fellow.

In 2005 he was awarded the US Presidential Green Chemistry Challenge Award (Academic Division) for work related to the use of ionic liquids in sustainable technology. This technology was licensed later that year to BASF. He was awarded the American Chemical Society Separations Science & Technology award in 2011 and in 2012, he was named recipient of the Paul Walden Award given by the DFG-SPP 1191 Priority Program on Ionic Liquids.";s:12:"organization";s:0:"";s:5:"title";s:0:"";s:8:"industry";s:0:"";s:4:"city";s:0:"";s:7:"country";s:0:"";}

Staging Error from above serialized string ———————-
Notice: unserialize(): Error at offset 2949 of 3064 bytes in /home/admin/public_html/acspost/wp-content/plugins/event-espresso/includes/admin-files/staff-management/edit_staff.php on line 12

I can get around this in two ways, remove all those characters from a staff members description. Or add the code below the edit_staff.php do get the staff members info to display in the UI for staff

`// IS Unserialize Fix
$result->meta = str_replace(‘”’, ‘”‘, $result->meta);
$result->meta = preg_replace(‘!s:(\d+):”(.*?)”;!se’, “‘s:’.strlen(‘$2′).’:\”$2\”;'”, $result->meta);
$meta = unserialize($result->meta);`

My question to the EE devs is… why?


Josh

  • Support Staff

September 30, 2015 at 11:25 am

The reason is because the data on staging has some issues with character encoding. Maybe it will help if you can compare some non-EE content on the two sites. For example, can you go to {production-url}/hosts/whyhost and compare the content on the page to {staging-url}/hosts/whyhost? Do you see the extra characters on staging where a quote or other special character is displayed?

For example, on production the word they'll is displayed on staging as they’ll. Here’s a screenshot that shows the two:

https://www.evernote.com/shard/s4/sh/616beb70-11c9-4e8b-9ee7-ef69bece41a4/d3fb9f7970069b12c15742581a69839a

You’ll see similar character encoding issues on other pages like program-overview/how-it-works/.

It’s the same underlying issue, things only get trickier and more error prone when you’re dealing with serialized data.

The way forward is to figure out how the staging site is ending up with character set issues. If you can step us through your process of how you’re getting the data out of production and onto staging, how you’re setting up the staging site, and please be as specific as possible, it may help us help you find the root cause of this and the way forward.


Kyle Mathews

October 1, 2015 at 1:16 pm

To date I have used 2 methods of exporting/Importing the data from production. I gave a high level overview in my post from September 15, 2015 at 3:58 pm. I will provide more details here:

First method, phpMyAdmin:
Export: https://interactivestrategies.box.com/s/snnid0ilydyvddl7ujlvnnzexjxkgln9
Import: https://interactivestrategies.box.com/s/mjbh10h9mlu3fivmfr8vhz557cjitm41
Second method, Sequel Pro:
Export: https://interactivestrategies.box.com/s/4ui91t6jwgtbg43luz5stv27lkgl8b9j
Import: https://interactivestrategies.box.com/s/mjbh10h9mlu3fivmfr8vhz557cjitm41

Both Prod and Stage are running on A2 Managed VPS servers
Stage: https://interactivestrategies.box.com/s/e8pyj0l1rme8vhb99zjpw4v7ru103m8r
Prod: https://interactivestrategies.box.com/s/1d9mxhuqpi5923p9g52675i3wzqdfz6z

For stage I created the following
https://interactivestrategies.box.com/s/4i4yjwc6lv4j7vlk1ntxcr72ejza20u8
https://interactivestrategies.box.com/s/nqsnuj446zllouf8yghyckz8buyhfxwl

Let me know what area you would like more details


Josh

  • Support Staff

October 1, 2015 at 2:57 pm

Yes, the screenshots do not have much detail to them. When you go to save the export output to a file, what’s the character set of the file that you selected?

For example: If you are exporting in a charset *other* than utf8 and importing *as* utf8 that will cause encoding issues.

Along with that, it may help if you can check with your host and ask them if they can compare the production and staging servers’ character set and collation and database character set and collations and verify that they match between production and staging.


Kyle Mathews

October 2, 2015 at 9:34 am

Josh –

My apologies, I assumed there was more familiarity with the tools I mentioned.
The default export options for both tools mentioned is uff8 and I have confirmed on import that the meta field is. I have started a ticket with A2 to check what you mentioned. I setup both servers in the same way so I am nit sure there could be a difference, but asked them to check just to be 100%

Default phpMyAdmin Export:
https://interactivestrategies.box.com/s/6nbzzgpb7dfc6k1hxhyfc9xd4rjwi2l4
Import Structure:
https://interactivestrategies.box.com/s/vfofu550we5csurm996hum5gjn8sncrg

Import/Export options from above:

Import: https://interactivestrategies.box.com/s/mjbh10h9mlu3fivmfr8vhz557cjitm41
Export: https://interactivestrategies.box.com/s/4ui91t6jwgtbg43luz5stv27lkgl8b9j


Josh

  • Support Staff

October 2, 2015 at 9:41 am

You might also ask your host for insight on why your staging server is displaying the extra characters like I shared with you in this screenshot:

https://www.evernote.com/shard/s4/sh/616beb70-11c9-4e8b-9ee7-ef69bece41a4/d3fb9f7970069b12c15742581a69839a


Kyle Mathews

October 2, 2015 at 11:03 am

I followed up with that question. This was the response to

check with your host and ask them if they can compare the production and staging servers’ character set and collation and database character set and collations and verify that they match between production and staging.

The MySQL configurations are identical on the two servers

Viewing 37 reply threads

The support post ‘Missing Staff Post WP & EE Update 3.1.37.5.P’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso