Log in | Register
  1. Forum
  3. Discontinued Products
  5. JFBConnect Joomla 2.5 Support (CLOSED)
  7. Error on migrating jos_jfbconnect_user_map DB Tables.

Topic-icon Error on migrating jos_jfbconnect_user_map DB Tables.

Active Subscriptions:

None
12 years 11 months ago #33777 by fb_721883146
Hi, i'm just having a problem with migrating the jos_jfbconnect_user_map data base tables from my joomla 1.5.26 to 2.5.11 Using spupgrade! I Think i i transferred all the tables correctly apart from the user map tables. When i try to transfer them i get a large list of errors.

I am am running on jfbconnect 4.3.4 on my joomla 1.5 site so i installed the same version on the 2.5 site. Was i correct in doing that?
So here's what i have transferred successfully:
jos_jfbconnect_config
os_jfbconnect_notification
jos_jfbconnect_request
jos_fb_announcement
jos_fb_announcement
jos_fb_categories
jos_fb_config
jos_fb_config_backup
jos_fb_favorites
jos_fb_groups
jos_fb_messages
jos_fb_messages_text
jos_fb_moderation
jos_fb_ranks
jos_fb_sessions
jos_fb_smileys
jos_fb_subscriptions
jos_fb_users
jos_fb_version

And this one has the errors
jos_jfbconnect_user_map

So two questions really!
1.Have i transferred all the correct database fields?
2.Do you know why i'm getting this error? (I've have copied the error output into a text file and attached it to this message.)
user-map-error.txt

Thank you in advance for any help:) Neil
The topic has been locked.
Support Specialist
12 years 11 months ago #33778 by alzander
You were using a very old version of JFBConnect at one point which had table columns that were later removed. The installer of JFBConnect *should* have removed those, but it doesn't look like it did for some reason.

If you have access to run a SQL query on your Joomla 1.5 database, please run the following queries:
ALTER TABLE 'jos_jfbconnect_user_map' DROP 'request_perm_status_update';
ALTER TABLE 'jos_jfbconnect_user_map' DROP 'request_perm_email';
Those are the two columns that are causing the issue and they haven't been used in JFBConnect since (at least) v4.0, but I'm pretty sure earlier.

As for all the jos_fb_xyz tables, those aren't from JFBConnect. If you run into problems with any of those tables, that's not caused by JFBConnect.

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

None
12 years 11 months ago #33799 by fb_721883146
Hi alex, I have just ran that query on my joomla 1.5 data base site and i got an error back.

Error
MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''jos_jfbconnect_user_map' DROP 'request_perm_status_update'' at line 1

I did manage to get the db fields to load in the end, I dropped the table in question and transferred it manually. All the fields in my user map are now there. Should everything be fine now? And should i be ok to upgrade to the latest version now all the tables are in correct?

I all so removed the fb_xxx tables. whoops:)

Thanks neil.
The topic has been locked.
Support Specialist
12 years 11 months ago #33811 by alzander
Neil,
Sorry my suggestion above didn't work as expected. If you transferred the fb_user_id and j_user_id columns from the usermap table manually, and then just didn't use your migrator tool to do it, things should be fine.

As for the fb_xxx tables... I don't know what those were for, so I don't know what you lose by removing them. Hope everything works well though.

If you need anything else, just let me know.

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

None
12 years 11 months ago #33823 by fb_721883146
Thanks for that Alex. Yes but i transferred the whole jos_jfbconnect_user_map table and everything within it. Well it worked anyway. Few!!

Mmm not sure what the fb_xxx tables are for now!
I just know i installed a lot of extensions 1.5 site and just wanted my new site with just the extensions i need.


Thanks again Alex! I'll keep you posted and let you know how i get on.

Neil :)
The topic has been locked.
Support Specialist
12 years 11 months ago #33829 by alzander
Neil,
Keeping those columns shouldn't be a problem with JFBConnect. We simply don't use them anymore and they should have been dropped when you upgraded at some point. They're just a little bit of extra data in your database that's unused.

Best of luck with the upgrade, and let us know if you need anything else.

Thanks,
Alex
The topic has been locked.
  1. Forum
  3. Discontinued Products
  5. JFBConnect Joomla 2.5 Support (CLOSED)
  7. Error on migrating jos_jfbconnect_user_map DB Tables.
From the Blog
Facebook | Twitter | LinkedIn | Blog RSS