ListTab "Table Mod"

that is done - it even lets me click the 'new' button, but it only shows the first entry and wont save anymore after that.

I even tried the 'modify core tables' option, and now it wont save any of them.... i am banging my head here... i have Joomla 1.0.11, Newest CB, and have latest listtab - even tried the table mod.

I have List Tab + Table Mod installed on CB version 1.0.1.

I'm not sure if List Tab has been verified as working on CB version 1.0.2.
The Table Mod also has not been verified for 1.0.2 either.

I did try it and saw no big problems. I do not know of anyone who would have 1.0.2 and this plugin in production use.

mikko

I am currently using CB 1.0.2 and Joomla 1.0.11 (recently updated from 1.0.7) and have exactly the same problem. I tried reinstalling cb 1.0.1 but I get the same error so I'm starting to think it's the latest Joomla version.

It was working fine before (cb 1.0.1 and joomla 1.0.7) except for an issue when trying to pick a date from a date field.

If I am trying to update a profile from within the admin window I get an SQL error saying that it doesn't recognize some fields when inserting the data in the main table. These belong to a listtab enabled tab (with alter core tables set to ON). So I believe that somehow those fields haven't been removed from the query and it is trying to insert the data in the old table rather than the newly created ones.

I would really appreciate any help on this. I pretty much tried everything there was to try. Even the mod plugin.

Post edited by: pyttech, at: 2006/12/02 08:05

The date issue has been solved, but there are some problems with the new release. I will take a look at it probably tomorrow.

mikko

This post describe how the plugin can be made to work with 1.0.2.

0) Back up

1) run this query: UPDATE `jos_comprofiler_fields` f,
jos_comprofiler_tabs t SET f.table = concat( "#__comprofiler_listtab_", f.tabid ) WHERE f.tabid = t.tabid AND t.pluginclass = 'listtab';

2) modify comprofiler.php

Find this line located roughly at line number 650
[code:1]
$database->setQuery( "SELECT f.* FROM #__comprofiler_fields f, #__comprofiler_tabs t"

. "\n WHERE f.published=1 and f.tabid = t.tabid AND t.enabled=1 and f.readonly=0" );
[/code:1]
And change it to this
[code:1]
$database->setQuery( "SELECT f.* FROM #__comprofiler_fields f, #__comprofiler_tabs t"

. "\n WHERE f.published=1 and f.tabid = t.tabid AND t.enabled=1 and f.readonly=0 AND f.table like '?__comprofiler'" );
[/code:1]

Then copy the files included in the attached zip over the original files.

NeonDevil: I included your readme here since it is much better than mine. Also put you in the copyrights.

mikko

Post edited by: mikko, at: 2006/12/06 12:22