OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



edit conference track

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.

edit conference track

Postby Dragone » Mon Oct 13, 2008 3:13 am

Hi to all,
I have a problem with Conference Track
I create a new track only with Title and Abbreviation and all works.
Then I edit the same track, I change nothing, I click on save, and I have this error
"DB Error: ERROR: null value in column "hide_about" violates not-null constraint"
I use OCS 2.1.0.1
Thanks in advance for your help
Daniela

This is the stack trace:
(postgres7): SELECT * FROM sessions WHERE session_id = ? [ (0=>'f7321b06fc0fe75f46ddffa016052158') ] (postgres7): SELECT * FROM users WHERE user_id = ? [ (0=>'16') ] (postgres7): SELECT * FROM user_settings WHERE user_id = ? [ (0=>'16') ]
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/conferences/lib/adodb/adodb.inc.php:377) in /var/conferences/classes/session/SessionManager.inc.php on line 57
(postgres7): UPDATE sessions SET user_id = ?, ip_address = ?, user_agent = ?, created = ?, last_used = ?, remember = ?, data = ? WHERE session_id = ? [ (0=>'16') (1=>'131.175.80.115') (2=>'Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.9.0.2) Gecko/2...') (3=>'1223885124') (4=>'1223890977') (5=>'0') (6=>'userId|s:2:"16";username|s:7:"mornati";') (7=>'f7321b06fc0fe75f46ddffa016052158') ] (postgres7): SELECT * FROM conferences WHERE path = ? [ (0=>'elpub') ] (postgres7): SELECT * FROM site (postgres7): SELECT * FROM site_settings (postgres7): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = ? AND setting_name = ? AND conference_id = ? AND sched_conf_id = ? [ (0=>'AcronPlugin') (1=>'crontab') (2=>'0') (3=>'0') ] (postgres7): UPDATE plugin_settings SET setting_value = ?, setting_type = ? WHERE plugin_name = ? AND setting_name = ? AND conference_id = ? AND sched_conf_id = ? [ (0=>'a:2:{i:0;a:3:{s:9:"className";s:20:"tasks.ReviewReminder";s:9:"f...') (1=>'object') (2=>'AcronPlugin') (3=>'crontab') (4=>'0') (5=>'0') ] (postgres7): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ? AND conference_id = ? AND sched_conf_id = ? [ (0=>'AcronPlugin') (1=>'0') (2=>'0') ] (postgres7): SELECT * FROM sched_confs WHERE path = ? and conference_id = ? [ (0=>'elpub2009') (1=>'3') ] (postgres7): SELECT COUNT(*) FROM roles WHERE conference_id = ? AND sched_conf_id = ? AND user_id = ? AND role_id = ? [ (0=>'3') (1=>'0') (2=>'16') (3=>'16') ] (postgres7): SELECT * FROM tracks WHERE track_id = ? [ (0=>'9') ] (postgres7): SELECT * FROM track_settings WHERE track_id = ? [ (0=>'9') ] (postgres7): UPDATE tracks SET seq = ?, meta_reviewed = ?, director_restricted = ?, hide_about = ? WHERE track_id = ? [ (0=>'1') (1=>'1') (2=>'0') (3=>'') (4=>'9') ]
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: null value in column "hide_about" violates not-null constraint in /var/conferences/lib/adodb/drivers/adodb-postgres7.inc.php on line 113
-1: ERROR: null value in column "hide_about" violates not-null constraint

ADOConnection._Execute(UPDATE tracks
SET
seq = ?,
meta_reviewed = ?,
director_restricted = ?,
hide_about = ?
WHERE track_id..., Array[5]) % line 860, file: adodb.inc.php
ADOConnection.Execute(UPDATE tracks
SET
seq = ?,
meta_reviewed = ?,
director_restricted = ?,
hide_about = ?
WHERE track_id..., Array[5]) % line 175, file: DAO.inc.php
DAO.update(UPDATE tracks
SET
seq = ?,
meta_reviewed = ?,
director_restricted = ?,
hide_about = ?
WHERE track_id..., Array[5]) % line 219, file: TrackDAO.inc.php
TrackDAO.updateTrack(Object:Track) % line 154, file: TrackForm.inc.php
TrackForm.execute() % line 81, file: TrackHandler.inc.php

DB Error: ERROR: null value in column "hide_about" violates not-null constraint
Stack Trace:
File: /var/conferences/classes/conference/TrackDAO.inc.php line 219
Function: DAO->update("UPDATE tracks SET seq = ?, meta_reviewed = ?, ...", Array(5))

File: /var/conferences/classes/manager/form/TrackForm.inc.php line 154
Function: TrackDAO->updateTrack(Object(Track))

File: /var/conferences/pages/manager/TrackHandler.inc.php line 81
Function: TrackForm->execute()

File: /var/conferences/pages/manager/ManagerHandler.inc.php line 311
Function: TrackHandler::updateTrack()

File: (unknown) line (unknown)
Function: ManagerHandler::updateTrack(Array(0))

File: /var/conferences/index.php line 56
Function: call_user_func(Array(2), Array(0))

File: /var/conferences/index.php line 67
Function: handleRequest()

(postgres7): UPDATE sessions SET user_id = ?, ip_address = ?, user_agent = ?, created = ?, last_used = ?, remember = ?, data = ? WHERE session_id = ? [ (0=>'16') (1=>'131.175.80.115') (2=>'Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.9.0.2) Gecko/2...') (3=>'1223885124') (4=>'1223890977') (5=>'0') (6=>'userId|s:2:"16";username|s:7:"mornati";') (7=>'f7321b06fc0fe75f46ddffa016052158') ]
Dragone
 
Posts: 45
Joined: Fri Apr 01, 2005 2:21 am
Location: Italy

Re: edit conference track

Postby asmecher » Tue Oct 14, 2008 4:39 pm

Hi Daniela,

It looks like PostgreSQL requires explicit casts. It's a quick fix, but may come up occasionally elsewhere in the system (and please let us know if it does). Try the patch at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=3814.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8470
Joined: Wed Aug 10, 2005 12:56 pm


Return to OCS Technical Support

Who is online

Users browsing this forum: No registered users and 4 guests