v1.3.1 errors after install

tms5q

I upgraded from 1.3.0 to 1.3.1 on my Bluehost ZenPhoto gallery with zenpage and am seeing two issues (I have since rolled back successfully to 1.3.0).

The first is the following error on the News and Overview tabs. I get this error on my real gallery with two news items, and a test album with no news items:

News: Zenphoto encountered an error
MySQL Query ( SELECT titlelink FROM `zp_zenpage_news` ORDER BY sticky DESC,date DESC ) failed. MySQL returned the error Unknown column 'sticky' in 'order clause'

The second is a problem editing albums directly from the album view. Normally when viewing the album, you can click on the album description (highlights yellow on mouse over) and it will enter edit mode. When I do this to make changes and then click save, the page comes back in gigantic font, with the whole web page within the edit frame; but from there I can click the breadcrumb to return to top level, and the changes were not saved.

Don't know if anyone else has reported these issues, but I did not find any reference searching the forum.

Thanks,
Tom

acrylian

I am sorry, I can not reproduce any of these errors and they have not been reported. Are you sure you really upgraded correctly and have run setup after uploading the files?

Normally when viewing the album, you can click on the album description (highlights yellow on mouse over) and it will enter edit mode.
Actually you click on the title and it hovers orange...;-)

but from there I can click the breadcrumb to return to top level, and the changes were not saved.
Of course, if you don't save it is not saved...

tms5q

I will try intalling again. It did report success on install the first time.

Regarding the MySQL error, it seems to be looking for a column in the zp_zenpage_news table that does not exist. I wish I could attach screen prints. I wonder if there is something in my web hosts configuration of ZenPhoto that could cause this kind of problem. Ideally I could find out from other Bluehost users if they have experienced the problem. I will try the forums there.

I appreciate the quick response, even if you were unable to replicate the issues.

kagutsuchi

My server is actually hosted by Bluehost, but I can't reproduce the problem either. Perhaps someone else on the Bluehost forums has had the same problem and can help diagnose the problem.

sbillard

Regards the column "sticky" which is missing. This column should have been created by the setup routine. If you run setup.php with a ?debug parameter it will log its SQL statements and their results. Perhaps this will tell why that field was not created.

`//zp-core/setup.php?debug`

The results will be in the zp-data/setup_log.txt file.