Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 CMS Related: User Group Problem

Author  Topic 

Zobot
Starting Member

2 Posts

Posted - 2011-05-26 : 16:20:23
I'm not sure how specific this problem is to the Joomla! CMS, but these seem like the most sensible forums for me to submit my query.

I am a relatively new webmaster (for two years...but I'm self-taught, so I don't know much about coding). Joomla! recently re-vamped their product, from v1.5 to v1.6---which are nearly two entirely different programs. Upgrading the older version forced me into a lot of nasty programming corners, and got me into situations where my site went down for weeks at a time. Bad.

Anyway, the new site is fine, and running well. However, I still have one problem: for some reason, whenever I insert my old jom_user tables (in mySQL), their affiliated groups get lost. In other words, each of my registered users should be showing up under the registered category, in my Joomla admin. back-end. Instead, they're blank. I have to manually assign each one (and there are over 800) to his/her proper group.

I'm wondering if there is a way to use the SQL commands to batch apply the proper user group to each user? Or is there something else I must do?

Thanks for your help!

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-05-26 : 16:30:59
This site is sql server not mysql - not that that matters.
You need someone who know the data structures - is there a joomla forum? I've never heard of it.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Zobot
Starting Member

2 Posts

Posted - 2011-05-27 : 23:55:40
Kay, thanks. I'll find the proper place to submit my query.

Go to Top of Page
   

- Advertisement -