|
No valid database connection jos_gj_options 2 Years, 8 Months ago
|
Karma: 0
|
|
Hello,
I have the following message apearing at the top of any page of groupjive (ie, group categories, single group view etc).
No valid database connection Table 'musician_mpweb.jos_gj_options' doesn't exist SQL=SELECT * FROM `jos_gj_options` WHERE `id` = '1'
Do you know where this come from ?
I don't have any table called jos_gj_options in MySQL
Is there anything I can do in configuration or PhpMyAdmin
Thanks a lot in advance !
|
|
|
|
Last Edit: 2009/06/10 16:21 By kokolapin.
|
|
|
Re:No valid database connection jos_gj_options 2 Years, 8 Months ago
|
Karma: 0
|
What version you running? 30a (1.7) does not have a _gj_options table. I checked the XML file of an older version (1.6 beta4) and it has one created as follows. Maybe you should upgrade.
| Code: |
CREATE TABLE IF NOT EXISTS `#__gj_options` ( `id` int(10) unsigned NOT NULL auto_increment, `onpage` int(5) NOT NULL default '0', `onpage_members` int(5) NOT NULL default '0', `bul_creator` enum('0','1') NOT NULL default '0', `blogm` int(5)
NOT NULL default '0', `nophoto` varchar(255) NOT NULL default '', `nophoto_logo` varchar(255) NOT NULL default '', `approval` enum('0','1') NOT NULL default '0', `pms` enum('email','uddeim','mypms','pmsenh','jim','missus','clexus')
NOT NULL default 'email', `notify` enum('0','1') NOT NULL default '0', `notifyjoin` enum('0','1') NOT NULL default '0', `nonreg` enum('0','1') NOT NULL default '0', `version` enum('0','1') NOT NULL default '0', `admin_email` varchar(55)
NOT NULL default 'Webmaster@MyDomain.com', `send_admin_emails` enum('0','1') NOT NULL default '1', `real_names` enum('0','1') NOT NULL default '0', `create_groups` int(11) NOT NULL default '1', `logosize` int(5)
NOT NULL default '128', `date_form` varchar(50) NOT NULL default '%Y-%m-%d %H:%i:%s', `jb` enum('0','1') NOT NULL default '0', `jb_cat` int(3) NOT NULL default '0', `eventlist` enum('0','1') NOT NULL default '0', `bulletin` enum('0','1')
NOT NULL default '1', `jomcomment` enum('0','1') NOT NULL default '0', `wysiwyg` enum('0','1') NOT NULL default '0', `wysiwyg_width` int(5) NOT NULL default '400', `wysiwyg_height` int(5) NOT NULL default '200', `wysiwyg_rows` int(5)
NOT NULL default '80', `wysiwyg_cols` int(5) NOT NULL default '15', `ajax_active` enum('0','1') NOT NULL default '0', `ajax_access` tinyint(3) NOT NULL DEFAULT '0', `ajax_message` varchar(25) NOT NULL default 'load data', `template` varchar(25)
NOT NULL default 'default', `hideprivate` enum('0','1') NOT NULL default '0', `jb_count` int(5) NOT NULL default '5', `el_count` int(5) NOT NULL default '5', `force_invite` enum('0','1') NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
|
|
|
|
|
|
|
|
Re:No valid database connection jos_gj_options 2 Years, 8 Months ago
|
Karma: 0
|
|
I totally desinstalled using joomla and manually through ftp,
and checked mysql tables for "gj" and further clean-up, and i reinstalled the latest version from site site.
I still had the message showing on profile access and update. I managed to get rid of them by creating the table and an additional field (because when you solve the first error by creating the option table, you get another error,
and a field has to be created in the option table, sorry i don't have the name in mind right now).
Now, it is possible that I first installed a version of groupjive that came with template plazza communa 3 template.
I don't use this template anymore, and have upgraded all components that could be upgraded (CB, GJ ..) and it was still happening.
Other people that run into this error may have this template, otherwise it is something else.
Regards
|
|
|
|
Last Edit: 2009/06/12 01:41 By kokolapin.
|
|
|
Re:No valid database connection jos_gj_options 2 Years, 7 Months ago
|
Karma: 0
|
|
I have same problem what i must do ?
No valid database connection Table 'musician_mpweb.jos_gj_options' doesn't exist SQL=SELECT * FROM `jos_gj_options` WHERE `id` = '1'
My template is from yoo theme,if i try with other template nothing happen same problems, i dont understand can u help me pls ?
ty very much
|
|
|
|
Last Edit: 2009/06/27 17:42 By boogy.
|
|
|
Re:No valid database connection jos_gj_options 2 Years, 7 Months ago
|
Karma: 0
|
|
you go on the internet for mysql tutorial for this:
- create table that you call with the name the GJ looks for
Then when this one is solved, you will have another message about a "field" this time.
- create a field with the name GJ asks for.
When you do those 2 things, you remove all error messages and all works fine.
|
|
|
|
|
|
|
Re:No valid database connection jos_gj_options 2 Years, 7 Months ago
|
Karma: 0
|
|
By the way,
in the code, the following lines contain gj_options and are still active
admin.groupjive.php (line 320)
groupjive.class.php (line 253
groupjive.html.php (line 572)
|
|
|
|
Last Edit: 2009/06/27 20:34 By kokolapin.
|
|
|
