The Joomla! Forum ™

I'm not sure that's the problem. I'm also not sure if you have looked at my post closely enough. I said, the tables do get into my new Joomla database but they just come in the wrong way. When I open de component to convert from PHPnuke, the converter sais:

Mambo Site Information
Table prefix  jos_

So I guess the table prefix is set correctly, it doesn't use mos_ or am I just not looking close enough? I'm quite n00b, lol.

Im having the same issue.  It throws everything into the DB and it looks great, I just dont see anything in the admin panel.  I also just tried to  copy the syntax to add a user directly into the db and the same issue.  The odd thing is, I can log in with a user from the db even though I dont see it in admin user panel.

I am hoping someone has an answer to this..

I imported nuke platinum users to joomla 1.07

Im having trouble with this step, can someone help me? I dont understand the converting the redgate to unixtime thingy, and that site does it.

Hi,
I'm trying to migrate from NUKE 6.0 to JOOMLA 1.0.7.
With EzPhpNuke dowloaded from here.
I'm having problem with the most of part of the Nuke web Site migration.

If I try to convert authors and user I receive:

Users  Converting
Authors Getting registered group value
Registering users with Mambo
Error executing the sql 'insert into jos_users (name, username, email, password, gid, registerdate) select username, username, user_email, user_password, 18, now() from nuke_users where username!='Anonymous''
Unknown column 'username' in 'field list' SQL=insert into jos_users (name, username, email, password, gid, registerdate) select username, username, user_email, user_password, 18, now() from nuke_users where username!='Anonymous'
Configuring users
Done
Authors Getting author group value
Setting author permissions
Updating group membership
Done
Completed Conversion finished

If I try to convert sections and content section i receive:

Sections categories  Creating Mambo section for sections
Creating categories for sections
Section contents Converting sections
Error getting the value for 'select id from jos_users where usertype='superadministrator''
Error executing the sql 'insert into jos_content (title, title_alias, introtext, `fulltext`, `state`, sectionid, catid, created, created_by, created_by_alias, images, urls, attribs, version, ordering, metakey, metadesc, hits) values ('La rivista: Introduzione', 'La rivista: Introduzione', 'La rivista: Introduzione', '


This error is common even if I try to convert other part ot Nuke site
Error getting the value for 'select id from jos_users where usertype='superadministrator''

Any Idea??

I think i had a similar problem one time, the Administrator account in NUKE isnt called superadministrator its called just administrator i think, so if you edit the file to select administrator  instead of superadministrator it should work.

If not then it must be something else.

It's called Nuke Authors

_________________
Joomla needs an e-sports script. Give Joomla an E- sports package like Vwar or a native Port......http://forum.americasarmy.com/viewtopic.php?t=255450

