Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community    E-Blah SQL Technical Support    General E-Blah SQL  ›  PostgreSQL
Users Browsing Forum
No Members and 1 Guests

PostgreSQL  This thread currently has 297 views. Print
1 Pages 1 Recommend Thread
vol7ron
April 14, 2008, 5:01pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 102
Gender: Male
Posts Per Day: 1.16
Reputation: 100.00%
Reputation Score: +9 / -0
Time Online: 1 days 22 minutes
Location: Washington DC
Age: 24
Is anyone interested in getting this to work with PostgreSQL?  I've modified the install files so that it sets up the tables/sequences/indexes, I feel it's on the brink of installing correctly.

There's some sort of connection issue that is a problem when running Blah.pl after install that I'm looking into tomorrow.  I'm doing this so that I can use it for work, but would it benefit anyone else?



Increase vol7ron's Rating
Logged Offline
Private Message Private message
Justin
April 15, 2008, 1:22am Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 14,924
Gender: Male
Posts Per Day: 6.90
Reputation: 93.35%
Reputation Score: +295 / -21
Time Online: 36 days 7 hours 17 minutes
Location: Tallassee, AL
Age: 21
If you fix it to work well, I'll add it to the next release.


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV

Logged Offline
Site Site Private Message Private message Reply: 1 - 3
vol7ron
April 15, 2008, 7:30am Report to Moderator Report to Moderator
E-Blah Member
Posts: 102
Gender: Male
Posts Per Day: 1.16
Reputation: 100.00%
Reputation Score: +9 / -0
Time Online: 1 days 22 minutes
Location: Washington DC
Age: 24
Definitely working on it.  I found a nice little MySQL -> PostgreSQL script from pgFoundry.org  It wasn't the best converter but handled a LOT of the work.

As I said the Tables/Sequences/Indexes were created correctly, which was half the install.  The point I'm at right now is figuring out an error on the final install page, which is blank.  There's no line number, no error code, just an error box.  Then there's a connection problem when continuing on.  I feel these are related and should be an easy fix, once found.  The problem is probably with the pg.pm file I created (copied from mysql.pm).

I hope I have the time to finish looking at this because it would be very useful at work.  We're using tWiki at the moment (a wiki built with perl for linux), which is great for documentation and procedures, but a discussion board would be nice for question & answers as well as a collaborative place for project ideas.



Increase vol7ron's Rating
Logged Offline
Private Message Private message Reply: 2 - 3
vol7ron
April 15, 2008, 4:27pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 102
Gender: Male
Posts Per Day: 1.16
Reputation: 100.00%
Reputation Score: +9 / -0
Time Online: 1 days 22 minutes
Location: Washington DC
Age: 24
I almost have it working for me. --- It installs fine and the tables populate, but now there's a problem logging in and registering users.  

The last problem was in the INSERT INTO and UPDATE query syntax.  
I was not as familiar with PostgreSQL syntax differences, especially when jumping from SAS to Access to SQL Server to Oracle to MySQL to DB2 and now back to this.  But this was good learning experience.

I'll try to figure out what's up with the log in, but if you have any suggestions on how it works, it might save me time instead of diving into the code.

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

Edit:
I might have fixed that, now the problem is that whenever I click a new page, the active user list is duplicated.  It's I click on a category I'm listed in active users twice.

Argh these problems never cease to stop and to think it'd be a quick fix because most of the code is the same.

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

Nevermind to this too... just another problem with the WHERE syntax as part of the DELETE query.  I think we're almost there.  I'll post again when there's an issue I would prefer some help to solve



Increase vol7ron's Rating

Revision History (3 edits)
vol7ron  -  April 15, 2008, 6:01pm
vol7ron  -  April 15, 2008, 5:33pm
vol7ron  -  April 15, 2008, 4:48pm
Logged Offline
Private Message Private message Reply: 3 - 3
1 Pages 1 Recommend Thread
Print