Log in | Register
  1. Forum
  3. Discontinued Products
  5. JFBConnect v8.x Support (Joomla 3 Only) (CLOSED)
  7. PostgreSql installation problems

Topic-icon PostgreSql installation problems

Active Subscriptions:

None
12 years 6 months ago #39173 by everburninglight
I tried to install Jfbconnect with PostgreSql, but got an error:

An error has occurred.

0 Database query failed (error # %s): %s SQL=SELECT value FROM joo_jfbconnect_config WHERE `setting` = 'db_version'

Does somebody have a fix? Thank you.
The topic has been locked.
Support Specialist
12 years 6 months ago #39187 by alzander
We don't have a fix right now. We're actually working on a release that should work on PostGres sites, and will try to get you a copy over the next few days as well. I'd say that about 95% of our code uses the database abstraction layer of Joomla already. Unfortunately, the installation routine is one area we need to update and are already testing that.

I hope you can be patient for a few days. There's holidays coming up, but hopefully we'll still be able to get something to you soon.

Thanks, and we definitely look forward to your feedback once we get you past the initial hiccups.
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #39203 by everburninglight
Great, waiting for your update. If you want, you can put me in touch with the developer, so, if I find some issues, I will be able to communicate quickly to get it working.
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #39307 by everburninglight
Any news with the fix?
The topic has been locked.
Support Specialist
12 years 6 months ago #39310 by alzander
Sorry for the delay. We have a build of JFBConnect that should mostly wok with Postgres databases. I say 'mostly' because we haven't tested everything, and I'm sure you'll run into some issues, somewhere. With that said, we have gone through and tested the installation, configuration, and login features. So the core portions of the extension should work.

If you run into any database errors, please post the exact error message you get here and we can help provide you with the updated code to fix the problem.

I'll be emailing you the package for Joomla 3.x right after I send this. To install, please:
* Go to the Joomla Install Manager
* Go to "Manage"
* Search for "JFBConnect"
* Click the checkbox and uninstall it
* Then, go to the installer and upload the package like it's brand new.

Thanks,
Alex
The topic has been locked.
Support Specialist
12 years 6 months ago #39311 by alzander
Oh.. this likely goes without saying, but please install on a development site first. While JFBConnect itself is ready for production environments, the Postgres functionality (as noted above) has not been fully tested.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #39312 by everburninglight
I can confirm the installation worked. I will now study how to do all the required setup.
The topic has been locked.
Support Specialist
12 years 6 months ago #39319 by alzander
That's a great start! As noted, there will be issues you run into. We already know of some, and those will be fixed over the next few minor releases.

Of course, if you run into anything, we'll gladly help you fix them up right away.

I hope that helps,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #39331 by everburninglight
I could solve the Google issue, because there was a link to the old code manager, but the tutorial should be fixed anyways.

All registration went fine. Now, the sclogin module does not work:

An error has occurred.

0 Database query failed (error # %s): %s SQL=SELECT manifest_cache FROM joo_extensions WHERE element="com_jfbconnect"

I think I need this fixed to enable login from Facebook.
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #39332 by everburninglight
I noticed that the sclogin module was installed (partially?) despite the error. But it gives errors when one clicks on the Register button, or tries to retrieve the username or password. Surely PostgreSQL does not tolerate id='' for a null value.

I also use the website in multi-language mode... so I don't know if it is just the SQL or it has an issue with the URL too.

Error: 0

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

Please try one of the following pages:

Home Page
Search this site

If difficulties persist, please contact the System Administrator of this site and report the error below..

Database query failed (error # %s): %s SQL=SELECT * FROM joo_menu WHERE id=''
The topic has been locked.
  1. Forum
  3. Discontinued Products
  5. JFBConnect v8.x Support (Joomla 3 Only) (CLOSED)
  7. PostgreSql installation problems
From the Blog
Facebook | Twitter | LinkedIn | Blog RSS