WordPress.org

1. goldgrl7
   Member
   Posted 4 months 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
   Posted 4 months ago #

   Hello,

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

   Dan (WP Portfolio Developer)

3. stopha
   Member
   Posted 3 months 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
   Posted 3 months 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 3 months ago #

   I'm totally comfortable with it, shoot!

6. Dan Harrison
   Member
   Posted 3 months 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 3 months 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 3 months ago #

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

9. Dan Harrison
   Member
   Posted 3 months 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 1 month 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
    Posted 1 month 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 1 month 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 1 month 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
    Posted 1 month 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 1 month ago #

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

Reply

You must log in to post.