Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter jensd

    (@jensd)

    Thanks, but [cn-entry id=1] displays the name only, not the bio or photo or social network link.

    • This reply was modified 3 years, 8 months ago by jensd.
    Thread Starter jensd

    (@jensd)

    Hi Steven, thanks for your quick reply. My goal is to create a people magazine with pages like this profile, which is basically a category with a photo, a bio, some links. So when an editor writes about Ryan Gosling, he adds the Ryan Gosling category, which creates the feed of RGs “profile page”. This could easily done with some extra fields.
    But I want to take this a little further: I want to use the “profile” in multiple places other than category pages, but also as in Gutenberg cards/blocks. Therefore I need a database of people profiles, that can be embedded in several places.
    Do you think this can be achieved with Connections?

    Thread Starter jensd

    (@jensd)

    Thanks, looks awsome.

    Tried it but I can’t seem to get it up and running with the old MySQL Version 4.0.22.

    First, activation doesn’t create the tables.
    When creating them manually with SQL I found at your forum:

    CREATE TABLE IF NOT EXISTS wp_downloads (
    file_id int(10) NOT NULL auto_increment,
    file tinytext,
    file_name text NOT NULL,
    file_des text NOT NULL,
    file_size varchar(20) NOT NULL default ”,
    file_category int(2) NOT NULL default ‘0’,
    file_date varchar(20) NOT NULL default ”,
    file_hits int(10) NOT NULL default ‘0’,
    file_permission tinyint(2) NOT NULL default ‘0’,
    PRIMARY KEY (file_id)
    ) TYPE=MyISAM ;

    everything seems to work until I upload a file:

    WordPress database error: [Column count doesn’t match value count at row 1]
    INSERT INTO hk_downloads VALUES (0, ‘/brownbound.zip’, ‘brownbound.zip’, ”, ‘64799’, 0, ‘1213454376’, ‘1213454376’, ‘1213454376’, 0, 0)

    The file itself is actually uploaded. Not displayed though, and no db records are written.

    Any ideas? Would be great, the plugin is exactly what I would love to use…

    Ok, sorry, found it:
    CREATE TABLE IF NOT EXISTShk_downloads` (
    file_id int(10) NOT NULL auto_increment,
    file tinytext,
    file_name text NOT NULL,
    file_des text NOT NULL,
    file_size varchar(20) NOT NULL default ”,
    file_category int(2) NOT NULL default ‘0’,
    file_date varchar(20) NOT NULL default ”,
    file_hits int(10) NOT NULL default ‘0’,
    file_permission tinyint(2) NOT NULL default ‘0’,
    PRIMARY KEY (file_id)
    ) TYPE=MyISAM ;`

    Hi,
    may I ask for the sql? I have the same problem, but I can’t find the sql to create the tables manually…

    thanks!

Viewing 5 replies - 1 through 5 (of 5 total)