Hi guys,

I'm making my site using Postgre because my University's server only allow this type of DB. I'd like to use this module to show some photos of the main user. I've tried to create manually the table and columns in postgre, trying to match with the information for mysql in the flickr.install.

I haven't receive errors, but the pictures in mysite.com/flickr aren't showing up.
I don't understand about programming, DBs and I was wondering if someone can give me a hand on this.

Thanks ;)

CommentFileSizeAuthor
#3 flickr_5.x-1.x_pg_3.patch671 bytesHorsePunchKid

Comments

andrewlevine’s picture

andrewlevine commented

Can you post the CREATE TABLE queries that you used? We'll need more info to debug. Not sure what queries are MySQL specific if any.

artfikan’s picture

artfikan commented

Sure, this is what I get when I export the table:

--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN1';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'adm_cac';

SET search_path = public, pg_catalog;

--
-- TOC entry 3 (OID 2317770)
-- Name: flickr_users; Type: TABLE; Schema: public; Owner: adm_cac
--

CREATE TABLE flickr_users (
identifier character varying(64) NOT NULL,
nsid character varying(64) NOT NULL,
uid integer DEFAULT 0 NOT NULL
);

--
-- Data for TOC entry 5 (OID 2317770)
-- Name: flickr_users; Type: TABLE DATA; Schema: public; Owner: adm_cac
--

COPY flickr_users (identifier, nsid, uid) FROM stdin;
1
\.

--
-- TOC entry 4 (OID 2318461)
-- Name: PRIMARY; Type: INDEX; Schema: public; Owner: adm_cac
--

CREATE INDEX "PRIMARY" ON flickr_users USING btree (uid);

----------------

I hope that can help.

HorsePunchKid’s picture

HorsePunchKid commented
Status: Active » Needs review
StatusFileSize
new flickr_5.x-1.x_pg_3.patch671 bytes

Here's a patch I just whipped up. Works for me!

HorsePunchKid’s picture

HorsePunchKid commented
Status: Needs review » Reviewed & tested by the community

Still working fine + pretty trivial patch = RTBC?

drewish’s picture

drewish commented
Status: Reviewed & tested by the community » Fixed

committed to DRUPAL-5.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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