OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Variety of errors

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
What to do if you have a technical problem with OCS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved. Please note that this FAQ is OJS-centric, but most issues are applicable to both platforms.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OCS Conference Support and Discussion subforum; if you have a development question, try the OCS Development subforum.

Variety of errors

Postby DavidRad » Thu Apr 26, 2007 3:39 am

When making a submission to a conference as admin, (http://japa.mhrbooks.com/ocs2/index.php ... veSubmit/1):

DB Error: Column count doesn't match value count at row 1

When clicking "Conference Help" link, (http://japa.mhrbooks.com/ocs2/index.php ... elp/view/##schedConf.overview##):

Fatal error: Call to a member function on a non-object in /usr/home/mhr/www/ocs2/pages/help/HelpHandler.inc.php on line 61

Thanks for any direction.
DavidRad
 
Posts: 47
Joined: Sun Mar 25, 2007 4:49 pm
Location: Saugerties, NY

BTW

Postby DavidRad » Thu Apr 26, 2007 3:55 am

Through phpMyAdmin I checked tables and got this output:

Problems with indexes of table `conference_settings`
PRIMARY and INDEX keys should not both be set for column `conference_id`
Problems with indexes of table `currencies`
PRIMARY and INDEX keys should not both be set for column `currency_id`
Problems with indexes of table `plugin_settings`
PRIMARY and INDEX keys should not both be set for column `plugin_name`
Problems with indexes of table `review_stages`
PRIMARY and INDEX keys should not both be set for column `paper_id`
Problems with indexes of table `roles`
PRIMARY and INDEX keys should not both be set for column `conference_id`
Problems with indexes of table `sched_conf_settings`
PRIMARY and INDEX keys should not both be set for column `sched_conf_id`
Problems with indexes of table `track_directors`
PRIMARY and INDEX keys should not both be set for column `sched_conf_id`

How could I fix this, and could this have broke during yesterday's cvs update.

Thanks
DavidRad
 
Posts: 47
Joined: Sun Mar 25, 2007 4:49 pm
Location: Saugerties, NY

Postby asmecher » Thu Apr 26, 2007 9:44 am

Hi David,

This is probably due to database schema changes since you installed -- but could you turn on the show_stacktrace option in config.inc.php and try again? The resulting output will help me track down the problem.

Regards,
Alec Smecher
Public Knowledge Project Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 8851
Joined: Wed Aug 10, 2005 12:56 pm

Postby DavidRad » Thu Apr 26, 2007 12:19 pm

Here is the output when I go to the submission link:

Code: Select all
--------------------------------------------------------------------------------
(mysql): SET NAMES 'utf8'   
--------------------------------------------------------------------------------
1064: syntax error near 'NAMES 'utf8'' at line 1

                                          adodb_mysql._execute(SET NAMES 'utf8') % line  845, file: adodb.inc.php
                                       adodb_mysql.execute(SET NAMES ?, Array[1]) % line  602, file: adodb-mysql.inc.php
                                    adodb_mysql.setcharset(utf8) % line  153, file: DBConnection.inc.php
                                 dbconnection.connect() % line  116, file: DBConnection.inc.php
                              dbconnection.initconn() % line   74, file: DBConnection.inc.php


--------------------------------------------------------------------------------
(mysql): SELECT * FROM sessions WHERE session_id = '594561a1730289f9057e87666c941c65'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM users WHERE user_id = '1'   
--------------------------------------------------------------------------------

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /usr/home/mhr/www/ocs2/lib/adodb/adodb.inc.php:377) in /usr/home/mhr/www/ocs2/classes/session/SessionManager.inc.php on line 56

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/mhr/www/ocs2/lib/adodb/adodb.inc.php:377) in /usr/home/mhr/www/ocs2/classes/session/SessionManager.inc.php on line 193

