Extension talk:TableEdit

From MediaWiki.org
Jump to navigation Jump to search

This page is for bugs, requests, and questions about Extension:TableEdit. Please add your item at the end of the page, and include your MediaWiki signature ("~~~~") at the end of your post.

Contents

Row Data spacing[edit]

I've noticed that when I save data in a cell, the way it applies to the page puts <p> tags around that data. The end effect causes the data to have extra spacing between rows.

Example :

<td><p>test</p></td>

It would appear this is caused by the way data is saved in wiki format from the editor.

|- bgcolor=#F7F9FA
|
test
|

Is it possible to force it to add the data to the same line as the start of the cell? Like this..

|- bgcolor=#F7F9FA
|test
|

Thereby removing the <p> tag.

<td>test</td>

Using Version 0.8 --Bandophahita 19:06, 17 September 2008 (UTC)

More Styling Information[edit]

Is there more styling information you can include? Like adding attributes to the other cells besides the header, add a border around the whole table? Or refer to a style class?

Rational for off page data[edit]

I was just wondering what the rational was for storing data off page. In a case like this it would seem that data entered would not be accessible to the standard wiki search. Is this true? --Dtsig 02:59, 21 April 2007 (UTC)

the text gets stored in the wiki as if it was a regular table. There are two reasons for storing it in the external database. The first has to do with asynchronous data mining of the table content. The idea is that middleware can be written to work on the external db without interfering with the wiki's db or having to go through the MW interfaces. I'm working on that kind of middleware right now, but it's in Perl, not PHP. The second is laziness/lack of imagination/coding skill on my part in terms of how to implement it if it was just saved in the wiki. In hindsight, I probably could have spent more time adapting whatever the parser already does with tables. -- JimHu 03:15, 21 April 2007 (UTC)
Is it possible to simply switch off the external storage? Possibly a variable set so the external db is not required.? --Dtsig 17:22, 24 April 2007 (UTC)
not yet. The table loads from the database, not from the wiki page. That could change in the future, especially with contributions from other coders (hint, hint) JimHu 23:59, 24 April 2007 (UTC)

Bulk load from a CVS or XML file[edit]

It would be great if you add the capability to read in a CVS or XML file

New TableEdit feature/enhancement --Dtsig 14:39, 6 August 2007 (UTC)[edit]

There should be a way to wrap it and have it create a table definition
2) If a user messes with the data or worse screws with the tag then we are really hosed <G>For those who don't need the data in a DB for other use, wouldn't it be possible for the routine to parse out a generic table and process just as if it came from the db? I think this would be a great enhancement. So a simple tage <tableedit/> on the page would have the parser put the appropriate 'link' before each table. I get that this wasn't the original purpose but would make MediaWiki much stronger.

--Dtsig 21:04, 14 February 2008 (UTC)[edit]

Jim, have put put any thought to this. Wouldn't it be a *simple* case of pulling out the table, its rows, columns and headings? Everything inside would stay the same I would think Though not sure how you are saving this off. Look forward to talking

Can't insert row in the middle neither[edit]

Hello it seems that I can't install neither a row in the middle of a table, is this correct? Oub 10:38, 7 November 2007 (UTC):

that's true in current versions. Note that the tables should be sortable, however. --JimHu 19:01, 14 November 2007
Re: JimHuthanks, but how can I sort, I mean I do not see any bottom for that functionality. Oub 09:20, 15 November 2007 (UTC):
Re: Ste I agree, I can't see any way to insert in the middle, it's a very important feature to update the table!:

Watchlist not working for me[edit]

Apologies for not noting changes on these pages - for some reason the watchlist emails are not reaching me --JimHu 19:01, 14 November 2007 (UTC)

Question about advanced templates[edit]

I have installed TableEdit successfully and have been enjoying the product to create our tables throughout our Wiki's. We're now interested in going further with the table and are trying to set up the advanced features - the drop down lists, etc, that is outlined in the documentation.

Our company has attempted to get these advanced tables to work, but nothing has been successful. The script example given in the documentation is:

  Qualifier||qualifier|select| |NOT
  GO ID||go_id|text
  GO term name||go_term|lookupcalc|SELECT page_title from go_archive.term WHERE go_id = '{{{go_id}}}' ORDER BY term_update DESC LIMIT 1|page_title|split|_!_|1Reference(s)||refs
  Evidence Code||evidence|select|IC: Inferred by Curator|IDA: Inferred from Direct Assay|NR: Not Recorded
  [...]

