getData:Unknown column shown in front-end

[victorchl]

Dear all,

I moved my local website to public host. and I found I can not open the menu in front-end. But it's worked in the background. Can anyone help? I searched in the forum but can not find solution. I also found after I unpublished the element of databasejoin of user. It's worked.

getData:Unknown column 'yng4k_users.name' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `skpub`.`id` AS `skpub___id`, `skpub`.`id` AS `skpub___id_raw`, `skpub`.`date_time` AS `skpub___date_time`, `skpub`.`date_time` AS `skpub___date_time_raw`, `skpub`.`Skpay` AS `skpub___Skpay`, `skpub`.`Skpay` AS `skpub___Skpay_raw`, `skpub`.`paydate` AS `skpub___paydate`, `skpub`.`paydate` AS `skpub___paydate_raw`, `skpub`.`authorname` AS `skpub___authorname`, ,......

 

[myfatebiz]

Follow this step to fix this error.

1. Login to administrator
2. Go to components --> fabrik --> connections
3. Click on site database
4. In details area you need put the correct user and password. Make sure Database name same as public host mysql database.

 

[victorchl]

Thank you for your answer~ Solved

 

[troester]

You can close solved threads by unchecking "open" in Thread Tools.