Question import errors

[Davagator]

On a fresh install of VB and the arcade, when I try to import a .tar game I get:

Warning: asort() expects parameter 1 to be array, null given in [path]/dbtech/vbarcade/functions_arcade.php on line 328

Warning: Invalid argument supplied for foreach() in [path]/dbtech/vbarcade/functions_arcade.php on line 330


Any ideas?

Thanks,
Dave

 

[Fillip H.]

I've uploaded a potential hotfix for this, can you please try re-downloading and re-uploading the file mentioned in the error?

 

[Davagator]

now i'm getting database errors.

Database error in vBulletin 4.2.0:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT IGNORE INTO dbtech_vbarcade_game
(`borntobebigFT`, `gameid`, `timestamp`, `icon`, `badge`, `flashfile`)
VALUES
('', '0', '1362858002', '', '', '');

MySQL Error : Unknown column 'borntobebigFT' in 'field list'
Error Number : 1054

 

[Davagator]

I removed arcade 2.0.1 and installed 2.0.0 and its importing just fine now.

 

[Fillip H.]

I'll grab both versions and do a comparison between the two so I can try to find the change that broke it, thanks

What version of PHP are you running?

 

[Davagator]

5.3.18

 

[Fillip H.]

Someone else wrote about a problem affecting those exact lines of code that caused this issue.

I've changed it to hopefully work for both PHP versions now, 2.0.1 should be safe for you now

 

[Davagator]

Seems to be working now. Thanks.

 

[Lightmaster-AH]

Hello,

same error here

Warnung: asort() expects parameter 1 to be array, null given in [path]/dbtech/vbarcade/functions_arcade.php (Zeile 328)
Warnung: Invalid argument supplied for foreach() in [path]/dbtech/vbarcade/functions_arcade.php (Zeile 330)

PHP Version 5.2.17

which file is affected, and what folder I need to upload again?

there is also the possibility to upload games directly to the server and install? always to import only one game over the acp is rather a somewhat lengthy process.

thanks

 

[Davagator]

You can FTP your games into the /public_html/dbtech/vbarcade/import folder and then import.

 

[Fillip H.]

Hello,

same error here

Warnung: asort() expects parameter 1 to be array, null given in [path]/dbtech/vbarcade/functions_arcade.php (Zeile 328)
Warnung: Invalid argument supplied for foreach() in [path]/dbtech/vbarcade/functions_arcade.php (Zeile 330)

PHP Version 5.2.17

which file is affected, and what folder I need to upload again?

/dbtech/vbarcade/functions_arcade.php is the file you should re-upload

 

[Lightmaster-AH]

Good morning,

unfortunately I can also import the new file no games. I tried it on by the acp and I have the game loaded directly via ftp in the import folder.

There are no games to be imported are displayed, although in / import / temp folder games can be found. Here again a few snapshots to.

Import over the acp


no imported games are shown


Here are the import and temp folder of my Server

 

[Fillip H.]

Are you sure those games were made for one of the supported Arcade systems?

 

[Lightmaster-AH]

Yes,

this all games from ibpArcade, where all my games come from. The games that have been imported in the installation of ibProArcade to vbarcade I uninstalled two and tried to install them again, with the same result that they are not displayed.

 

[Lightmaster-AH]

Here is another screenshot of six games, that I wnt to Import:



The Name of the games did not shown and if I klick to omport I have an mysql error:

Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT IGNORE INTO dbtech_vbarcade_game
(`3dfroggerIBPAG`, `gameid`, `timestamp`, `icon`, `badge`, `flashfile`)
VALUES
('', '0', '1363191837', '', '', '');

MySQL-Fehler : Unknown column '3dfroggerIBPAG' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Wednesday, 13.03.2013 @ 17:23:57
Datum : Wednesday, 13.03.2013 @ 17:23:58
Skript : /admincp/arcade_admin.php?do=review
Referrer : /admincp/arcade_admin.php?do=review

Klassenname : vB_Database
MySQL-Version : 5.5.28-log

 

[Fillip H.]

Can you try re-downloading and re-uploading /admincp/arcade_admin.php to ensure you have the latest version?

 

[Lightmaster-AH]

Okay,

that was it

by the way, is it possible that you are the royalty owner informed if there is a small fix? or I overlooked these notes just?

thanks for help!

 

[Fillip H.]

Sorry, I don't understand that question, could you re-word it please?

 

[Lightmaster-AH]

Yes,

sorry, my english is not the best. Sometimes you gave me the notice, that I should replace a file, to delete a error. So my question, can I find a hint about your small changes of a file? Perhaps it would clarify some ask of themselves.

I hope you understand what I want to ask so.

 

[Fillip H.]

We currently don't have a system to notify people of hotfixes, since it's not a guarantee that it will actually fix the issue for some people without creating other issues (as seen in this and similar threads).

If a significant amount of people report the same issue, or a significant amount of issues are reported and hotfixes, we release a bugfix roll-up release.