Importing Joomla users with CB Juice and Community Builder and handline an error with CB Juice2 v2-0-4
This article was written November 10, 2011

The Problem:
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 ' FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)' at line 1 SQL=SELECT u.id,, FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)

I had already set up all of my extra fields in Joomla 1.7 then found I could not export a demo csv due to the error above. I had never had this problem with J1.5 and thought I would see if CB Juice would work on an demo install of Joomla 1.5 I wasn't using.

The Hack:
There area very confusing version numbers when discussing CB Juice and Joomla and I will attempt to make this as clear as possible.
CB Juice v1.7 installs on Joomla 1.5
CB Juice v2 installs on Joomla 1.7
If you have the wrong versions installed you will get errors and this fix won't work until you set the versions straight.

I exported my comprofiler tables from the 1.7 database in phpmyadmin, changed the prefix to jos_ using Notepad++. I then imported those tables to my J1.5 database. Then I installed CB and CBJuice into J1.5 and was able to export a demo csv file. I add all of my users data into that demo and am now able to import that into my 1.7 site with CB Juice.

The next issue is if the user didn't have an email address, CBJuice would normally make one up for you, but this did not work in the CBJ2 version and I had to create several dummy and unique emails. I have also recently used this for another site and even though I did not check the box that said to notify the users, it still sent out emails with the user name and ****** as the password. I had 200 confused people on my hands. This time, to prevent having 532 confused people, I changed the @ to 111@111. This way if emails were sent they would go to non-existant accounts. I then used dbreplacer from NoNumber.nl to do a find and replace in the user email table and replaced 111@111 with simply @.

You could tweak this hack to import users in general and then uninstall CB.

This is a very ugly work-around and if someone knows a better way to import to Community Builder, please post.

This is one of two Akeeba extensions I install on every site. There are many combinations and levels of security you can implement with Admin Tools. It is a fairly user friendly extension, but I do recommend reading the documentation to get the most out of it. If you don't know what you are doing, you can lock yourself out of the site. Not a fault of the extension, but of proceeding without reading. Thank you for all the hard work, Akeeba!

One of my favorite WSYWIG editors is JCE. The first thing I do with a new Joomla installation is load in this editor.

I love the way you can upload images with JCE. I also like the DocMan plug-in for JCE. Linking to articles is also very easy because you get dropdown boxes to select either the specific article or the existing link to the destination.

Getting a new website found is increasingly difficult. Competition is fierce. It's a lot like playing pool in that it's more about finesse than brute force.

I don't offer search engine optimization (SEO) as a paid service. It's important for me to be really good at one thing and Joomla is it. HOWEVER! I am pretty good at SEO. My own site comes up #3 out of 11.5 million results if you Google "joomla web design". I will tell you this was no easy task and it took a long time. If you are willing and dedicate the time, effort and a little money, I'll tell you everything I know about how to get your site up in the search results.

A reliable web host is as elusive as the Loch Ness monster. In the six years Montano Designs has been creating web site and had a web site of our own, we've been through 10 COUNT 'EM 10! web hosts. We started out with Go Daddy back when you got one of the owner's sons on the phone if you called tech support. Like so many business that grow too fast, their support suffered and we moved on.

We've tried most of the major web hosts and some little guys. Here's the problem: The big guys offer loads of data storage and bandwidth for a low, low price in a shared environment. They fill up their servers with some legitimate customers and a few rogues. These rogues do nasty things on their sites like spamming, flooding, and all sorts of things that bog down the server. All of the sudden your site gets slow and you don't know why.

I recently found 18 websites who's owners had blatantly plagiarized my site. Most were word-for-word, a few loose derivatives, 3 even copied my “About Us” information for theirs. That boggles the mind. How can you not know enough about yourself that you have to  copy someone else's information?

Last night I got one of those feelings to do something I don't normally do. There's a little voice in the back of your head that says “you should check this out.”  My little voice was saying that I should check to see if anyone has been infringing on my copyrighted text and sure enough I found scads!!!

This article will explain what you can do if this happens to you.