| User | Post |
|
5:01 am
24 May 2008
|
frankfso
Member
| | Oregon | |
|
| posts 7 |
|
|
After upgrading to 3.1.1 I'm receiving the following errors on the forum page.
WordPress database error: [Unknown column 'post_id' in 'field list']
WordPress database error: [Unknown column 'wp_sftopics.post_id' in 'field list']
Website
http://fantasysportsoutlook.com/
Forum
http://fantasysportsoutlook.com/sf-forum/
I'm hoping this is just something I didn't do because this is easily one of the best plugins written for WP.
Thank you for your help,
Frank
|
|
|
5:05 am
24 May 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
Frank,
Are you sure you performed the upgrade? After uploading the files, you have to go to the wp admin and the forum menu at the top and perform the ugprade… if so, did it complete correctly? Can you get into the spf admin pages?
which version did you upgrade from?
|
|
|
5:27 am
24 May 2008
|
frankfso
Member
| | Oregon | |
|
| posts 7 |
|
|
After uploading the files I did the upgrade. The admin section shows up fine (under the toolbox tab it shows Installed Version: Version: 3.1.1 Build: 336).
I upgraded from version 3.0.3
|
|
|
5:39 am
24 May 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
do you know your php version and your mysql version?
thanks…
|
|
|
5:46 am
24 May 2008
|
frankfso
Member
| | Oregon | |
|
| posts 7 |
|
|
Sorry should have sent that along earlier, also running wp ver. 2.5.1
PHP version 5.2.6
MySQL version 5.0.45-community
Thanks for the help,
Frank
|
|
|
6:09 am
24 May 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
did you upload a full 3.1.1 package or did you do the upgrade package… this is our first attempt at the upgrade package…
|
|
|
6:35 am
24 May 2008
|
frankfso
Member
| | Oregon | |
|
| posts 7 |
|
|
First thanks for your help. Any time I've run into any kind of problem or just needed to know if I could do something I'd come in here and search for an answer…and I always left with the help I needed.
I did the full 3.1.1 package.
Looking through my database tables, all the forums, posts, topics, users, etc., show up in the tables.
I haven't installed any new plugins since the last upgrade.
Frank
|
|
|
|
|
It always puzzles me when every now and then you get a system that doesn't complete the install. And there os no apparent reason why this should be! All the same apologies for that.
Quick question before we find a solution. Do you have the new 'sfmembers' table in your database and does it contain data?
|
|
|
8:50 am
24 May 2008
|
frankfso
Member
| | Oregon | |
|
| posts 7 |
|
|
Andy,
yes the sfmembers table is present with data.
Frank
|
|
|
|
|
So what seems to have happened - and for reasons unknown - the upgrade was able to create a new table but not able to add columns to an existing one which is pretty bizarre.
So how to put it right…?
You sound like you know your way around a database. What about code? If I asked you to modify a value in a database table and modify a section of code would you be OK with doing that?
|
|
|
3:30 pm
24 May 2008
|
frankfso
Member
| | Oregon | |
|
| posts 7 |
|
|
Hi Andy, again thanks for the help. With you telling me what I have to do I'd be OK. Before I called it a night I did upload the package again, thinking I may have missed a file.
Thanks,
Frank
|
|
|
|
|
I'll send you an email with some instructions.
|
|
|
5:09 pm
24 May 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
Andy,
Did we use an mysql alter table function in the upgrade? guess I should look… some hosts dont give that privilege to users…
|
|
|
|
|
Just sent the email
yes we did. But it's the same code that WP uses for it's upgrades and if Frank has got this far he has probably hit some ALTER statements before.
I have sent him some code to run. if that doesn't work then he may need to add the db columns manually.
|
|
|
6:17 pm
24 May 2008
|
frankfso
Member
| | Oregon | |
|
| posts 7 |
|
|
Andy, Mr P
Much thanks! Works fine after your upgrade.
Totally awesome work and support you do for us.
Thank You
Frank
|
|
|
7:10 pm
24 May 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
Good news!! Glad you are back up…
|
|
|
12:06 am
18 Jun 2008
|
PetMono
Guest
| | | |
|
| |
|
|
hello everyone. first of all my v3.1.1 is working great. and looking great 2!
i found this thread as i put the following in google search = WordPress database error:[Unknown column 'post_id' in 'field list']
so i am not sure what to ask. i don't know if i got this error message after installing 3.1.1 as i just found the error by accident when i linked to my “archive” and i installed 3.1.1 several weeks ago. frank, did the code that andy give you fix BOTH of your error messages?
note: i did not upgrade but had a clean 3.1.1 install.there is a lot of language beneath the error message. it tells me nothing at this point. does it tell you anything, i.e., not a 3.1.1 issue but something else…
|
|
|
12:08 am
18 Jun 2008
|
PetMono
Guest
| | | |
|
| |
|
|
oops. so sorry, brain cramp. here is the code beneath the error…
SELECT count(DISTINCT post_id) FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('59') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC
|
|
|
12:42 am
18 Jun 2008
|
PetMono
Guest
| | | |
|
| |
|
|
i deactivated v3.1.1 and the db error went away…
|
|
|
1:39 am
18 Jun 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
It might be time to go the other way (deactive other stuff) for testing… that error message is NOT generated by SPF… if it went away with deactivation, then there must be a conflict… deactivate the rest of plugins, and start activating one by one until the error reappears, then we can know what is conflicting..
|
|
|
2:09 am
18 Jun 2008
|
PetMono
Guest
| | | |
|
| |
|
|
makes sense, thanks papa. is there any particular order to this process. turn off a plug first then fire 3.1.1 up again? i think simple tags likes to be on first for it to work correctly so order is important for that particular plug.
|
|
|
|
|
I'd start with any plugin you have installed that has anything to do with categories. Keep SPF active and deactivate plugins and then see if the error goes away. remember to refresh the page you are on after each plugin change before testing.
|
|
This forum is currently locked - access is read only
Forums