My question is, how or where, or at what point, do you insert these script commands? Are they in the portal itself, such as:

<newtableedit> [script commands] </newtableedit>

Or, do you create the table, using the <newtableedit> tag, then once you're in the table, somehow insert these script commands?

We have tried numerous different scenarios, different syntaxes, etc, but have come up with nothing. Going from the documentation, it seems to be related to the <headings> tag, but again, we don't know how or where to use these <headings> tags, if at all, to accomplish what we want.

If anyone has been able to get these advanced tables to work, please respond to this and let us know how you did it.

Thank you!

The advanced tables take their formatting from pages in the Template namespace. Create a page Template:MyTable, and put in the scripting. Then on the page where you want that kind of table, use

<newtableedit> MyTable </newtableedit> --JimHu 04:16, 11 February 2008 (UTC) (I really wish the watchlist would work.. It seems to work on my User:Talk page.)

Working fine now - thank you! ]


I have the same question, except the above solution does not work. All of the options that should be in the dropdown are columns in the table instead. The add data button leads to a blank page with the page title as a heading. This happened after I copy/pasted the script out of the help file into a new template and then called it using <newTableEdit>Template:Name</newTableEdit> with TableEdit 0.8 and MW 1.13. I see my MW version is a bit out of date, is that the problem? --Lovettse 20:47, 13 January 2009 (UTC)

Just in case it's relevant, I've disabled caching on my wiki. I had to change these two lines in LocalSettings.php:
$wgEnableParserCache = false;
$wgCachePages = false;
Also, I got the same result when I pulled out the line using a SQL query and both pulldown menus.--Lovettse 21:02, 13 January 2009 (UTC)

Lines in the table[edit]

Is there a way to show the lines in the table? In edit mode you see the lines between the cells, but when you save it you don't? It would look better for our tables to have the lines between the columns & rows to make it more visible.

Anyone know if this can be accomplished? Thanks!!

--Dtsig 21:06, 14 February 2008 (UTC)[edit]

Although I haven't looked it should be a css for the table style. It should be possible to modify this though it would be manual after each new table. I would think that this could be an option when creating a table. Jim?

I think it defaults to using the Prettytable template, which might not be in everyone's wiki. --JimHu 08:18, 16 February 2008 (UTC)

Nice Enhancements --Dtsig 16:38, 27 March 2008 (UTC)[edit]

  1. Quick Enter; it would be nice to define a character that someone could use to enter more than one row at a time. For example, if I go to ADD i can only enter i row,column at a time. If i entered something like 'data 1~data 2~data 3' then upon exiting table edit mod it would break that down to 3 rows of data for that column. If you have multiple columns you might in the second box put 'col2 row1~~col2 row3' which would associate with the first column of data.
  2. Modify Table Properties; this would allow adding a column or removing a column

another 'Clone a Row' --Dtsig 17:29, 27 March 2008 (UTC)[edit]

It would also be very nice to have the ability to clone 1 row of data to another. This allows quick and easy editing/creating. Especially since you only get 1 row of data at a time.

This one will be in the next release as copy row --JimHu 22:27, 8 April 2008 (UTC)

Followup to email --208.214.103.202 19:39, 8 April 2008 (UTC)[edit]

Okay, as a first task I would suggest the ability to ADD a column or DELETE a column. I would suggest that both of these button be at the bottom with the "save" data. Possibly 2 rows of controls? Add Column, Delete Columns, Delete Table on 1 row. Add Data, Save Data, Save Return and Cancel Changes on the second row.

-- Add column and delete column work via Edit Headings, but only on the last column, so far. --JimHu 22:37, 8 April 2008 (UTC)

---I do not get the 'Edit Headings' on my TableEdit. Currently version 0.5 Is there a newer version. Sorry for late reply but I am not getting 'watchlist' messages <sigh>. thanks --Dtsig 22:35, 19 May 2008 (UTC)

Cancel changes; from the overall table page, simply like the back arrow - returning to the wiki page. No harm no foul

This should be easy. On the todo list for the next release --JimHu 22:37, 8 April 2008 (UTC)

