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.
Variety of errors
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.
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.
8 posts
• Page 1 of 1
BTW
by 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
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
by 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/
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: 5765
- Joined: Wed Aug 10, 2005 12:56 pm
by DavidRad » Thu Apr 26, 2007 12:19 pm
Here is the output when I go to the submission link:
here's what I get when I start "Step one of the submission process
submission" process:
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
- 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
by 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/
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: 5765
- Joined: Wed Aug 10, 2005 12:56 pm
Gotcha
by 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
by 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:
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/
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
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: 5765
- Joined: Wed Aug 10, 2005 12:56 pm
8 posts
• Page 1 of 1
Return to OCS Technical Support
Who is online
Users browsing this forum: No registered users and 1 guest