Comments (7)
Could you post complete self-contained example?
from node-mysql2.
tricky. This is the repository I'm hacking on: https://github.com/webjay/gignal-api/tree/prepared-stmnts
The database is by default set to LATIN1_SWEDISH_CI
.
from node-mysql2.
Actually I think the problem is on our end, but it doesn't show with node-mysql.
from node-mysql2.
Is it possible to get few rows dump and db schema so it's easier for me to set up test locally?
from node-mysql2.
Sure.
CREATE TABLE `stream` (
`stream_id` int(11) NOT NULL AUTO_INCREMENT,
`event_id` int(11) NOT NULL,
`original_id` text NOT NULL,
`service` enum('Twitter','Flickr','Facebook','Foursquare','Instagram') NOT NULL,
`created_on` datetime NOT NULL,
`updated_on` datetime DEFAULT NULL,
`user_id` int(11) NOT NULL,
`username` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`user_image` text,
`text` text,
`thumb_photo` text,
`large_photo` text,
`serial_data` text NOT NULL,
`admin_entry` tinyint(4) DEFAULT '0',
`saved_on` datetime NOT NULL,
`type` enum('text','photo') NOT NULL DEFAULT 'text',
PRIMARY KEY (`stream_id`),
KEY `event_id` (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `stream` (`stream_id`, `event_id`, `original_id`, `service`, `created_on`, `updated_on`, `user_id`, `username`, `name`, `user_image`, `text`, `thumb_photo`, `large_photo`, `serial_data`, `admin_entry`, `saved_on`, `type`)
VALUES
(148138, 147, '392789221548625920', 'Twitter', '2013-10-22 23:07:02', '0000-00-00 00:00:00', 7128982, 'twillumsgaard', 'Erik Willumsgaard', 'http://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf.jpeg', '@lytken Jamen, det er jo let med flere p-pladser.Nedlæg torve, legepladser,parker og fodboldbaner? Eller hvad? :) #kbhpol #kv13', '', '', 'O:8:\"stdClass\":23:{s:8:\"metadata\";O:8:\"stdClass\":2:{s:11:\"result_type\";s:6:\"recent\";s:17:\"iso_language_code\";s:2:\"da\";}s:10:\"created_at\";s:30:\"Tue Oct 22 23:07:02 +0000 2013\";s:2:\"id\";i:392789221548625920;s:6:\"id_str\";s:18:\"392789221548625920\";s:4:\"text\";s:128:\"@lytken Jamen, det er jo let med flere p-pladser.Nedlæg torve, legepladser,parker og fodboldbaner? Eller hvad? :) #kbhpol #kv13\";s:6:\"source\";s:3:\"web\";s:9:\"truncated\";b:0;s:21:\"in_reply_to_status_id\";i:392761620268847104;s:25:\"in_reply_to_status_id_str\";s:18:\"392761620268847104\";s:19:\"in_reply_to_user_id\";i:30933634;s:23:\"in_reply_to_user_id_str\";s:8:\"30933634\";s:23:\"in_reply_to_screen_name\";s:6:\"lytken\";s:4:\"user\";O:8:\"stdClass\":39:{s:2:\"id\";i:7128982;s:6:\"id_str\";s:7:\"7128982\";s:4:\"name\";s:17:\"Erik Willumsgaard\";s:11:\"screen_name\";s:13:\"twillumsgaard\";s:8:\"location\";s:21:\"Vesterbro, København\";s:11:\"description\";s:161:\"Konsulent. Socialdemokrat. BR-kandidat ved kommunalvalget i Kbh. Tweeter bl.a. om #kbh, #kbhpol, #dkpol og #kv13. Interesser: Trafik, miljø og erhvervsudvikling\";s:3:\"url\";s:23:\"https://t.co/R25i9IgLFu\";s:8:\"entities\";O:8:\"stdClass\":2:{s:3:\"url\";O:8:\"stdClass\":1:{s:4:\"urls\";a:1:{i:0;O:8:\"stdClass\":4:{s:3:\"url\";s:23:\"https://t.co/R25i9IgLFu\";s:12:\"expanded_url\";s:49:\"https://www.facebook.com/ErikWillumsgaard?fref=ts\";s:11:\"display_url\";s:30:\"facebook.com/ErikWillumsgaa…\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:23;}}}}s:11:\"description\";O:8:\"stdClass\":1:{s:4:\"urls\";a:0:{}}}s:9:\"protected\";b:0;s:15:\"followers_count\";i:1098;s:13:\"friends_count\";i:2001;s:12:\"listed_count\";i:62;s:10:\"created_at\";s:30:\"Thu Jun 28 11:30:55 +0000 2007\";s:16:\"favourites_count\";i:1777;s:10:\"utc_offset\";i:7200;s:9:\"time_zone\";s:10:\"Copenhagen\";s:11:\"geo_enabled\";b:1;s:8:\"verified\";b:0;s:14:\"statuses_count\";i:6276;s:4:\"lang\";s:2:\"da\";s:20:\"contributors_enabled\";b:0;s:13:\"is_translator\";b:0;s:24:\"profile_background_color\";s:6:\"ACDED6\";s:28:\"profile_background_image_url\";s:70:\"http://a0.twimg.com/profile_background_images/564029721/a-panorama.jpg\";s:34:\"profile_background_image_url_https\";s:72:\"https://si0.twimg.com/profile_background_images/564029721/a-panorama.jpg\";s:23:\"profile_background_tile\";b:0;s:17:\"profile_image_url\";s:99:\"http://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf_normal.jpeg\";s:23:\"profile_image_url_https\";s:100:\"https://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf_normal.jpeg\";s:18:\"profile_banner_url\";s:56:\"https://pbs.twimg.com/profile_banners/7128982/1381858462\";s:18:\"profile_link_color\";s:6:\"038543\";s:28:\"profile_sidebar_border_color\";s:6:\"EEEEEE\";s:26:\"profile_sidebar_fill_color\";s:6:\"EFEFEF\";s:18:\"profile_text_color\";s:6:\"333333\";s:28:\"profile_use_background_image\";b:1;s:15:\"default_profile\";b:0;s:21:\"default_profile_image\";b:0;s:9:\"following\";b:0;s:19:\"follow_request_sent\";b:0;s:13:\"notifications\";b:0;}s:3:\"geo\";N;s:11:\"coordinates\";N;s:5:\"place\";N;s:12:\"contributors\";N;s:13:\"retweet_count\";i:0;s:14:\"favorite_count\";i:0;s:8:\"entities\";O:8:\"stdClass\":4:{s:8:\"hashtags\";a:2:{i:0;O:8:\"stdClass\":2:{s:4:\"text\";s:6:\"kbhpol\";s:7:\"indices\";a:2:{i:0;i:114;i:1;i:121;}}i:1;O:8:\"stdClass\":2:{s:4:\"text\";s:4:\"kv13\";s:7:\"indices\";a:2:{i:0;i:122;i:1;i:127;}}}s:7:\"symbols\";a:0:{}s:4:\"urls\";a:0:{}s:13:\"user_mentions\";a:1:{i:0;O:8:\"stdClass\":5:{s:11:\"screen_name\";s:6:\"lytken\";s:4:\"name\";s:21:\"Jens-Kristian Lütken\";s:2:\"id\";i:30933634;s:6:\"id_str\";s:8:\"30933634\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:7;}}}}s:9:\"favorited\";b:0;s:9:\"retweeted\";b:0;s:4:\"lang\";s:2:\"da\";}', 0, '2013-10-22 23:08:04', 'text'),
(148137, 147, '392788521557061632', 'Twitter', '2013-10-22 23:04:15', '0000-00-00 00:00:00', 7128982, 'twillumsgaard', 'Erik Willumsgaard', 'http://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf.jpeg', '@HISonne @MiaNyegaard @amgeisler - Det er hele kulturen i Handicapcenter Kbh og SOF, der skal have en ordentlig overhaling! #kv13 #kbhpol', '', '', 'O:8:\"stdClass\":23:{s:8:\"metadata\";O:8:\"stdClass\":2:{s:11:\"result_type\";s:6:\"recent\";s:17:\"iso_language_code\";s:2:\"da\";}s:10:\"created_at\";s:30:\"Tue Oct 22 23:04:15 +0000 2013\";s:2:\"id\";i:392788521557061632;s:6:\"id_str\";s:18:\"392788521557061632\";s:4:\"text\";s:137:\"@HISonne @MiaNyegaard @amgeisler - Det er hele kulturen i Handicapcenter Kbh og SOF, der skal have en ordentlig overhaling! #kv13 #kbhpol\";s:6:\"source\";s:3:\"web\";s:9:\"truncated\";b:0;s:21:\"in_reply_to_status_id\";i:392771914361745408;s:25:\"in_reply_to_status_id_str\";s:18:\"392771914361745408\";s:19:\"in_reply_to_user_id\";i:72525812;s:23:\"in_reply_to_user_id_str\";s:8:\"72525812\";s:23:\"in_reply_to_screen_name\";s:7:\"HISonne\";s:4:\"user\";O:8:\"stdClass\":39:{s:2:\"id\";i:7128982;s:6:\"id_str\";s:7:\"7128982\";s:4:\"name\";s:17:\"Erik Willumsgaard\";s:11:\"screen_name\";s:13:\"twillumsgaard\";s:8:\"location\";s:21:\"Vesterbro, København\";s:11:\"description\";s:161:\"Konsulent. Socialdemokrat. BR-kandidat ved kommunalvalget i Kbh. Tweeter bl.a. om #kbh, #kbhpol, #dkpol og #kv13. Interesser: Trafik, miljø og erhvervsudvikling\";s:3:\"url\";s:23:\"https://t.co/R25i9IgLFu\";s:8:\"entities\";O:8:\"stdClass\":2:{s:3:\"url\";O:8:\"stdClass\":1:{s:4:\"urls\";a:1:{i:0;O:8:\"stdClass\":4:{s:3:\"url\";s:23:\"https://t.co/R25i9IgLFu\";s:12:\"expanded_url\";s:49:\"https://www.facebook.com/ErikWillumsgaard?fref=ts\";s:11:\"display_url\";s:30:\"facebook.com/ErikWillumsgaa…\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:23;}}}}s:11:\"description\";O:8:\"stdClass\":1:{s:4:\"urls\";a:0:{}}}s:9:\"protected\";b:0;s:15:\"followers_count\";i:1098;s:13:\"friends_count\";i:2001;s:12:\"listed_count\";i:62;s:10:\"created_at\";s:30:\"Thu Jun 28 11:30:55 +0000 2007\";s:16:\"favourites_count\";i:1777;s:10:\"utc_offset\";i:7200;s:9:\"time_zone\";s:10:\"Copenhagen\";s:11:\"geo_enabled\";b:1;s:8:\"verified\";b:0;s:14:\"statuses_count\";i:6275;s:4:\"lang\";s:2:\"da\";s:20:\"contributors_enabled\";b:0;s:13:\"is_translator\";b:0;s:24:\"profile_background_color\";s:6:\"ACDED6\";s:28:\"profile_background_image_url\";s:70:\"http://a0.twimg.com/profile_background_images/564029721/a-panorama.jpg\";s:34:\"profile_background_image_url_https\";s:72:\"https://si0.twimg.com/profile_background_images/564029721/a-panorama.jpg\";s:23:\"profile_background_tile\";b:0;s:17:\"profile_image_url\";s:99:\"http://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf_normal.jpeg\";s:23:\"profile_image_url_https\";s:100:\"https://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf_normal.jpeg\";s:18:\"profile_banner_url\";s:56:\"https://pbs.twimg.com/profile_banners/7128982/1381858462\";s:18:\"profile_link_color\";s:6:\"038543\";s:28:\"profile_sidebar_border_color\";s:6:\"EEEEEE\";s:26:\"profile_sidebar_fill_color\";s:6:\"EFEFEF\";s:18:\"profile_text_color\";s:6:\"333333\";s:28:\"profile_use_background_image\";b:1;s:15:\"default_profile\";b:0;s:21:\"default_profile_image\";b:0;s:9:\"following\";b:0;s:19:\"follow_request_sent\";b:0;s:13:\"notifications\";b:0;}s:3:\"geo\";N;s:11:\"coordinates\";N;s:5:\"place\";N;s:12:\"contributors\";N;s:13:\"retweet_count\";i:0;s:14:\"favorite_count\";i:0;s:8:\"entities\";O:8:\"stdClass\":4:{s:8:\"hashtags\";a:2:{i:0;O:8:\"stdClass\":2:{s:4:\"text\";s:4:\"kv13\";s:7:\"indices\";a:2:{i:0;i:124;i:1;i:129;}}i:1;O:8:\"stdClass\":2:{s:4:\"text\";s:6:\"kbhpol\";s:7:\"indices\";a:2:{i:0;i:130;i:1;i:137;}}}s:7:\"symbols\";a:0:{}s:4:\"urls\";a:0:{}s:13:\"user_mentions\";a:3:{i:0;O:8:\"stdClass\":5:{s:11:\"screen_name\";s:7:\"HISonne\";s:4:\"name\";s:18:\"Henriette I. Sonne\";s:2:\"id\";i:72525812;s:6:\"id_str\";s:8:\"72525812\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:8;}}i:1;O:8:\"stdClass\":5:{s:11:\"screen_name\";s:11:\"MiaNyegaard\";s:4:\"name\";s:11:\"MiaNyegaard\";s:2:\"id\";i:17652025;s:6:\"id_str\";s:8:\"17652025\";s:7:\"indices\";a:2:{i:0;i:9;i:1;i:21;}}i:2;O:8:\"stdClass\":5:{s:11:\"screen_name\";s:9:\"amgeisler\";s:4:\"name\";s:18:\"Anne Marie Geisler\";s:2:\"id\";i:56400417;s:6:\"id_str\";s:8:\"56400417\";s:7:\"indices\";a:2:{i:0;i:22;i:1;i:32;}}}}s:9:\"favorited\";b:0;s:9:\"retweeted\";b:0;s:4:\"lang\";s:2:\"da\";}', 0, '2013-10-22 23:05:04', 'text'),
(148136, 147, '392785701055787008', 'Twitter', '2013-10-22 22:53:03', '0000-00-00 00:00:00', 15097746, 'chrpeder', 'Christian R Pedersen', 'http://a0.twimg.com/profile_images/378800000548692102/b6b2aca4ff6002570e3e893ddadc1d58.jpeg', 'RT @LisbethZornig: Jeg er imponeret over de kirkelige organisationers arbejde for at få #stemmerpaakanten til #kv13 d 19 nov http://t.co/SQ…', '', '', 'O:8:\"stdClass\":24:{s:8:\"metadata\";O:8:\"stdClass\":2:{s:11:\"result_type\";s:6:\"recent\";s:17:\"iso_language_code\";s:2:\"da\";}s:10:\"created_at\";s:30:\"Tue Oct 22 22:53:03 +0000 2013\";s:2:\"id\";i:392785701055787008;s:6:\"id_str\";s:18:\"392785701055787008\";s:4:\"text\";s:143:\"RT @LisbethZornig: Jeg er imponeret over de kirkelige organisationers arbejde for at få #stemmerpaakanten til #kv13 d 19 nov http://t.co/SQ…\";s:6:\"source\";s:81:\"<a href=\"http://twitter.com/#!/download/ipad\" rel=\"nofollow\">Twitter for iPad</a>\";s:9:\"truncated\";b:0;s:21:\"in_reply_to_status_id\";N;s:25:\"in_reply_to_status_id_str\";N;s:19:\"in_reply_to_user_id\";N;s:23:\"in_reply_to_user_id_str\";N;s:23:\"in_reply_to_screen_name\";N;s:4:\"user\";O:8:\"stdClass\":39:{s:2:\"id\";i:15097746;s:6:\"id_str\";s:8:\"15097746\";s:4:\"name\";s:20:\"Christian R Pedersen\";s:11:\"screen_name\";s:8:\"chrpeder\";s:8:\"location\";s:11:\"Nordjylland\";s:11:\"description\";s:92:\"Sognepræst og mediekonsulent. Presse-kontakt Folkekirken i Aalborg Stift. Telefon: 23203099\";s:3:\"url\";s:22:\"http://t.co/r2XBYHVPEO\";s:8:\"entities\";O:8:\"stdClass\":2:{s:3:\"url\";O:8:\"stdClass\":1:{s:4:\"urls\";a:1:{i:0;O:8:\"stdClass\":4:{s:3:\"url\";s:22:\"http://t.co/r2XBYHVPEO\";s:12:\"expanded_url\";s:26:\"http://www.aalborgstift.dk\";s:11:\"display_url\";s:15:\"aalborgstift.dk\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:22;}}}}s:11:\"description\";O:8:\"stdClass\":1:{s:4:\"urls\";a:0:{}}}s:9:\"protected\";b:0;s:15:\"followers_count\";i:275;s:13:\"friends_count\";i:566;s:12:\"listed_count\";i:2;s:10:\"created_at\";s:30:\"Thu Jun 12 15:40:20 +0000 2008\";s:16:\"favourites_count\";i:463;s:10:\"utc_offset\";i:7200;s:9:\"time_zone\";s:10:\"Copenhagen\";s:11:\"geo_enabled\";b:1;s:8:\"verified\";b:0;s:14:\"statuses_count\";i:1639;s:4:\"lang\";s:2:\"da\";s:20:\"contributors_enabled\";b:0;s:13:\"is_translator\";b:0;s:24:\"profile_background_color\";s:6:\"C0DEED\";s:28:\"profile_background_image_url\";s:93:\"http://a0.twimg.com/profile_background_images/797349011/56f92e70d67012cb24435f86466e673c.jpeg\";s:34:\"profile_background_image_url_https\";s:95:\"https://si0.twimg.com/profile_background_images/797349011/56f92e70d67012cb24435f86466e673c.jpeg\";s:23:\"profile_background_tile\";b:0;s:17:\"profile_image_url\";s:98:\"http://a0.twimg.com/profile_images/378800000548692102/b6b2aca4ff6002570e3e893ddadc1d58_normal.jpeg\";s:23:\"profile_image_url_https\";s:100:\"https://si0.twimg.com/profile_images/378800000548692102/b6b2aca4ff6002570e3e893ddadc1d58_normal.jpeg\";s:18:\"profile_banner_url\";s:57:\"https://pbs.twimg.com/profile_banners/15097746/1377726818\";s:18:\"profile_link_color\";s:6:\"0084B4\";s:28:\"profile_sidebar_border_color\";s:6:\"FFFFFF\";s:26:\"profile_sidebar_fill_color\";s:6:\"DDEEF6\";s:18:\"profile_text_color\";s:6:\"333333\";s:28:\"profile_use_background_image\";b:1;s:15:\"default_profile\";b:0;s:21:\"default_profile_image\";b:0;s:9:\"following\";b:0;s:19:\"follow_request_sent\";b:0;s:13:\"notifications\";b:0;}s:3:\"geo\";N;s:11:\"coordinates\";N;s:5:\"place\";N;s:12:\"contributors\";N;s:16:\"retweeted_status\";O:8:\"stdClass\":24:{s:8:\"metadata\";O:8:\"stdClass\":2:{s:11:\"result_type\";s:6:\"recent\";s:17:\"iso_language_code\";s:2:\"da\";}s:10:\"created_at\";s:30:\"Tue Oct 22 21:50:13 +0000 2013\";s:2:\"id\";i:392769887812476928;s:6:\"id_str\";s:18:\"392769887812476928\";s:4:\"text\";s:129:\"Jeg er imponeret over de kirkelige organisationers arbejde for at få #stemmerpaakanten til #kv13 d 19 nov http://t.co/SQNknDMnR3\";s:6:\"source\";s:82:\"<a href=\"http://twitter.com/download/iphone\" rel=\"nofollow\">Twitter for iPhone</a>\";s:9:\"truncated\";b:0;s:21:\"in_reply_to_status_id\";N;s:25:\"in_reply_to_status_id_str\";N;s:19:\"in_reply_to_user_id\";N;s:23:\"in_reply_to_user_id_str\";N;s:23:\"in_reply_to_screen_name\";N;s:4:\"user\";O:8:\"stdClass\":39:{s:2:\"id\";i:1354082354;s:6:\"id_str\";s:10:\"1354082354\";s:4:\"name\";s:14:\"Lisbeth Zornig\";s:11:\"screen_name\";s:13:\"LisbethZornig\";s:8:\"location\";s:13:\"underdanmark \";s:11:\"description\";s:160:\"Social lobbyist og den ene halvdel af hr. og fru Underdanmark. Ejer af Huset Zornig - en bevægelse af folk, der vil radikal forandring for udsatte #kv13 #dkpol\";s:3:\"url\";s:22:\"http://t.co/GFic8OaVgb\";s:8:\"entities\";O:8:\"stdClass\":2:{s:3:\"url\";O:8:\"stdClass\":1:{s:4:\"urls\";a:1:{i:0;O:8:\"stdClass\":4:{s:3:\"url\";s:22:\"http://t.co/GFic8OaVgb\";s:12:\"expanded_url\";s:30:\"http://www.stemmerpaakanten.dk\";s:11:\"display_url\";s:19:\"stemmerpaakanten.dk\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:22;}}}}s:11:\"description\";O:8:\"stdClass\":1:{s:4:\"urls\";a:0:{}}}s:9:\"protected\";b:0;s:15:\"followers_count\";i:2188;s:13:\"friends_count\";i:815;s:12:\"listed_count\";i:10;s:10:\"created_at\";s:30:\"Mon Apr 15 11:00:21 +0000 2013\";s:16:\"favourites_count\";i:134;s:10:\"utc_offset\";i:10800;s:9:\"time_zone\";s:6:\"Athens\";s:11:\"geo_enabled\";b:0;s:8:\"verified\";b:0;s:14:\"statuses_count\";i:589;s:4:\"lang\";s:2:\"da\";s:20:\"contributors_enabled\";b:0;s:13:\"is_translator\";b:0;s:24:\"profile_background_color\";s:6:\"C0DEED\";s:28:\"profile_background_image_url\";s:48:\"http://abs.twimg.com/images/themes/theme1/bg.png\";s:34:\"profile_background_image_url_https\";s:49:\"https://abs.twimg.com/images/themes/theme1/bg.png\";s:23:\"profile_background_tile\";b:0;s:17:\"profile_image_url\";s:89:\"http://a0.twimg.com/profile_images/3525432701/e81fd954c934e603cea404a1c67974d2_normal.png\";s:23:\"profile_image_url_https\";s:91:\"https://si0.twimg.com/profile_images/3525432701/e81fd954c934e603cea404a1c67974d2_normal.png\";s:18:\"profile_banner_url\";s:59:\"https://pbs.twimg.com/profile_banners/1354082354/1369429351\";s:18:\"profile_link_color\";s:6:\"0084B4\";s:28:\"profile_sidebar_border_color\";s:6:\"C0DEED\";s:26:\"profile_sidebar_fill_color\";s:6:\"DDEEF6\";s:18:\"profile_text_color\";s:6:\"333333\";s:28:\"profile_use_background_image\";b:1;s:15:\"default_profile\";b:1;s:21:\"default_profile_image\";b:0;s:9:\"following\";b:0;s:19:\"follow_request_sent\";b:0;s:13:\"notifications\";b:0;}s:3:\"geo\";N;s:11:\"coordinates\";N;s:5:\"place\";N;s:12:\"contributors\";N;s:13:\"retweet_count\";i:3;s:14:\"favorite_count\";i:0;s:8:\"entities\";O:8:\"stdClass\":4:{s:8:\"hashtags\";a:2:{i:0;O:8:\"stdClass\":2:{s:4:\"text\";s:16:\"stemmerpaakanten\";s:7:\"indices\";a:2:{i:0;i:69;i:1;i:86;}}i:1;O:8:\"stdClass\":2:{s:4:\"text\";s:4:\"kv13\";s:7:\"indices\";a:2:{i:0;i:91;i:1;i:96;}}}s:7:\"symbols\";a:0:{}s:4:\"urls\";a:1:{i:0;O:8:\"stdClass\":4:{s:3:\"url\";s:22:\"http://t.co/SQNknDMnR3\";s:12:\"expanded_url\";s:45:\"http://m.kristeligt-dagblad.dk/artikel/530172\";s:11:\"display_url\";s:38:\"m.kristeligt-dagblad.dk/artikel/530172\";s:7:\"indices\";a:2:{i:0;i:106;i:1;i:128;}}}s:13:\"user_mentions\";a:0:{}}s:9:\"favorited\";b:0;s:9:\"retweeted\";b:0;s:18:\"possibly_sensitive\";b:0;s:4:\"lang\";s:2:\"da\";}s:13:\"retweet_count\";i:3;s:14:\"favorite_count\";i:0;s:8:\"entities\";O:8:\"stdClass\":4:{s:8:\"hashtags\";a:2:{i:0;O:8:\"stdClass\":2:{s:4:\"text\";s:16:\"stemmerpaakanten\";s:7:\"indices\";a:2:{i:0;i:88;i:1;i:105;}}i:1;O:8:\"stdClass\":2:{s:4:\"text\";s:4:\"kv13\";s:7:\"indices\";a:2:{i:0;i:110;i:1;i:115;}}}s:7:\"symbols\";a:0:{}s:4:\"urls\";a:0:{}s:13:\"user_mentions\";a:1:{i:0;O:8:\"stdClass\":5:{s:11:\"screen_name\";s:13:\"LisbethZornig\";s:4:\"name\";s:14:\"Lisbeth Zornig\";s:2:\"id\";i:1354082354;s:6:\"id_str\";s:10:\"1354082354\";s:7:\"indices\";a:2:{i:0;i:3;i:1;i:17;}}}}s:9:\"favorited\";b:0;s:9:\"retweeted\";b:0;s:4:\"lang\";s:2:\"da\";}', 0, '2013-10-22 22:54:04', 'text'),
(148135, 147, '392782301588762624', 'Twitter', '2013-10-22 22:39:33', '0000-00-00 00:00:00', 1352505030, 'nevadonoah', 'Noah Nevado', 'http://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252.jpeg', '', 'http://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png', 'http://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png', 'O:8:\"stdClass\":24:{s:8:\"metadata\";O:8:\"stdClass\":2:{s:11:\"result_type\";s:6:\"recent\";s:17:\"iso_language_code\";s:2:\"da\";}s:10:\"created_at\";s:30:\"Tue Oct 22 22:39:33 +0000 2013\";s:2:\"id\";i:392782301588762624;s:6:\"id_str\";s:18:\"392782301588762624\";s:4:\"text\";s:141:\"@AnetteStenfeldt Kvinder er i politik men unge er et særsyn. Kvinder stemmer men unge stemmer ej! #kv13 #htkom #fokus http://t.co/9D6wiwPHiZ\";s:6:\"source\";s:3:\"web\";s:9:\"truncated\";b:0;s:21:\"in_reply_to_status_id\";i:392779568882274304;s:25:\"in_reply_to_status_id_str\";s:18:\"392779568882274304\";s:19:\"in_reply_to_user_id\";i:64208613;s:23:\"in_reply_to_user_id_str\";s:8:\"64208613\";s:23:\"in_reply_to_screen_name\";s:15:\"AnetteStenfeldt\";s:4:\"user\";O:8:\"stdClass\":39:{s:2:\"id\";i:1352505030;s:6:\"id_str\";s:10:\"1352505030\";s:4:\"name\";s:11:\"Noah Nevado\";s:11:\"screen_name\";s:10:\"nevadonoah\";s:8:\"location\";s:10:\"Hedehusene\";s:11:\"description\";s:136:\"Politik, Børn & Unge, QPR Byrådskandidat i Høje Taastrup,\r\nHovedbestyrelse i Radikale Venstre\r\nAfdleder i Klub Bispebjerg Fritidsklub\";s:3:\"url\";s:22:\"http://t.co/nnC4v7r9fk\";s:8:\"entities\";O:8:\"stdClass\":2:{s:3:\"url\";O:8:\"stdClass\":1:{s:4:\"urls\";a:1:{i:0;O:8:\"stdClass\":4:{s:3:\"url\";s:22:\"http://t.co/nnC4v7r9fk\";s:12:\"expanded_url\";s:25:\"http://www.radikalehtk.dk\";s:11:\"display_url\";s:14:\"radikalehtk.dk\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:22;}}}}s:11:\"description\";O:8:\"stdClass\":1:{s:4:\"urls\";a:0:{}}}s:9:\"protected\";b:0;s:15:\"followers_count\";i:219;s:13:\"friends_count\";i:608;s:12:\"listed_count\";i:9;s:10:\"created_at\";s:30:\"Sun Apr 14 18:36:53 +0000 2013\";s:16:\"favourites_count\";i:4;s:10:\"utc_offset\";N;s:9:\"time_zone\";N;s:11:\"geo_enabled\";b:1;s:8:\"verified\";b:0;s:14:\"statuses_count\";i:1921;s:4:\"lang\";s:2:\"da\";s:20:\"contributors_enabled\";b:0;s:13:\"is_translator\";b:0;s:24:\"profile_background_color\";s:6:\"C0DEED\";s:28:\"profile_background_image_url\";s:48:\"http://abs.twimg.com/images/themes/theme1/bg.png\";s:34:\"profile_background_image_url_https\";s:49:\"https://abs.twimg.com/images/themes/theme1/bg.png\";s:23:\"profile_background_tile\";b:0;s:17:\"profile_image_url\";s:99:\"http://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252_normal.jpeg\";s:23:\"profile_image_url_https\";s:100:\"https://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252_normal.jpeg\";s:18:\"profile_banner_url\";s:59:\"https://pbs.twimg.com/profile_banners/1352505030/1376661459\";s:18:\"profile_link_color\";s:6:\"0084B4\";s:28:\"profile_sidebar_border_color\";s:6:\"C0DEED\";s:26:\"profile_sidebar_fill_color\";s:6:\"DDEEF6\";s:18:\"profile_text_color\";s:6:\"333333\";s:28:\"profile_use_background_image\";b:1;s:15:\"default_profile\";b:1;s:21:\"default_profile_image\";b:0;s:9:\"following\";b:0;s:19:\"follow_request_sent\";b:0;s:13:\"notifications\";b:0;}s:3:\"geo\";N;s:11:\"coordinates\";N;s:5:\"place\";N;s:12:\"contributors\";N;s:13:\"retweet_count\";i:0;s:14:\"favorite_count\";i:0;s:8:\"entities\";O:8:\"stdClass\":5:{s:8:\"hashtags\";a:3:{i:0;O:8:\"stdClass\":2:{s:4:\"text\";s:4:\"kv13\";s:7:\"indices\";a:2:{i:0;i:98;i:1;i:103;}}i:1;O:8:\"stdClass\":2:{s:4:\"text\";s:5:\"htkom\";s:7:\"indices\";a:2:{i:0;i:104;i:1;i:110;}}i:2;O:8:\"stdClass\":2:{s:4:\"text\";s:5:\"fokus\";s:7:\"indices\";a:2:{i:0;i:111;i:1;i:117;}}}s:7:\"symbols\";a:0:{}s:4:\"urls\";a:0:{}s:13:\"user_mentions\";a:1:{i:0;O:8:\"stdClass\":5:{s:11:\"screen_name\";s:15:\"AnetteStenfeldt\";s:4:\"name\";s:16:\"Anette Stenfeldt\";s:2:\"id\";i:64208613;s:6:\"id_str\";s:8:\"64208613\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:16;}}}s:5:\"media\";a:1:{i:0;O:8:\"stdClass\":10:{s:2:\"id\";i:392782301597151232;s:6:\"id_str\";s:18:\"392782301597151232\";s:7:\"indices\";a:2:{i:0;i:118;i:1;i:140;}s:9:\"media_url\";s:46:\"http://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png\";s:15:\"media_url_https\";s:47:\"https://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png\";s:3:\"url\";s:22:\"http://t.co/9D6wiwPHiZ\";s:11:\"display_url\";s:26:\"pic.twitter.com/9D6wiwPHiZ\";s:12:\"expanded_url\";s:63:\"http://twitter.com/nevadonoah/status/392782301588762624/photo/1\";s:4:\"type\";s:5:\"photo\";s:5:\"sizes\";O:8:\"stdClass\":4:{s:5:\"small\";O:8:\"stdClass\":3:{s:1:\"w\";i:340;s:1:\"h\";i:334;s:6:\"resize\";s:3:\"fit\";}s:5:\"large\";O:8:\"stdClass\":3:{s:1:\"w\";i:693;s:1:\"h\";i:681;s:6:\"resize\";s:3:\"fit\";}s:5:\"thumb\";O:8:\"stdClass\":3:{s:1:\"w\";i:150;s:1:\"h\";i:150;s:6:\"resize\";s:4:\"crop\";}s:6:\"medium\";O:8:\"stdClass\":3:{s:1:\"w\";i:600;s:1:\"h\";i:590;s:6:\"resize\";s:3:\"fit\";}}}}}s:9:\"favorited\";b:0;s:9:\"retweeted\";b:0;s:18:\"possibly_sensitive\";b:0;s:4:\"lang\";s:2:\"da\";}', 0, '2013-10-22 22:40:05', 'photo'),
(148134, 147, '392782301588762624', 'Twitter', '2013-10-22 22:39:33', '0000-00-00 00:00:00', 1352505030, 'nevadonoah', 'Noah Nevado', 'http://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252.jpeg', '@AnetteStenfeldt Kvinder er i politik men unge er et særsyn. Kvinder stemmer men unge stemmer ej! #kv13 #htkom #fokus http://t.co/9D6wiwPHiZ', '', '', 'O:8:\"stdClass\":24:{s:8:\"metadata\";O:8:\"stdClass\":2:{s:11:\"result_type\";s:6:\"recent\";s:17:\"iso_language_code\";s:2:\"da\";}s:10:\"created_at\";s:30:\"Tue Oct 22 22:39:33 +0000 2013\";s:2:\"id\";i:392782301588762624;s:6:\"id_str\";s:18:\"392782301588762624\";s:4:\"text\";s:141:\"@AnetteStenfeldt Kvinder er i politik men unge er et særsyn. Kvinder stemmer men unge stemmer ej! #kv13 #htkom #fokus http://t.co/9D6wiwPHiZ\";s:6:\"source\";s:3:\"web\";s:9:\"truncated\";b:0;s:21:\"in_reply_to_status_id\";i:392779568882274304;s:25:\"in_reply_to_status_id_str\";s:18:\"392779568882274304\";s:19:\"in_reply_to_user_id\";i:64208613;s:23:\"in_reply_to_user_id_str\";s:8:\"64208613\";s:23:\"in_reply_to_screen_name\";s:15:\"AnetteStenfeldt\";s:4:\"user\";O:8:\"stdClass\":39:{s:2:\"id\";i:1352505030;s:6:\"id_str\";s:10:\"1352505030\";s:4:\"name\";s:11:\"Noah Nevado\";s:11:\"screen_name\";s:10:\"nevadonoah\";s:8:\"location\";s:10:\"Hedehusene\";s:11:\"description\";s:136:\"Politik, Børn & Unge, QPR Byrådskandidat i Høje Taastrup,\r\nHovedbestyrelse i Radikale Venstre\r\nAfdleder i Klub Bispebjerg Fritidsklub\";s:3:\"url\";s:22:\"http://t.co/nnC4v7r9fk\";s:8:\"entities\";O:8:\"stdClass\":2:{s:3:\"url\";O:8:\"stdClass\":1:{s:4:\"urls\";a:1:{i:0;O:8:\"stdClass\":4:{s:3:\"url\";s:22:\"http://t.co/nnC4v7r9fk\";s:12:\"expanded_url\";s:25:\"http://www.radikalehtk.dk\";s:11:\"display_url\";s:14:\"radikalehtk.dk\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:22;}}}}s:11:\"description\";O:8:\"stdClass\":1:{s:4:\"urls\";a:0:{}}}s:9:\"protected\";b:0;s:15:\"followers_count\";i:219;s:13:\"friends_count\";i:608;s:12:\"listed_count\";i:9;s:10:\"created_at\";s:30:\"Sun Apr 14 18:36:53 +0000 2013\";s:16:\"favourites_count\";i:4;s:10:\"utc_offset\";N;s:9:\"time_zone\";N;s:11:\"geo_enabled\";b:1;s:8:\"verified\";b:0;s:14:\"statuses_count\";i:1921;s:4:\"lang\";s:2:\"da\";s:20:\"contributors_enabled\";b:0;s:13:\"is_translator\";b:0;s:24:\"profile_background_color\";s:6:\"C0DEED\";s:28:\"profile_background_image_url\";s:48:\"http://abs.twimg.com/images/themes/theme1/bg.png\";s:34:\"profile_background_image_url_https\";s:49:\"https://abs.twimg.com/images/themes/theme1/bg.png\";s:23:\"profile_background_tile\";b:0;s:17:\"profile_image_url\";s:99:\"http://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252_normal.jpeg\";s:23:\"profile_image_url_https\";s:100:\"https://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252_normal.jpeg\";s:18:\"profile_banner_url\";s:59:\"https://pbs.twimg.com/profile_banners/1352505030/1376661459\";s:18:\"profile_link_color\";s:6:\"0084B4\";s:28:\"profile_sidebar_border_color\";s:6:\"C0DEED\";s:26:\"profile_sidebar_fill_color\";s:6:\"DDEEF6\";s:18:\"profile_text_color\";s:6:\"333333\";s:28:\"profile_use_background_image\";b:1;s:15:\"default_profile\";b:1;s:21:\"default_profile_image\";b:0;s:9:\"following\";b:0;s:19:\"follow_request_sent\";b:0;s:13:\"notifications\";b:0;}s:3:\"geo\";N;s:11:\"coordinates\";N;s:5:\"place\";N;s:12:\"contributors\";N;s:13:\"retweet_count\";i:0;s:14:\"favorite_count\";i:0;s:8:\"entities\";O:8:\"stdClass\":5:{s:8:\"hashtags\";a:3:{i:0;O:8:\"stdClass\":2:{s:4:\"text\";s:4:\"kv13\";s:7:\"indices\";a:2:{i:0;i:98;i:1;i:103;}}i:1;O:8:\"stdClass\":2:{s:4:\"text\";s:5:\"htkom\";s:7:\"indices\";a:2:{i:0;i:104;i:1;i:110;}}i:2;O:8:\"stdClass\":2:{s:4:\"text\";s:5:\"fokus\";s:7:\"indices\";a:2:{i:0;i:111;i:1;i:117;}}}s:7:\"symbols\";a:0:{}s:4:\"urls\";a:0:{}s:13:\"user_mentions\";a:1:{i:0;O:8:\"stdClass\":5:{s:11:\"screen_name\";s:15:\"AnetteStenfeldt\";s:4:\"name\";s:16:\"Anette Stenfeldt\";s:2:\"id\";i:64208613;s:6:\"id_str\";s:8:\"64208613\";s:7:\"indices\";a:2:{i:0;i:0;i:1;i:16;}}}s:5:\"media\";a:1:{i:0;O:8:\"stdClass\":10:{s:2:\"id\";i:392782301597151232;s:6:\"id_str\";s:18:\"392782301597151232\";s:7:\"indices\";a:2:{i:0;i:118;i:1;i:140;}s:9:\"media_url\";s:46:\"http://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png\";s:15:\"media_url_https\";s:47:\"https://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png\";s:3:\"url\";s:22:\"http://t.co/9D6wiwPHiZ\";s:11:\"display_url\";s:26:\"pic.twitter.com/9D6wiwPHiZ\";s:12:\"expanded_url\";s:63:\"http://twitter.com/nevadonoah/status/392782301588762624/photo/1\";s:4:\"type\";s:5:\"photo\";s:5:\"sizes\";O:8:\"stdClass\":4:{s:5:\"small\";O:8:\"stdClass\":3:{s:1:\"w\";i:340;s:1:\"h\";i:334;s:6:\"resize\";s:3:\"fit\";}s:5:\"large\";O:8:\"stdClass\":3:{s:1:\"w\";i:693;s:1:\"h\";i:681;s:6:\"resize\";s:3:\"fit\";}s:5:\"thumb\";O:8:\"stdClass\":3:{s:1:\"w\";i:150;s:1:\"h\";i:150;s:6:\"resize\";s:4:\"crop\";}s:6:\"medium\";O:8:\"stdClass\":3:{s:1:\"w\";i:600;s:1:\"h\";i:590;s:6:\"resize\";s:3:\"fit\";}}}}}s:9:\"favorited\";b:0;s:9:\"retweeted\";b:0;s:18:\"possibly_sensitive\";b:0;s:4:\"lang\";s:2:\"da\";}', 0, '2013-10-22 22:40:05', 'text'),
(148133, 147, '392779568882274304', 'Twitter', '2013-10-22 22:28:41', '0000-00-00 00:00:00', 64208613, 'AnetteStenfeldt', 'Anette Stenfeldt', 'http://a0.twimg.com/profile_images/378800000491028334/1234f163fff142de8179e860026bbe0c.jpeg', '', 'http://pbs.twimg.com/media/BXNu79aCUAEDXGv.jpg', 'http://pbs.twimg.com/media/BXNu79aCUAEDXGv.jpg', 'O:8:\"stdClass\":24:{s:8:\"metadata\";O:8:\"stdClass\":2:{s:11:\"result_type\";s:6:\"recent\";s:17:\"iso_language_code\";s:2:\"da\";}s:10:\"created_at\";s:30:\"Tue Oct 22 22:28:41 +0000 2013\";s:2:\"id\";i:392779568882274304;s:6:\"id_str\";s:18:\"392779568882274304\";s:4:\"text\";s:113:\"Kvinder ind i politik - find din lokale kandidat #kv13 #vejlepol mød os d. 2.11. i Vejle. http://t.co/6LxDfbF1dm\";s:6:\"source\";s:3:\"web\";s:9:\"truncated\";b:0;s:21:\"in_reply_to_status_id\";N;s:25:\"in_reply_to_status_id_str\";N;s:19:\"in_reply_to_user_id\";N;s:23:\"in_reply_to_user_id_str\";N;s:23:\"in_reply_to_screen_name\";N;s:4:\"user\";O:8:\"stdClass\":39:{s:2:\"id\";i:64208613;s:6:\"id_str\";s:8:\"64208613\";s:4:\"name\";s:16:\"Anette Stenfeldt\";s:11:\"screen_name\";s:15:\"AnetteStenfeldt\";s:8:\"location\";s:14:\"Vejle, Denmark\";s:11:\"description\";s:153:\"Folkeskolelærer, tillidsrepræsentant, skolebibliotekar, mor til Clara og Thomas, gift med Jens. Er byrådskandidat for @socialdemokraterne #kv13 #dkpol\";s:3:\"url\";N;s:8:\"entities\";O:8:\"stdClass\":1:{s:11:\"description\";O:8:\"stdClass\":1:{s:4:\"urls\";a:0:{}}}s:9:\"protected\";b:0;s:15:\"followers_count\";i:52;s:13:\"friends_count\";i:130;s:12:\"listed_count\";i:2;s:10:\"created_at\";s:30:\"Sun Aug 09 17:02:17 +0000 2009\";s:16:\"favourites_count\";i:0;s:10:\"utc_offset\";i:7200;s:9:\"time_zone\";s:10:\"Copenhagen\";s:11:\"geo_enabled\";b:0;s:8:\"verified\";b:0;s:14:\"statuses_count\";i:70;s:4:\"lang\";s:2:\"en\";s:20:\"contributors_enabled\";b:0;s:13:\"is_translator\";b:0;s:24:\"profile_background_color\";s:6:\"352726\";s:28:\"profile_background_image_url\";s:48:\"http://abs.twimg.com/images/themes/theme5/bg.gif\";s:34:\"profile_background_image_url_https\";s:49:\"https://abs.twimg.com/images/themes/theme5/bg.gif\";s:23:\"profile_background_tile\";b:0;s:17:\"profile_image_url\";s:98:\"http://a0.twimg.com/profile_images/378800000491028334/1234f163fff142de8179e860026bbe0c_normal.jpeg\";s:23:\"profile_image_url_https\";s:100:\"https://si0.twimg.com/profile_images/378800000491028334/1234f163fff142de8179e860026bbe0c_normal.jpeg\";s:18:\"profile_banner_url\";s:57:\"https://pbs.twimg.com/profile_banners/64208613/1379830592\";s:18:\"profile_link_color\";s:6:\"D02B55\";s:28:\"profile_sidebar_border_color\";s:6:\"829D5E\";s:26:\"profile_sidebar_fill_color\";s:6:\"99CC33\";s:18:\"profile_text_color\";s:6:\"3E4415\";s:28:\"profile_use_background_image\";b:1;s:15:\"default_profile\";b:0;s:21:\"default_profile_image\";b:0;s:9:\"following\";b:0;s:19:\"follow_request_sent\";b:0;s:13:\"notifications\";b:0;}s:3:\"geo\";N;s:11:\"coordinates\";N;s:5:\"place\";N;s:12:\"contributors\";N;s:13:\"retweet_count\";i:0;s:14:\"favorite_count\";i:0;s:8:\"entities\";O:8:\"stdClass\":5:{s:8:\"hashtags\";a:2:{i:0;O:8:\"stdClass\":2:{s:4:\"text\";s:4:\"kv13\";s:7:\"indices\";a:2:{i:0;i:49;i:1;i:54;}}i:1;O:8:\"stdClass\":2:{s:4:\"text\";s:8:\"vejlepol\";s:7:\"indices\";a:2:{i:0;i:55;i:1;i:64;}}}s:7:\"symbols\";a:0:{}s:4:\"urls\";a:0:{}s:13:\"user_mentions\";a:0:{}s:5:\"media\";a:1:{i:0;O:8:\"stdClass\":10:{s:2:\"id\";i:392779568886468609;s:6:\"id_str\";s:18:\"392779568886468609\";s:7:\"indices\";a:2:{i:0;i:90;i:1;i:112;}s:9:\"media_url\";s:46:\"http://pbs.twimg.com/media/BXNu79aCUAEDXGv.jpg\";s:15:\"media_url_https\";s:47:\"https://pbs.twimg.com/media/BXNu79aCUAEDXGv.jpg\";s:3:\"url\";s:22:\"http://t.co/6LxDfbF1dm\";s:11:\"display_url\";s:26:\"pic.twitter.com/6LxDfbF1dm\";s:12:\"expanded_url\";s:68:\"http://twitter.com/AnetteStenfeldt/status/392779568882274304/photo/1\";s:4:\"type\";s:5:\"photo\";s:5:\"sizes\";O:8:\"stdClass\":4:{s:5:\"small\";O:8:\"stdClass\":3:{s:1:\"w\";i:340;s:1:\"h\";i:230;s:6:\"resize\";s:3:\"fit\";}s:6:\"medium\";O:8:\"stdClass\":3:{s:1:\"w\";i:600;s:1:\"h\";i:406;s:6:\"resize\";s:3:\"fit\";}s:5:\"thumb\";O:8:\"stdClass\":3:{s:1:\"w\";i:150;s:1:\"h\";i:150;s:6:\"resize\";s:4:\"crop\";}s:5:\"large\";O:8:\"stdClass\":3:{s:1:\"w\";i:960;s:1:\"h\";i:650;s:6:\"resize\";s:3:\"fit\";}}}}}s:9:\"favorited\";b:0;s:9:\"retweeted\";b:0;s:18:\"possibly_sensitive\";b:0;s:4:\"lang\";s:2:\"da\";}', 0, '2013-10-22 22:29:05', 'photo');
from node-mysql2.
Works for me with your data. Code:
var mysql = require('mysql2');
var pool = mysql.createPool({
user: 'root',
password: '',
database: 'test',
charset: 'LATIN1_SWEDISH_CI'
});
var limit = 20
var fields = 'stream_id, original_id, service, username, user_id, name, user_image, text, thumb_photo, large_photo, UNIX_TIMESTAMP(created_on) AS created_on, UNIX_TIMESTAMP(saved_on) AS saved_on, created_on as creation, admin_entry, type';
var sql = 'SELECT ' + fields + ' FROM stream WHERE event_id = ?';
sql += ' ORDER BY created_on DESC';
sql += ' LIMIT ?';
var id = 147;
pool.getConnection(function (err, connection) {
var param = [id, connection.escape(limit)];
connection.execute(sql, param, function (err, rows) {
console.log(rows);
connection.end();
});
});
output:
[ { stream_id: 148138,
original_id: '392789221548625920',
service: 'Twitter',
username: 'twillumsgaard',
user_id: 7128982,
name: 'Erik Willumsgaard',
user_image: 'http://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf.jpeg',
text: '@lytken Jamen, det er jo let med flere p-pladser.Nedlæg torve, legepladser,parker og fodboldbaner? Eller hvad? :) #kbhpol #kv13',
thumb_photo: '',
large_photo: '',
created_on: 1382443622,
saved_on: 1382443684,
creation: Fri Nov 22 2013 23:07:02 GMT+1100 (EST),
admin_entry: 0,
type: 'text' },
{ stream_id: 148137,
original_id: '392788521557061632',
service: 'Twitter',
username: 'twillumsgaard',
user_id: 7128982,
name: 'Erik Willumsgaard',
user_image: 'http://pbs.twimg.com/profile_images/378800000605022528/9f3289573c8a70d6e38b5baa71247adf.jpeg',
text: '@HISonne @MiaNyegaard @amgeisler - Det er hele kulturen i Handicapcenter Kbh og SOF, der skal have en ordentlig overhaling! #kv13 #kbhpol',
thumb_photo: '',
large_photo: '',
created_on: 1382443455,
saved_on: 1382443504,
creation: Fri Nov 22 2013 23:04:15 GMT+1100 (EST),
admin_entry: 0,
type: 'text' },
{ stream_id: 148136,
original_id: '392785701055787008',
service: 'Twitter',
username: 'chrpeder',
user_id: 15097746,
name: 'Christian R Pedersen',
user_image: 'http://a0.twimg.com/profile_images/378800000548692102/b6b2aca4ff6002570e3e893ddadc1d58.jpeg',
var mysql = require('mysql2');
text: 'RT @LisbethZornig: Jeg er imponeret over de kirkelige organisationers arbejde for at få #stemmerpaakanten til #kv13 d 19 nov http://t.co/SQ…',
thumb_photo: '',
large_photo: '',
created_on: 1382442783,
saved_on: 1382442844,
creation: Fri Nov 22 2013 22:53:03 GMT+1100 (EST),
admin_entry: 0,
type: 'text' },
{ stream_id: 148135,
original_id: '392782301588762624',
service: 'Twitter',
username: 'nevadonoah',
user_id: 1352505030,
name: 'Noah Nevado',
user_image: 'http://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252.jpeg',
text: '',
thumb_photo: 'http://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png',
large_photo: 'http://pbs.twimg.com/media/BXNxbBjCMAAz5Vl.png',
created_on: 1382441973,
saved_on: 1382442005,
creation: Fri Nov 22 2013 22:39:33 GMT+1100 (EST),
admin_entry: 0,
type: 'photo' },
{ stream_id: 148134,
original_id: '392782301588762624',
service: 'Twitter',
username: 'nevadonoah',
user_id: 1352505030,
name: 'Noah Nevado',
user_image: 'http://pbs.twimg.com/profile_images/378800000237329474/d5849d87d9d852ae0586e699fc348252.jpeg',
text: '@AnetteStenfeldt Kvinder er i politik men unge er et særsyn. Kvinder stemmer men unge stemmer ej! #kv13 #htkom #fokus http://t.co/9D6wiwPHiZ',
thumb_photo: '',
large_photo: '',
created_on: 1382441973,
saved_on: 1382442005,
creation: Fri Nov 22 2013 22:39:33 GMT+1100 (EST),
admin_entry: 0,
type: 'text' },
{ stream_id: 148133,
original_id: '392779568882274304',
service: 'Twitter',
username: 'AnetteStenfeldt',
user_id: 64208613,
name: 'Anette Stenfeldt',
user_image: 'http://a0.twimg.com/profile_images/378800000491028334/1234f163fff142de8179e860026bbe0c.jpeg',
text: '',
thumb_photo: 'http://pbs.twimg.com/media/BXNu79aCUAEDXGv.jpg',
large_photo: 'http://pbs.twimg.com/media/BXNu79aCUAEDXGv.jpg',
created_on: 1382441321,
saved_on: 1382441345,
creation: Fri Nov 22 2013 22:28:41 GMT+1100 (EST),
admin_entry: 0,
type: 'photo' } ]
from node-mysql2.
The problem was as expected on our end. Sorry for the wasted time.
from node-mysql2.
Related Issues (20)
- `bigNumberStrings: true` is not respected for LIMIT and OFFSET
- Is there any way to get this library to set the SNI field when establishing a TLS connection? HOT 2
- Type 'Query' must have a '[Symbol.iterator]()' method that returns an iterator.ts(2488) Exception HOT 1
- re escaping special chars in json values HOT 1
- Timeout since 3.9.4 HOT 2
- HANDSHAKE_SSL_ERROR with RDS and 3.9.3+ HOT 12
- Can't create more than max prepared stmtount statements(current value: 16382) HOT 4
- Release 3.9.4 breaks code that depended on .hasOwnProperty() HOT 3
- got warning when host is an IP address HOT 1
- Transaction issue in my code. Please Help!
- read ECONNRESET after upgrading HOT 9
- typeCast: false causes out of bounds reads to packet when result set contains NULL values and binary protocol is used.
- README documentation HOT 1
- True negative: ssl-mode query params in connectionString considered as invalid HOT 1
- TypeError: LRU is not a constructor HOT 3
- PoolConnection.execute() retrun object v3.9.7 HOT 6
- Deadlock found when trying to get lock HOT 3
- [createConnection] Can't add new command when connection is in closed state HOT 8
- Sporadic read ETIMEDOUT error HOT 9
- Incorrect typings lead to pool.destroy is not a function HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 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.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
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.
from node-mysql2.