Hello,
Deactivate, and then reactivate the plugin, and try again. That should work.
Dan [ Signature moderated. ]
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!
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
I’m totally comfortable with it, shoot!
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
well, that didn’t work, but I just went in to the database and added the missing field, and it’s now working. Strangeness!
and thank YOU! for your quick response. I really appreciate it!
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
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.
@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
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
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
Hi Walter
Thanks. Sounds like the ALTER command or dbDelta command in WP is not working properly for you.
Glad it works.
Dan
I believe that is the same field I added in my database. Glad you got it working.
