Jayzteroid wrote:
Hello there!

I don't use CB yet, but I have some kind of error with the User list
Warning: Invalid argument supplied for foreach() in .../components/com_fireboard/template/default/plugin/userlist/userlist.php on line 380.

I understand the code very little, therefore I decided to bring the subject up here in this forum.

Any ideas what might be wrong?

Regards,
J-J

Run your sql queries one by one again..

I got rid of the error, but the list remains empty.
I even uninstalled and installed the FB again, but with the same results.

I've installed the FB for two other sites also without any problems.
This one seems to be the toughest one.

I also checked the fb_tables one by one and they match.
The comparison was made by using working tables of another site on the other side and non-working on the other side.
I dropped extra tables and reordered the list.

No wanted results.
Almost all of my tricks are used.

I'll keep on fighting.

Cheers,
J-J

You're not alone. I've rerun the queries a few times and still get the error. I have no clue what causes it.

I noticed that Joomla gave me an error when I reinstalled (after uninstalling).
"Notice: 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_fb_attachments where filelocation like
'%...includes/database.php on line 294

I don't have much of clue what that means.

I decided to check once again the differencies between the tables of working FB and non-working FB.

I discovered that all the tables where in place, but there were some missing PRIMARY KEYs and KEYs.
I use SQL Manager Lite for MySQL to compare and edit.

After that I uninstalled the non-working FB once again and reinstalled it.
This time there was no error in the page that opens after installation, all were ok and installation was success.

But still... userlist stays empty, even after login in.
Darn... all my knowledge, tricks and ideas are used.
I'm starting to feel kind of hopeless with this issue

Whee!

Now its done.

My mistake was to forget add this line:
INSERT INTO `#__groups` VALUES ('1', 'Registered User';

Added that, voilá, half the users appeared to the user list.

Now I think its not that hard to compare the records of the users to make them all appear.

I have the same problem..so where did you add the line:

INSERT INTO `#__groups` VALUES ('1', 'Registered User';

did you simply put this line and ran it as an sql query or something? Where did you add it?

Im glad you fixed it cause no one here was helping with it..i hope you can point me to the right direction!!

I used SQL Manager Lite for MySQL program.
I connected to the database, opened the table "jos_fb_groups", then selected the Data tab, clicked + and added to the "id" value 1 and to the "title" Registered user.

I'm not sure how this should be done by usin phpmyadmin.

That did the trick..gosh i have been waiting for some help with this for so long..and you fixed it like that! Thanks a lot!

I still have some trouble when i click the next button in the userlist..but i believe that has been discussed before on this problem so gonna use the search

I don't have a table called 'jos_fb_groups'. When or how does this get created?

I found it. For some reason, the mySQL queries to add 'jos_fb_groups' was left out of the 1.0.1 to 1.0.3 upgrade file. I had to find it in the 1.0.0 to 1.0.3 file. The mySQL query to add id-1 and title-Registered Users is in that file also. I upgraded my FB from 1.0.1 to 1.0.3. IT WORKS NOW! w00t!