vb.org Archive

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)

egyptsons 11-30-2005 08:42 AM

When I import the product file (making sure overwrite is yes) I get the following sql error

Code:

Database error in vBulletin 3.5.1:

Invalid SQL:
INSERT INTO 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);

MySQL Error : Duplicate entry '7' for key 1
Error Number : 1062


Oblivion Knight 11-30-2005 08:45 AM

Please refer to the following bug (and fix):
http://www.v3arcade.com/forums/vbugs...iew&vbug_id=50

:)

egyptsons 11-30-2005 09:18 AM

Quote:

Originally Posted by Oblivion Knight
Please refer to the following bug (and fix):
http://www.v3arcade.com/forums/vbugs...iew&vbug_id=50

:)

Thanks I do it

memoriess 11-30-2005 11:12 AM

Hi, I tried to import the plugins, but it keep loading and loading.. Very long.

John 11-30-2005 12:24 PM

Quote:

Originally Posted by fringehead
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

53 pages of support questions in a couple of days, if I replied to everyone who was too lazy to search the thread I'd never have any time for anything else.

ShadowOne 11-30-2005 01:43 PM

Everything works great for me....

glorify 11-30-2005 01:51 PM

sql error on challenges--any ideas?

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO arcade_challenges (fromuserid, touserid, gameid, datestamp, status) VALUES (1, 559, 100, 1133364256, '1');

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Wednesday, November 30th 2005 @ 09:24:16 AM
Script : http://www.glorifythepast.com/forums/arcade.php

John 11-30-2005 02:06 PM

Quote:

Originally Posted by glorify
sql error on challenges--any ideas?

Upgrade to 1.0.2. (Uploading it now.)

Impreza04 11-30-2005 02:24 PM

Still getting the error even with 1.0.2

PHP Code:

Invalid SQL:
INSERT INTO vB_arcade_categories VALUES (7,'Puzzle',1),(8,'Action',2),(3,'Retro',3),(4,'Sport',4),(5,'Shooters',5),(1,'Other',100),(2,'Favorites',101);

MySQL Error  Duplicate entry '7' for key 1
Error Number 
1062
Date         
WednesdayNovember 30th 2005 04:23:26 PM
Script       
http://www.playstation-racing.co.uk/forum/admincp/plugin.php
Referrer     http://www.playstation-racing.co.uk/forum/admincp/plugin.php?do=productadd 


John 11-30-2005 02:27 PM

Quote:

Originally Posted by Impreza04
Still getting the error even with 1.0.2

PHP Code:

Invalid SQL:
INSERT INTO vB_arcade_categories VALUES (7,'Puzzle',1),(8,'Action',2),(3,'Retro',3),(4,'Sport',4),(5,'Shooters',5),(1,'Other',100),(2,'Favorites',101);

MySQL Error  Duplicate entry '7' for key 1
Error Number 
1062
Date         
WednesdayNovember 30th 2005 04:23:26 PM
Script       
http://www.playstation-racing.co.uk/forum/admincp/plugin.php
Referrer     http://www.playstation-racing.co.uk/forum/admincp/plugin.php?do=productadd 


You'd only get that if your product was uninstalled, and your tables already exist. You can use the attached XML file to install, which will skip the inserting of new records.


All times are GMT. The time now is 07:12 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03081 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
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (5)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