Publisher does not support the Fluid field type. Please do not contact asking when support will be available.
If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.
Ticket: Installing Publisher redirects to a blank white page / Update P&T add-ons throws errors
Status | Resolved |
Add-on / Version | Publisher |
Severity | Critical |
EE Version | 24 |
Stephen Bowling
May 08, 2013Installing Publisher redirects to a blank white page, clicking back shows Publisher installation complete, but then gives error after clicking Update P&T add-ons.
A Database Error Occurred
Error Number: 1060
Duplicate column name 'selection_id'
ALTER TABLE `exp_assets_selections` ADD `selection_id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY AFTER `file_id`
Filename: third_party/publisher/libraries/Publisher/fieldtypes/Publisher_assets.php
Line Number: 112
On the front-end of the site, I get the following error when loading a page.
Error Number: 1054
Unknown column 'ae.publisher_lang_id' in 'where clause'
SELECT DISTINCT a.file_id, a.*, ae.* FROM exp_assets_files a INNER JOIN exp_assets_selections ae ON ae.file_id = a.file_id WHERE ae.entry_id IN (28) AND ae.field_id IN (2) AND is_draft = 0 AND ae.publisher_lang_id = 1 AND ae.publisher_status = "open" ORDER BY ae.sort_order
Filename: third_party/publisher/models/publisher_query.php
Line Number: 74
I haven’t changed any settings on Publisher yet.
I’m on a local MAMP server adding Publisher to an existing site. All P&T add-ons are up to date: Assets 2.1.2, WYGWAM 2.7.1, Playa 4.4.2. Please let me know what additional information would be helpful.
BoldMinded (Brian)
Stephen, what happens if you uninstall Publisher, then go to that Publisher_assets.php file and comment out the entire install() method, then try to re-install Publisher?
Stephen Bowling
Commenting out that install method causes the front-end and back-end of the site to only render white pages :/ Not getting any errors.
BoldMinded (Brian)
You need to turn up the debugging. In index.php and admin.php make sure $debug = 1, and make sure $config[‘debug’] = 2, then you’ll see errors.
Stephen Bowling
Sorry you are right, had to up it to 2.
BoldMinded (Brian)
Go to line 945 or so in the install_move_data() method of models/publisher_category.php and update it to this:
You might need to uninstall and then re-install Publisher.
Stephen Bowling
Should I keep the install method from before commented out as well?
BoldMinded (Brian)
No, remove the comments and see what happens.
Stephen Bowling
Okay, first got a memory error, then hit back and got this error:
BoldMinded (Brian)
What version of Publisher do you have?
BoldMinded (Brian)
That line should be this:
Stephen Bowling
I have version 0.98.7. Changing that line fixed it (and updating line 910 of publisher_category.php). Thanks for your help.
Is there any other information about my setup that would help?
BoldMinded (Brian)
So everything installed correctly now?
Stephen Bowling
Yes, looks good. No errors.
BoldMinded (Brian)
Cool. I’ve made those same changes locally so they’ll be fixed in 98.8
Stephen Bowling
Ran into another error after updating settings in Publisher
Can you please assist with this as well? :D
Stephen Bowling
Sorry, some additional information:
Changed a few of the select values on the setting page after install – the channels for approval, member groups, etc. Clicked ‘Save Settings’ and got the above error. Visiting other pages in the module don’t throw errors, but after returning to the Settings page, the errors persist.
BoldMinded (Brian)
Can you take a screen shot of your settings page? That error doesn’t tell me much.
Stephen Bowling
Sure, see link below.
https://dl.dropboxusercontent.com/u/144295/publisher_settings.jpg
BoldMinded (Brian)
Ah, retina images on a non-retina screen, fun 😊 Unfortunately that didn’t reveal anything new either. Can you go to publisher/libraries/Interface_Builder/fieldtypes/Select.php and on line 59 you’ll see this:
Change that whole block to this:
Stephen Bowling
Here’s a screen shot w/ all the variables alongside the error messages.
https://dl.dropboxusercontent.com/u/144295/publisher_var_dump.jpg
BoldMinded (Brian)
Since you had previous troubles with installing, would it be too much to ask to uninstall and re-install one more time? I can’t replicate this locally, and its throwing errors on everything :/
Stephen Bowling
Would not be a problem. I just uninstalled and reinstalled. I hit a memory limit issue, then increased the memory limit in php.ini from 32MB to 128MB and pulled a fresh version of the database from the production server.
Reinstalled Publisher and everything installed smoothly, still got the same errors on the settings page though :/ We have ~1,500 rows in our channel data table if that makes a difference for the initial install.
I’m working on getting a staging server up so Publisher isn’t only on my local machine and see how that goes. I’ll keep you updated.
Stephen Bowling
I have a staging server up. I installed Publisher on it and it installed fine (no memory error), but the same errors are occurring on the settings page. I added FTP/CP info to the ticket if you want to take a look at the environment. Please let me know if there is anything else I should try on my end.
BoldMinded (Brian)
Stephen, are the correct file paths available to me on FTP? I can edit the mcp file, but its not reflecting my changes in the CP.
Stephen Bowling
It’s hosted on Pagoda Box, so changes have to be deployed through the CP still (weak). Do you have an account there? If so I can add you as a collaborator which will let you deploy.
I just deployed the latest changes though, so should be up-to-date now.
BoldMinded (Brian)
I just created an acct there, username is tilzinger.
Stephen Bowling
Thanks, just added to the project. You have to click Deploy Latest in the top right to move code changes into production on the staging server.
BoldMinded (Brian)
Strange. Ok. Thanks!
BoldMinded (Brian)
I don’t know if this is going to work. I have to wait several minutes after every file change to see the debugging output b/c of the deployments.
Stephen Bowling
Yeah, Pagoda Box can be a pain when trying to make quick changes. I set it up on a server over at DreamHost, but that one isn’t showing any issues, which would be a good thing, except we can’t run the production site there :/
Very strange.
BoldMinded (Brian)
That leads me to believe that it’s a server issue. What version of php is the pagoda box?
Stephen Bowling
5.3.8 on PagodaBox, 5.4.4 locally, 5.3.13 on DreamHost (where it seems to work okay). It looks like the DreamHost server has many more extensions enabled as well.
Pagoda:
DreamHost:
BoldMinded (Brian)
Stephen, one thing that sticks out is the Dreamhost server has “–enable-json=shared”, but the other server does not. Publisher does rely on json_encode and json_decode methods, so I wonder if that might have something to do with it?
BoldMinded (Brian)
Stephen, I have someone else getting similar errors on the settings screen. I’ve asked them for FTP access, then hopefully I can sort out the issue.
Stephen Bowling
I tried enabling the JSON extension and uninstalled/reinstalled with no luck. Please keep me posted with whatever you find on the other installation. In the meantime we are setting up a simplified workflow using statuses and the native emails for new posts. Thanks! 😊
BoldMinded (Brian)
Stephen, would you be able to zip up the whole site and send it to me so I can debug locally? If so send it to support@boldminded.com
BoldMinded (Brian)
Stephen, I wasn’t getting these errors in my local install with the code you sent. I’m using MAMP with PHP 5.3.6
Stephen Bowling
Thanks for taking the time to look further into my issues. I’ll try some different versions of PHP in MAMP and see if I have better luck.
Brian Litzinger
Closing this for now, if it comes up again just open a new ticket.