Database issue: [Unknown column ......]

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
June 20, 2019 at 6:20 am #493942
Kim Johnson
Expired Member

Post count: 5
Hi,

I followed all your instruction and update the core plugin from v1 to v2. After update, I start getting the database issue. For example
```
SELECT 'bancity' from wp_geodir_gd_place_detail where post_id = 5112
```
```
SELECT 'banlicence' from wp_geodir_gd_place_detail where post_id = 5112
```
I tried on 4 staging sites and the issue remains the same on all sites.
June 20, 2019 at 4:23 pm #494037

Paolo
Site Admin

Post count: 31206

Hi,

please provide a link to one of the staging sites, phpmyadmin + FTP + wp-admin credentials.

We’ll fix whatever did not work during the conversion.

Let us know,

Thanks

June 21, 2019 at 5:51 am #494118

Kim Johnson
Expired Member

Post count: 5

This reply has been marked as private.

June 21, 2019 at 7:58 am #494127

Naveen Giri
Moderator

Post count: 1559

Hi Kim,

It seems the custom field name is different than the previously added fields. so the query was not able find those key.

I have changed the keys of those fields in database table ‘wp_geodir_custom_fields’.
you can check now.

You can use this database or just use the above table for your live site.

June 21, 2019 at 10:38 am #494153

Kim Johnson
Expired Member

Post count: 5

So changing the columns name directly in the database will not cause the other issue?

June 21, 2019 at 10:49 am #494156

Naveen Giri
Moderator

Post count: 1559

I havn’t changed column name. just changed the meta key of the field.

so right now you can solve the issue in two way.
either by deleting the fields and adding them again with proper meta key.

or you can do it change the htmlvar_name of the field in ‘wp_geodir_custom_fields’ table

changing the htmlvar_name will not cause issue here. since we are just changing field name with the correct one.
Author

Posts