Leads from social media in suitecrm like Facebook and twitter

Hello Experts
I want your help i want to collect leads from social media like Facebook and twitter using suitecrm. How i will achieve this help me please.
Basically i want to integrate Facebook and twitter in suitecrm how to do it anyone ?

Hi @namitkakusuitecrm,

What have you got so far?

Thank you for reply sir i got the solution for this problem.

Hello Mr.Rae i still didn’t find the solution that why suitecrm not worked on my localhost.
Every time it shows Database failure error. Please refer to suitecrmlog details. What i am doing wrong. What i am doing wrong please tell me.I am fed up with this system sir .
See this:

Logs would be a great start

Hello Mr Rae ok i will check that . Can you please help me out in other scenario.
I want to create one logic hook in Tasks because i want to copy one field value to accounts. How do i do that for similar module it is easy but for another module how will i do that ?
This is my LogicHook Code:

if(!defined('sugarEntry') || !sugarEntry)
	die('Not a valid Entry Point');
class Demo{
	function namit($bean , $event,  $arguments)
      echo "Working";
      $bean = BeanFactory::newBean('Tasks');
      $bean->order_type_c = $bean->name;


but what i want is to copy value from one module into another module

Can we please resolve the first issue before we change to the next, it would be much appreciated :+1:

Ok sir but i don’t understand what is happening in log file. Let me send you the code

Tue Dec 24 09:52:55 2019 [5316][1][FATAL] Mysqli_query failed.
Tue Dec 24 09:52:55 2019 [5316][1][FATAL] Retrieving record by id opportunities:3ce91934-e41b-28bd-d409-5e01a6718903 found Query Failed: SELECT opportunities.,opportunities_cstm. FROM opportunities LEFT JOIN opportunities_cstm ON opportunities.id = opportunities_cstm.id_c WHERE opportunities.id = ‘3ce91934-e41b-28bd-d409-5e01a6718903’ AND opportunities.deleted=0 LIMIT 0,1: MySQL error 1932: Table ‘suitecrm.opportunities_cstm’ doesn’t exist in engine
Tue Dec 24 09:52:55 2019 [5316][1][FATAL] Exception handling in D:\xampp\htdocs\suitecrm\include\MVC\Controller\SugarController.php:400
Tue Dec 24 09:52:55 2019 [5316][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tue Dec 24 09:52:55 2019 [5316][1][FATAL] backtrace:
#0 D:\xampp\htdocs\suitecrm\include\database\DBManager.php(353): sugar_die(‘Database failur…’)
#1 D:\xampp\htdocs\suitecrm\include\database\DBManager.php(328): DBManager->registerError(‘Retrieving reco…’, ‘Retrieving reco…’, true)
#2 D:\xampp\htdocs\suitecrm\include\database\MysqliManager.php(179): DBManager->checkError(‘Retrieving reco…’, true)
#3 D:\xampp\htdocs\suitecrm\include\database\MysqlManager.php(285): MysqliManager->query(‘SELECT opportun…’, true, ‘Retrieving reco…’)
#4 D:\xampp\htdocs\suitecrm\data\SugarBean.php(4528): MysqlManager->limitQuery(‘SELECT opportun…’, 0, 1, true, ‘Retrieving reco…’)
#5 D:\xampp\htdocs\suitecrm\data\BeanFactory.php(104): SugarBean->retrieve(‘3ce91934-e41b-2…’, true, true)
#6 D:\xampp\htdocs\suitecrm\data\Link2.php(474): BeanFactory::getBean(‘Opportunities’, ‘3ce91934-e41b-2…’)
#7 D:\xampp\htdocs\suitecrm\data\Relationships\SugarRelationship.php(156): Link2->getBeans()
#8 D:\xampp\htdocs\suitecrm\data\Link2.php(629): SugarRelationship->removeAll(Object(Link2))
#9 D:\xampp\htdocs\suitecrm\data\SugarBean.php(5411): Link2->delete(‘78f26bb2-a8d1-a…’)
#10 D:\xampp\htdocs\suitecrm\data\SugarBean.php(5391): SugarBean->delete_linked(‘78f26bb2-a8d1-a…’)
#11 D:\xampp\htdocs\suitecrm\data\SugarBean.php(5217): SugarBean->mark_relationships_deleted(‘78f26bb2-a8d1-a…’)
#12 D:\xampp\htdocs\suitecrm\include\MassUpdate.php(286): SugarBean->mark_deleted(‘78f26bb2-a8d1-a…’)
#13 D:\xampp\htdocs\suitecrm\include\MVC\Controller\SugarController.php(781): MassUpdate->handleMassUpdate()
#14 D:\xampp\htdocs\suitecrm\include\MVC\Controller\SugarController.php(525): SugarController->action_massupdate()
#15 D:\xampp\htdocs\suitecrm\include\MVC\Controller\SugarController.php(494): SugarController->do_action()
#16 D:\xampp\htdocs\suitecrm\include\MVC\Controller\SugarController.php(468): SugarController->handle_action()
#17 D:\xampp\htdocs\suitecrm\include\MVC\Controller\SugarController.php(373): SugarController->process()
#18 D:\xampp\htdocs\suitecrm\include\MVC\SugarApplication.php(113): SugarController->execute()
#19 D:\xampp\htdocs\suitecrm\index.php(52): SugarApplication->execute()
#20 {main}

Hi @namitkakusuitecrm,

Could you please try running a Quick Repair and Rebuild from the administration repair menu and ensure you scroll to the bottom and execute any SQL that appears by pressing the “Execute” button

Yes sir as you have said there was something missing so i execute all by click Execute button.
Please have a look at this video :slight_smile:https://www.loom.com/share/a18b266cc78b4abe87160dadc295fa79

Did that fix the issue?

No sir, Again when i repair and rebuild it shows some errors below and those errors are not fixing using repair.

Could you try executing that code from a MySQL interface like phpmyadmin or the equivalent that comes with your hosting and let us know the error

Yes i execute one command there was one column miss from table but again column is not added.
it gives error in phpmyadmin
" Table ‘suitecrm.opportunities_cstm’ doesn’t exist in engine".

Could you manually check for that table? Just to be sure its not there and we’ll look at sorting this

Sir table (opportunities_cstm) is there but when i click on that table then it gives below error.
Table ‘suitecrm.opportunities_cstm’ doesn’t exist in engine

Cool, thanks for checking. I’m away from my desk ATM but when I’m back I’ll take a look. I imaging the db schema is not synced correctly

Ok sir please ping me whenever you are free. This is very serious issue for me . Thanks for the help
Merry Christmas in advance.

Hello sir again my whole system get crashed only i can login and it shows only blank header. that’s it. What is this database issue and how to solve it sir . Please help me when you are free

Hello Namit,
For LinkedIn to SuiteCRM Lead. This free Google chrome extension may help you, They have almost 900+ active users.

“They”? Come on peeps, we know it’s your plug-in don’t give the impression that you are providing an unbiased recommendation. Clearly state that you are the provider for plug-ins in your suggestion.

Also, I will give you a first offence, undocumented warning that you are posting an advertisement without reasonable merit. The OP did ask specifically for Twitter/Facebook and not LinkedIn. Refer to the SuiteCRM code of conduct (especially about the spam section) and please keep posts on topic and neutral as possible going forward.