CampaignChain Community Edition
License: Other
Version 2.x of CampaignChain is work in progress. Please install 1.x: https://github.com/CampaignChain/campaignchain/tree/1.0
Create GUI in Channel module to allow user to reconnect.
When posting new Linkedin update and API returns:
[status code] 401
[reason phrase] Unauthorized
[url] https://api.linkedin.com/v1/people/~/shares
... then redirect to above GUI to refresh token.
This could be handled by a plugin to the core's scheduler provided by the OAuth client bundle. It could once per day check the expiration date and then warn the user via email and in the GUI.
This link http://www.ymc.ch/en/?p=5989 contains a redirect. Even if ymc.ch is a website location CC will ignore it and won't create a CTA/bit.ly link.
If images got removed from an Activity by clicking on the X laid over an image and then the Activity is being saved, the supposedly deleted images still show up when editing the Activity afterwards.
Installation on Windows fails with message:
[Symfony\Component\Process\Exception\RuntimeException]
TTY mode is not supported on Windows platform.
Script Sp\BowerBundle\Composer\ScriptHandler::bowerInstall handling the post-install-cmd event terminated with an exception
[RuntimeException]
An error occurred when executing the ""sp:bower:install --interactive=false"" command.
See: https://github.com/symfony/Process/blob/master/Process.php#L948
It should be possible to add, remove and modify users of campaign chain.
Composer installation fails with
ECONFLICT Unable to find suitable version for moment
[Sp\BowerBundle\Bower\Exception\RuntimeException]
An error occured while installing dependencies
Here is output from Bower install:
Unable to find a suitable version for moment, please choose one:
1) moment#2.8 which resolved to 2.8.4 and is required by campaignchain-core
2) moment#>= 2.6.0 which resolved to 2.9.0 and is required by moment-timezone#0.2.5
3) moment#>=2.5.0 which resolved to 2.9.0 and is required by fullcalendar#2.3.1
4) moment#~2.9.0 which resolved to 2.9.0 and is required by bootstrap-daterangepicker#1.3.19
This code prevents existing onClick functions to be executed aftewards
// Has a link been clicked? jQuery('a').click(function(){ campaignchain.sendUrlReport(jQuery(this).attr("href")); return false; })
When trying to connect a Google Analytics property that contains several Google Analytics Views, then the error page shows up saying "Unfortunately, something went wrong" as well as a success message above it in green saying "They Google Analytics property ... was connected successfully.".
When going on the Channels overview page, what you will see is that in fact the first view of the property was connected.
If you now again connect a Google Analytics Location, all checkboxes for the various Google Analytics Views that belong to the connected property will be inactive. Hence, you cannot connect the the other Views that were not yet connected.
The users's photo and name would be displayed here:
The photo/name would only be shown if a user has actually been assigned to the respective Action or Medium.
Hello:
This is my first time on AWS and Git and Ubuntu...many new things here so it's no wonder I had a few issues installing the app. All were on my side (i think). For example I pointed to the wrog directory for Java and I placed the application in a folder a couple of levels below www.
The install signalled errors over the Java not being found...so..
1.) would this be considered a valid location for Java run time to be here: /usr/lib/jvm/java-7-openjdk-amd64/jre/bin
2.) I want to move the install location to the www directory...is there an uninstall proceedure or is deleting the files and re-installing appropriate. Although I passed the installation tests, I never went forward with the installation from the browser.
3.) During installation the following messages appeared:
Created project in campaignchain
Class SymfonyStandard\Composer is not autoloadable, can not call post-root-packa ge-install script
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Warning: The lock file is not up to date with the latest changes in composer.jso n. You may be getting outdated dependencies. Run update to update them.
I have been using the master version! Should I roll back and use the Beta version?
I appreciate any help you can offer.
Thanks, Rich
For example, only 1 image can be uploaded to a Facebook post. After 1 image has been uploaded, the upload button can still be clicked and an image can be selected for upload. After one has been selected, an error shows up that only 1 image can be uploaded.
Instead, the image upload button should become inactive once the maximum number of images has been reached.
In addition to that, a message should appear on the right side of the button saying "x of y images uploaded".
Camera implies that you would take a live photo.
I have found this stackoverflow thread on the topic:
http://stackoverflow.com/questions/11870731/protect-content-uploaded-by-a-specific-user-in-symfony-2
Did some quick research. A combination of the two could be a solution:
Store images outside of web/ and write a Controller and/or Twig extension with access control to display them
Use Gaufrette as a Symfony Bundle for abstract file system management, to have some flexibility (i.e. store images on local file system, Amazon S3, FTP, etc.)
I'm getting this error when I run php app/console cache:clear --env=prod --no-debug
[Symfony\Component\Config\Exception\FileLoaderLoadException]
[Semantical Error] The annotation "@fos\RestBundle\Controller\Annotations\GET" in method CampaignChai
n\CoreBundle\Controller\REST\PackageController::getVendorsMetaAction() does not exist, or could not b
e auto-loaded in CampaignChain\CoreBundle\Controller\REST\PackageController (which is being imported
from "/var/www/campaignchain/vendor/campaignchain/core/Resources/config/routing_rest.yml").
[Doctrine\Common\Annotations\AnnotationException]
[Semantical Error] The annotation "@fos\RestBundle\Controller\Annotations\GET" in method CampaignChai
n\CoreBundle\Controller\REST\PackageController::getVendorsMetaAction() does not exist, or could not b
e auto-loaded.
Can't wait to get started on this in May/June :) Campaign chain looks amazing! ( @michield )
Only campaigns which are not being executed can be deleted.
At the current state of the FB API, you have to be logged in and you app has to be accepted, before we can force a logout. So if the user sees first the connect page, we have show the popup where the user have to give every access, then can we log him out.
What an option would be, is re-authentication. Then FB would ask for a password always and then in the FB context, the user could log themselves out.
When connecting new Facebook Channel or adding a Facebook Location, check whether the Facebook user is admin of a Facebook page which already exists as a Location inside CampaignChain,
Sometimes it's not possible to edit campaigns on the timeline, double-click isn't working (Mac, Firefox, Version 44).
Hi!
After install the 1.0.0-alpha.3 release of campaignchain-ce, and after check any of the default modules from the list I want to install and submit the install button from the admin dashboard, the module install popup info window message appears but after that the system doesn't install any module and I don't get any error message in the log file, any idea to debug this problem? My test environment is a new LXC ubuntu container with all the requirements installed
Thanks!
PS: can we use GitHub to report issues or we must to use JIRA?
As a user, I want to write a description of my campaign so that other users are informed about the goal and details of the campaign.
As a user I always want to know in which section I am so that I don't get lost on the website.
Greetings! I was finally able to get this fun software installed and I'm totally digging it. However, I'm having some issues with the Google Analytics integration.
When I click on "Connect With Google" it prompts for an ID and password as one would expect but then it tells me that the redirect_uri is invalid.
I'm sure I'm doing something wrong in the configuration of the key so if anyone has a step by step for how to make it work that'd be grand.
Thanks!
Hello: gronganz!
Edited 2/18/2016
Hello I need some direction!
The installation onto my system (Ubuntu 14 trusty) went well except when I attempted to start the installation wizard.
First off there was no install.php in the root directory so I located one in the /web/campaignchain directory.
I ran the script and needed to change permissions on two folders and 2 files. reran the script and was greeted with a success message:
Server Environment Installation Wizard
Welcome to your new CampaignChain application!
This wizard will guide you through the installation process.
Your configuration looks good to run Symfony.
A button appears stating "Next Step"
when I select that I am routed to this url domain/install/
However; I get a 404 error
I installed campaignchain in a home folder and then symlink to /var/www/campaignchain folder.
I have checked everything I know to check, but getting the application setup is driving me batty. I admit I am new to Ubuntu and such and this has me stumped. Any help would be much appreciated. Also this is a clean install of ubuntu as an Amazon instance.
I could really use some advice.
Thanks, Rich
Per campaign, one Webinar can be added, if the Webinar is scheduled within the campaign duration. This means that the same Webinar could be added to several campaigns. Yet, this is not possible, because URLs must be unique for Locations. Hence, whenever a Location for an Activity or Operation already exists, a duplicate entry error is being thrown.
A solution would be to allow 1-to-many relationships for Activity->Locations and Operation->Locations.
Once channel has been created it should be possible to delete it, e.g channels that has been created for testing purpose
Hey guys
I have tried to install Campaignchain 3 ways now and I can not seem to get there.
The first way was on an existing AWS EC2 Ubuntu LAMP instance where I created a virtual env for the project. I was using beta 3 version. Campaign chain was loaded into the user virtual env with sym link to web. This had many problems including the first message I posted about the 404 redirects.
Second effort was on a clean new instance of AWS EC2 ubuntu LAMP. Here too I installed the beta 3 version. I implemented it two ways (in a virtual env and globally) each time I was unable to complete the installation because of symfony or composer and 404 issues
Lastly - On a new clean instance of AWS EC2 Ubuntu LAMP I installed version dev-master. This is where I encountered the Class SymfonyStandard\Composer is not autoloadable issue. So as it stands it seems no matter what I try, no matter how I install I am unable to get this running on the Ubuntu 14.02 LAMP.
Just to ask? Is there a preferred system that this should run on? It seems like everything should run on this type of system...with either in virtual or global packages installed. YET --- I fail to be abe to get er goin!
Any thoughts? help???
Thanks, Rich
Hello: Two questions. Is there a user forum? Is adding images to the social campaigns on the roadmap? Thanks, Rich
YUI compressor is outdated and requires Java
Today it's recommended to use UglifyJS which requires npm
See previous -- see next ( I created this but do not know how to delete it) pls disregard.
Bad luck! :-(
After trying to connect to a twitter channel at /channel/twitter/create/login I get this error:
CRITICAL - Uncaught PHP Exception Exception: "Notice: Undefined index: oauth_token" at /opt/campaignchain/campaignchain-ce-1.0.0-alpha.4/vendor/hybridauth/hybridauth/hybridauth/Hybrid/Auth.php line 152
Stack Trace
in vendor/hybridauth/hybridauth/hybridauth/Hybrid/Auth.php at line 152 -
throw new Exception( $m, $c, $p );
}
else{
throw new Exception( $m, $c );
}
}
at Hybrid_Auth ::initialize (array('base_url' => 'http://10.0.3.214:8000/security/authentication/client/oauth/login', 'providers' => array('Twitter' => array('enabled' => true, 'keys' => array('key' => '****', 'secret' => '*****'), 'force_login' => true)), 'debug_mode' => false, 'debug_file' => 'app/logs/oauth.log'))
in vendor/hybridauth/hybridauth/hybridauth/Hybrid/Auth.php at line 39 +
at Hybrid_Auth ->__construct (array('base_url' => 'http://10.0.3.214:8000/security/authentication/client/oauth/login', 'providers' => array('Twitter' => array('enabled' => true, 'keys' => array('key' => '********', 'secret' => '*******'), 'force_login' => true)), 'debug_mode' => false, 'debug_file' => 'app/logs/oauth.log'))
in vendor/campaignchain/security-authentication-client-oauth/Authentication.php at line 65 +
at Authentication ->authenticate ('Twitter', array('key_labels' => array('key', 'App Key'), 'secret_labels' => array('secret', 'App Secret'), 'config_url' => 'https://apps.twitter.com', 'parameters' => array('force_login' => true)))
in vendor/campaignchain/channel-twitter/Controller/TwitterController.php at line 53 +
at TwitterController ->loginAction (object(Request))
at call_user_func_array (array(object(TwitterController), 'loginAction'), array(object(Request)))
in app/bootstrap.php.cache at line 3020 +
at HttpKernel ->handleRaw (object(Request), '1')
in app/bootstrap.php.cache at line 2982 +
at HttpKernel ->handle (object(Request), '1', true)
in app/bootstrap.php.cache at line 3131 +
at ContainerAwareHttpKernel ->handle (object(Request), '1', true)
in app/bootstrap.php.cache at line 2376 +
at Kernel ->handle (object(Request))
in web/app_dev.php at line 28 +
at require ('/opt/campaignchain/campaignchain-ce-1.0.0-alpha.4/web/app_dev.php')
in vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Resources/config/router_dev.php at line 31 +
Logs -
1 error
INFO - Matched route "campaignchain_channel_twitter_login" (parameters: "_controller": "CampaignChain\Channel\TwitterBundle\Controller\TwitterController::loginAction", "_route": "campaignchain_channel_twitter_login")
DEBUG - Read SecurityContext from the session
DEBUG - Reloading user from user provider.
DEBUG - SELECT t0.username AS username1, t0.username_canonical AS username_canonical2, t0.email AS email3, t0.email_canonical AS email_canonical4, t0.enabled AS enabled5, t0.salt AS salt6, t0.password AS password7, t0.last_login AS last_login8, t0.locked AS locked9, t0.expired AS expired10, t0.expires_at AS expires_at11, t0.confirmation_token AS confirmation_token12, t0.password_requested_at AS password_requested_at13, t0.roles AS roles14, t0.credentials_expired AS credentials_expired15, t0.credentials_expire_at AS credentials_expire_at16, t0.id AS id17, t0.language AS language18, t0.locale AS locale19, t0.timezone AS timezone20, t0.currency AS currency21, t0.dateFormat AS dateFormat22, t0.timeFormat AS timeFormat23, t0.createdDate AS createdDate24, t0.modifiedDate AS modifiedDate25 FROM campaignchain_user t0 WHERE t0.id = ? LIMIT 1
DEBUG - Username "admin" was reloaded from user provider.
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\MenuBundle\EventListener\VoterInitializerListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "CampaignChain\CoreBundle\EventListener\LoginListener::setLocale".
DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
DEBUG - SELECT t0.id AS id1, t0.resourceOwner AS resourceOwner2, t0.`key` AS key3, t0.secret AS secret4, t0.createdDate AS createdDate5, t0.modifiedDate AS modifiedDate6 FROM campaignchain_security_authentication_client_oauth_application t0 WHERE t0.resourceOwner = ? LIMIT 1
CRITICAL - Uncaught PHP Exception Exception: "Notice: Undefined index: oauth_token" at /opt/campaignchain/campaignchain-ce-1.0.0-alpha.4/vendor/hybridauth/hybridauth/hybridauth/Hybrid/Auth.php line 152
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\MenuBundle\EventListener\VoterInitializerListener::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
DEBUG - Notified event "kernel.request" to listener "CampaignChain\CoreBundle\EventListener\LoginListener::setLocale".
DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
DEBUG - SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_activity'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_activity' */ WHERE k.table_name = 'campaignchain_activity' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_activity' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_bundle'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_bundle' */ WHERE k.table_name = 'campaignchain_bundle' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_bundle' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_campaign'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_campaign' */ WHERE k.table_name = 'campaignchain_campaign' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_campaign' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_channel'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_channel' */ WHERE k.table_name = 'campaignchain_channel' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_channel' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_cta'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_cta' */ WHERE k.table_name = 'campaignchain_cta' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_cta' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_group'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_group' */ WHERE k.table_name = 'campaignchain_group' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_group' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_hook'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_hook' */ WHERE k.table_name = 'campaignchain_hook' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_hook' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_hook_assignee'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_hook_assignee' */ WHERE k.table_name = 'campaignchain_hook_assignee' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_hook_assignee' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_job'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_job' */ WHERE k.table_name = 'campaignchain_job' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_job' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_location'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_location' */ WHERE k.table_name = 'campaignchain_location' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_location' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_location_facebook'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_location_facebook' */ WHERE k.table_name = 'campaignchain_location_facebook' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_location_facebook' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_location_facebook_user_page'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_location_facebook_user_page' */ WHERE k.table_name = 'campaignchain_location_facebook_user_page' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_location_facebook_user_page' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_location_linkedin_user'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_location_linkedin_user' */ WHERE k.table_name = 'campaignchain_location_linkedin_user' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_location_linkedin_user' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_location_twitter_user'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_location_twitter_user' */ WHERE k.table_name = 'campaignchain_location_twitter_user' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_location_twitter_user' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_milestone'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_milestone' */ WHERE k.table_name = 'campaignchain_milestone' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_milestone' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_module'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_module' */ WHERE k.table_name = 'campaignchain_module' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_module' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_module_activity_channel'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_module_activity_channel' */ WHERE k.table_name = 'campaignchain_module_activity_channel' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_module_activity_channel' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_operation'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_operation' */ WHERE k.table_name = 'campaignchain_operation' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_operation' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_operation_facebook_status'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_operation_facebook_status' */ WHERE k.table_name = 'campaignchain_operation_facebook_status' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_operation_facebook_status' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_operation_linkedin_news_item'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_operation_linkedin_news_item' */ WHERE k.table_name = 'campaignchain_operation_linkedin_news_item' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_operation_linkedin_news_item' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_operation_twitter_status'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_operation_twitter_status' */ WHERE k.table_name = 'campaignchain_operation_twitter_status' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_operation_twitter_status' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_report_analytics_activity_fact'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_report_analytics_activity_fact' */ WHERE k.table_name = 'campaignchain_report_analytics_activity_fact' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_report_analytics_activity_fact' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_report_analytics_activity_metric'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_report_analytics_activity_metric' */ WHERE k.table_name = 'campaignchain_report_analytics_activity_metric' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_report_analytics_activity_metric' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_report_analytics_channel_fact'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_report_analytics_channel_fact' */ WHERE k.table_name = 'campaignchain_report_analytics_channel_fact' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_report_analytics_channel_fact' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_report_analytics_channel_metric'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_report_analytics_channel_metric' */ WHERE k.table_name = 'campaignchain_report_analytics_channel_metric' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_report_analytics_channel_metric' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_report_cta'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_report_cta' */ WHERE k.table_name = 'campaignchain_report_cta' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_report_cta' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_scheduler'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_scheduler' */ WHERE k.table_name = 'campaignchain_scheduler' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_scheduler' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_scheduler_report'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_scheduler_report' */ WHERE k.table_name = 'campaignchain_scheduler_report' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_scheduler_report' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_security_authentication_client_oauth_application'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_security_authentication_client_oauth_application' */ WHERE k.table_name = 'campaignchain_security_authentication_client_oauth_application' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_security_authentication_client_oauth_application' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_security_authentication_client_oauth_token'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_security_authentication_client_oauth_token' */ WHERE k.table_name = 'campaignchain_security_authentication_client_oauth_token' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_security_authentication_client_oauth_token' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_system'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_system' */ WHERE k.table_name = 'campaignchain_system' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_system' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_user'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_user' */ WHERE k.table_name = 'campaignchain_user' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_user' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'campaignchain_ce' AND TABLE_NAME = 'campaignchain_user_group'
DEBUG - SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'campaignchain_user_group' */ WHERE k.table_name = 'campaignchain_user_group' AND k.table_schema = 'campaignchain_ce' /*!50116 AND c.constraint_schema = 'campaignchain_ce' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
DEBUG - SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'campaignchain_user_group' AND TABLE_SCHEMA = 'campaignchain_ce'
DEBUG - SELECT t0.id AS id1, t0.currency AS currency2, t0.name AS name3, t0.version AS version4, t0.logo AS logo5, t0.icon AS icon6, t0.style AS style7, t0.homepage AS homepage8, t0.navigation AS navigation9, t0.modules AS modules10, t0.createdDate AS createdDate11, t0.modifiedDate AS modifiedDate12 FROM campaignchain_system t0 WHERE t0.id = ?
Any idea?
Thanks!
Otherwise, e.g. the Twitter and Facebook APIs will return an error when you try posting existing content to a stream
There should be an MX check for the email address at registration.
This is how it currently looks:
Instead, the title text should flow at the right side of the icon.
Class SymfonyStandard\Composer is not autoloadable, can not call post-root-package-install script
Tried to install dev-master but encounter this error immediately Class SymfonyStandard\Composer is not autoloadable. I tried looking for a solution but I am not a programmer. Is there something I can do on my end?
Thanks, Rich
campaignchain/operation-facebook/Job/ReportPublishStatus.php on line 92 PHP Notice: Undefined variable: comments
campaignchain/operation-facebook/Job/ReportPublishStatus.php on line 71 PHP Notice: Undefined variable: likes
We should check what comes back from the Facebook API.
If we store the ID in the cookie, redirection shouldnt wait for the tracking ajax response
If a job failed, it shouldn't try more then X times. X should be stored once in core, but the submodules should be able to overwrite it.
After X error, scheduler should write a log, send an email and shouldn't try it any more.
A scheduled 'update status' activity on twitter channel does not post something to the actual twitter channel.
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.