Advertisement:

Author Topic: From Agora Forum to SMF  (Read 40069 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,941
  • 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,086
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

Offline !Beevan

  • Newbie
  • *
  • Posts: 1
Re: From Agora Forum to SMF
« Reply #20 on: June 27, 2011, 05:04:33 PM »
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

If I recall correctly a friend in a related field was having a similar issue. I will send him an e-mail and see if maybe he knows anything about a fix.

Offline Tinny77

  • Newbie
  • *
  • Posts: 1
Re: From Agora Forum to SMF
« Reply #21 on: June 05, 2012, 03:11:40 AM »
Sorry to bump such an old topic, but the problem I got is related to this one...
Tried the converter but I always get duplicated Primary errors.
Tried an insert ignore but 3 messages out of four were missing.
Anyone wnows how to fix this problem?
Tried toset primary to auto increment, tried to edit it tomanother number after it has been inserted... No luck... I wanna move from Agora and I can't

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: From Agora Forum to SMF
« Reply #22 on: June 08, 2012, 05:58:49 PM »
Don't know if it works in your case, but what I notice is that from time to time reduce the number of "items" converted in one step helps.
For example if you open the agora_to_admf.sql file you can find this line:
Code: [Select]
---* {$to_prefix}messages 200that means that at each rount the converter will take 200 messages and convert all of them and the insert the result into the SMF database, try with a lower number, for example:
Code: [Select]
---* {$to_prefix}messages 50doing this will result into a slower conversion process, but at least should avoid/reduce similar issues...unless I'm completely wrong and in my case it was just a case... ;)


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline phimubok

  • Newbie
  • *
  • Posts: 1
Re: From Agora Forum to SMF
« Reply #23 on: May 27, 2013, 09:40:46 PM »
I tried the converter and after playing around until it finally started converting my SMF forum was still empty!

it brought absolutely nothing across... the paths were correct... however starting the converter came up with an error message that the database was not specified...so what i did was to write

USE 'databasename' 

into the *.sql file I also replaced the {from_prefix} and {to_prefix} within the SQL file to the correct jos_ and smf_ prefixes my tables were using ... the problem was that for some reason the script couldnt get iot out of the config file(s) ...

anyway .. both tables agora and smf are in the same database... so ... finaly i could move to the next step and it said successful and printed for some weird reason the whole *sql file
and then the good luck message...

checked the smf forum = empty .... any help???

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: From Agora Forum to SMF
« Reply #24 on: May 28, 2013, 02:52:49 PM »
Try logging in as admin and go to admin > maintenance > routine.
There run the "fix and repair errors" and "recount all statistics".


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline dbrooke

  • Newbie
  • *
  • Posts: 4
Re: From Agora Forum to SMF
« Reply #25 on: May 30, 2017, 10:18:50 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.

I have rewrote this version of the converter to work with newer versions of PHP (using MySQLi...). Ping this thread if it is needed.

Offline dbrooke

  • Newbie
  • *
  • Posts: 4
Re: From Agora Forum to SMF
« Reply #26 on: May 30, 2017, 10:52:45 PM »
here it is.. agora (3) to SMF 1.20x.

Read the README.

Donovan