Okay, so the import within my first testing area worked fine. Now I've set up another one and the installation went pretty well (I removed some styles before, so that the other error wouldn't occur. I still have no idea how there could be something wrong with the indexes though...).
I set the board to "debug mode" for additional information.
Then I ran the import skript and at Step 22 (Importing Page view Counts) it suddenly said:
Code:
[...]
Invalid SQL:
UPDATE `vb_vw_counter` SET `views` = CASE `pageid`
WHEN 12 THEN 12
WHEN 19 THEN 19
WHEN 20 THEN 20
WHEN 21 THEN 21
WHEN 24 THEN 24
WHEN 34 THEN 34
WHEN 36 THEN 36
WHEN 37 THEN 37
WHEN 39 THEN 39
WHEN 40 THEN 40
WHEN 45 THEN 45
WHEN 47 THEN 47
WHEN 48 THEN 48
WHEN 49 THEN 49
WHEN 50 THEN 50
WHEN 51 THEN 51
WHEN 53 THEN 53
WHEN 56 THEN 56
WHEN 59 THEN 59
WHEN 60 THEN 60
WHEN 74 THEN 74
WHEN 76 THEN 76
WHEN 78 THEN 78
WHEN 80 THEN 80
WHEN 84 THEN 84
WHEN 85 THEN 85
WHEN 88 THEN 88
WHEN 92 THEN 92
WHEN 94 THEN 94
WHEN 95 THEN 95
WHEN 100 THEN 100
WHEN 101 THEN 101
WHEN 102 THEN 102
WHEN 103 THEN 103
WHEN 104 THEN 104
WHEN 107 THEN 107
WHEN 108 THEN 108
WHEN 109 THEN 109
WHEN 110 THEN 110
WHEN 111 THEN 111
WHEN 113 THEN 113
WHEN 114 THEN 114
WHEN 116 THEN 116
WHEN 117 THEN 117
WHEN 118 THEN 118
WHEN 120 THEN 120
WHEN 121 THEN 121
WHEN 122 THEN 122
WHEN 124 THEN 124
WHEN 125 THEN 125
WHEN 126 THEN 126
WHEN 127 THEN 127
WHEN 128 THEN 128
WHEN 129 THEN 129
WHEN 130 THEN 130
WHEN 131 THEN 131
WHEN 132 THEN 132
WHEN 134 THEN 134
WHEN 135 THEN 135
WHEN 136 THEN 136
WHEN 137 THEN 137
WHEN 138 THEN 138
WHEN 139 THEN 139
WHEN 140 THEN 140
WHEN 141 THEN 141
WHEN 142 THEN 142
WHEN 143 THEN 143
WHEN 144 THEN 144
WHEN 145 THEN 145
WHEN 146 THEN 146
WHEN 147 THEN 147
WHEN 148 THEN 148
WHEN 149 THEN 149
WHEN 150 THEN 150
WHEN 151 THEN 151
WHEN 152 THEN 152
WHEN 153 THEN 153
WHEN 154 THEN 154
WHEN 155 THEN 155
WHEN 156 THEN 156
WHEN 157 THEN 157
WHEN 158 THEN 158
WHEN 159 THEN 159
WHEN 160 THEN 160
WHEN 161 THEN 161
WHEN 162 THEN 162
WHEN 163 THEN 163
WHEN 164 THEN 164
WHEN 165 THEN 165
WHEN 166 THEN 166
WHEN 167 THEN 167
WHEN 168 THEN 168
WHEN 169 THEN 169
WHEN 170 THEN 170
WHEN 171 THEN 171
WHEN 172 THEN 172
WHEN 173 THEN 173
WHEN 174 THEN 174
WHEN 175 THEN 175
WHEN 176 THEN 176
WHEN 177 THEN 177
WHEN 178 THEN 178
WHEN 179 THEN 179
WHEN 180 THEN 180
WHEN 181 THEN 181
WHEN 182 THEN 182
WHEN 183 THEN 183
WHEN 184 THEN 184
WHEN 185 THEN 185
WHEN 186 THEN 186
WHEN 187 THEN 187
WHEN 188 THEN 188
WHEN 189 THEN 189
WHEN 190 THEN 190
WHEN 191 THEN 191
WHEN 192 THEN 192
WHEN 193 THEN 193
WHEN 194 THEN 194
WHEN 195 THEN 195
WHEN 196 THEN 196
WHEN 197 THEN 197
WHEN 198 THEN 198
WHEN 199 THEN 199
WHEN 201 THEN 201
WHEN 202 THEN 202
WHEN 203 THEN 203
WHEN 204 THEN 204
WHEN 205 THEN 205
WHEN 206 THEN 206
WHEN 207 THEN 207
WHEN 209 THEN 209
WHEN 211 THEN 211
WHEN 213 THEN 213
WHEN 214 THEN 214
WHEN 216 THEN 216
WHEN 217 THEN 217
WHEN 220 THEN 220
WHEN 221 THEN 221
WHEN 222 THEN 222
WHEN 223 THEN 223
WHEN 224 THEN 224
WHEN 226 THEN 226
WHEN 230 THEN 230
WHEN 231 THEN 231
WHEN 234 THEN 234
WHEN 242 THEN 242
WHEN 243 THEN 243
WHEN 244 THEN 244
WHEN 246 THEN 246
WHEN 248 THEN 248
WHEN 249 THEN 249
WHEN 250 THEN 250
WHEN 257 THEN 257
WHEN 265 THEN 265
WHEN 277 THEN 277
WHEN 282 THEN 282
WHEN 289 THEN 289
WHEN 290 THEN 290
WHEN 292 THEN 292
WHEN 297 THEN 297
WHEN 305 THEN 305
WHEN 312 THEN 312
WHEN 322 THEN 322
WHEN 326 THEN 326
WHEN 343 THEN 343
WHEN 371 THEN 371
WHEN 379 THEN 379
WHEN 421 THEN 421
WHEN 422 THEN 422
WHEN 452 THEN 452
WHEN 455 THEN 455
WHEN 486 THEN 486
WHEN 495 THEN 495
WHEN 497 THEN 497
END WHERE `pageid` IN (12,19,20,21,24,34,36,37,39,40,45,47,48,49,50,51,53,56,59,60,74,76,78,80,84,85,88,92,94,95,100,101,102,103,104,107,108,109,110,111,113,114,116,117,118,120,121,122,124,125,126,127,128,129,130,131,132,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,201,202,203,204,205,206,207,209,211,213,214,216,217,220,221,222,223,224,226,230,231,234,242,243,244,246,248,249,250,257,265,277,282,289,290,292,297,305,312,322,326,343,371,379,421,422,452,455,486,495,497);
MySQL-Fehler : Unknown column 'pageid' in 'where clause'
Fehler-Nr. : 1054
Fehler-Zeit : Tuesday, 09.06.2015 @ 19:19:46
Datum : Tuesday, 09.06.2015 @ 19:19:46
Skript : xxx/pride-test/admin_cp/wiki_cp.php?panel=impex&do=import&step=25&nostyle=1
Referrer : xxx/pride-test/admin_cp/wiki_cp.php?panel=impex&do=import
IP-Adresse : xxx
Benutzername : xxx
Klassenname : vB_Database
MySQL-Version : 5.5.42-37.1-log
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 444
#2 vB_Database->query_write() called in [path]/vault/core/controller/db/vb3.php on line 186
#3 vw_DB_Controller_vB3->query_write() called in [path]/vault/core/model/db/mysql/vw.php on line 950
#4 vw_DB_MySQL_Model->shutdown_or_run() called in [path]/vault/core/model/db/mysql/vw.php on line 719
#5 vw_DB_MySQL_Model->update() called in [path]/vault/core/controller/import/handle/vw3/popularity/vw.php on line 103
#6 vw_Import_Handle_VW3_Popularity_Controller->do_popularity() called in [path]/vault/core/controller/import/steps/vw3/vw.php on line 558
#7 {closure}() called in [path]/vault/core/controller/progress/vw.php on line 100
#8 vw_Progress_Controller->call() called in [path]/vault/core/controller/cp/impex/vw.php on line 114
#9 vw_CP_ImpEx_Controller->import() called in [path]/vault/core/controller/cp/impex/vw.php on line 35
#10 vw_CP_ImpEx_Controller->execute() called in [path]/vault/helper/vb/global.php on line 66
#11 require_once([path]/vault/helper/vb/global.php) called in [path]/admin_cp/wiki_cp.php on line 24
Needles to say that this try didn't work. I could set up another (third) test board and see if it works there since it worked fine on the first test board. But that would be a little bit over the top, wouldn't it?