· 9 years ago · Feb 03, 2016, 04:09 AM
1executing Read
2looking for product 0 of 3
3doc ni:
4{ _id: 5698a6168807ab64067a6bad,
5 styx_name: 'My Product Photo hello',
6 short_description: 'One fine weekend, Andrew and his cuddly little muchkin friends went to IHOP to reward themselves for doing a great job over the week.',
7 styx_type: 'P',
8 pin_icon: 'sic:pricetag',
9 theme: 'theme2',
10 color_theme: { color1: '#9C27B1', color2: '#E91E63', color3: '#ffffff' },
11 owner: 1,
12 duration: 0,
13 width: 0,
14 height: 0,
15 items:
16 [ { y: 70.98, x: 12.5, prod: [Object] },
17 { y: 61.83, x: 86.75, prod: [Object] },
18 { y: 1.26, x: 9.75, prod: [Object] } ],
19 products: [ 1, 2, 3 ],
20 product_pool: [ 1, 2, 3 ],
21 uuid_v1: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
22 date_simple: '2016-02-03 11:33:28',
23 date_unix: 1454470408,
24 date_updated: 1452844564,
25 date_updated_simple: '2016-01-15 15:56:04',
26 styx_id: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
27 prev_uuid_v1: 'e39048c0-ca26-11e5-8d9d-db253276affd',
28 owner_info:
29 [ RowDataPacket {
30 user_id: 1,
31 date_added: Tue Nov 24 2015 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
32 temp_sessionid: 'abcd123',
33 user_type: 'V',
34 username: 'ajpyoung',
35 email: 'andrewjohnyoung@gmail.com',
36 registration_type: 'STANDARD',
37 firstname: 'Andrew',
38 lastname: 'Young',
39 display_name: 'AYoung',
40 gender: 'M',
41 birthdate: Tue Aug 26 1975 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
42 alias: null,
43 social_account: 'FB',
44 about: '1',
45 active: 'Y',
46 premium_type: 1,
47 api_signature: null,
48 api_key: null,
49 reset_password: null,
50 reset_pass_timestamp: null,
51 register_key: '1',
52 promoter_paypal_email: 'andrewjohnyoung@gmail.com',
53 country_code: 'PH',
54 user_picture: '1',
55 user_picture_display: 1,
56 timezone: 'America/Los_Angeles',
57 total_product: 0,
58 total_collection: 0,
59 total_follower: 0,
60 total_following: 0,
61 twitter_id: '0',
62 twitter_screename: '0',
63 oauth_token: '0',
64 oauth_secret: '0',
65 registered_via: 0,
66 total_username_change: 0,
67 total_password_retry: 0 } ] }
68looking for product 1 of 3
69doc ni:
70{ _id: 5698a6168807ab64067a6bad,
71 styx_name: 'My Product Photo hello',
72 short_description: 'One fine weekend, Andrew and his cuddly little muchkin friends went to IHOP to reward themselves for doing a great job over the week.',
73 styx_type: 'P',
74 pin_icon: 'sic:pricetag',
75 theme: 'theme2',
76 color_theme: { color1: '#9C27B1', color2: '#E91E63', color3: '#ffffff' },
77 owner: 1,
78 duration: 0,
79 width: 0,
80 height: 0,
81 items:
82 [ { y: 70.98, x: 12.5, prod: [Object] },
83 { y: 61.83, x: 86.75, prod: [Object] },
84 { y: 1.26, x: 9.75, prod: [Object] } ],
85 products: [ 1, 2, 3 ],
86 product_pool: [ 1, 2, 3 ],
87 uuid_v1: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
88 date_simple: '2016-02-03 11:33:28',
89 date_unix: 1454470408,
90 date_updated: 1452844564,
91 date_updated_simple: '2016-01-15 15:56:04',
92 styx_id: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
93 prev_uuid_v1: 'e39048c0-ca26-11e5-8d9d-db253276affd',
94 owner_info:
95 [ RowDataPacket {
96 user_id: 1,
97 date_added: Tue Nov 24 2015 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
98 temp_sessionid: 'abcd123',
99 user_type: 'V',
100 username: 'ajpyoung',
101 email: 'andrewjohnyoung@gmail.com',
102 registration_type: 'STANDARD',
103 firstname: 'Andrew',
104 lastname: 'Young',
105 display_name: 'AYoung',
106 gender: 'M',
107 birthdate: Tue Aug 26 1975 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
108 alias: null,
109 social_account: 'FB',
110 about: '1',
111 active: 'Y',
112 premium_type: 1,
113 api_signature: null,
114 api_key: null,
115 reset_password: null,
116 reset_pass_timestamp: null,
117 register_key: '1',
118 promoter_paypal_email: 'andrewjohnyoung@gmail.com',
119 country_code: 'PH',
120 user_picture: '1',
121 user_picture_display: 1,
122 timezone: 'America/Los_Angeles',
123 total_product: 0,
124 total_collection: 0,
125 total_follower: 0,
126 total_following: 0,
127 twitter_id: '0',
128 twitter_screename: '0',
129 oauth_token: '0',
130 oauth_secret: '0',
131 registered_via: 0,
132 total_username_change: 0,
133 total_password_retry: 0 } ] }
134looking for product 2 of 3
135doc ni:
136{ _id: 5698a6168807ab64067a6bad,
137 styx_name: 'My Product Photo hello',
138 short_description: 'One fine weekend, Andrew and his cuddly little muchkin friends went to IHOP to reward themselves for doing a great job over the week.',
139 styx_type: 'P',
140 pin_icon: 'sic:pricetag',
141 theme: 'theme2',
142 color_theme: { color1: '#9C27B1', color2: '#E91E63', color3: '#ffffff' },
143 owner: 1,
144 duration: 0,
145 width: 0,
146 height: 0,
147 items:
148 [ { y: 70.98, x: 12.5, prod: [Object] },
149 { y: 61.83, x: 86.75, prod: [Object] },
150 { y: 1.26, x: 9.75, prod: [Object] } ],
151 products: [ 1, 2, 3 ],
152 product_pool: [ 1, 2, 3 ],
153 uuid_v1: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
154 date_simple: '2016-02-03 11:33:28',
155 date_unix: 1454470408,
156 date_updated: 1452844564,
157 date_updated_simple: '2016-01-15 15:56:04',
158 styx_id: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
159 prev_uuid_v1: 'e39048c0-ca26-11e5-8d9d-db253276affd',
160 owner_info:
161 [ RowDataPacket {
162 user_id: 1,
163 date_added: Tue Nov 24 2015 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
164 temp_sessionid: 'abcd123',
165 user_type: 'V',
166 username: 'ajpyoung',
167 email: 'andrewjohnyoung@gmail.com',
168 registration_type: 'STANDARD',
169 firstname: 'Andrew',
170 lastname: 'Young',
171 display_name: 'AYoung',
172 gender: 'M',
173 birthdate: Tue Aug 26 1975 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
174 alias: null,
175 social_account: 'FB',
176 about: '1',
177 active: 'Y',
178 premium_type: 1,
179 api_signature: null,
180 api_key: null,
181 reset_password: null,
182 reset_pass_timestamp: null,
183 register_key: '1',
184 promoter_paypal_email: 'andrewjohnyoung@gmail.com',
185 country_code: 'PH',
186 user_picture: '1',
187 user_picture_display: 1,
188 timezone: 'America/Los_Angeles',
189 total_product: 0,
190 total_collection: 0,
191 total_follower: 0,
192 total_following: 0,
193 twitter_id: '0',
194 twitter_screename: '0',
195 oauth_token: '0',
196 oauth_secret: '0',
197 registered_via: 0,
198 total_username_change: 0,
199 total_password_retry: 0 } ] }
200looking for product 3 of 3
201doc ni:
202{ _id: 5698a6168807ab64067a6bad,
203 styx_name: 'My Product Photo hello',
204 short_description: 'One fine weekend, Andrew and his cuddly little muchkin friends went to IHOP to reward themselves for doing a great job over the week.',
205 styx_type: 'P',
206 pin_icon: 'sic:pricetag',
207 theme: 'theme2',
208 color_theme: { color1: '#9C27B1', color2: '#E91E63', color3: '#ffffff' },
209 owner: 1,
210 duration: 0,
211 width: 0,
212 height: 0,
213 items:
214 [ { y: 70.98, x: 12.5, prod: [Object] },
215 { y: 61.83, x: 86.75, prod: [Object] },
216 { y: 1.26, x: 9.75, prod: [Object] } ],
217 products: [ 1, 2, 3 ],
218 product_pool: [ 1, 2, 3 ],
219 uuid_v1: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
220 date_simple: '2016-02-03 11:33:28',
221 date_unix: 1454470408,
222 date_updated: 1452844564,
223 date_updated_simple: '2016-01-15 15:56:04',
224 styx_id: '6d800fd0-bb5d-11e5-a25a-0d27cfcadca7dondo',
225 prev_uuid_v1: 'e39048c0-ca26-11e5-8d9d-db253276affd',
226 owner_info:
227 [ RowDataPacket {
228 user_id: 1,
229 date_added: Tue Nov 24 2015 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
230 temp_sessionid: 'abcd123',
231 user_type: 'V',
232 username: 'ajpyoung',
233 email: 'andrewjohnyoung@gmail.com',
234 registration_type: 'STANDARD',
235 firstname: 'Andrew',
236 lastname: 'Young',
237 display_name: 'AYoung',
238 gender: 'M',
239 birthdate: Tue Aug 26 1975 00:00:00 GMT+0800 (Malay Peninsula Standard Time),
240 alias: null,
241 social_account: 'FB',
242 about: '1',
243 active: 'Y',
244 premium_type: 1,
245 api_signature: null,
246 api_key: null,
247 reset_password: null,
248 reset_pass_timestamp: null,
249 register_key: '1',
250 promoter_paypal_email: 'andrewjohnyoung@gmail.com',
251 country_code: 'PH',
252 user_picture: '1',
253 user_picture_display: 1,
254 timezone: 'America/Los_Angeles',
255 total_product: 0,
256 total_collection: 0,
257 total_follower: 0,
258 total_following: 0,
259 twitter_id: '0',
260 twitter_screename: '0',
261 oauth_token: '0',
262 oauth_secret: '0',
263 registered_via: 0,
264 total_username_change: 0,
265 total_password_retry: 0 } ] }
266TypeError: Cannot read property 'prod' of undefined
267 at extractProductInfo (D:\projects\shopstyx_node\advertisement_ugc_api\server\Routines\Advertisement\v2\admin\readAdvert.js:157:85)
268 at checkX (D:\projects\shopstyx_node\advertisement_ugc_api\server\Routines\Advertisement\v2\admin\readAdvert.js:281:3)
269 at Query._callback (D:\projects\shopstyx_node\advertisement_ugc_api\server\Routines\Advertisement\v2\admin\readAdvert.js:205:16)
270 at Query.Sequence.end (D:\projects\shopstyx_node\commonnodeconfig\node_modules\mysql\lib\protocol\sequences\Sequence.js:96:24)
271 at Query._handleFinalResultPacket (D:\projects\shopstyx_node\commonnodeconfig\node_modules\mysql\lib\protocol\sequences\Query.js:144:8)
272 at Query.EofPacket (D:\projects\shopstyx_node\commonnodeconfig\node_modules\mysql\lib\protocol\sequences\Query.js:128:8)
273 at Protocol._parsePacket (D:\projects\shopstyx_node\commonnodeconfig\node_modules\mysql\lib\protocol\Protocol.js:280:23)
274 at Parser.write (D:\projects\shopstyx_node\commonnodeconfig\node_modules\mysql\lib\protocol\Parser.js:73:12)
275 at Protocol.write (D:\projects\shopstyx_node\commonnodeconfig\node_modules\mysql\lib\protocol\Protocol.js:39:16)
276 at Socket.<anonymous> (D:\projects\shopstyx_node\commonnodeconfig\node_modules\mysql\lib\Connection.js:96:28)
277
278D:\projects\shopstyx_node\advertisement_ugc_api>