Forum OpenACS Development: Re: Error upgrading OpenACS 5.7 to OpenACS 5.9

Collapse
Posted by Frank Bergmann on
acs-admin apparently has an issue in apm-admin-init. It seems the table generation lacks semicolons, at least they hit the DB literally without them...

::xo::db::require table apm_package_downloads {
time timestamp
ip text
user_id integer
channel text
package text
version text
url text
}

Here is the error:

[04/Dec/2015:15:24:55][29352.1353279232][-main-] Notice: Querying 'create table apm_package_downloads (
time timestamp
ip text
user_id integer
channel text
package text
version text
url text
);'
[04/Dec/2015:15:24:55][29352.1353279232][-main-] Error: Ns_PgExec: result status: 7 message: ERROR: syntax error at or near "ip"
LINE 3: ip text
^