^^ that hasnt made a difference for my board, its wiped off my champion hack though.. and still seeing this error...

Invalid SQL:
ALTER TABLE vb3_arcade_categories ADD categoryid int(10) unsigned NOT NULL auto_increment;

MySQL Error : Duplicate column name 'categoryid'
Error Number : 1060

what to do...??!?!

Mine seems to be working fine after upgrade, seems exactly the same as before. I did have to do ALOT of SQL editing on my part before, but I have to admit John, you did a great job on 1.0.1 let me know if you need any thing from me :D

Yes.

I am also still getting this when trying to import the product file

try going into phpmyadmin and deleteing everything that has to do with arcade, all databases and the stuff in usergroup and user. Then go into the product, edit the uninstaller, by deleting all the SQL uninstall steps. Then uninstall V3. Upload the XML again and it should work. Hope That Helps :P

yeh i know that, im trying to avoid all of that as i spent a lot of time adding stuff on the arcade... iv already lost all previous data from 3.0.x then tried members to play games again, comment etc.. and now i think thats wiped off as well.. isn't there 1 code line or something i can add or is this long way the only option i have??

Damn:(

I hoped that as it not a major problem, and only a prob that u maybe can find a fix, it could be solved like this...and not to have uninstall everything, loose the scores and the games:(

Damnnnnnnnnn:(

Isn't that going to drop all of the current scores? To duplicate the problem everyone seems to be having just try to upgrade from 1.0.0 to 1.0.1. That's all I have done.

I uninstalled many times. But why on a fresh re install every one is having that Duplicate column name 'categoryid'

im just upgrading from 1.0.0 to 1.0.1 (overwrite files & product) and got that error. :disappointed:

The reason this is so damn frustrating is that all the errors you guys are posting here are bugs that I've already fixed, because I was experiencing them on my prefixed test forums.

I've just installed, uninstalled, and reinstalled on my prefix forums about ten times without problems. If you're having problems, email me your class_database_analyse.php file to john {at} eovie.com.

there wernt no error on my board for the arcade anyway...? anywho.. im emailing you my file then.. the exact one downloaded from here.. its a database error though isn't it? not a file error? :ermm: i dunno :speechless: :nervous:

Its fixed for me now... I forgot to reupload class_database_analyse.php this last update.
Thanks John

dholaholic, the file you just sent me is not the latest revision.

I have posted two time and have seen numerous replied to other posts... No help for me?

This? https://vborg.vbsupport.ru/showpost....&postcount=684

its the one i just downloaded 20mins ago.. unless you updated the pack... iv just downloaded it right now again and sent you the file... let me know if thats the latest 1??

Yes, that's the correct file.

I feel kinda dumb here, but I just fixed the problem by uploading all the files again. I'm guessing that everyone did the samething I did when you updated the .zip, they just tried to install the new product or use the dbfix.

ok now the product installs... but my arcade... lost all the games and its onlyshowing >> ALL, RANDOM (what happened to the others??)

looks like I had the same mistake too.

Now that its working for me:
- Had to use v3arcades site to reinstall all the default games as they didnt show up
- The game categories didnt get added this time around

Both are minor issues (for me anyway) and everything else works perfectly

yep... any ideas? Thanks!

yeah i know, same here. i got to look and copy the categories of v3arcade... and installgames off their.

Thanks John for fixing this up for me / us. Much Aprriciated :)

Anyones help reqs go un answered?

I tried to go to v3arcade site and I get

well do you have guest permision? I know on my install that wasn't set as default.

My heart is back again:)

I uploaded all the files again and run the arcadetools.php?do=fixdb and now even the game settings are seems to working:)

Thnx john, sorry if i asked many times:)

I am also missing the navigation that I had before

You probably weren't answered because it has been asked many times before, set your usergroup permissions.

About Favorites and Navigation, how do I get them back?

INSERT INTO `vb3_arcade_categories` VALUES (7,'Puzzle',1),(8,'Action',2),(3,'Retro',3),(4,'Sp ort',4),(5,'Shooters',5),(1,'Other',100),(2,'Favor ites',101);

There were some navigation links before where we had the option to use those only instead of vb navbar

v3arcade settings > Use Alternate Navbar Template

Maybe if you had better instructions and included the details I wouldn't have to read every single post in these forums to find the information you left out in the 1st place. Try to improve the documentation... First and foremost try to be polite to people. Ignoring people is just rude.

I see many people have suggested you add the info to the docs, but I guess you decided against it.

Here is the link to the thread with the information on how to change the permissions so you can use the arcade:

http://www.v3arcade.com/forums/showt...set+permission

geez. calm down. you're leeching off his hardwork and still you give him a hard time.

I'm clam here. You're the one calling people names.
Go back and read the thread; get your facts straight.

you guys should really register on johns website and submit bug tickets for problems @ http://www.v3arcade.com/forums/vbugs.php so you get better support.....

k, well i just tried to upgrade the arcade from 1.0 to 1.0.1 but I still get the same error that everybody here had (read the 7 last pages).

I really don't understand why I get this, isn't it supposed to be simple...?

I tried doing the arcadetools.php?do=fixdb, it says that all Databases has been fixed but when I try reuploading the product it still gives me that error.

Also I can't uninstall the product as I can't see the product in my product list anymore...

I really do not want to lose all of the information that my users worked so hard to gain for...what do I do???

For everyone getting errors upgrading from 1.0.0 to 1.0.1, running these two queries should enable you to upgrade successfully.

Be sure to replace $TP with your table prefix.