· 8 years ago · Jan 27, 2018, 12:18 AM
1PDOException Object
2(
3 [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'ai_jumboni_category' already exists
4 [string:Exception:private] =>
5 [code:protected] => 42S01
6 [file:protected] => /Users/adampicitelli/projects/adorama-magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
7 [line:protected] => 276
8 [trace:Exception:private] => Array
9 (
10 [0] => Array
11 (
12 [file] => /Users/adampicitelli/projects/adorama-magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
13 [line] => 276
14 [function] => query
15 [class] => PDO
16 [type] => ->
17 [args] => Array
18 (
19 [0] => -- DROP TABLE IF EXISTS ai_jumboni_category;
20CREATE TABLE ai_jumboni_category (
21 `jum_cat_id` int(11) unsigned NOT NULL auto_increment,
22 `name` varchar(255) NOT NULL,
23 `icon` varchar(255) NOT NULL,
24 `catposition` text NOT NULL,
25 `created_time` datetime DEFAULT NULL,
26 `update_time` datetime DEFAULT NULL,
27 PRIMARY KEY (`jum_cat_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8
29 )
30
31 )
32
33 [1] => Array
34 (
35 [file] => /Users/adampicitelli/projects/adorama-magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
36 [line] => 397
37 [function] => raw_query
38 [class] => Varien_Db_Adapter_Pdo_Mysql
39 [type] => ->
40 [args] => Array
41 (
42 [0] => -- DROP TABLE IF EXISTS ai_jumboni_category;
43CREATE TABLE ai_jumboni_category (
44 `jum_cat_id` int(11) unsigned NOT NULL auto_increment,
45 `name` varchar(255) NOT NULL,
46 `icon` varchar(255) NOT NULL,
47 `catposition` text NOT NULL,
48 `created_time` datetime DEFAULT NULL,
49 `update_time` datetime DEFAULT NULL,
50 PRIMARY KEY (`jum_cat_id`)
51) ENGINE=InnoDB DEFAULT CHARSET=utf8
52 )
53
54 )
55
56 [2] => Array
57 (
58 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php
59 [line] => 636
60 [function] => multi_query
61 [class] => Varien_Db_Adapter_Pdo_Mysql
62 [type] => ->
63 [args] => Array
64 (
65 [0] =>
66
67
68-- DROP TABLE IF EXISTS ai_jumboni_category;
69CREATE TABLE ai_jumboni_category (
70 `jum_cat_id` int(11) unsigned NOT NULL auto_increment,
71 `name` varchar(255) NOT NULL,
72 `icon` varchar(255) NOT NULL,
73 `catposition` text NOT NULL,
74 `created_time` datetime DEFAULT NULL,
75 `update_time` datetime DEFAULT NULL,
76 PRIMARY KEY (`jum_cat_id`)
77) ENGINE=InnoDB DEFAULT CHARSET=utf8;
78
79-- DROP TABLE IF EXISTS ai_jumboni_category_catalog_category_assoc;
80CREATE TABLE IF NOT EXISTS `ai_jumboni_category_catalog_category_assoc` (
81 `prod_cat_id` int(11) NOT NULL,
82 `jum_cat_id` int(11) NOT NULL,
83 `position` int(11) NOT NULL,
84) ENGINE=InnoDB DEFAULT CHARSET=utf8;
85
86-- DROP TABLE IF EXISTS ai_jumboni_category_link_assoc;
87CREATE TABLE IF NOT EXISTS `ai_jumboni_category_link_assoc` (
88 `link_id` int(11) NOT NULL,
89 `jum_cat_id` int(11) NOT NULL,
90 `position` int(11) NOT NULL,
91) ENGINE=MyISAM DEFAULT CHARSET=utf8;
92
93
94-- DROP TABLE IF EXISTS ai_jumboni_category_tout_assoc;
95CREATE TABLE IF NOT EXISTS `ai_jumboni_category_tout_assoc` (
96 `tout_id` int(11) NOT NULL AUTO_INCREMENT,
97 `jum_cat_id` int(11) NOT NULL,
98 `position` int(11) NOT NULL,
99) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
100
101-- DROP TABLE IF EXISTS ai_jumboni_link;
102CREATE TABLE ai_jumboni_link (
103 `link_id` int(11) NOT NULL AUTO_INCREMENT,
104 `text` varchar(50) NOT NULL,
105 `url` varchar(50) NOT NULL,
106 `new_window` tinyint(1) NOT NULL,
107 PRIMARY KEY (`link_id`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8;
109
110
111 )
112
113 )
114
115 [3] => Array
116 (
117 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/local/Ai/Jumboni/sql/jumboni_setup/mysql4-install-0.1.0.php
118 [line] => 56
119 [function] => run
120 [class] => Mage_Core_Model_Resource_Setup
121 [type] => ->
122 [args] => Array
123 (
124 [0] =>
125
126
127-- DROP TABLE IF EXISTS ai_jumboni_category;
128CREATE TABLE ai_jumboni_category (
129 `jum_cat_id` int(11) unsigned NOT NULL auto_increment,
130 `name` varchar(255) NOT NULL,
131 `icon` varchar(255) NOT NULL,
132 `catposition` text NOT NULL,
133 `created_time` datetime DEFAULT NULL,
134 `update_time` datetime DEFAULT NULL,
135 PRIMARY KEY (`jum_cat_id`)
136) ENGINE=InnoDB DEFAULT CHARSET=utf8;
137
138-- DROP TABLE IF EXISTS ai_jumboni_category_catalog_category_assoc;
139CREATE TABLE IF NOT EXISTS `ai_jumboni_category_catalog_category_assoc` (
140 `prod_cat_id` int(11) NOT NULL,
141 `jum_cat_id` int(11) NOT NULL,
142 `position` int(11) NOT NULL,
143) ENGINE=InnoDB DEFAULT CHARSET=utf8;
144
145-- DROP TABLE IF EXISTS ai_jumboni_category_link_assoc;
146CREATE TABLE IF NOT EXISTS `ai_jumboni_category_link_assoc` (
147 `link_id` int(11) NOT NULL,
148 `jum_cat_id` int(11) NOT NULL,
149 `position` int(11) NOT NULL,
150) ENGINE=MyISAM DEFAULT CHARSET=utf8;
151
152
153-- DROP TABLE IF EXISTS ai_jumboni_category_tout_assoc;
154CREATE TABLE IF NOT EXISTS `ai_jumboni_category_tout_assoc` (
155 `tout_id` int(11) NOT NULL AUTO_INCREMENT,
156 `jum_cat_id` int(11) NOT NULL,
157 `position` int(11) NOT NULL,
158) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
159
160-- DROP TABLE IF EXISTS ai_jumboni_link;
161CREATE TABLE ai_jumboni_link (
162 `link_id` int(11) NOT NULL AUTO_INCREMENT,
163 `text` varchar(50) NOT NULL,
164 `url` varchar(50) NOT NULL,
165 `new_window` tinyint(1) NOT NULL,
166 PRIMARY KEY (`link_id`)
167) ENGINE=InnoDB DEFAULT CHARSET=utf8;
168
169
170 )
171
172 )
173
174 [4] => Array
175 (
176 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php
177 [line] => 376
178 [args] => Array
179 (
180 [0] => /Users/adampicitelli/projects/adorama-magento/app/code/local/Ai/Jumboni/sql/jumboni_setup/mysql4-install-0.1.0.php
181 )
182
183 [function] => include
184 )
185
186 [5] => Array
187 (
188 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php
189 [line] => 276
190 [function] => _modifyResourceDb
191 [class] => Mage_Core_Model_Resource_Setup
192 [type] => ->
193 [args] => Array
194 (
195 [0] => install
196 [1] =>
197 [2] => 0.1.2
198 )
199
200 )
201
202 [6] => Array
203 (
204 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php
205 [line] => 240
206 [function] => _installResourceDb
207 [class] => Mage_Core_Model_Resource_Setup
208 [type] => ->
209 [args] => Array
210 (
211 [0] => 0.1.2
212 )
213
214 )
215
216 [7] => Array
217 (
218 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php
219 [line] => 161
220 [function] => applyUpdates
221 [class] => Mage_Core_Model_Resource_Setup
222 [type] => ->
223 [args] => Array
224 (
225 )
226
227 )
228
229 [8] => Array
230 (
231 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/App.php
232 [line] => 399
233 [function] => applyAllUpdates
234 [class] => Mage_Core_Model_Resource_Setup
235 [type] => ::
236 [args] => Array
237 (
238 )
239
240 )
241
242 [9] => Array
243 (
244 [file] => /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/App.php
245 [line] => 329
246 [function] => _initModules
247 [class] => Mage_Core_Model_App
248 [type] => ->
249 [args] => Array
250 (
251 )
252
253 )
254
255 [10] => Array
256 (
257 [file] => /Users/adampicitelli/projects/adorama-magento/app/Mage.php
258 [line] => 627
259 [function] => run
260 [class] => Mage_Core_Model_App
261 [type] => ->
262 [args] => Array
263 (
264 [0] => Array
265 (
266 [scope_code] =>
267 [scope_type] => store
268 [options] => Array
269 (
270 )
271
272 )
273
274 )
275
276 )
277
278 [11] => Array
279 (
280 [file] => /Users/adampicitelli/projects/adorama-magento/index.php
281 [line] => 80
282 [function] => run
283 [class] => Mage
284 [type] => ::
285 [args] => Array
286 (
287 [0] =>
288 [1] => store
289 )
290
291 )
292
293 )
294
295 [previous:Exception:private] =>
296 [errorInfo] => Array
297 (
298 [0] => 42S01
299 [1] => 1050
300 [2] => Table 'ai_jumboni_category' already exists
301 )
302
303)
304Error in file: "/Users/adampicitelli/projects/adorama-magento/app/code/local/Ai/Jumboni/sql/jumboni_setup/mysql4-install-0.1.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'ai_jumboni_category' already exists
305
306#0 /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php(390): Mage::exception('Mage_Core', 'Error in file: ...')
307#1 /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php(276): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.1.2')
308#2 /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php(240): Mage_Core_Model_Resource_Setup->_installResourceDb('0.1.2')
309#3 /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/Resource/Setup.php(161): Mage_Core_Model_Resource_Setup->applyUpdates()
310#4 /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/App.php(399): Mage_Core_Model_Resource_Setup::applyAllUpdates()
311#5 /Users/adampicitelli/projects/adorama-magento/app/code/core/Mage/Core/Model/App.php(329): Mage_Core_Model_App->_initModules()
312#6 /Users/adampicitelli/projects/adorama-magento/app/Mage.php(627): Mage_Core_Model_App->run(Array)
313#7 /Users/adampicitelli/projects/adorama-magento/index.php(80): Mage::run('', 'store')
314#8 {main}