Save Data; from the overall table page, this would write it out but not return. Allow adding. I have found that at times, because of timing, meetings etc, I have come back adding rows and a few rows I had added earlier are gone. <sigh>

Hmm.... session data expires? So, you want save and return to page to be separate? --JimHu 22:37, 8 April 2008 (UTC)

Add Column would maybe prompt for column heading then add NULLs for that column as needed through all rows.

Delete Column would prompt for the column to delete. Go through the rows in the db deleting the positions.

We could go further with a "clear" for the TABLE and ROW

I think I know what you want here, but just to check... you want to keep the structure, but empty the data for existing row (clear row from row edit view) or all rows (clear table from table view). --JimHu 22:37, 8 April 2008 (UTC)
exactly --Dtsig 22:37, 19 May 2008 (UTC)

I still wonder if have this "non db" required wouldn't be a big enhancement. But then that probably might not be so easy the way it is structured. I think once I looked and you build the page according to the DB. Of course if this is true then you could build a "sort" column into the db automatically without displaying. Then you could have "pop-up" page of all rows with this column on it. Allow the user to RENUMBER them and use that as your SELECT ORDER column.

I'm working on a version that extracts the table from the wikitext. Not fully db-free, though. I wrote this partly as an alternative to Semantic Mediawiki, where the table db is separately mineable from the main wiki db, so while I see what you mean, I don't think TableEdit is going to go there.--JimHu 22:37, 8 April 2008 (UTC)

Misc Table properties showing --Dtsig 16:38, 27 March 2008 (UTC)[edit]

id='5' class = 'sortable'

This information shows just above the table. If I look at the HTML for the table setup it looks like