--------------------------------------------------------------------------------
(mysql): UPDATE sessions SET user_id = '1', ip_address = '24.161.80.157', user_agent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; SU 2.011; .NET CLR 1.1.4322)', created = '1176899102', last_used = 1177607417, remember = 1, data = 'username|s:5:\"admin\";userId|s:1:\"1\";' WHERE session_id = '594561a1730289f9057e87666c941c65'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM conferences WHERE path = 'apsaadenver'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM site   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND setting_name = 'crontab' AND conference_id = 0   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): UPDATE plugin_settings SET setting_value = 'a:2:{i:0;a:3:{s:9:\"className\";s:20:\"tasks.ReviewReminder\";s:9:\"frequency\";a:1:{s:4:\"hour\";s:1:\"0\";}s:4:\"args\";a:0:{}}i:1;a:3:{s:9:\"className\";s:32:\"tasks.RegistrationExpiryReminder\";s:9:\"frequency\";a:1:{s:4:\"hour\";s:1:\"0\";}s:4:\"args\";a:0:{}}}', setting_type = 'object' WHERE plugin_name = 'AcronPlugin' AND setting_name = 'crontab' AND conference_id = 0   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND conference_id = '0'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND conference_id = '0'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND conference_id = '0'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'tasks.ReviewReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM scheduled_tasks WHERE class_name = 'tasks.ReviewReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): UPDATE scheduled_tasks SET last_run = '1969-12-31 18:59:59' WHERE class_name = 'tasks.ReviewReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT r.*, r2.review_revision, a.review_file_id, u.first_name, u.last_name FROM review_assignments r LEFT JOIN users u ON (r.reviewer_id = u.user_id) LEFT JOIN review_stages r2 ON (r.paper_id = r2.paper_id AND r.stage = r2.stage) LEFT JOIN papers a ON (r.paper_id = a.paper_id) WHERE (r.cancelled IS NULL OR r.cancelled = 0) AND r.date_notified IS NOT NULL AND r.date_completed IS NULL ORDER BY r.paper_id   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'tasks.RegistrationExpiryReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM scheduled_tasks WHERE class_name = 'tasks.RegistrationExpiryReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): UPDATE scheduled_tasks SET last_run = '1969-12-31 18:59:59' WHERE class_name = 'tasks.RegistrationExpiryReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT i.* FROM sched_confs i LEFT JOIN conferences c ON (i.conference_id = c.conference_id) WHERE c.enabled = 1 ORDER BY c.seq, i.seq-1   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM conferences WHERE conference_id = '1'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM sched_confs WHERE path = 'apsaadenver' and conference_id = '1'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM roles WHERE conference_id = 1 AND sched_conf_id = 5 AND user_id = 1 AND role_id = 4096   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM sched_confs WHERE conference_id = '1' AND end_date < now()   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM sched_confs WHERE conference_id = '1' AND start_date < now() AND end_date > now()   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM sched_confs WHERE sched_conf_id = '5'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT count(*), status FROM papers p LEFT JOIN tracks s ON (s.track_id = p.track_id) WHERE p.sched_conf_id = '5' AND p.user_id = '1' GROUP BY p.status   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM roles WHERE conference_id = 1 AND sched_conf_id = 5 AND user_id = 1 AND role_id = 4096   
--------------------------------------------------------------------------------

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/mhr/www/ocs2/lib/adodb/adodb.inc.php:377) in /usr/home/mhr/www/ocs2/classes/core/Request.inc.php on line 40

--------------------------------------------------------------------------------
(mysql): UPDATE sessions SET user_id = '1', ip_address = '24.161.80.157', user_agent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; SU 2.011; .NET CLR 1.1.4322)', created = '1176899102', last_used = 1177607417, remember = 1, data = 'username|s:5:\"admin\";userId|s:1:\"1\";' WHERE session_id = '594561a1730289f9057e87666c941c65' 




here's what I get when I start "Step one of the submission process
submission" process:

Code: Select all
--------------------------------------------------------------------------------
(mysql): SET NAMES 'utf8'   
--------------------------------------------------------------------------------
1064: syntax error near 'NAMES 'utf8'' at line 1

                                          adodb_mysql._execute(SET NAMES 'utf8') % line  845, file: adodb.inc.php
                                       adodb_mysql.execute(SET NAMES ?, Array[1]) % line  602, file: adodb-mysql.inc.php
                                    adodb_mysql.setcharset(utf8) % line  153, file: DBConnection.inc.php
                                 dbconnection.connect() % line  116, file: DBConnection.inc.php
                              dbconnection.initconn() % line   74, file: DBConnection.inc.php


--------------------------------------------------------------------------------
(mysql): SELECT * FROM sessions WHERE session_id = '594561a1730289f9057e87666c941c65'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM users WHERE user_id = '1'   
--------------------------------------------------------------------------------

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /usr/home/mhr/www/ocs2/lib/adodb/adodb.inc.php:377) in /usr/home/mhr/www/ocs2/classes/session/SessionManager.inc.php on line 56

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/mhr/www/ocs2/lib/adodb/adodb.inc.php:377) in /usr/home/mhr/www/ocs2/classes/session/SessionManager.inc.php on line 193

--------------------------------------------------------------------------------
(mysql): UPDATE sessions SET user_id = '1', ip_address = '24.161.80.157', user_agent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; SU 2.011; .NET CLR 1.1.4322)', created = '1176899102', last_used = 1177607585, remember = 1, data = 'username|s:5:\"admin\";userId|s:1:\"1\";' WHERE session_id = '594561a1730289f9057e87666c941c65'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM conferences WHERE path = 'apsaadenver'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM site   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND setting_name = 'crontab' AND conference_id = 0   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): UPDATE plugin_settings SET setting_value = 'a:2:{i:0;a:3:{s:9:\"className\";s:20:\"tasks.ReviewReminder\";s:9:\"frequency\";a:1:{s:4:\"hour\";s:1:\"0\";}s:4:\"args\";a:0:{}}i:1;a:3:{s:9:\"className\";s:32:\"tasks.RegistrationExpiryReminder\";s:9:\"frequency\";a:1:{s:4:\"hour\";s:1:\"0\";}s:4:\"args\";a:0:{}}}', setting_type = 'object' WHERE plugin_name = 'AcronPlugin' AND setting_name = 'crontab' AND conference_id = 0   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND conference_id = '0'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND conference_id = '0'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'AcronPlugin' AND conference_id = '0'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'tasks.ReviewReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM scheduled_tasks WHERE class_name = 'tasks.ReviewReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): UPDATE scheduled_tasks SET last_run = '1969-12-31 18:59:59' WHERE class_name = 'tasks.ReviewReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT r.*, r2.review_revision, a.review_file_id, u.first_name, u.last_name FROM review_assignments r LEFT JOIN users u ON (r.reviewer_id = u.user_id) LEFT JOIN review_stages r2 ON (r.paper_id = r2.paper_id AND r.stage = r2.stage) LEFT JOIN papers a ON (r.paper_id = a.paper_id) WHERE (r.cancelled IS NULL OR r.cancelled = 0) AND r.date_notified IS NOT NULL AND r.date_completed IS NULL ORDER BY r.paper_id   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'tasks.RegistrationExpiryReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM scheduled_tasks WHERE class_name = 'tasks.RegistrationExpiryReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): UPDATE scheduled_tasks SET last_run = '1969-12-31 18:59:59' WHERE class_name = 'tasks.RegistrationExpiryReminder'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT i.* FROM sched_confs i LEFT JOIN conferences c ON (i.conference_id = c.conference_id) WHERE c.enabled = 1 ORDER BY c.seq, i.seq-1   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM conferences WHERE conference_id = '1'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM sched_confs WHERE path = 'apsaadenver' and conference_id = '1'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM roles WHERE conference_id = 1 AND sched_conf_id = 5 AND user_id = 1 AND role_id = 4096   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM sched_confs WHERE conference_id = '1' AND end_date < now()   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM sched_confs WHERE conference_id = '1' AND start_date < now() AND end_date > now()   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT * FROM sched_confs WHERE sched_conf_id = '5'   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT count(*), status FROM papers p LEFT JOIN tracks s ON (s.track_id = p.track_id) WHERE p.sched_conf_id = '5' AND p.user_id = '1' GROUP BY p.status   
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT COUNT(*) FROM roles WHERE conference_id = 1 AND sched_conf_id = 5 AND user_id = 1 AND role_id = 4096   
--------------------------------------------------------------------------------

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/mhr/www/ocs2/lib/adodb/adodb.inc.php:377) in /usr/home/mhr/www/ocs2/classes/core/Request.inc.php on line 40

--------------------------------------------------------------------------------
(mysql): UPDATE sessions SET user_id = '1', ip_address = '24.161.80.157', user_agent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; SU 2.011; .NET CLR 1.1.4322)', created = '1176899102', last_used = 1177607585, remember = 1, data = 'username|s:5:\"admin\";userId|s:1:\"1\";' WHERE session_id = '594561a1730289f9057e87666c941c65'   
--------------------------------------------------------------------------------


At this point I can't see any links to continue the next step of the process. I could disable the stylesheet and possibly see more. Please let me know. if you need more.

Thanks for your help!!!

David
DavidRad
 
Posts: 47
Joined: Sun Mar 25, 2007 4:49 pm
Location: Saugerties, NY

Postby asmecher » Thu Apr 26, 2007 1:18 pm

Hi David,

That looks like the output of "debug", not "show_stacktrace". What happens when you turn on "show_stacktrace", but not "debug"?

Regards,
Alec Smecher
Public Knowledge Project Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 8851
Joined: Wed Aug 10, 2005 12:56 pm

Gotcha

Postby DavidRad » Thu Apr 26, 2007 2:07 pm

Gotcha

Code: Select all
DB Error: Column count doesn't match value count at row 1
Stack Trace:
File: /usr/home/mhr/www/ocs2/classes/paper/PaperDAO.inc.php line 232
Function: paperdao->update("INSERT INTO papers (user_id, sched_conf_id, track_...", Array(30))

File: /usr/home/mhr/www/ocs2/classes/presenter/form/submit/PresenterSubmitStep1Form.inc.php line 136
Function: paperdao->insertpaper(Object(paper))

File: /usr/home/mhr/www/ocs2/pages/presenter/SubmitHandler.inc.php line 136
Function: presentersubmitstep1form->execute()

File: /usr/home/mhr/www/ocs2/pages/presenter/PresenterHandler.inc.php line 125
Function: submithandler::savesubmit(Array(1))

File: (unknown) line (unknown)
Function: presenterhandler::savesubmit(Array(1))

File: /usr/home/mhr/www/ocs2/index.php line 46
Function: call_user_func(Array(2), Array(1))

File: /usr/home/mhr/www/ocs2/index.php line 57
Function: handlerequest()
DavidRad
 
Posts: 47
Joined: Sun Mar 25, 2007 4:49 pm
Location: Saugerties, NY

Postby asmecher » Thu Apr 26, 2007 3:01 pm

Hi David,

Got it -- update CVS. You'll probably also have to update your database. Try running:
Code: Select all
php tools/dbXMLtoSQL.php -schema execute dbscripts/xml/ocs_schema.xml
Regards,
Alec Smecher
Open Journal Systems Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 8851
Joined: Wed Aug 10, 2005 12:56 pm

Postby DavidRad » Thu Apr 26, 2007 3:20 pm

Ya-whoo!! :D
DavidRad
 
Posts: 47
Joined: Sun Mar 25, 2007 4:49 pm
Location: Saugerties, NY


Return to OCS Technical Support

Who is online

Users browsing this forum: No registered users and 5 guests