WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Portfolio Plugin (WP Portfolio)
[resolved] Can not add to portfolio (15 posts)

  1. goldgrl7
    Member
    Posted 2 years ago #

    I can not add new websites to the portfolio. I love this plugin and haven't found any other portfolio plugins that are even close. I hope it is fixed soon. I get this database error when trying to add a new websiet:

    WordPress database error: [Unknown column 'customfield' in 'field list']
    INSERT INTO wp_WPPortfolio_websites (sitename, siteurl, sitedescription, sitegroup, customthumb, siteactive, siteorder, specificpage, customfield, siteadded) VALUES ('fanfare', 'http://www.fanfarewss.com', 'Fanfare WSS', '1', '', '1', '0', '0', '', '2012-01-05 20:12:06')

    http://wordpress.org/extend/plugins/wp-portfolio/

  2. Dan Harrison
    Member
    Plugin Author

    Posted 2 years ago #

    Hello,

    Deactivate, and then reactivate the plugin, and try again. That should work.

    Dan [ Signature moderated. ]

  3. stopha
    Member
    Posted 2 years ago #

    Hi Dan - question - I'm getting the WordPress database error: [Unknown column 'customfield' in 'field list'] error, I tried deactivating and reactivating the plugin as well as Deleting it and reinstalling. Is there anything else I can try? Are there any known plugin conflicts? I don't have many plugins installed, so I'm wondering if that might be the issue.

    What are next steps when the error keeps occurring even after the recommended fix?

    Thanks!

  4. Dan Harrison
    Member
    Plugin Author

    Posted 2 years ago #

    Hello

    The plugin should automatically create the database tables, and customfield is basically one of those missing fields.

    How comfortable are you with editing plugin files? I've got a trick that should work...

    Dan

  5. stopha
    Member
    Posted 2 years ago #

    I'm totally comfortable with it, shoot!

  6. Dan Harrison
    Member
    Plugin Author

    Posted 2 years ago #

    Right

    1) Deactivate plugin
    2) Edit line 26 of wp-portfolio.php, change: define('WPP_VERSION', '1.24'); to define('WPP_VERSION', '1.00');
    3) Activate plugin (nothing should happen)

    4) Deactivate plugin
    5) Edit line 26 of wp-portfolio.php, change: define('WPP_VERSION', '1.00'); to define('WPP_VERSION', '1.24');
    6) Activate plugin (this should add the columns such as customfield)

    If that doesn't work, then something else is going on, possibly with your database.

    Dan

  7. stopha
    Member
    Posted 2 years ago #

    well, that didn't work, but I just went in to the database and added the missing field, and it's now working. Strangeness!

  8. stopha
    Member
    Posted 2 years ago #

    and thank YOU! for your quick response. I really appreciate it!

  9. Dan Harrison
    Member
    Plugin Author

    Posted 2 years ago #

    Hmm, odd, must just be something odd. Phase of the moon perhaps! Glad you got it sorted... I wanted to avoid getting you into SQL :)

    You're welcome :)

    Dan

  10. wgator
    Member
    Posted 2 years ago #

    Stopha,
    Can you post the step you did to resolve this issue in the db (what table, field properties?). I followed Dan's steps but they they did not work.

  11. Dan Harrison
    Member
    Plugin Author

    Posted 2 years ago #

    @wgator - what version are you using? Are you installing from new? Or upgrading?

    I've spotted this issue a few times, mostly due to odd permissions with MySQL on a hosting account.

    Dan

  12. wgator
    Member
    Posted 2 years ago #

    Hi Dan,
    To be honest I don't know...I just did the automatic upgrade today. However, I had this issue for a while now. I was hopping that the upgrade will fix it.

    When I opened the file you mentioned it said Ver. 1.27 (this is after today's upgrade). Then, I went ahead and changed the file accordingly but still did not work.

    The front-end of the plugin works great. The problem is that it won't allow me to add or edit websites in the portfolio.

    Thank you for the quick response,

    Walter

  13. wgator
    Member
    Posted 2 years ago #

    Hi Dan,
    I figure it out.

    I added "customfield" to the "wp_WPPortfolio_websites" table using phpMyAdmin. I placed it in between "specificpage" and "siteadded" with following details:

    Field: customfield
    Type: varchar(150)
    Collation: utf8_general_ci
    Attributes: (blank)
    Null: NULL
    Extra: (blank)

    Everything is working fine...

    Thanks

  14. Dan Harrison
    Member
    Plugin Author

    Posted 2 years ago #

    Hi Walter

    Thanks. Sounds like the ALTER command or dbDelta command in WP is not working properly for you.

    Glad it works.
    Dan

  15. stopha
    Member
    Posted 2 years ago #

    I believe that is the same field I added in my database. Glad you got it working.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic