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.
| 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. |
 |
|
|
Zobot
Starting Member
2 Posts |
Posted - 2011-05-27 : 23:55:40
|
Kay, thanks. I'll find the proper place to submit my query. |
|
|
|
|
|
|
|
|
CMS Related: User Group Problem