vb.org Archive
Page 12 of 14 « First 21011 12 1314
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)
-   -   Major Additions - Mindestic Gaming CMS Lite BETA (https://vborg.vbsupport.ru/showthread.php?t=137797)

oninuva 11-04-2007 12:30 PM
This still under dev? It is very interesting.

SS9267547 11-05-2007 08:40 AM
Yes this is still under development. Just start things back up so the next release should be a few weeks. I'll post more info up later and as for issues posted in the thread will be addressed in the next release.

cgfuse 11-05-2007 07:09 PM
Quote:
Originally Posted by jgommel (Post 1326281)
I did a brand new installation, but I too received the database error that I was missing the mindesticgcms_game table. I checked the database and sure enough, that was the only table missing.

Code:
Database error in vBulletin 3.6.8:

Invalid SQL:


        SELECT COUNT(*) AS games
        FROM vb_mindesticgcms_game AS game
        WHERE 1=1;

MySQL Error  : Table 'neosmutc_neosmutdb.vb_mindesticgcms_game' doesn't exist
Error Number : 1146
Date        : Sunday, August 26th 2007 @ 04:11:08 PM
Script      : http://www.neosmut.com/vb/games.php
Referrer    :
IP Address  : 76.188.204.236
Username    : RodentX
Classname    : vb_database
I ended up having to add the missing table and rows manually... so far so good.

Code:
$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_game (
    gameid int(11) NOT NULL auto_increment,
    gamename varchar(255) NOT NULL default '',
    gameusername varchar(50) default NULL,
    gameuserid int(10) unsigned NOT NULL default '0',
    gamelastupdate int(10) unsigned NOT NULL default '0',
    gamedateline int(10) unsigned NOT NULL default '0',
    gamereleasedate int(10) unsigned NOT NULL default '0',
    gameplatformid smallint(5) unsigned NOT NULL default '0',
    gamevalid int(10) NOT NULL default '1',
    gameviews int(10 NOT NULL default '0',
    gamedescription text NOT NULL,
    gameipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gameeditusername VARCHAR( 50 ) DEFAULT '' NULL,
    gameedituserid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL,
    gameeditipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gamegenreid smallint(5) unsigned NOT NULL default '0',
    gamemediumid smallint(5) unsigned NOT NULL default '0',
    gameorginid smallint(5) unsigned NOT NULL default '0',
    gameplayerid smallint(5) unsigned NOT NULL default '0',
    gamedeveloperid smallint(5) unsigned NOT NULL default '0',
    gamepublisherid smallint(5) unsigned NOT NULL default '0',
    gameesrbid smallint(5) unsigned NOT NULL default '0',
    gamemultiplayid smallint(5) unsigned NOT NULL default '0',
    PRIMARY KEY  (gameid)
) TYPE=MyISAM");
I get the same problem as you, and i tried your fix and this is what it says.

Code:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 4
STR: ->
SQL: $db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_game (
    gameid int(11) NOT NULL auto_increment,
    gamename varchar(255) NOT NULL default '',
    gameusername varchar(50) default NULL,
    gameuserid int(10) unsigned NOT NULL default '0',
    gamelastupdate int(10) unsigned NOT NULL default '0',
    gamedateline int(10) unsigned NOT NULL default '0',
    gamereleasedate int(10) unsigned NOT NULL default '0',
    gameplatformid smallint(5) unsigned NOT NULL default '0',
    gamevalid int(10) NOT NULL default '1',
    gameviews int(10 NOT NULL default '0',
    gamedescription text NOT NULL,
    gameipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gameeditusername VARCHAR( 50 ) DEFAULT '' NULL,
    gameedituserid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL,
    gameeditipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gamegenreid smallint(5) unsigned NOT NULL default '0',
    gamemediumid smallint(5) unsigned NOT NULL default '0',
    gameorginid smallint(5) unsigned NOT NULL default '0',
    gameplayerid smallint(5) unsigned NOT NULL default '0',
    gamedeveloperid smallint(5) unsigned NOT NULL default '0',
    gamepublisherid smallint(5) unsigned NOT NULL default '0',
    gameesrbid smallint(5) unsigned NOT NULL default '0',
    gamemultiplayid smallint(5) unsigned NOT NULL default '0',
    PRIMARY KEY  (gameid)
) TYPE=MyISAM")


SQL query:

$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_game ( gameid int(11) NOT NULL auto_increment, gamename varchar(255) NOT NULL default '', gameusername varchar(50) default NULL, gameuserid int(10) unsigned NOT NULL default '0', gamelastupdate int(10) unsigned NOT NULL default '0', gamedateline int(10) unsigned NOT NULL default '0', gamereleasedate int(10) unsigned NOT NULL default '0', gameplatformid smallint(5) unsigned NOT NULL default '0', gamevalid int(10) NOT NULL default '1', gameviews int(10 NOT NULL default '0', gamedescription text NOT NULL, gameipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL, gameeditusername VARCHAR( 50 ) DEFAULT '' NULL, gameedituserid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL, gameeditipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL, gamegenreid smallint(5) unsigned NOT NULL default '0', gamemediumid smallint(5) unsigned NOT NULL default '0', gameorginid smallint(5) unsigned NOT NULL default '0', gameplayerid smallint(5) unsigned NOT NULL default '0', gamedeveloperid smallint(5) unsigned NOT NULL default '0', gamepublisherid smallint(5) unsigned NOT NULL default '0', gameesrbid smallint(5) unsigned NOT NULL default '0', gamemultiplayid smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (gameid) ) TYPE=MyISAM")

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_gam' at line 1
I dont know if im doing it wrong or not, any help is greatly appreciated :)

SS9267547 11-06-2007 01:03 AM
If for some reason it wasn't installed, to manully put it in paste the following in your phpmyadmin under 'SQL' or whatever program you use (Replace 'community' with whatever your TABLE PREFIX is setup as in vb if any) :
PHP Code:
CREATE TABLE `community_mindesticgcms_game` (
  `gameid` int(11) unsigned NOT NULL auto_increment,
  `gamename` varchar(255) NOT NULL default '',
  `gameusername` varchar(50) NOT NULL default '',
  `gameuserid` int(10) unsigned NOT NULL default '0',
  `gamelastupdate` int(10) unsigned NOT NULL default '0',
  `gamedateline` int(10) unsigned NOT NULL default '0',
  `gamereleasedate` int(10) unsigned NOT NULL default '0',
  `gameplatformid` smallint(5) unsigned NOT NULL default '0',
  `gamevalid` int(10) NOT NULL default '1',
  `gameviews` int(10) NOT NULL default '0',
  `gamedescription` text NOT NULL,
  `gameipaddress` varchar(15) NOT NULL default '',
  `gameeditusername` varchar(50) NOT NULL default '',
  `gameedituserid` int(10) unsigned NOT NULL default '0',
  `gameeditipaddress` varchar(15) NOT NULL default '',
  `gamegenreid` smallint(5) unsigned NOT NULL default '0',
  `gamemediumid` smallint(5) unsigned NOT NULL default '0',
  `gameorginid` smallint(5) unsigned NOT NULL default '0',
  `gameplayerid` smallint(5) unsigned NOT NULL default '0',
  `gamedeveloperid` smallint(5) unsigned NOT NULL default '0',
  `gamepublisherid` smallint(5) unsigned NOT NULL default '0',
  `gameesrbid` smallint(5) unsigned NOT NULL default '0',
  `gamemultiplayid` smallint(5) unsigned NOT NULL default '0',
  `gameesrbcddata` mediumtext NOT NULL,
  PRIMARY KEY  (`gameid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; 

Gn_Snake 11-10-2007 09:09 AM
Hi,
i have error mysql :

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT COUNT(*) AS total
FROM HG_mindesticgcms_game AS game;

MySQL Error : La tabella 'hardwaregame.hg_mindesticgcms_game' non esiste
Error Number : 1146
Date : Saturday, November 10th 2007 @ 12:10:27 PM
Script : http://127.0.0.1/forum/admincp/admin...ms.php?do=list
Referrer : http://127.0.0.1/forum/admincp/index.php
IP Address : 127.0.0.1
Username :
Classname : vB_Database


Help Me!!

SS9267547 11-10-2007 01:40 PM
I think your missing the game table. Just put in the sql from thishttps://vborg.vbsupport.ru/showpost....&postcount=114 post.

Gn_Snake 11-13-2007 02:17 PM
Quote:
Originally Posted by SS9267547 (Post 1379720)
I think your missing the game table. Just put in the sql from thishttps://vborg.vbsupport.ru/showpost....&postcount=114 post.
Thx :D

Gn_Snake 11-13-2007 02:23 PM
Very good this feature for the future: :D

11. Game Cheats System.

SS9267547 11-13-2007 11:31 PM
Yeah for sure. When I get to it who knows lol. In the next few weeks I'm planning on releasing the next beta so things will start up with development again.

Phlex 11-14-2007 05:03 PM
It would be wonderful if it would be possible to use this also as a movie database


All times are GMT. The time now is 03:36 PM.
Page 12 of 14 « First 21011 12 1314
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.01181 seconds
  • Memory Usage 1,781KB
  • 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
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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