I just installed Services 3.0 on my D6 website and when I try to add a new service (SOAP), I get following error:

user warning: Field 'server_settings' doesn't have a default value query: INSERT INTO services_endpoint (name, server, path, authentication, resources, debug) VALUES ('users', 'rest_server', '/users', 'a:1:{s:8:\"services\";s:8:\"services\";}', 'a:0:{}', 0) in C:\Users\***\Documents\Workspace\***\drupal\includes\common.inc on line 3538.

Any more people like me with the same error?

CommentFileSizeAuthor
#6 endpoint_defaults.patch706 bytesmarcingy

Comments

marcingy’s picture

Priority: Critical » Normal

This is not critical

marcingy’s picture

Status: Needs work » Active
hernangomez’s picture

In a new installation of Drupal 6.22 with PostgreSQL 8.3 as database and the next modules :

Administration menu (6.x-1.6)
Chaos tools (6.x-1.8)
Devel generate (6.x-1.23)
Autoload (6.x-2.1)
Input stream helper (6.x-1.0)
REST Server (6.x-2.0-beta3)
XMLRPC Server (6.x-3.0)
Chaos tools (6.x-1.8)
Services (6.x-3.0)

I have a similar problem :

warning: pg_query() [function.pg-query]: Query failed: ERROR: null value for column «server_settings» restriction violate not null in /var/www/Drupal6/includes/database.pgsql.inc on line 138.
user warning: query: INSERT INTO services_endpoint (name, server, path, authentication, resources, debug) VALUES ('xmlrpc_cp_sa', 'xmlrpc_server', 'api/XMLRPC', 'a:1:{s:8:"services";s:8:"services";}', 'a:0:{}', 0) in /var/www/Drupal6/includes/common.inc on line 3538.

¿ Can i help you with any test ?

marcingy’s picture

Priority: Normal » Major

Bump back up to major we should fix this before 3.1 comes out.

marcingy’s picture

The issue is that we don't declare an explicit default and mysql just works - this will be straight forward to fix.

marcingy’s picture

Status: Active » Needs review
StatusFileSize
new706 bytes

Set defaults for endpoint fields that are text/blob.

marcingy’s picture

Version: 6.x-3.0 » 7.x-3.x-dev
kylebrowning’s picture

Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.