Skip to Content Skip to Menu

🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

[SOLVED] Group Jive Database error

  • Taboga
  • Taboga
  • OFFLINE
  • Posts: 87
  • Thanks: 0
  • Karma: -1
13 years 9 months ago - 13 years 9 months ago #158127 by Taboga
[SOLVED] Group Jive Database error was created by Taboga
What should I do?

DB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_grcategory' doesn't exist SQL=SHOW COLUMNS FROM jos_gj_grcategory LIKE 'cat_image'

ry to create field `cat_image` Error while alter table #__gj_grcategory
DB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_grcategory' doesn't exist SQL=ALTER TABLE `jos_gj_grcategory` ADD `cat_image` varchar(255) default NULL

DB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_grcategory' doesn't exist SQL=ALTER TABLE `jos_gj_grcategory` ADD `access` tinyint(3) NOT NULL DEFAULT '0'
check if field `ordering` exists

DB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_grcategory' doesn't exist SQL=SHOW COLUMNS FROM jos_gj_grcategory LIKE 'ordering'

Warning: Invalid argument supplied for foreach() in /home/vetsinpa/public_html/administrator/components/com_groupjive/install.groupjive.php on line 301
field `ordering` does not existtry to create field `ordering`Error while alter table #__gj_grcategoryDB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_grcategory' doesn't exist SQL=ALTER TABLE `jos_gj_grcategory` ADD `ordering` tinyint(4) default NULLcheck if field `descr` exists

DB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_grcategory' doesn't exist SQL=SHOW COLUMNS FROM jos_gj_grcategory LIKE 'descr'

Warning: Invalid argument supplied for foreach() in /home/vetsinpa/public_html/administrator/components/com_groupjive/install.groupjive.php on line 301
field `descr` does not existtry to create field `descr`Error while alter table #__gj_grcategoryDB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_grcategory' doesn't exist SQL=ALTER TABLE `jos_gj_grcategory` ADD `descr` text NOT NULL default ''check if field `params` exists

DB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_groups' doesn't exist SQL=SHOW COLUMNS FROM jos_gj_groups LIKE 'params'

Warning: Invalid argument supplied for foreach() in /home/vetsinpa/public_html/administrator/components/com_groupjive/install.groupjive.php on line 301
field `params` does not existtry to create field `params`Error while alter table #__gj_groupsDB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_groups' doesn't exist SQL=ALTER TABLE `jos_gj_groups` ADD `params` text NOT NULL default ''check if default settings existscheck if usertable still uses new enum set

DB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_users' doesn't exist SQL=SHOW COLUMNS FROM jos_gj_users LIKE 'status'
table uses old valuestry to alter table to use new valuesError while alter table #__gj_users - add field status_tmpDB function failed with error number 1146
Table 'vetsinpa_jo151.jos_gj_users' doesn't exist SQL=ALTER TABLE `jos_gj_users` ADD `status_tmp` enum('active','inactive','invited','need approval','undefined') NOT NULL default 'undefined'


What should I do?
Last edit: 13 years 9 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
13 years 9 months ago #158145 by nant
Replied by nant on topic Re: Group Jive Database error
What versions or everything are you using?

Please Log in or Create an account to join the conversation.

  • Taboga
  • Taboga
  • OFFLINE
  • Posts: 87
  • Thanks: 0
  • Karma: -1
13 years 9 months ago #158212 by Taboga
Replied by Taboga on topic Re: Group Jive Database error
I am using Joomla 1.6 and the latest version of Group Jive (freshly downloaded)

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48616
  • Thanks: 8302
  • Karma: 1446
13 years 9 months ago #158233 by krileon
Replied by krileon on topic Re: Group Jive Database error
You are trying to use GJ 1.8, which is end of life. It also will not work on Joomla 1.6. Please download GJ 2.1 and install as a CB plugin, please review its included documentation for installation information.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • Taboga
  • Taboga
  • OFFLINE
  • Posts: 87
  • Thanks: 0
  • Karma: -1
13 years 9 months ago #158235 by Taboga
Replied by Taboga on topic Re: Group Jive Database error
Thank you!

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum