 #1 Error when creating new group [FIXED in new upl  (1 viewing) (1) Guest
 | | |
|
TOPIC: #1 Error when creating new group [FIXED in new upl
|
|
#1 Error when creating new group [FIXED in new upl 3 Years, 2 Months ago
|
Karma: 0
|
|
When creating new group. Group was created but with additional error.
Probobly because eventlist - I don't install this plugin yet.
DB function failed with error number 1146
Table 'joomlamk24.jos_gj_jb' doesn't exist SQL=SELECT a.*, a.name AS groupname, DATE_FORMAT(date_s, '%d.%m.%Y') AS date_s, b.catname, b.id AS catid, c.category_id, d.name, d.username, e.category_id AS category_id_el FROM jos_gj_groups as a INNER JOIN jos_gj_grcategory AS b ON a.category = b.id INNER JOIN jos_users as d ON a.user_id = d.id LEFT JOIN jos_gj_jb as c ON a.id = c.group_id LEFT JOIN jos_gj_eventlist as e ON a.id = e.group_id WHERE a.id='4' AND b.access <= 2 AND a.active='1'
|
|
|
|
Last Edit: 2008/12/04 22:11 By Rapunzl.
|
|
|
Re:I'm first here - with small issue 3 Years, 2 Months ago
|
Karma: 7
|
|
In GJ settings, make sure you say no to enabling Eventlist. This feature has not yet been updated for the new version.
|
|
|
|
|
|
|
Re:I'm first here - with small issue 3 Years, 2 Months ago
|
Karma: 0
|
|
I have "No" value in this option. THis error occures also when I click on created group
Table 'joomlamk24.jos_gj_eventlist' doesn't exist SQL=SELECT a.*, a.name AS groupname, DATE_FORMAT(date_s, '%d.%m.%Y') AS date_s, b.catname, b.id AS catid, c.category_id, d.name, d.username, e.category_id AS category_id_el FROM jos_gj_groups as a INNER JOIN jos_gj_grcategory AS b ON a.category = b.id INNER JOIN jos_users as d ON a.user_id = d.id LEFT JOIN jos_gj_jb as c ON a.id = c.group_id LEFT JOIN jos_gj_eventlist as e ON a.id = e.group_id WHERE a.id='4' AND b.access <= 0 AND a.active='1'
This is SQL message, means that table jos_gj_eventlist is not installed. And I look in GJ1.7 install zip and didn't found CREATE%table%gj_eventlist%
Regards.
|
|
|
|
Last Edit: 2008/12/04 11:07 By mkalisz.
|
|
|
Re:I'm first here - with small issue 3 Years, 2 Months ago
|
Karma: 7
|
Confirmed... moving to known bugs. Thanks 
|
|
|
|
|
|
|
Re:I'm first here - with small issue 3 Years, 2 Months ago
|
Karma: 7
|
A proposed temporary fix was sent to me by Creator. It's stiggi's birthday, so in case he doesn't get the fix uploaded soon, you can continue testing using this:
Hi, I would have posted this in the forum but they are all locked. For those that would like to continue testing the new GJ version even though the confirmed bug. All that is needed is to execute this Query in phpmyadmin:
CREATE TABLE IF NOT EXISTS `jos_gj_eventlist` (
`id` int(11) unsigned NOT NULL auto_increment,
`group_id` int(11),
`category_id` int(11),
PRIMARY KEY (`id`)
) TYPE=MyISAM
Then testing of GJ will be able to continue until the bug has been fixed.
Cheers
Dave
PS - Dave aka Creator, the forums are not locked. Only the top thread (to keep people hopefully posting in the correct topic) and this (Confirmed Bugs) are locked.

|
|
|
|
Last Edit: 2008/12/04 16:59 By Rapunzl.
|
|
|
Re:I'm first here - with small issue 3 Years, 2 Months ago
|
Karma: 6
|
|
It seems I am getting blind while working each evening on this stuff..
I removed the creation of the gj_eventlist table - so the SQL statement you posted couldn't join
I will remove the eventlist code from core groupjive the next days. I don't know if I find the time to write the plugin this year. Have to talk to Schlu before to find a good integration solution.
I added the missing SQL statement to the component file. Please download com_groupjive_v28e.zip.
|
|
Micha
Moderator
Posts: 291
|
|
|
|
|
 | | | 
|