{|{{Prettytable}} id='5' class = 'sortable'

Not really sure why it is showing in the page. Template error??

User Not Logged In Error[edit]

Hi,

I have recently split up my wiki and moved some of it to a new wiki and am having problems with the tableEdit extension. I have managed to move all my tableedit tables to the new working ang get them working fine. The only problem comes when I am not logged onto my wiki and I click the "edit table" link which then provides me with an error.

Internal error Detected bug in an extension! Hook TableEdit::loadMessages failed to return a value; should return true to continue  hook processing or false to abort. Backtrace: #0 /includes/MessageCache.php(684): wfRunHooks('LoadAllMessages') #1



Does anyone Know how to fix this or hide the "edit table" link when a user is not logged on?

Question about lines showing in the table[edit]

This was addressed somewhat (above), but I am seeking more clarification. When I click the "edit table" link, it displays the borders no problem. But when the table is saved/viewed on the portal, no borders are displayed. Is there a way to make the borders visible? Above, it references modifying CSS properties, but I am lost as to where/how to do that. Is that modification made in the portal code itself, after the table is generated? If so, what and where do I insert in the code to make the borders appear (and does it have to be done for each and every table)?

In addition, another comment relates to using the PrettyTable template. On my wiki (MediaWiki), when I edit the page containing the table, it uses the PrettyTable template, but it does not exist on my wiki (IE, when I click on it's link there is no content/page is not created).

Other than this minor visual issue, we love this table product and use it extensively on our intranets.

If anyone could assist us with this, we would appreciate it. Thank you very much!

Examples?[edit]

I could only find this page on your wiki where it's used in a template on a page (at the very top) and it's broken. This page has one example (in German, but it's something).

This extension looks very cool, but I can't get my head around it on my first look, and would like to see where it has been used. -- Chriswaterguy 08:35, 11 June 2008 (UTC)

Installation: beware of «update_schema.php»[edit]

update_schema.php (from «TableEdit.0.8») is useless, because:

  • Works only under Linux (it use PHP function «getopt», it use some UNIX utilities, ...);
  • «ENGINE=MyISAM» and «DEFAULT CHARSET=latin1» are hardcoded in SQL texts.
  • TableEdit_tables.sql contains some syntax errors (L18, L33, ...).

Instead of running «update_schema.php», users must critically review TableEdit_tables.sql, fix errors and parameters («ENGINE», «DEFAULT CHARSET») and run it manually. --StasFomin 12:37, 28 July 2008 (UTC)

Note added to the installation instructions to note problems with update schema. We let the schema SQL docs and the installer get out of sync, since we're trying to reproduce schema adjustments we made manually, and I screwed up in manually editing the SQL (left out some commas). We're working on a new version of update schema, but it's not there yet (because I made some additional modifications - adding a timestamp to the metadata). We can try to make it more platform independent if you can give us some help; it was actually tested on Macs, not Linux --JimHu 15:30, 28 July 2008 (UTC)

Installation error;[edit]

mediawiki 1.12 php5 phpmyadmin

I just can't run the file "TableEdit_tables.sql" , I kept receive this error message.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY `template` (`template`), KEY `page_name` (`page_name`) ) ENGINE=MyISAM DE' at line 13

working on a new release to fix this. In the meantime, here is a dump of the structure of those tables from EcoliWiki, where it's running live - note that this is already slightly changed from the 0.8 release; but it should be compatible and will prepare you for the 0.81 release:
-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- Host: trimer.local:3306
-- Generation Time: Jul 30, 2008 at 05:14 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `colipedia`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_box`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_box`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_box` (
  `box_id` int(10) unsigned NOT NULL auto_increment,
  `template` varchar(255) NOT NULL,
  `page_name` varchar(255) NOT NULL,
  `page_uid` varchar(255) NOT NULL,
  `box_uid` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `headings` varchar(255) NOT NULL,
  `heading_style` varchar(255) NOT NULL,
  `box_style` varchar(255) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY  (`box_id`),
  KEY `template` (`template`),
  KEY `page_name` (`page_name`),
  KEY `page_uid` (`page_uid`),
  KEY `box_uid` (`box_uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_box_metadata`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_box_metadata`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_box_metadata` (
  `box_metadata_id` int(10) unsigned NOT NULL auto_increment,
  `box_id` int(10) unsigned NOT NULL default '0',
  `box_metadata` varchar(255) NOT NULL default '',
  `timestamp` int(10) NOT NULL,
  PRIMARY KEY  (`box_metadata_id`),
  KEY `box_id` (`box_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_row`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_row`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_row` (
  `row_id` int(10) unsigned NOT NULL auto_increment,
  `box_id` int(10) unsigned NOT NULL,
  `owner_uid` int(10) default NULL,
  `row_data` text NOT NULL,
  `row_style` varchar(255) NOT NULL,
  `row_sort_order` int(11) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`row_id`),
  KEY `box_id` (`box_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_row_metadata`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_row_metadata`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_row_metadata` (
  `row_metadata_id` int(10) unsigned NOT NULL auto_increment,
  `row_id` int(10) unsigned NOT NULL default '0',
  `row_metadata` varchar(255) NOT NULL default '',
  `timestamp` int(10) NOT NULL,
  PRIMARY KEY  (`row_metadata_id`),
  KEY `row_id` (`row_id`),
  KEY `row_metadata` (`row_metadata`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
hope this helps --JimHu 22:18, 30 July 2008 (UTC)
      • It really does help, thanks you very much.


    • Thank you, but how does one then install it properly if one is receiving this error? Do I copy the above text into the "TableEdit_table.sql" file and rerun the update php file.

Work with Extension:ParserFunctions?[edit]

What is the data structure? Is all the data store somewhere else within database? Can we retrive it on another page? On the other hand, can we do some calculation with those data?

For example:
{{#expr: {{{Field1}}} * {{{Field2}}} }}

I think Extension:WikiDB is an great idea but it's still very primitive.


Fix "Printable Version" page[edit]

I had a problem with the default skin of MediaWiki and TableEdit, when useing "Printable Version". In all of my tables the first column got way too wide, because MediaWiki displays "Edit Tanle" button with it's full URL.

I came up with a workaround:

  1. Edit file /path/to/mediawiki-root-dir/skins/common/commonPrint.css
  2. Add following to the end of file:
tr.sortbottom {
    font-size: 0px;
    display: none;
}

Done - the "Printable Version" page should now display without the "Edit Table" row at all. If you happen to wonder, "font-size: 0px;" is there to do the trick with some older browsers, in 99% of cases "display: none;" is all that is needed. Wyrmiyu 21:10, 14 October 2008 (UTC)


TableEdit stopped working[edit]

I had to migrate our wiki due to a server crash. Everything in the mediawiki seems fine except for the TableEdit. It won't allow me to create a new table nor edit an old table.

werd


Sending variables to the template?[edit]

Is it possible to send variables to the template in a similar way you do with a 'normal' template? eg. I'd like to be able to do something like this:

         <newTableEdit>{{Template:Gene_data|gene=FABP3}}</newTableEdit>
or this  <newTableEdit>Template:Gene_data|gene=FABP3</newTableEdit>
or       <newTableEdit>{{Gene_data|gene=FABP3}}</newTableEdit>


thanx, Russell Smithies

Newest version[edit]

On http://ecoliwiki.net/ the version listed is 0.99 but the version publicly available is 0.8. Is 0.99 available somewhere?

First-time Installation problem with REL-0.99[edit]

update_schema.php expects the five SQL files for the table structure to have the .sql extension, but in the version of the package linked in this page ( trimer.tamu.edu/jh/TableEdit-v0.99.tar.gz ), the files in the sql directory do not have that suffix. DEinspanjer 19:37, 25 August 2009 (UTC)

Same here, .sql extensions missing --sandb 01:31, 15 October 2009

Other than the .sql extenstions missing from the filenames, the sql commands also fail to take into account databases with prefixes in their tables. table prefixes also needs to be added to SpecialTableEdit.body.php sql table calls. -- 218.186.13.227 08:38, 19 October 2009 (UTC)

Support for newer MediaWiki versions[edit]

The file INSTALL talks about AdminSettings.php, which disappeared in recent MediaWiki versions.

Is it possible to use TableEdit with MediaWiki versions 1.13 and newer? If so, is this documented anywhere?

(Note: prev. person didn't sign anything.)

It should be possible by editing the update_schema.php file:

if (is_file("$wikipath/AdminSettings.php")) {
require_once ("$wikipath/AdminSettings.php");
} elseif (is_file("$wikipath/LocalSettings.php")) {
require_once ("$wikipath/LocalSettings.php");
} else { die("Can't find AdminSettings.php in $wikipath\n");
}

That will go in order to check Admin*, then Local*. Now, I haven't been able to do this yet, due to an libldab.so.2 error, buuut I don't see why it wouldn't work. XtinaS 04:24, 18 January 2010 (UTC)

TableEdit-v2.0 coming...[edit]

I've been working with TableEdit a lot at work (EcoliWiki.net) and have produced a refined version. This project/extension was never meant to handle all the things we've added to it over the years, and I felt a major rewrite was in order. I have read all the above problems/concerns/fixes and am trying to address each this time. Check back later, and be glad...I'm writing documentation!!!

--Bluecurio 02:02, 25 March 2010 (UTC)

Hello Bluecurio. Any luck finishing up a new version of this extension. I can't get the existing one to install because of an error related to update_schema.php when I try to install. Any help? Thnx so much for all the hard work! jlewis04 at syr dot edu.

Table-Prefix in Mediawiki[edit]

We have a prefix on all our tables in mediawiki. E.g. the table pages is named "wikipages", users "wikiusers" and so on.

When creating a new table, TableEdit complains:

Syntax error:
function „wikiBox::save_to_db“. SQL-Error „1146: Table 'wikidb.wikiext_TableEdit_box' doesn't exist“.

First I changed the names with phpmyadmin to wikiext_...

And then I had to change class.wikiBox.php and had to patch this table-prefix to the select conditions in function query_relations_table

--212.80.243.66 10:30, 25 March 2010 (UTC)

When table is changed and saved, it is not saved back to the orginal page in the wiki[edit]

Hello

Some 2 years ago I installed TableEdit in a wiki (running mediawiki-1.9.3) I think the TableEdit version is 0.75. For that version a different database was needed and took the default wikibox_db.

I have not used TableEdit for a long time and had recently a hard disk crash. I was able to recover the wiki via the corresponding mysql db and I think I also recovered successfully the db for TableEdit, although I am not sure about the corresponding user and his/her password.

However everyting seems to work save one problem. When I edit the table and add an entry (in the public area) then save the table back to the wiki the page is not save in the right place.

Say the orginal table is in

http://localhost/wiki/index.php/Miembros_CADEDIF then after editing, adding and saving the new table is in http://localhost/wiki/index.php/Table of course I could edit that page and copy its content into http://localhost/wiki/index.php/Miembros_CADEDIF but I don't remember that is was this cumbersome. Any suggestion is strongly appreciated. Thanks Oub 18:05, 16 September 2010 (UTC):

render cell as link?[edit]

EcoliWiki has some tables (example: galF:Gene_Product(s)) that have plain text in a cell that is rendered on the page as a live link (such as the "GO ID" column of the "Gene Ontology" table) - how is this done?

It appears to use Template:GO_table_product though I can't see how that causes the entries to render as links.

It doesn't appear to be the CSS that's doing it... Some sort of DB lookup?

Any clues?

Thanks!

TableEdit and InternetExplorer[edit]

I tried TableEdit with IE 7 and the table isn't sortable anymore, seems like the TH style is not applied. Anyone know a solution for this ? Thanks. (it works just fine with Firefox...)

  • Mediawiki 1.16
  • TableEdit 1.0.5

--Dyntheos 08:30, 13 December 2010 (UTC)

$(document).ready in init_datatables.js does not get called with IE 7, because of some javascript errors. "Errors" in the sens of IE, not Firefox. IE does not like the leading comas :

  • 'sInfoEmpty': 'No entries to show',
  • },
var base_options = {
	'bFilter': false,
	'bInfo': false,
	'bSort': true,
	'bPaginate': false,
	'oLanguage': {
		'sSearch': 'Filter Rows:',
		'sZeroRecords': 'No Rows in Table',
		'sInfoEmpty': 'No entries to show',
		
	},
};

So, basically, you have to correct the init_datatables.js and get rid of all the leading comas.

--Dyntheos 14:32, 15 December 2010 (UTC)

Column Styles[edit]

I am looking to designate specific column widths for my table, for example 50% for the first column, 20% for the second, and 15% for the third and fourth. In standard MediaWiki this is possible by declaring the format for the column prior to the column name itself. However, this doesn't seem to be the case with TableEdit. I don't see any ways to change column widths or, for that matter, to perform any sort of formatting of columns.

68.108.150.103 15:55, 9 February 2011 (UTC)

Partial workaround... you can specify width/style for all columns except the first one, in which case such styles end up as part of the header. This seems a parsing bug. Although when adding a new row to the table, the style codes show up in that dialogue. Ugly but acceptable workaround until this can be fixed.

68.108.150.103 16:56, 9 February 2011 (UTC)

No timestamp on first entry[edit]

Seems the timestamp only works after editing an existing row, rather than upon first entering one.

I've forced a timestamp to appear by editing SpecialTableEdit.body.php's processing of the timestamp column:

                                  case 'timestamp':
                                          if ($row->timestamp)
                                                  return date("Y-m-d",$row->timestamp);
                                          else
                                                  return date("Y-m-d",time());
                                          break;

Maybe not the best workaround but works for me!

--68.108.150.103 17:01, 9 February 2011 (UTC)

Secial Characters and Umlauts[edit]

This refers to MediaWiki 1.16.0 and TableEdit 1.05:

Seemingly TableEdit doesn'l like umlauts like "ö", "ä" and "ü". If I edit or add a row and use a umlaut, it get's screwed up. For example: "Lötbedarf" becomes "Lötbedarf". However if I use HTML-encodiung like "&ouml ;" inside the TableEdit form, everything is fine. It's very unlikely to be caused by my database or webserver settings, as anywhere else outside TableEdit umlauts work perfectly fine. Does anyone know what may cause this behaviour? 213.144.1.62 12:27, 17 March 2011 (UTC).

Does this happen with other accented characters, like "í", "à", "ã", "ñ", "ç", "ô", etc? --Lance E Sloan 16:35, 17 March 2011 (UTC)

Auto user addtion to table field[edit]

Hello,

Is it possible to add to the table field the name of user that created the row in automatic manner but not typing yourself [User:usernames|username]? I mean the column (e.g. 'created author') have to contain only the username of primary author, but not the username of users that will edit the table in future. I have tried the following:

  • filling the 'created author' as ~~~ in template leads to rows conflict each time that table are upgraded.
  • adding {{REVISIONUSER}} variable to table template is not working
  • sql query "SELECT user_name FROM wikidb.username WHERE user_name="{{REVISIONUSER}}" from table template (case 'lookup') results in 'permission denied' error message in editing box.

Are there any other ways to do that I want? Thank you in advance. 95.84.190.156 16:24, 21 March 2011 (UTC)

Error when removing column headings[edit]

The following error appears when I try to edit a four column table to remove one of the columns:

 Warning: preg_match() [function.preg-match]: Unknown modifier '{' in ... /html/extensions/TableEdit/modules/TableMarkerUpper.php on line 48

64.134.238.215 22:34, 6 April 2011 (UTC)


tableedit installation[edit]

I am trying to install tableedit extension for my wiki. I have installed Apache, mysql,myphpadmin,mediawiki succesfully which are working fine. I am new to mediawiki and php as well. Can anyone please explain me how to install tableedit extension given on the link Extension:TableEdit

I have downloaded the extension and extracted into the extension folder of mediawiki. After that I am not getting what I have to do.I am using Windows Xp. many Thanks.--146.162.240.242 08:56, 17 August 2011 (UTC)

Parse error: parse error, unexpected T_NEW[edit]

on TableEdit-v1.0.5/install.php on line 63

I'm using PHP 4.4. Could this be the cause?

Upgrade document blank?![edit]

# tar -zxf TableEdit-v1.0.5.tar.gz 
# cd TableEdit-v1.0.5/
# cat UPGRADE 
UPGRADE INSTRUCTIONS
--------------------------------------------------------------------------------
1.
#

Anyone know where to find upgrading instructions? The UPGRADE file in the latest version has no instructions.

Installation error?[edit]

Hello everyone. I am trying to install the TableEdit extension. I am running:

  • Windows Server 2008 R2
  • IIS 7.5
  • PHP 5.3.9
  • MySQL 5.5.20
  • MediaWiki 1.18.1

I have already installed the ProtectSection extension and I have verified it works as expected.

When I run php install.php -w c:\inetpub\wwwroot\mediawiki I get the error: No superuser credentials could be found. Please provide the details of a user with appropriate permissions to update the database. See the documentation.

I've double-checked my LocalSettings.php file, and I made an AdminSettings.php file with the necessary settings. I can run phpMyAdmin with the superuser credentials specified with no problem.

I've also tried the command line: php install.php ../.. and I get the same error.

Any help would be appreciated.

Update: I created the tables using phpMyAdmin, from the \SQL folder.

Thanks, Steve

PHP error[edit]

I can't create a table, and the index.php specialpages link is broken as well, looking in my logs, I have the following error :

PHP Fatal error: Call to a member function addMessages() on a non-object in <host>/wiki/extensions/TableEdit/SpecialTableEdit.body.php on line 1346, referer: http://<host>/wiki/index.php?title=Time_Line&action=edit

any ideas on how to fix?

I get the same error. Fatal error: Call to a member function addMessages() on a non-object in /<dir>/extensions/TableEdit/SpecialTableEdit.body.php on line 1346

Fatal error: Call to a member function insert_row() on a non-object[edit]

Reporting a similar, probably related error as the above user(s)... and a fix!

I had a working installation and had been using the extension for some time. I moved servers and the extension "broke". The only difference appears to be in PHP versions (the latest stable release on each machine). The "working" server had PHP 5.3.3-7+squeeze3 with Suhosin-Patch (cli) The new server has PHP 5.3.3-1ubuntu9.10 with Suhosin-Patch (cli)

On editing a row I get:

Fatal error: Call to a member function get_serialized() on a non-object in /<path>/extensions/tableEdit/SpecialTableEdit.body.php on line 522

On adding a row to an existing table I get:

Fatal error: Call to a member function insert_row() on a non-object in /<path>/extensions/tableEdit/SpecialTableEdit.body.php on line 528

These, and the symptoms noted above may be secondary symptoms related to the primary problem, also indicated above: on the page resulting from clicking the "Edit this page" link, the sidebar Special pages link fails with an error regarding memcache; it's possible this error is losing the "box" information that is needed by the above routines. The error associated with that special pages link is:

Fatal error: Undefined class constant 'COMPRESSION_SAVINGS' in /<path>/includes/memcached-client.php on line 967

Looking at line 967, the guilty constant is referred to as: self::COMPRESSION_SAVINGS On line 96 of the same file, it's defined as const COMPRESSION_SAVINGS = 0.20;

I am not enough of a php expert to know why that constant declaration isn't understood later on in the file, but substituting 0.20 in place of self::COMPRESSION_SAVINGS solved the other issues. I'll leave it to smarter minds to comment on here with an appropriate permanent fix.

Edit: Found another similar error/fix:

Fatal error: Undefined class constant 'COMPRESSED' in /<path>/includes/memcached-client.php on line 975

Replacing self::COMPRESSED with 2 here, and elsewhere in the file near line 899, and everything looks like it works. I also, preventatively, changed self::SERIALIZED to 1 in the memcached-client.php file, which may fix any other issues I haven't yet encountered.

Anyone know why self::<constant name> isn't referring to the constants at the top of the file?

184.7.78.185 23:13, 16 March 2012 (UTC)

Edit #2: According to http://stackoverflow.com/questions/151969/php-self-vs-this apparently changing self::<constant name> to static::<constant name> is the correct solution.

184.7.78.185 00:06, 17 March 2012 (UTC)

Edit #3: Reported the bug at https://bugzilla.wikimedia.org/show_bug.cgi?id=35274

184.7.78.185 00:28, 17 March 2012 (UTC)

Patch for Table Edit for Mediawiki 1.19[edit]

Table Edit have been helpful for our wiki adoption. Unfortunately when we try to upgrade to Mediawiki 1.19 Table edit doesn't support this version yet.

Anybody knows how to fix this? or are there any new Table edit version coming up to support the Mediawiki newer version? Thanks!

new version just added that we use with 1.19.2 --JimHu (talk) 19:22, 30 April 2013 (UTC)

Example links are not useful[edit]

The example links on this page that take you to ecoliwiki are useless because you cannot enter edit mode since they have limited editing to logged in users and they have disabled the create account feature. I tried to find an example somewhere else but could not.

Apologies for neglect[edit]

Apologies for neglecting this page. For some reason I am not getting watchlist notifications. I changed my email address to see if that helps. --JimHu (talk) 19:21, 30 April 2013 (UTC)

TableEdit: "No such special page. You have requested an invalid special page. A list of valid special pages......"[edit]

I have been using the extension TableEdit 1.0.8 for several MediaWiki versions- currently at MW 1.20.2. Upon attempting to edit a table, I'm now getting the error listed in the Subject above. I've always followed the upgrade instructions when updating the extensions, and updating MW itself.

I seem to remember that at one point during a TableEdit upgrade, it was necessary to update the mySQL db directly rather than using update_schema; however, I can't seem to find those instructions.

Many thanks in advance for any help.

updating to 1.08: how to update db tables for TableEdit?[edit]

I'm trying to update TableEdit to 1.08 and am getting the following:


(21:44 root@soho89-16-227-15 /var/www/html/colorist/wiki3/extensions/Library/WebServer/wiki-extensions/trunk/TableEdit) # php install.php -w /var/www/html/colorist/wiki3 It seems TableEdit is already installed! Try and upgrade TableEdit? (Y/N) y As of now there is no code written to update the existing database tables for TableEdit. If you have access to the MySQL database you can do this by hand. Sorry.



I have access to the MySQL database via phpMyAdmin or via the shell. Is there a pointer somewhere to what I might have to do to update the existing database tables ?

thank you very much in advance.

Installation in MediaWiki 1.2 or higher[edit]

I would like to install TableEdit in MediaWiki. The MediaWiki version is 1.2.

Is there a way to install without using the AdminSettings.php file?

I was also unable to locate the update_schema.php file which is suggested earlier on the discussion page.

Thanks for any tips!

--mindinme

Localization[edit]

There must be a reason why I can't find this extension from translatewiki.net ?

I'd be interested to translate it to my language.

89.166.60.185 08:16, 1 May 2014 (UTC)

Where's the real download link?[edit]

Maybe it's just too late and I need sleep, but the only download link I see is to a Github repo with dozens of files. The Github repo does not include a tar or gz file. Am I really supposed to download all these by hand, package them up myself, and put the package onto my server? Isn't there a link to a public gz somewhere? MatthewBurton (talk) 06:09, 6 February 2015 (UTC)

Query and Update from Another Page?[edit]

  • Is it possible to query a single field from a single record, with wikitext on another page?
  • Is it possible to append a new record with wikitext on another page?

Johnywhy (talk) 10:59, 28 May 2018 (UTC)