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
there are no converters for this, because Agora isn't too popular.
Quote from: Jntg4 on April 22, 2009, 04:53:44 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. ;)
I just have modified the FireBoard converter (http://www.simplemachines.org/community/index.php?topic=228775.0) 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.
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)?
I installed everything well, but now when I run this converter I get the following error.
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.
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.
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?
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.
Works well thank you. But you need to start with smf 1.1.. version first.
I'm not sure I understand, what do you mean by having to start with smf 1.1. version first?
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
http://www.simplemachines.org/community/index.php?topic=306131.msg2040017#msg2040017
Yes i tried, but he give me this error:
(http://img180.imageshack.us/img180/7655/semttuloos.jpg)
PS- I have installed the SMF in the same DB of AGORA forum.
Best regards,
Remy Joaquim
I'm getting the same error as above. How did you fix this?
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 (http://www.neverfailgroup.com/solutions/disaster-recovery.html) 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.
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!
take some time to read http://www.simplemachines.org/community/index.php?topic=146192.0
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.
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
Quote from: mjblack 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
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.
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
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:
---* {$to_prefix}messages 200
that 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:
---* {$to_prefix}messages 50
doing 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... ;)
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???
Try logging in as admin and go to admin > maintenance > routine.
There run the "fix and repair errors" and "recount all statistics".
Quote from: shprota on April 25, 2009, 10:29:04 PM
I just have modified the FireBoard converter (http://www.simplemachines.org/community/index.php?topic=228775.0) 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.
here it is.. agora (3) to SMF 1.20x.
Read the README.
Donovan