Leads from social media in suitecrm like Facebook and twitter

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

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 ?

#2

Hi @namitkakusuitecrm,

What have you got so far?

#3

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

#4

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:

#5

Logs would be a great start

#6

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:

<?php
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

#7

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

#8

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}

#9

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

#10

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

#11

Did that fix the issue?

#12

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

#13

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

#14

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".

#15

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

#16

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

#17

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

#18

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

#19

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

#20

@urdhvatech
“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.