vb.org Archive
Page 18 of 78 « First 81617 18 19202868 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)

divided_by_fear 11-29-2005 10:34 PM
anyone have a working module for vbadvanced? seems that the one on v3 dont work??

bold 11-29-2005 10:42 PM
refreshing this thread like theres no tomorrow

John 11-29-2005 10:43 PM
If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.

fringehead 11-29-2005 10:45 PM
When I click on the arcade I get:

"you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation. "

I don't see any games in the CP either..

Any help appriciated!

THanks,

Sean

john1744 11-29-2005 10:45 PM
Oh wait quick question will this work fine with just 3.5.0?

b6gm6n 11-29-2005 10:46 PM
Upgrade A-OK...cheers

-b6

lanc3lot 11-29-2005 10:49 PM
Quote:
Originally Posted by John
If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run admincp.php?do=fixdb.

It should solve any problems you've been having.

It will fix if i do the one with the arcadetools.php also the prob i have in the setting of the game?

Lionel 11-29-2005 10:53 PM
Quote:
Originally Posted by John
If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run admincp.php?do=fixdb.

It should solve any problems you've been having.
none of these solutions work for me. Same errors.

Lionel 11-29-2005 10:55 PM
I wish to uninstall and start from scratch. How can I uninstall?

John 11-29-2005 10:57 PM
And you use table prefixes?

bold 11-29-2005 10:58 PM
workin fine for me

Lionel 11-29-2005 11:00 PM
yes I do use prefixes

fringehead 11-29-2005 11:02 PM
I uploaded the files, then chowned them to the proper website permissions...

Why am I getting no access from the admin? and why do I not see games? Do I need to download games?

lanc3lot 11-29-2005 11:05 PM
Quote:
Originally Posted by John
If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run admincp.php?do=fixdb.

It should solve any problems you've been having.

It will solve also the prob i have when i alter the settings?

When u say install again, u mean repaste the files u have inside or just upload the new xml? I did upload only the xml and everything went ok, though, when i try alter the settings i have the same error

Also, when u say run admincp.php?do=fixdb, what do u mean? :)

John 11-29-2005 11:08 PM
Quote:
Originally Posted by lanc3lot
It will solve also the prob i have when i alter the settings?

When u say install again, u mean repaste the files u have inside or just upload the new xml? I did upload only the xml and everything went ok, though, when i try alter the settings i have the same error

Also, when u say run admincp.php?do=fixdb, what do u mean? :)
It was a big typo. Should be:

Quote:
If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.

Moparx 11-29-2005 11:08 PM
Quote:
Originally Posted by TsirhCitna
So I tried to upgrade from 1.0.0 to 1.0.1 and this is what I get when I try to import the new product. I selected overwrite.

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 @ 06:59:57 PM
Script          : http://www.tenstones.net/forums/admincp/plugin.php
Referrer        : http://www.tenstones.net/forums/admincp/plugin.php?do=productadd
IP Address  : 4.229.225.84
Username        : Bob
Classname        : vB_Database
I am also getting this... I originally uninstalled the product earlier today and just tried to reinstall since 1.0.1 supports posts per day now.

I have tried manually dropping the vb3_arcade_* tables to no avail


running arcadetools.php?do=fixdb gives me this:
Quote:
Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_cpuser AS phrasegroup_cpuser,
language.phrasegroup_arcade AS phrasegroup_arcade,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM vb3_user AS user
LEFT JOIN vb3_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN
vb3_administrator AS administrator ON (administrator.userid = user.userid) INNER JOIN vb3_language AS language ON
(language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'
Error Number : 1054
Date : Tuesday, November 29th 2005 @ 08:06:06 PM
Script : http://www.virtualinfusion.net/<admincp>/arcadetools.php?do=fixdb

Lionel 11-29-2005 11:11 PM
I do get errors running that tools also. All phrases disappeared too.

lanc3lot 11-29-2005 11:14 PM
When i do this john (i mean without the typo:P) i have:

Code:
Database error in vBulletin 3.5.0:

Invalid SQL:
CREATE TABLE vb3new_arcade_categories (categoryid int(10) unsigned NOT NULL auto_increment, catname varchar(250) NOT NULL, displayorder int(10) unsigned NOT NULL, PRIMARY KEY (categoryid));

MySQL Error  : Table 'vb3new_arcade_categories' already exists
Error Number : 1050
Date        : Wednesday, November 30th 2005 @ 03:13:32 AM
Script      : http://www.gamers.gr/forums/admincp/arcadetools.php?do=fixdb
Referrer    :
IP Address  : 212.54.217.231
Username    : lancelot
Classname    : vb_database

TsirhCitna 11-29-2005 11:14 PM
Quote:
Originally Posted by John
If you've been having problems and you're using table prefixes, download the zip file again and try to install. If you get an error when trying to install, upload arcadetools.php into your admincp directory and run arcadetools.php?do=fixdb.

It should solve any problems you've been having.
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:14:04 PM
Script          : http://www.tenstones.net/forums/admincp/arcadetools.php?do=fixdb
Referrer        :

John 11-29-2005 11:16 PM
Quote:
Originally Posted by TsirhCitna
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:14:04 PM
Script          : http://www.tenstones.net/forums/admincp/arcadetools.php?do=fixdb
Referrer        :
Download the zip again.

If fixdb doesn't help, try uninstalling and reinstalling.

Lionel 11-29-2005 11:19 PM
How do you uninstall? I just redownloaded and still have the same problem

lanc3lot 11-29-2005 11:21 PM
Quote:
Originally Posted by John
If fixdb doesn't help, try uninstalling and reinstalling.
That reffers to me aswell?:(

It will be a mess to uinstall, i just have the settings problem:(

Lionel 11-29-2005 11:21 PM
In admincp/product, arcade does not show. So how to uninstall?

Moparx 11-29-2005 11:21 PM
updated zip doesnt do anything for me

John 11-29-2005 11:33 PM
Quote:
Originally Posted by lanc3lot
That reffers to me aswell?:(

It will be a mess to uinstall, i just have the settings problem:(
I don't know what you're referring to by "the settings problem".

Lionel, you uninstall products in the same place as you install them. Use the drop down menu.

Lionel 11-29-2005 11:33 PM
WOW, settings are gone, I deleted tables, and on reinstall, I get errors again

jesus likes pie 11-29-2005 11:34 PM
Wow the upgrade.txt thing included in 1.0.1 is kind of confusing.....

TsirhCitna 11-29-2005 11:35 PM
Quote:
Originally Posted by John
I don't know what you're referring to by "the settings problem".

Lionel, you uninstall products in the same place as you install them. Use the drop down menu.
It shows the only installed product as vBulletin.

lanc3lot 11-29-2005 11:35 PM
I repost then:)

John there is also another bug.

I tried to change the settings in one of the games and see the outcome:

Code:
Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb3new_arcade_games SET
        title='Asteroids',
        description='Η εποχή των 80s επιστρέφει, με ένα ακόμα παιχνίδι της Retro κατηγορίας του gamers.gr',
        width='500',
        height='375',
        gamepermissions='7',
        minpoststotal='1',
        minpostsperday='0',
        minpoststhisday='0',
        minreglength='0',
        minrep='0',
        categoryid='3',
        isreverse='0'
        WHERE gameid=7;

MySQL Error  : Unknown column 'minpoststhisday' in 'field list'
Error Number : 1054
Date        : Wednesday, November 30th 2005 @ 02:16:42 AM
Script      : http://www.gamers.gr/forums/admincp/arcadeadmin.php
Referrer    : http://www.gamers.gr/forums/admincp/arcadeadmin.php?do=editgame&gameid=7&s=
IP Address  : 212.54.217.231
Username    : lancelot
Classname    : vb_database

Lionel 11-29-2005 11:36 PM
Quote:
Originally Posted by John
I don't know what you're referring to by "the settings problem".

Lionel, you uninstall products in the same place as you install them. Use the drop down menu.
John, problem is the product disappeared, not to be found in that place, after I upgraded from 1.0 to 1.01. I manually deleted the tables, and since settings were empty in admincp, nothing was necessary.. However on re installing I get the same errors.

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 05:15 AM.
Page 18 of 78 « First 81617 18 19202868 Last »
Show 40 post(s) from this thread on one page

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.03374 seconds
  • Memory Usage 1,850KB
  • 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
  • (6)bbcode_code_printable
  • (2)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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