nicole_89

nicole_89 does not currently provide support for this item.

101 comments found.

Hi, I have problem with the social auth module. I have installed the module and fill in the secret and key for facebook login. When I first try to login with facebook, the user registered but the following error occured:

Notice: Error: Table ‘pinegood_pinegoods.oc_customer_authentication’ doesn’t exist Error No: 1146 SELECT customer_id FROM oc_customer_authentication WHERE provider = ‘Facebook’ AND identifier = MD5 LIMIT 1 in /home/pinegood/public_html/new/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/pinegood/public_html/new/catalog/model/module/nicosocialauth.php on line 7Notice: Error: Table ‘pinegood_pinegoods.oc_customer_authentication’ doesn’t exist Error No: 1146 INSERT INTO oc_customer_authentication SET customer_id = ‘4’, provider = ‘Facebook’, identifier = MD5 , web_site_url = ‘http://www.webagedeveloper.com\nhttp://www.javaparty.net', profile_url = ‘https://www.facebook.com/app_scoped_user_id/10153259441101749/', photo_url = ‘https://graph.facebook.com/10153259441101749/picture?width=150&height=150', display_name = ‘Westly Tanbri’, description = ’’, first_name = ‘Westly’, last_name = ‘Tanbri’, gender = ‘male’, language = ‘en_US’, age = ’’, birth_day = ‘24’, birth_month = ‘4’, birth_year = ‘1991’, email = ‘slvr_fcuk@hotmail.com’, email_verified = ‘slvr_fcuk@hotmail.com’, phone = ’’, address = ’’, country = ‘Indonesia’, region = ‘Jakarta, Indonesia’, city = ‘Jakarta’, zip = ’’, date_added = NOW in /home/pinegood/public_html/new/system/library/db/mysqli.php on line 41Warning: Cannot modify header information – headers already sent by (output started at /home/pinegood/public_html/new/index.php:105) in /home/pinegood/public_html/new/catalog/model/module/nicosocialauth.php on line 82Warning: Cannot modify header information – headers already sent by (output started at /home/pinegood/public_html/new/index.php:105) in /home/pinegood/public_html/new/catalog/controller/module/nicosocialauth.php on line 145Warning: Cannot modify header information – headers already sent by (output started at /home/pinegood/public_html/new/index.php:105) in /home/pinegood/public_html/new/system/library/response.php on line 12

Then when I try to login with facebook, the following error occured:

Notice: Error: Table ‘pinegood_pinegoods.oc_customer_authentication’ doesn’t exist Error No: 1146 SELECT customer_id FROM oc_customer_authentication WHERE provider = ‘Facebook’ AND identifier = MD5 LIMIT 1 in /home/pinegood/public_html/new/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/pinegood/public_html/new/catalog/model/module/nicosocialauth.php on line 7Warning: Cannot modify header information – headers already sent by (output started at /home/pinegood/public_html/new/index.php:105) in /home/pinegood/public_html/new/system/library/response.php on line 12

How to solve this?

Thanks

Hi

This happens because ‘oc_customer_authentication’ table does not exist in the database.

To fix this you need to redownload the theme (from downloads tab on themeforest) and update theme files (at least catalog/controller/ folder, if possible all theme files) and then rerun import tool from customize theme to create the table automatically.

You need to uncheck all options on import tab to avoid overwriting module configuration and product images).

Thanks! It solved the issue!

by
by
by
by
by
by