vb.org Archive - Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0

Page 73 of 312

« First

123

173

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0 (https://vborg.vbsupport.ru/showthread.php?t=114012)

Snoop-It

11-30-2005 12:04 AM

^^ 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...??!?!

Retell

11-30-2005 12:04 AM

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

Lionel

11-30-2005 12:06 AM

Yes.

PHP Code:


		
			
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
Date         : Tuesday, November 29th 2005 @ 09:05:13 PM

Moparx

11-30-2005 12:07 AM

Quote:

Originally Posted by Lionel

Yes.

PHP Code:


		
			
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

Date         : Tuesday, November 29th 2005 @ 09:05:13 PM

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

Retell

11-30-2005 12:07 AM

Quote:

Originally Posted by dholaholic

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

Snoop-It

11-30-2005 12:10 AM

Quote:

Originally Posted by Retell

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??

lanc3lot

11-30-2005 12:10 AM

Quote:

Originally Posted by John

Anyone having problems.

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:(

TsirhCitna

11-30-2005 12:12 AM

Quote:

Originally Posted by John

Uninstall the product.

Run each of these queries one by one.

Code:

ALTER TABLE usergroup DROP arcadepermissions

ALTER TABLE user DROP arcadeoptions

ALTER TABLE arcade_games DROP isreverse

ALTER TABLE user DROP challengecache

DROP TABLE IF EXISTS arcade_challenges

DROP TABLE IF EXISTS arcade_categories

DROP TABLE IF EXISTS arcade_games

DROP TABLE IF EXISTS arcade_news

DROP TABLE IF EXISTS arcade_sessions

DROP TABLE IF EXISTS arcade_ratings

So far, all of the errors I've seen here were solved on my table prefix installation by the latest installation. Because I can't replicate this problem it's very difficult for me to fix it.

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.

Lionel

11-30-2005 12:12 AM

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

Snoop-It

11-30-2005 12:14 AM

Quote:

Originally Posted by Lionel

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:

All times are GMT. The time now is 09:06 PM.

Page 73 of 312

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03326 seconds Memory Usage 1,754KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: