MyBB Community Forums

I get the below error after attempting to activate the Game Section (1.2 RC2) plugin.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1163 - The used table type doesn't support BLOB/TEXT columns
Query:
    ALTER TABLE `mybb_sessions` ADD `gamesession` TEXT NOT NULL; 

Can you point me in the right direction as to how to fix this?

Do you use MySQL, or another db?

I have to say that the Game Section isn't controlled to work with other systems, yet.

Yes sir I'm using MySQL. When I get the error, I click the "back" button in my browser and activate the plugin for a second time it does activate correctly. Once I visit the arcade I get the below statement.

The Game Section Settings doesn't exist.

I would love to get this Mod to work.

Yes, that's normal. Can you deactivate the Game Section?

Yes I can deactivate the Game Section.

have installed game section but when trying to set permissions i get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'canplaytournaments' in 'field list'
Query:
UPDATE mybb_usergroups SET type='1', title='Registered', description='', namestyle='{username}', usertitle='', stars='0', starimage='images/star.gif', image='', isbannedgroup='0', canview='1', canviewthreads='1', canviewprofiles='1', candlattachments='1', canpostthreads='1', canpostreplys='1', canpostattachments='1', canratethreads='1', caneditposts='1', candeleteposts='1', candeletethreads='1', caneditattachments='1', canpostpolls='1', canvotepolls='1', canusepms='1', cansendpms='1', cantrackpms='1', candenypmreceipts='1', pmquota='0', maxpmrecipients='5', cansendemail='1', maxemails='5', canviewmemberlist='1', canviewcalendar='1', canaddevents='1', canbypasseventmod='0', canmoderateevents='0', canviewonline='1', canviewwolinvis='0', canviewonlineips='0', cancp='0', issupermod='0', cansearch='1', canusercp='1', canuploadavatars='1', canchangename='0', showforumteam='0', usereputationsystem='1', cangivereputations='1', reputationpower='1', maxreputationsday='5', attachquota='0', cancustomtitle='1', canwarnusers='0', canreceivewarnings='1', maxwarningsday='3', canmodcp='0', canviewgames='1', canplaygames='1', canplaytournaments='1', canaddtournaments='1' WHERE gid='2'

---

btw this happens with every user group

(2009-01-25, 10:36 PM)gimmezell Wrote: [ -> ]Yes I can deactivate the Game Section.

And you still have the same problem when you try to activate it again? Can you give me the SQL code which makes your exact table (from backup).

(2009-01-26, 12:01 PM)Bonkers Mad!!! Wrote: [ -> ]have installed game section but when trying to set permissions i get this error:

[b]MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'canplaytournaments' in 'field list'

---

btw this happens with every user group

Which version did you download and install AND where?

Yes, I still have the same problem once I activate it again. What exactly to you need as far as the SQL code?

Quote:Which version did you download and install AND where?

1.2 RC2.1

what do you mean by "where"?

where did i download it from or where did i upload it to?

i downloaded it from HERE

and uploaded the files to the corresponding folders on my site

Game Section 1.2 RC3 is released!
Changes since 1.2 RC2.1:
- games_bit updated to fix design artefact
- Bugfix for user merge function
- Update for force system
- Numratings field added to fix number of ratings bug
- Rating field updated as float to make the system more precise
- Bugfix for bug that there can only be one rate
- Plugin fix adding deafult game
- Last Champions bug fixed
- Control if tournament system is activated when browsing tournaments page
- Bugfix of replace_templates_gs function
- Fix of pluginname in module_meta.php file
- Loading stylesheet of rating bug fixed
- When you delete a game, the favourites and tournaments of that game are deleted now, and the tournaments statistics, too
- champion field added in mybb_games_tournaments to simplify the whole system
- When you edit the activity of a game, the tournaments statitics are updated
- Updated field asking to add gamedata to 1-0 system
- Control if the user is logged in before showing add and delete functions of favourites
- Control if user is has permissions to add a tournament before show the link
- Bug controlling permissions to add a tournament fixed
- Bug in games overview in ACP fixed
- Bug fix for warning when deleting a user without champions
- Check if the given by the game is empty when adding a score
- Change to make it possible to add an extra group permission in the Game Section tab
- Language update
- Settings translation bug fix
- Favourite function on scores page
- The page detector of the newscore page looks now to the date added, too.
- Redirect to the previous page when a favourite is added or deleted
- Include old comment in the comment form
- Fixed randomgames in IE
- Fixed tournaments links in IE
- Fixed tournaments search system for IE
- Session system changed to own table
- Delete session when user is deleted or merged
- Session cleanup task

Changes since 1.1.9:
- Overviewed/rewritten code
- Tournaments UNFINISHED
- Support for many game systems
- Less queries for the user statistics
- Most played games (in stats)
- Players with most champions (in stats)
- Advanced version of the last new champions (Option in menu) - all champions changes (with cache)
- Favourites
- Last played
- Advanced who's online
- Category picture
- Number of games in category
- New system to show the categories
- New settings system
- Search system in ACP
- Control games (warning when adding the same game)
- Choise between 1 large query and 3 less queries
- Category in games overview (AdminCP)
- Added date in games overview (AdminCP)
- Searchbar on the page with your search results
- Compatibility with edit, merge and delete of users
- Possibility to view statistics of the category
- Random games with refresh button (AJAX)
- Compatible with MySQL strict
- Updated rate system
- Compatibility of Who's online system with bots database

More information