Ok here is what I know about manipulating Data BAses for NUke~! (please forgive the typing etc I have been programming nuke (I hate it) for 72 hours now! ..yeah on just 14 hours sleep....sigh. (Website got trashed again)

Ok Get a backup of your Data base.
Get this http://www.en.wampserver.com/
Install it and go into phpmy admin and create 2 data bases. nuke and nuke1

Whatever version of phpnuke you have you want to reduce the information to JUST the forums!

Get tables

• nuke_users
• nuke_bbtopics
• Nuke_bbposts
• Nuke_bbtext

That is all you need

Now create the exact same data base using a nuke SQL drop file  and go into the tables

• nuke_users
• nuke_bbtopics
• Nuke_bbposts
• Nuke_bbtext

and empty them but don't delete them!

Now go back to your nuke tables and export using phpmyadmin but deselect all but data and insert. That way you can copy only the data from nuke (pcnuke)(phpnuke)phpbb Its all the same.

With just Data the data base will automatically assighn everything into the correct order. from there you should be able to create a data base from any version of phpnuke or any flavour of so long as it has phpBB forum tables. (I just converted phpnuke to PNC nuke..and downgraded from 7.9 to 7.6 in the process.)

Once that is done you could Purge all other tables and leave them empty.

As for links and images not showing properly in simpleboard, I think that's got more to do with how Joolma interprets the numbers and as yet no one has told it to!

In another words you will have to recreate those links within Mambo or Joolma as I get the impression both use a different way of doing it! Prehaps someone could make the script convert these (quotes) (images) (link references) into something readable!! In anycase once the quotes are visable the Simpleboard engine will gradually take over and correctly assignh them in the way they should be! (prehaps)

_________________
Joomla needs an e-sports script. Give Joomla an E- sports package like Vwar or a native Port......http://forum.americasarmy.com/viewtopic.php?t=255450

Before I forget. You only need these 4 tables in your Joolma or Mambo data base to convert with~!

All else is needless unless you have dowloads and PM you really want to save...most people wont mind loosing them....

_________________
Joomla needs an e-sports script. Give Joomla an E- sports package like Vwar or a native Port......http://forum.americasarmy.com/viewtopic.php?t=255450

i downloaded ezPHPNUKE 1.0.1 and instaled in my joomla 1.0.8 site and imported nuke_users and nuke_users to joomla database but i wright nuke_ as prefix in componnet administration and i get this:

No phpNuke data was found. Set the table prefix to the correct value and click Change.

i don't know what to do everything seems ok!

http://mamboxchange.com/projects/phpnuke2mos/

I've found that this works well. It did a perfect job transferring my users from PHP-Nuke 7.8 to Mambo 4.5.3h. I tried modifying it to work with Joomla!, but my PHP coding skills aren't that good and I could get it to work... 

You are correct. I have tried it again using an older data base and it did not work using just the 5 tables. I think it's referencing the tables as a whole rather than just a few. I would try using all the "native" nuke tables (delete add ons like somiar, shout box etc so you can upload better, quickly).

Sorry to mislead you all. I did it using just the 4 or 5 that were needed and had no issues but I found on another server it only worked using all the native nuke tables.



It should work with joolma? I have done it twice now,(not sure who to go with, Mambo or Joolma??

...Is the nuke_ tables on the very same data base? IF not they should be, Just delete the nuke_ tables when your done.


IF anyone knows, is there a way to change the name in SQL in batch? Eg I have phpnuke as pcn-"table name"

Is there a way to change all from pcn_ to nuke_ or am I stuck doing this individually?

_________________
Joomla needs an e-sports script. Give Joomla an E- sports package like Vwar or a native Port......http://forum.americasarmy.com/viewtopic.php?t=255450

ok, here is what i did:

converted nuke to phpbb, and with impex converted phpbb to vbulletin, then i'm going to make a bridge

I used a program Called SQLyog to backup just the data not the tables then restored to new freash installed database
didn't have a problem.


K4LCH

_________________
Loyd
http://k4lch.info
http://volstatehosting.com

ezPHPNuke works with Joomla 1.0.8 ?

I can install it like a component?

Hi,

I use PhpNuke7.8 and Joomla 1.0.8. I installed the component attached to this thread with no problems. It converted the Polls with success, however not the Stories and Content. I have not converted any users, as I had solved the forum thing via a bbb2nuke > phpbb > smf conversion. Any ideas why the stories and content are not converted?

This isn't working for me . i get everything converted just post's are not showing why?

change your admin in phpnuke to letsay adminn, delete the users from joomla and do it again

Hi there, I could not find the attach in this 3ar. I have same problem I get the mesage that the comp oes not find the nuke table and is asking to change the suffix but it is right.

I'm trying with a old version of exphpnuke and tryng to migrate from php-nuke 7.6 to mambo 4.5.3

thanks for your help

cx

Am I understanding correctly?

This process will really just port over the user DB and forum posts, but most "content" (stories and articles with images) won't make the trip?

I've got a site I want to move over but it will have a stand alone forum so I'm going to invite the Nuke users and just don't want to see the articles go away.

_________________
http://www.AeronauticPictures.com/royalty-free-stock-footage/ Aerial Footage!
http://www.AutoBahnShop.com/ Vroom!

I am looking for the converter as need to convert a site from phpnuke to joomla but am not quite sure where to get the latest converter. Your help would be appreciated.

Darlene

Excuse this note I have found the file but have a problem below.

I too have this problem, users show in phpmyadmin but not on site. I have checked the database and the prefix is jos.

I did find this above (change your admin in phpnuke to letsay adminn, delete the users from joomla and do it again ) but can't figure out what is meant by change admin and where.

Your help would be appreciated.

Darlene

hey Chuck
I am sorry I miss something over here ,you  said phpnuke converter worked gerat.I am having some trouble to finding converter
do you think can you please direct me to phpnuke converter for me ,thanks.

_________________
http://www.mjturkiye.net

is there any new or updated coverter or way to convert my phpnuke site 7.6 over to joomla 1.0.12..

regards
rick

_________________
Rick Estrada
http://www.jomtube.com - Video Gallery Component
http://www.subfighter.tv - Mixed Martial Arts Social Network

i think someone sholud tell me step by step how to convert phpnuke to joomla..or write some note n seperate them as pdf..lets end the nuke era together 

need info on the subject......

need to know if the works....

is there any other way?

I might be missing something obvious, but wouldn't this be an obvious choice for a Summer of Code project?

Some lassie could create a program that allows you to connect to your old CMS (PhpNuke, Drupal, Xoops, etc) and then choose which information you would like to convert and then pull it all into joomla?

It would be an easy way to sell Joomla to potential users by making it easier for them to convert.

Hi,
I know this problem, I got it one time when I tried to made a multisite with joomla.... In fact the problem is that the users  exist in #__users but not int the access level table, you have to insert a record for each member in the access level table #_core_acl_aro when you will complete this task you will find the list of all users in the user manger in the back end.

_________________
La facilité ne m'amuse pas, ne ma jamais amusé j'ai toujours défié les choses!
http://sourceforall.webssolutions.biz
http://webssolutions.biz

New to website building, I went with Yahoo hosting and built a site using php-nuke(6.0). As I'ved learned more, I found upgrading is definately in order, which has led me here. So far it looks like the Mambo/Joomla community actually has some organization to it, unlike php-nuke. So...

I want to upgrade to Joomla from PHP-Nuke 6.0, and please tell me where to find a better forums!(current Splatt 3.1). The good thing is the site is brand new, and actually still in development. I haven't but maybe 2 references to upgrading Yahoo Hosting php-nuke. I'm amazed Yahoo has only 6.0. General Nuke seems to need a stable "current" latest base version. It's up to what 8.0, and people are suggesting don't use  it, use ver 7.3, or 7.6 at the latest!

So in my ignorance, I should upgrade Yahoo php-nuke 6.0 to what? And what forums?

hello dear.. just open php file for component and change every superadministrator to super administrator
and save it and every thing will be ok..
see u

_________________
http://emi.marsteam.net
http://www.marsteam.net

I don't see the answer for this question. I have the same issue. I imoprted my 300 users and PHPMyAdmin looks great but they do not display in the control panel . Unless I change the ID to one I created with the pannel. Is there another table I need to update?