Advertisement:

Author Topic: From Agora Forum to SMF  (Read 39991 times)

WillemC

  • Guest
From Agora Forum to SMF
« on: April 22, 2009, 01:06:10 PM »
Hi all,

I got a question which I haven't seen on this forum yet.
I have a Joomla 1.5.9 website, with the Agora Forum.
I'm totally not satisfied with the Agora Forum because of the bugs in it.

Now I was wondering, is it possible for me to install this forum in my ftp and transfer the users (they are in my Joomla section) to this forum (perhaps even also the topics, but I guess that ain't going to work)

If I install this forum in my FTP, will it give problems with my Agora forum, or can I install it and start making everything work and finally transfer to this forum.

Thanks in advance, and if this question is allready asked, eventhoug I couldn't find it, just give me a link to it.

Willem

Offline Jntg4

  • Jr. Member
  • **
  • Posts: 151
Re: From Agora Forum to SMF
« Reply #1 on: April 22, 2009, 04:53:44 PM »
there are no converters for this, because Agora isn't too popular.
Free Domain Name: http://www.co.cc/?id=167358

Offline fra107

  • Semi-Newbie
  • *
  • Posts: 19
Re: From Agora Forum to SMF
« Reply #2 on: April 23, 2009, 06:33:40 PM »
there are no converters for this, because Agora isn't too popular.

Are you sure about it? Agorà is the best Joomla 1.5 native forum, and it's installed on about 30.000 sites.  ;)

Offline shprota

  • Newbie
  • *
  • Posts: 5
Re: From Agora Forum to SMF
« Reply #3 on: April 25, 2009, 10:29:04 PM »
I just have modified the FireBoard converter to convert my Agora forum to SMF.
It works for Agora 2.x and 3.x as it appears. However it lacks some features like transfering avatars. I didn't need that, so no code for it.
All instructions from the Fireboard converter apply as well as the patch to allow SMF use Joomla-generated password hashes.

WillemC

  • Guest
Re: From Agora Forum to SMF
« Reply #4 on: April 29, 2009, 09:22:05 AM »
Okay, I downloaded the agora to smf file. But now?
I first need to install SMF on my server. Then add this file into the same root as my forum?

In the explenation page I read about a .sql file and convert.php.
Do I have to use the files which are shown in the link you gave me? (Fireboard converter)?
« Last Edit: April 29, 2009, 09:45:18 AM by WillemC »

WillemC

  • Guest
Re: From Agora Forum to SMF
« Reply #5 on: May 01, 2009, 05:47:49 AM »
I installed everything well, but now when I run this converter I get the following error.

Code: [Select]
open_basedir restriction in effect. File(/var/www/vhosts/.../httpdocs/SMFForum../../../configuration.php) is not within the allowed path(s): (/var/www/vhosts/.../httpdocs:/tmp) in /var/www/vhosts/../httpdocs/SMFForum/convert.php on line 544

I have searched the internet, and found out that it has to do with security. They aren't in the same folder.
But I wonder how I can solve this, while the agora forum is in /components/com_agora (it's an extension) while I installed the SMF forum in httpdocs/SMFForum.

What to do now? I really would like this to work.

ThorstenE

  • Guest
Re: From Agora Forum to SMF
« Reply #6 on: May 02, 2009, 01:16:34 AM »
have you tried your joomla directory as path for the fireboard installation? the converter tried to find the configuration.php from Joomla without luck. I believe the path to Joomla/Agora wasn't specified right.

WillemC

  • Guest
Re: From Agora Forum to SMF
« Reply #7 on: May 03, 2009, 06:34:03 AM »
I re-installed SMF and installed it in the same Database as the Agora forum.
Now I want to convert it, but I get this error:

The error MySQL gave was: SELECT command denied to user 'xxxx'@'localhost' for table 'jos_users'.

How is this possible? I have only one DB-user in that DB. So why does it give this error?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: From Agora Forum to SMF
« Reply #8 on: May 11, 2009, 07:24:35 PM »
That means that your database user does not have permissions to that table.
Give your host the that error (unmodified ofcourse), and they can help you through granting that database user access it needs.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline amorosso

  • Semi-Newbie
  • *
  • Posts: 28
Re: From Agora Forum to SMF
« Reply #9 on: December 28, 2009, 07:35:24 PM »
Works well thank you. But you need to start with smf 1.1.. version first.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: From Agora Forum to SMF
« Reply #10 on: December 28, 2009, 07:50:56 PM »
I'm not sure I understand, what do you mean by having to start with smf 1.1. version first?
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline SrMorte

  • Semi-Newbie
  • *
  • Posts: 21
Re: From Agora Forum to SMF
« Reply #11 on: May 26, 2010, 04:48:40 PM »
Hello

People anyone have been using this converter ?
I tried today, but he gave me a error on the "Agora Path"
I inserted:
/home/XXXX/public_html/components/com_agora
This is the right path ?

I am using the Agora Forum 3.0.13.

Best Regards,
Remy Joaquim


Offline SrMorte

  • Semi-Newbie
  • *
  • Posts: 21
Re: From Agora Forum to SMF
« Reply #13 on: May 27, 2010, 03:36:58 PM »
Yes i tried, but he give me this error:



PS- I have installed the SMF in the same DB of AGORA forum.


Best regards,
Remy Joaquim

Offline srbmaddie

  • Newbie
  • *
  • Posts: 1
Re: From Agora Forum to SMF
« Reply #14 on: March 13, 2011, 12:29:45 PM »
I'm getting the same error as above. How did you fix this?

Offline MotherBoard

  • Semi-Newbie
  • *
  • Posts: 24
Re: From Agora Forum to SMF
« Reply #15 on: April 01, 2011, 01:36:57 PM »
From what I understand you can transfer the forum, but are going to have a very very hard time keeping all of the user information in place. One idea I have heard includes running disaster recovery [nofollow] as a solution for recovering files that have been 'lost in translation.' I wish you the best of luck and would recommend taking every step necessary.
« Last Edit: April 11, 2011, 12:48:08 PM by MotherBoard »

Offline mjblack

  • Newbie
  • *
  • Posts: 6
Re: From Agora Forum to SMF
« Reply #16 on: May 31, 2011, 06:55:59 AM »
Im terribly sorry to cross post this...but...

Hey guys,

Ok copied the SMF database into the joomla database, changed settings so that SMF looks to that database.

All fine...all works ok..

But still getting the error:

The error MySQL gave was: SELECT command denied to user 'greenair_joomla1'@'localhost' for table 'jos_users'

when i run the converter....

Can someone please give me 30secs of time to explain the process to sort this?

Think im starting to lose my mind ::) cant think of any other way to add the user to joomla1 as its the root database.

I have used cpanel to check that joomla1 is a user of joomla1 and it is..

Thanks in advance!

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,069
Re: From Agora Forum to SMF
« Reply #17 on: May 31, 2011, 07:01:04 AM »

Offline mjblack

  • Newbie
  • *
  • Posts: 6
Re: From Agora Forum to SMF
« Reply #18 on: May 31, 2011, 07:13:03 AM »
Hi thanks for the quick reply.

Yes i have read this many times...

Problem: SELECT command denied to user
Info: The cause of this error is that SMF and Software X are in separate databases and the SMF database user does not have access to Software X's database.
Fix: If your host has cPanel you can add the SMF database user to Software X's database.  If your host does not have cPanel you can contact them with regards on how to accomplish this. As well as a last resort, what you can do is reinstall SMF in the same database as Software X.

Whats not sinking in is that, ok ..

SMF data has now been transfered into the root joomla database 'joomla1'

settings.php in in SMF have been changed to look at the root database (so SMF is no longer in its own DB)

SMF works fine so im thinking that all the addresses are correct.

but the converter is looking at 2 bits of info in the same DB so why can it not access the data?

What steps do i have to do to make sure that greenair_joomla1 user is allowed access to its own DB?

I know this all sounds very thick, but after now 2 days of going over and over, im very confused.

regards,

Mike.


Offline mjblack

  • Newbie
  • *
  • Posts: 6
Re: From Agora Forum to SMF
« Reply #19 on: May 31, 2011, 07:20:27 AM »
OK....was being very thick.....

I didnt put the full database name in :-[  :-[

ok got past that....

now we have anew error:

Unssucessful :....


Caused the error:

Duplicate entry '62' for key 1