Difference between revisions of "Talk:PKP Frequently Asked Questions"

From PKP Wiki
Jump to: navigation, search
m (Reverted edits by 81.98.23.137 (talk) to last revision by 149.169.164.122)
Line 2: Line 2:
  
 
A very large list of users and email addresses are displayed including the ones we had tried to delete using the “Remove” function. What would be the best way to get rid of these invalid email addresses so they no longer appear on the “Enroll Existing User” lists?
 
A very large list of users and email addresses are displayed including the ones we had tried to delete using the “Remove” function. What would be the best way to get rid of these invalid email addresses so they no longer appear on the “Enroll Existing User” lists?
 
 
________________
 
 
Your PHP bulletin board seems to have blacklisted the whole of Virgin Media so aI cannot login - you have failed to respond to a request for an alternative e-mail address so I have to post the query here
 
 
The system has installed but I cannot login because of a duplicate key issue (both ocs and ojs - the error for ocs is here:-
 
 
"mysql): SELECT * FROM sessions WHERE session_id = 'hjdsshde79g29soelaqsnficj6fkb4gdpgdh9271gkjoktqm7od1'  (mysql): INSERT INTO sessions (session_id, ip_address, user_agent, created, last_used, remember, data) VALUES ('hjdsshde79g29soelaqsnficj6fkb4gdpgdh9271gkjoktqm7od1', '::1', 'Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1', 1327281735, 1327281735, 0, '')  1062: Duplicate entry 'hjdsshde79g29soelaqsnficj6fkb4gdpgdh9271' for key 'sessions_pkey'
 
 
                        ADOConnection._Execute(INSERT INTO sessions
 
(session_id, ip_address, user_agent, created, last_used, remember, data)
 
VALUES
 
('hjdsshde79g29...) % line  845, file: adodb.inc.php
 
                    ADOConnection.Execute(INSERT INTO sessions
 
(session_id, ip_address, user_agent, created, last_used, remember, data)
 
VALUES
 
(?, ?, ?, ?, ?,..., Array[7]) % line  200, file: DAO.inc.php
 
                  DAO.update(INSERT INTO sessions
 
(session_id, ip_address, user_agent, created, last_used, remember, data)
 
VALUES
 
(?, ?, ?, ?, ?,..., Array[7]) % line  74, file: SessionDAO.inc.php
 
              SessionDAO.insertSession(Object:Session) % line  82, file: SessionManager.inc.php
 
            SessionManager.SessionManager(Object:SessionDAO, Object:Request) % line  114, file: SessionManager.inc.php
 
 
DB Error: Duplicate entry 'hjdsshde79g29soelaqsnficj6fkb4gdpgdh9271' for key 'sessions_pkey'
 
(mysql): UPDATE sessions SET user_id = NULL, ip_address = '::1', user_agent = 'Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1', created = 1327281735, last_used = 1327281735, remember = 0, data = '' WHERE session_id = 'hjdsshde79g29soelaqsnficj6fkb4gdpgdh9271gkjoktqm7od1'  "
 
 
Can I please get advice on the problem?
 

Revision as of 19:33, 22 January 2012

We initially used the “Remove” button to try to delete invalid emails from the OJS system but have since realized that these names remain in the system. While they do not appear in the “All Users” lists, these email addresses continue to appear when a Journal Manager clicks on the various function links under the “Roles” section (at the bottom of the first screen displayed after a Journal Manager logs into the software), clicks on each of the functional roles associated with the Journal, and then clicks on “Enroll Existing User.”

A very large list of users and email addresses are displayed including the ones we had tried to delete using the “Remove” function. What would be the best way to get rid of these invalid email addresses so they no longer appear on the “Enroll Existing User” lists?