Book not publishing in Legacy Publishing Issue #99

archive_db_commands.sql

SELECT * FROM modules WHERE uuid='b82c2559-d091-42f5-9413-6123b31a1765';

error.pytb

2015-03-26 15:12:43,600 DEBUG [cnxpublishing][Dummy-3] debug_authorization of url http://localhost:6543/publications/524 (view name u'' against context <cnxpublishing.RootFactory object at 0x7fb03ca79710>): ACLAllowed permission 'view' via ACE ('Allow', 'system.Everyone', 'view') in ACL (('Allow', 'system.Everyone', 'view'), ('Allow', 'system.Authenticated', 'publish'), ('Allow', 'g:trusted-publishers', ('publish.assign-acceptance', 'publish.remove-acceptance', 'publish.assign-acl', 'publish.remove-acl', 'publish.create-identifier', 'publish.remove-identifier')), ('Allow', 'g:publishers', ('publish.assign-acceptance', 'publish.remove-acceptance', 'publish.assign-acl', 'publish.remove-acl')), ('Allow', 'g:reviewers', ('preview',)), ('Allow', 'g:moderators', ('preview', 'moderate')), ('Allow', 'g:administrators', ('preview', 'moderate')), ('Deny', 'system.Everyone', <pyramid.security.AllPermissionsList object at 0x7fb044745290>)) on context <cnxpublishing.RootFactory object at 0x7fb03ca79710> for principals ['system.Everyone']
2015-03-26 15:12:43,607 ERROR [waitress][Dummy-3] Exception when serving /publications/524
Traceback (most recent call last):
  File "/opt/dev/local/lib/python2.7/site-packages/waitress-0.8.9-py2.7.egg/waitress/channel.py", line 337, in service
    task.service()
  File "/opt/dev/local/lib/python2.7/site-packages/waitress-0.8.9-py2.7.egg/waitress/task.py", line 173, in service
    self.execute()
  File "/opt/dev/local/lib/python2.7/site-packages/waitress-0.8.9-py2.7.egg/waitress/task.py", line 392, in execute
    app_iter = self.channel.server.application(env, start_response)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/router.py", line 242, in __call__
    response = self.invoke_subrequest(request, use_tweens=True)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/router.py", line 217, in invoke_subrequest
    response = handle_request(request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/tweens.py", line 21, in excview_tween
    response = handler(request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/router.py", line 163, in handle_request
    response = view_callable(context, request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/config/views.py", line 329, in attr_view
    return view(context, request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/config/views.py", line 305, in predicate_wrapper
    return view(context, request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/config/views.py", line 287, in _authdebug_view
    return view(context, request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/config/views.py", line 245, in _secured_view
    return view(context, request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/config/views.py", line 355, in rendered_view
    result = view(context, request)
  File "/opt/dev/local/lib/python2.7/site-packages/pyramid-1.5.1-py2.7.egg/pyramid/config/views.py", line 501, in _requestonly_view
    response = view(request)
  File "/opt/dev/cnx-publishing/cnxpublishing/views.py", line 84, in get_publication
    state, messages = check_publication_state(publication_id)
  File "/opt/dev/cnx-publishing/cnxpublishing/db.py", line 896, in check_publication_state
    publication_state, publication_messages = cursor.fetchone()
TypeError: 'NoneType' object is not iterable

notes.md

https://github.com/Connexions/cnx-publishing/issues/99

Places to start looking:

https://github.com/Connexions/cnx-publishing/commit/6ed8ff6c83dd880caec6dc3632ef386aa1cefb05

https://github.com/Connexions/cnx-archive/commit/010c4040bc1e3fa32c35baa6f38111f7197bfc67

I managed to get the page to render by creating a new account in legacy. But I need to test it again because the two profiles seem inconsistent. E.g. "rich_hart" and "richhart".

Questions:

Does creating an account without facebook mean that the account will be transfered over to legacy?