vb.org Archive - Major Additions - ibProArcade

I'd guess that the arcade_pmactive field didnt get created on the user table.
Assumming your not using prefixes which from the rror abve your not try running this query in phpmyadmin, Before doing so just check if the field already exists but i doubt it does.

Code:

ALTER TABLE `user` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';

ok just tried this query and it was not there now i get this error:

PHP Code:


		
			
mySQL query error: INSERT INTO games_cats (c_id,cat_name,active,show_all,pos,password,num_of_games) VALUES ('1','Default','1','0','1','','9')



mySQL error: Duplicate entry '1' for key 1

mySQL error code: 

Date: Sunday 27th of November 2005 09:35:07 AM

there are no queries to run in install instructions and i can't get the install script to work cause i keep getting errors just a reminder this is vb 3.07 arcade upgrade from 2.51 please help thanks

redlabour

11-27-2005 02:40 PM

Quote:

Originally Posted by JTyson

can you email me the game? i'll have a look tyson@fuo-motorsports.com

Which Game you are talking about ? Please use quote so anyone knows how you mean. You did reply on me and i talk about the integration of Arcade into MKportal - not of a Single Game.

Koopa

11-27-2005 02:49 PM

Does anyone know how I'd set up a class for the black text to appear on the white background I posted earlier? Thanks.

kewl1uk

11-27-2005 02:49 PM

Quote:

Originally Posted by JTyson

Yep thats why, it doesnt have a php file in there only a text file with instructions

ok thanks.

JTyson

11-27-2005 02:50 PM

Quote:

Originally Posted by bonnmac

ok just tried this query and it was not there now i get this error:

PHP Code:


		
			
mySQL query error: INSERT INTO games_cats (c_id,cat_name,active,show_all,pos,password,num_of_games) VALUES ('1','Default','1','0','1','','9')



mySQL error: Duplicate entry '1' for key 1

mySQL error code: 

Date: Sunday 27th of November 2005 09:35:07 AM

there are no queries to run in install instructions and i can't get the install script to work cause i keep getting errors just a reminder this is vb 3.07 arcade upgrade from 2.51 please help thanks

try this, this will throw your game counts out as it will delete the cat so the script can recreate it, otherwise you can try to comment out the query from the install file.

Code:

DELETE FROM games_cats WHERE c_id = 1;

JTyson

11-27-2005 02:53 PM

Quote:

Originally Posted by redlabour

Which Game you are talking about ? Please use quote so anyone knows how you mean. You did reply on me and i talk about the integration of Arcade into MKportal - not of a Single Game.

Sorry this was for a couple of posts before mine, its nearly 1 am here so im getting a little sloppy.

For your request look for my earlier post on mkportal as i had a couple of questions.

bonnmac

11-27-2005 02:57 PM

Quote:

Originally Posted by JTyson

try this, this will throw your game counts out as it will delete the cat so the script can recreate it, otherwise you can try to comment out the query from the install file.

Code:

DELETE FROM games_cats WHERE c_id = 1;

ok did that and now i get this..

PHP Code:


		
			
mySQL query error: ALTER TABLE session ADD in_game VARCHAR( 32 ) NOT NULL



mySQL error: Duplicate column name 'in_game'

mySQL error code: 

Date: Sunday 27th of November 2005 09:54:29 AM

is there a list of queries i can run to remove the old arcade completly so i can just do a fresh complete install of new? thanks for your help!!

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

Page 66 of 758

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06839 seconds Memory Usage 1,758KB 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 (3)bbcode_code_printable (3)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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: