Unknown column 'hash_url' in 'field list'
xn2001 - October 15, 2009 - 02:23
| Project: | Boost |
| Version: | 6.x-1.13 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
Whenever a static page is generated by boost, I got an error message in "Recent log entries":
Unknown column 'hash_url' in 'field list' query: UPDATE boost_cache_relationships SET base_dir = 'cache/mywebsite.com', page_callback = 'view', page_type = 'list_of_videos', page_id = 'page_1', child_page_callback = 'node', child_page_type = 'video', child_page_id = '103', hash_url = 'c5da47f868159d052f04be2cf0887def', timestamp = '1255570331' WHERE hash = '80a9fbfd7f3b5146232c2d8db7d194c4' in /var/www/test/mywebsite.com/sites/all/modules/boost/boost.module on line 1639.I did run update.php.
I uninstall boost and re-install it but it still give the error message.
However, static pages generated by boost are fine.
#1
Also, I checked the boost_cache_relationships table and hash_url & timestamp columns don't exist.
#2
Rerun boost_update_6120. Seems like I forgot to add those columns to the boost_schema() call, so they will be missing on new installs. Error has to do with a new feature, for views. Most new features come with their own set of bugs ;)
#3
#4
Thx mikeytown2.
For those who have the same problem, I rerun boost_update_6120 and there is no more error in "Recent log entries".
I also Reset boost database to make sure that data are update correctly.
#5
committed, marking this RTBC until 6.x-1.13 goes out.
#6
1.13 will be out very soon.
#7
Hi Mikeytown2,
I am also getting this error and I have installed 1.13...
Unknown column 'hash_url' in 'field list' query: UPDATE boost_cache_relationships SET base_dir = 'cache/www.futsalma.com', page_callback = 'node_page_default', page_type = '', page_id = '', child_page_callback = 'node', child_page_type = 'image', child_page_id = '74', hash_url = '3d0db916d1ea2f83ee4950868c536f9d', timestamp = '1256985724' WHERE hash = '97a28eaffca09899010f053a3bd14e03' in /home/content/m/i/l/miller13/html/futsalma/sites/all/modules/boost/boost.module on line 1689.
Should I install the new dev version?
Nina
#8
@BlueIrisNina
Is the database up to date? When you go to the status page does it say you need to run an update? If not manually run boost_update_6120. Let me know if that takes care of the issue for you.
#9
Hi,
The database is up-to-date and I had applied the patches from this thread but I had not manually run the 6120 update.
I did that shortly after I posted the message to you... so far so good. I'll let you know if it changes.
Thanks so much for your help!
Nina
#10
#11
Automatically closed -- issue fixed for 2 weeks with no activity.