Home arrow Forum
myLANsite forum
Welcome, Guest
Please Login or Register.    Lost Password?
Doesn't show the participants list? (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Doesn't show the participants list?
#379
hamatzu (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Doesn't show the participants list? 2 Years, 1 Month ago Karma: 0  
Hello!
First of all I will thank you for a lovely component for joomla, this have saved me a lot of work.

Now to the problem, I have installed all components and they are working fine. Except for a little small thing, the participants list in the frontend. When you want to show this it doesn't show anything, only the result of how many participants is on the lan, next button and so on.

I have added columns in the backen and they are showing correctly, except the users then. I need help, what could be the problem?

Kind regards, Hamatzu!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#381
Remirol (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:Doesn't show the participants list? 2 Years, 1 Month ago Karma: 0  
I have the exact same problem which seems to be unrelated to the previous posts concerning not being viewable in the front or backend. I've changed all the (array) fields and it makes no difference.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#382
moensch (Admin)
Admin
Posts: 283
graph
User Online Now Click here to see the profile of this user
Re:Doesn't show the participants list? 2 Years, 1 Month ago Karma: 13  
Fixed this. There is an error in the preparation of the SQL script. If you have communitybuilder installed, I first try to join the #__comprofiler table to the user table, but then only in the next line join the user table, this creates an SQL error. To fix, edit the mls_events.php and replace the lines around 208 - 220 with this:
Code:

//Select records $query = "SELECT p.*," .$seatSql ."\n u.name AS `joomla_name`,u.username AS `joomla_username`,u.email AS `joomla_email`,u.id AS `joomla_userid`," ."\n p.subscribed_time AS `mylansite_subscribed`,p.checkin AS `mylansite_checked_in`,p.checkout AS `mylansite_checked_out`,p.paid AS `mylansite_paid`," ."\n e.name AS `eventname`" .$cbsql1 ."\n FROM `#__mls_events_participants` AS `p`" ."\n INNER JOIN `#__mls_events` AS `e` ON e.id = p.eventid" ."\n INNER JOIN `#__users` AS u ON u.id = p.userid" .$cbsql2 ."\n" . $where ."\n ORDER BY p.subscribed_time" ."\n LIMIT $pageNav->limitstart, $pageNav->limit";
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#384
Remirol (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:Doesn't show the participants list? 2 Years, 1 Month ago Karma: 0  
Thanks for the update- I made the change but the participants still do not show up on the front end. You are right that I have Community Builder Installed but the changes didn't help. Any more ideas?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#387
ETE_Ed (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:Doesn't show the participants list? 2 Years, 1 Month ago Karma: 0  
I had the same problem.. but after downgrading to 1.0 , it's now showing again..
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#388
moensch (Admin)
Admin
Posts: 283
graph
User Online Now Click here to see the profile of this user
Re:Doesn't show the participants list? 2 Years, 1 Month ago Karma: 13  
You need to create at least one field within communitybuilder, this is still a defect and has to be fixed. Unless one field has been created by you, the query will fail.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
© 2008 myLANsite - Lanparty components for Joomla
Joomla! is Free Software released under the GNU/GPL License.