We have a problem with one conference in our system where the conference director decided to extend the submission period for Posters only. To do this he deleted all other submission types in Conference setup.
This meant unfortunatly that the previous submitted papers for the conference “disappeared” for the conference director. We can see that the submitted papers are in the database but are lost for the review process.
Do any of you have a suggestion on how to reconnect these submissions?
At a glance, I’m not sure how this would cause the papers to disapper. As you’ve noted, the database will still contain their data. Have you checked your PHP error log for details to see whether an error appears when you attempt to fetch the listing of submissions?
Regards,
Alec Smecher
Public Knowledge Project Team
Thanks for the advice.
I do get some errors there that seems connected to our problem.
Please see log below.
Not sure how to proceed now, though.
/Anders
[04-Oct-2017 14:38:59 Europe/Belgrade] PHP Fatal error: Call to a member function getLocalizedName() on null in C:\inetpub\wwwroot\cache\t_compile%%2D^2DF^2DF52775%%submissionsUnassigned.tpl.php on line 40
[04-Oct-2017 14:39:08 Europe/Belgrade] PHP Fatal error: Call to a member function getLocalizedName() on null in C:\inetpub\wwwroot\cache\t_compile%%95^95F^95FFC06A%%submissionsInReview.tpl.php on line 60
[04-Oct-2017 14:40:46 Europe/Belgrade] PHP Fatal error: Call to a member function getLocalizedName() on null in C:\inetpub\wwwroot\cache\t_compile%%80^80E^80EC87A9%%submissionsArchives.tpl.php on line 43
[04-Oct-2017 15:05:50 Europe/Belgrade] PHP Fatal error: Call to a member function getLocalizedName() on null in C:\inetpub\wwwroot\cache\t_compile%%95^95F^95FFC06A%%submissionsInReview.tpl.php on line 60
[05-Oct-2017 08:01:30 Europe/Belgrade] PHP Fatal error: Call to a member function getLocalizedName() on null in C:\inetpub\wwwroot\cache\t_compile%%2D^2DF^2DF52775%%submissionsUnassigned.tpl.php on line 40
[05-Oct-2017 08:19:58 Europe/Belgrade] PHP Fatal error: Call to a member function getLocalizedName() on null in C:\inetpub\wwwroot\cache\t_compile%%95^95F^95FFC06A%%submissionsInReview.tpl.php on line 60
SELECT sts.setting_value FROM papers p
LEFT JOIN paper_settings sts ON (p.paper_id = sts.paper_id AND sts.setting_name = 'sessionType')
LEFT JOIN controlled_vocabs cv ON (cv.symbolic = 'paperType')
LEFT JOIN controlled_vocab_entries cve ON (cve.controlled_vocab_id=cv.controlled_vocab_id AND sts.setting_value=cve.controlled_vocab_entry_id)
WHERE sts.setting_value IS NOT NULL AND cve.controlled_vocab_entry_id IS NULL;
If I’ve written that query right, it should give you a list of all papers that refer to paper types that have been deleted. You can either remove the paper_settings entries it lists to un-set the paper type, or re-create the paper types and update the IDs as necessary.
Regards,
Alec Smecher
Public Knowledge Project Team
