Latest Updates

Latest Updates RSS

shiny 8:02 AM on August 4, 2009 | reply | # |

SELECT ... FROM (settings left join entries on settings.entry_id = entries.id) WHERE settings.name = 'background_image' AND settings.profile_id = '' ORDER BY settings.id DESC LIMIT 5000 OFFSET 0
shiny 8:01 AM on August 4, 2009 | reply | # |

i'm stuck - ERROR: invalid input syntax for integer: ""
brian 7:43 AM on August 4, 2009 | reply | # |

OMB is on Gitorious too http://gitorious.org/openmicroblogger/mainline/trees/master
brian 6:15 AM on August 4, 2009 | reply | # |

@shiny if you follow the recent changes to mysql.php -- I need to catch up postgresql.php with those
brian 6:13 AM on August 4, 2009 | reply | # |

@shiny cool, thanks a lot!
shiny 6:05 AM on August 4, 2009 | reply | # |

got it working - will send git merge request on github soon
shiny 6:00 AM on August 4, 2009 | reply | # |

is prefix optional? It's trying to create tables that have names beginning with . (which makes postgres angry)
brian 4:57 AM on August 4, 2009 | reply | # |

@shiny instead of using the web install and config.php, just go straight to /app/config/config.yml -- change "mysql" to "postgresql". then browse to /
brian 4:50 AM on August 4, 2009 | reply | # |

@shiny I haven't run it on PostgreSQL in a long time, but I might try it out tonight since you're interested
shiny 4:08 AM on August 4, 2009 | reply | # |

does this really work in postgres? How do i tell config.php to connect the postgres not mysql?