DR Byte and Chuck,
Thank you for your reply.
Under Admin->Configuration->Maximum values, wI have for Search results 20 pages.

If I had any missing files or problem with default config file. nothing showed in flight check before install started. According to Zen software my install was successful.

Something interesting I noted today. if I run sql query on most of the table in my database on my sever, I get the same mysql error 1064. Version on my server for mysql has not changed. In my admin, most of pull downs gives me the same error # 1064 as I have noted in the beginning of my post.

Artistic Leaf