Code: Select all
$query = "SELECT {$cond['distinct']} i.id, {$cond[orderkey]} AS orderkey, ...
Code: Select all
$cond['orderkey']
Code: Select all
$query = "SELECT {$cond['distinct']} i.id, {$cond[orderkey]} AS orderkey, ...
Code: Select all
$cond['orderkey']
Code: Select all
if (substr($order, 0, 3) === 'bp.') {
$cond['orderproperty'] = substr($order, 3);
$cond['orderkey'] = 'bp.value';
$order = 'bp.value';
$cond['joinparts']['properties'] = true;
} else {
$cond['orderkey'] = "''";
}
Code: Select all
if (substr($order, 0, 3) === 'bp.') {
$cond['orderproperty'] = substr($order, 3);
$cond['orderkey'] = 'bp.value';
$order = 'bp.value';
$cond['joinparts']['properties'] = true;
} else {
$cond['orderkey'] = "'1'";
}
Code: Select all
CREATE TABLE serendipity_images
(
id serial NOT NULL,
name character varying(255) NOT NULL DEFAULT ''::character varying,
extension character varying(5) NOT NULL DEFAULT ''::character varying,
mime character varying(255) NOT NULL DEFAULT ''::character varying,
size integer NOT NULL DEFAULT 0,
dimensions_width integer NOT NULL DEFAULT 0,
dimensions_height integer NOT NULL DEFAULT 0,
date integer NOT NULL DEFAULT 0,
thumbnail_name character varying(255) NOT NULL DEFAULT ''::character varying,
authorid integer DEFAULT 0,
path text,
hotlink smallint,
realname character varying(255) NOT NULL DEFAULT ''::character varying,
CONSTRAINT serendipity_images_pkey PRIMARY KEY (id)
)
Code: Select all
CREATE TABLE serendipity_authors
(
realname character varying(255) NOT NULL DEFAULT ''::character varying,
username character varying(32) DEFAULT NULL::character varying,
"password" character varying(32) DEFAULT NULL::character varying,
authorid serial NOT NULL,
mail_comments smallint DEFAULT 1::smallint,
mail_trackbacks smallint DEFAULT 1::smallint,
email character varying(128) NOT NULL DEFAULT ''::character varying,
userlevel integer NOT NULL DEFAULT 0,
right_publish smallint DEFAULT 1::smallint,
CONSTRAINT serendipity_authors_pkey PRIMARY KEY (authorid)
)
Code: Select all
CREATE TABLE serendipity_authorgroups
(
groupid integer NOT NULL DEFAULT 0,
authorid integer NOT NULL DEFAULT 0
)
Code: Select all
CREATE TABLE serendipity_access
(
groupid integer NOT NULL DEFAULT 0,
artifact_id integer NOT NULL DEFAULT 0,
artifact_type character varying(64) NOT NULL DEFAULT ''::character varying,
artifact_mode character varying(64) NOT NULL DEFAULT ''::character varying,
artifact_index character varying(64) NOT NULL DEFAULT ''::character varying
)
Wahrscheinlich nicht nur der erste Fehler. Die Version packt's wohl insgesamt nicht mehr so ganz .Der erste Fehler resultiert glaube ich aus deiner Postgresql Version,
Da hast Du natürlich recht. Aber ich müsste den gesamten Server neu aufbauen, und dazu habe ich z.Z.t gar keine Lust. Selbst das Umheben auf MySQL wäre wohl nicht der Hit, da ich noch die UraltVersion 3.23 habe. Wahrscheinlich muss ich mir mal nen Ruck geben und das alles neu machen.7.4 ist ja auch schon ein wenig in die Jahre gekommen ...