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

Page 72 of 312

« First

122

172

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)

Moparx

11-29-2005 11:36 PM

John, can you make arcadetools.php check to see if a table exists before it trys to add/remove/modify it? that would probably clear up alot of issues.

I assume 1.0.0's 'uninstaller' doesnt uninstall correctly.. as i cant reinstall without errors

Lionel

11-29-2005 11:42 PM

Here is the error I get after I drop all tables and try to start from scratch

PHP Code:


		
			
 Database error in vBulletin 3.5.1:
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 @ 08:40:53 PM

Moparx

11-29-2005 11:43 PM

Quote:

Originally Posted by Lionel

Here is the error I get after I drop all tables and try to start from scratch

PHP Code:


		
			
 Database error in vBulletin 3.5.1:

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 @ 08:40:53 PM

ya thats the error that is plaguing me

Cap'n Steve

11-29-2005 11:46 PM

Quote:

Originally Posted by Paul M

Usergroup settings for minimum posts/reputation etc

This is easy to do with Promotions, unless you're talking about setting permissions for individual games.

To everyone who has it installed but can't see the link in their navigation panels, try going to the Plugin Manager, Editing a plugin and saving it without changing anything. For some reason, this fixed it when I was having the same problem with another hack.

Snoop-It

11-29-2005 11:50 PM

SQL query:

ALTER TABLE vb3_arcade_categories ADD categoryid int( 10 ) unsigned NOT NULL AUTO_INCREMENT

MySQL said: Documentation
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

I dont have a clue what im doing, could some 1 guide me the exact code to paste in phpmyadmin

Lionel

11-29-2005 11:52 PM

Oh man, version 1.0 was working perfect. Just don't know what took me to be among the first to upgrade. Now I've got nothing :-(

Snoop-It

11-29-2005 11:55 PM

^^ i hear ya, my whole enitre arcade is wiped off... :/

John	11-29-2005 11:59 PM

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.

lanc3lot

11-30-2005 12:02 AM

Sorry to repeat again, but that includes the setting problem i just posted again 3 posts above?
:(

John	11-30-2005 12:03 AM

Quote:

Originally Posted by lanc3lot

Sorry to repeat again, but that includes the setting problem i just posted again 3 posts above?
:(

Anyone having problems.

All times are GMT. The time now is 08:15 AM.

Page 72 of 312

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02290 seconds Memory Usage 1,745KB 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 (3)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: