· 7 years ago · Sep 10, 2018, 07:44 PM
1PDOException Object
2(
3 [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
4 [string:Exception:private] =>
5 [code:protected] => 42000
6 [file:protected] => /var/www/html/magento/lib/Zend/Db/Statement/Pdo.php
7 [line:protected] => 228
8 [trace:Exception:private] => Array
9 (
10 [0] => Array
11 (
12 [file] => /var/www/html/magento/lib/Zend/Db/Statement/Pdo.php
13 [line] => 228
14 [function] => execute
15 [class] => PDOStatement
16 [type] => ->
17 [args] => Array
18 (
19 [0] => Array
20 (
21 )
22
23 )
24
25 )
26
27 [1] => Array
28 (
29 [file] => /var/www/html/magento/lib/Varien/Db/Statement/Pdo/Mysql.php
30 [line] => 110
31 [function] => _execute
32 [class] => Zend_Db_Statement_Pdo
33 [type] => ->
34 [args] => Array
35 (
36 [0] => Array
37 (
38 )
39
40 )
41
42 )
43
44 [2] => Array
45 (
46 [file] => /var/www/html/magento/app/code/core/Zend/Db/Statement.php
47 [line] => 291
48 [function] => _execute
49 [class] => Varien_Db_Statement_Pdo_Mysql
50 [type] => ->
51 [args] => Array
52 (
53 [0] => Array
54 (
55 )
56
57 )
58
59 )
60
61 [3] => Array
62 (
63 [file] => /var/www/html/magento/lib/Zend/Db/Adapter/Abstract.php
64 [line] => 480
65 [function] => execute
66 [class] => Zend_Db_Statement
67 [type] => ->
68 [args] => Array
69 (
70 [0] => Array
71 (
72 )
73
74 )
75
76 )
77
78 [4] => Array
79 (
80 [file] => /var/www/html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php
81 [line] => 238
82 [function] => query
83 [class] => Zend_Db_Adapter_Abstract
84 [type] => ->
85 [args] => Array
86 (
87 [0] => CREATE TABLE IF NOT EXISTS `oziway_salestechnique_article` (
88 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
89 `user_id` int(10) NOT NULL,
90 `title` varchar(45) NOT NULL,
91 `content` varchar(4000) DEFAULT NULL,
92 `active` int(1) DEFAULT NULL
93 [1] => Array
94 (
95 )
96
97 )
98
99 )
100
101 [5] => Array
102 (
103 [file] => /var/www/html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
104 [line] => 504
105 [function] => query
106 [class] => Zend_Db_Adapter_Pdo_Abstract
107 [type] => ->
108 [args] => Array
109 (
110 [0] => CREATE TABLE IF NOT EXISTS `oziway_salestechnique_article` (
111 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
112 `user_id` int(10) NOT NULL,
113 `title` varchar(45) NOT NULL,
114 `content` varchar(4000) DEFAULT NULL,
115 `active` int(1) DEFAULT NULL
116 [1] => Array
117 (
118 )
119
120 )
121
122 )
123
124 [6] => Array
125 (
126 [file] => /var/www/html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
127 [line] => 423
128 [function] => query
129 [class] => Varien_Db_Adapter_Pdo_Mysql
130 [type] => ->
131 [args] => Array
132 (
133 [0] => CREATE TABLE IF NOT EXISTS `oziway_salestechnique_article` (
134 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
135 `user_id` int(10) NOT NULL,
136 `title` varchar(45) NOT NULL,
137 `content` varchar(4000) DEFAULT NULL,
138 `active` int(1) DEFAULT NULL
139 )
140
141 )
142
143 [7] => Array
144 (
145 [file] => /var/www/html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
146 [line] => 693
147 [function] => raw_query
148 [class] => Varien_Db_Adapter_Pdo_Mysql
149 [type] => ->
150 [args] => Array
151 (
152 [0] => CREATE TABLE IF NOT EXISTS `oziway_salestechnique_article` (
153 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
154 `user_id` int(10) NOT NULL,
155 `title` varchar(45) NOT NULL,
156 `content` varchar(4000) DEFAULT NULL,
157 `active` int(1) DEFAULT NULL
158 )
159
160 )
161
162 [8] => Array
163 (
164 [file] => /var/www/html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
165 [line] => 675
166 [function] => multi_query
167 [class] => Varien_Db_Adapter_Pdo_Mysql
168 [type] => ->
169 [args] => Array
170 (
171 [0] =>
172CREATE TABLE IF NOT EXISTS `oziway_salestechnique_article` (
173 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
174 `user_id` int(10) NOT NULL,
175 `title` varchar(45) NOT NULL,
176 `content` varchar(4000) DEFAULT NULL,
177 `active` int(1) DEFAULT NULL;
178 `creation_time` datetime DEFAULT CURRENT_TIMESTAMP,
179 `modification_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
180);
181
182CREATE TABLE IF NOT EXISTS `oziway_salestechnique_rate` (
183 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
184 `article_id` int(11) NOT NULL,
185 `rate_up` int(11) DEFAULT NULL,
186 `rate_down` int(11) DEFAULT NULL,
187 `user_id` int(10) NOT NULL
188);
189
190ALTER TABLE `oziway_salestechnique_article`
191CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
192
193ALTER TABLE `oziway_salestechnique_article`
194CHANGE COLUMN `title` `title` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL ,
195CHANGE COLUMN `content` `content` VARCHAR(4000) CHARACTER SET 'utf8' NULL DEFAULT NULL ;
196
197
198 )
199
200 )
201
202 [9] => Array
203 (
204 [file] => /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
205 [line] => 933
206 [function] => multiQuery
207 [class] => Varien_Db_Adapter_Pdo_Mysql
208 [type] => ->
209 [args] => Array
210 (
211 [0] =>
212CREATE TABLE IF NOT EXISTS `oziway_salestechnique_article` (
213 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
214 `user_id` int(10) NOT NULL,
215 `title` varchar(45) NOT NULL,
216 `content` varchar(4000) DEFAULT NULL,
217 `active` int(1) DEFAULT NULL;
218 `creation_time` datetime DEFAULT CURRENT_TIMESTAMP,
219 `modification_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
220);
221
222CREATE TABLE IF NOT EXISTS `oziway_salestechnique_rate` (
223 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
224 `article_id` int(11) NOT NULL,
225 `rate_up` int(11) DEFAULT NULL,
226 `rate_down` int(11) DEFAULT NULL,
227 `user_id` int(10) NOT NULL
228);
229
230ALTER TABLE `oziway_salestechnique_article`
231CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
232
233ALTER TABLE `oziway_salestechnique_article`
234CHANGE COLUMN `title` `title` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL ,
235CHANGE COLUMN `content` `content` VARCHAR(4000) CHARACTER SET 'utf8' NULL DEFAULT NULL ;
236
237
238 )
239
240 )
241
242 [10] => Array
243 (
244 [file] => /var/www/html/magento/app/code/local/Oziway/SalesTechnique/sql/oziway_salestechnique_setup/mysql4-install-1.0.0.php
245 [line] => 32
246 [function] => run
247 [class] => Mage_Core_Model_Resource_Setup
248 [type] => ->
249 [args] => Array
250 (
251 [0] =>
252CREATE TABLE IF NOT EXISTS `oziway_salestechnique_article` (
253 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
254 `user_id` int(10) NOT NULL,
255 `title` varchar(45) NOT NULL,
256 `content` varchar(4000) DEFAULT NULL,
257 `active` int(1) DEFAULT NULL;
258 `creation_time` datetime DEFAULT CURRENT_TIMESTAMP,
259 `modification_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
260);
261
262CREATE TABLE IF NOT EXISTS `oziway_salestechnique_rate` (
263 `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
264 `article_id` int(11) NOT NULL,
265 `rate_up` int(11) DEFAULT NULL,
266 `rate_down` int(11) DEFAULT NULL,
267 `user_id` int(10) NOT NULL
268);
269
270ALTER TABLE `oziway_salestechnique_article`
271CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
272
273ALTER TABLE `oziway_salestechnique_article`
274CHANGE COLUMN `title` `title` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL ,
275CHANGE COLUMN `content` `content` VARCHAR(4000) CHARACTER SET 'utf8' NULL DEFAULT NULL ;
276
277
278 )
279
280 )
281
282 [11] => Array
283 (
284 [file] => /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
285 [line] => 624
286 [args] => Array
287 (
288 [0] => /var/www/html/magento/app/code/local/Oziway/SalesTechnique/sql/oziway_salestechnique_setup/mysql4-install-1.0.0.php
289 )
290
291 [function] => include
292 )
293
294 [12] => Array
295 (
296 [file] => /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
297 [line] => 421
298 [function] => _modifyResourceDb
299 [class] => Mage_Core_Model_Resource_Setup
300 [type] => ->
301 [args] => Array
302 (
303 [0] => install
304 [1] =>
305 [2] => 1.0.0
306 )
307
308 )
309
310 [13] => Array
311 (
312 [file] => /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
313 [line] => 327
314 [function] => _installResourceDb
315 [class] => Mage_Core_Model_Resource_Setup
316 [type] => ->
317 [args] => Array
318 (
319 [0] => 1.0.0
320 )
321
322 )
323
324 [14] => Array
325 (
326 [file] => /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
327 [line] => 235
328 [function] => applyUpdates
329 [class] => Mage_Core_Model_Resource_Setup
330 [type] => ->
331 [args] => Array
332 (
333 )
334
335 )
336
337 [15] => Array
338 (
339 [file] => /var/www/html/magento/app/code/core/Mage/Core/Model/App.php
340 [line] => 428
341 [function] => applyAllUpdates
342 [class] => Mage_Core_Model_Resource_Setup
343 [type] => ::
344 [args] => Array
345 (
346 )
347
348 )
349
350 [16] => Array
351 (
352 [file] => /var/www/html/magento/app/code/core/Mage/Core/Model/App.php
353 [line] => 354
354 [function] => _initModules
355 [class] => Mage_Core_Model_App
356 [type] => ->
357 [args] => Array
358 (
359 )
360
361 )
362
363 [17] => Array
364 (
365 [file] => /var/www/html/magento/app/Mage.php
366 [line] => 684
367 [function] => run
368 [class] => Mage_Core_Model_App
369 [type] => ->
370 [args] => Array
371 (
372 [0] => Array
373 (
374 [scope_code] => oziwaynet
375 [scope_type] => store
376 [options] => Array
377 (
378 )
379
380 )
381
382 )
383
384 )
385
386 [18] => Array
387 (
388 [file] => /var/www/html/magento/index.php
389 [line] => 158
390 [function] => run
391 [class] => Mage
392 [type] => ::
393 [args] => Array
394 (
395 [0] => oziwaynet
396 [1] => store
397 )
398
399 )
400
401 )
402
403 [previous:Exception:private] =>
404 [errorInfo] => Array
405 (
406 [0] => 42000
407 [1] => 1064
408 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
409 )
410
411)
412Error in file: "/var/www/html/magento/app/code/local/Oziway/SalesTechnique/sql/oziway_salestechnique_setup/mysql4-install-1.0.0.php" - SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
413
414#0 /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
415#1 /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '1.0.0')
416#2 /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('1.0.0')
417#3 /var/www/html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
418#4 /var/www/html/magento/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
419#5 /var/www/html/magento/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()
420#6 /var/www/html/magento/app/Mage.php(684): Mage_Core_Model_App->run(Array)
421#7 /var/www/html/magento/index.php(158): Mage::run('oziwaynet', 'store')
422#8 {main}