smelliott

still available on github https://github.com/wp-plugins/abase

I accomplished this by modifying the abase plugin and adding a defaults= to the plugin. Works well. I noticed there has not been much activity on this plugin in a while. Is it still being supported? This is a great plugin and I would hate to see it die.

Did you ever find a solution to this?

found this script easy to integrate and use for clickable column header sorting: https://www.kryogenix.org/code/browser/sorttable/

interesting, would only handle 16 records at a time. had to split into two files.

I commented out the following to get th import to work. I know this is not a fix, but worked for now.

case ‘insert’:
$sql = ‘INSERT INTO ‘ . self::$participants_table . ‘ SET ‘;
if ( !PDb_Date_Parse::is_mysql_timestamp( @$post[‘date_recorded’] ) )
// $sql .= ‘ date_recorded = NOW(), ‘; <-commented out
if ( !PDb_Date_Parse::is_mysql_timestamp( @$post[‘date_updated’] ) )
// $sql .= ‘ date_updated = NOW(), ‘;<-commented out
$where = ”;
break;

found a little more info on debug:
WordPress database error Column ‘date_updated’ specified twice for query INSERT INTO

…[-] Participants_Db::process_form storing record sql=INSERT INTO xx_participants_database SET date_recorded = NOW(), date_updated = NOW(), first_name = %s, last_name = %s, address = %s, city = %s, state = %s, zip = %s, phone = %s, email = %s,……. private_id = %s, date_recorded = %s, date_updated = %s,……

it looks like you code is listing the date_updated and date_recorded twice in the sql statement…