My ISP recently upgraded to MySQL 5 (I do not have the exact version handy, which I know can be important, but I couldn't find it quickly when looking at my site admin page - I will post it once I get that). I was running Coppermine 1.3 at the time, and I got the message:
There was an error while processing a database query
when I just logged into the homepage. I figured no big deal, it's probably an incompatibility with the new MySQL, so I thought upgrading to Coppermine 1.4 might take care of it. It did not, and I get the same message. I am able to get to the login page, but after enetring my user info, I get:
Template error
Failed to find block 'file_line'(#(<!-- BEGIN file_line -->)(.*?)(<!-- END file_line -->)#s) in :
<tr>
<td class="tableb" align="center">
<font size="3"><b>{MESSAGE}</b></font>
<br /><br />
</td>
</tr>
I had not made any additional changes to anything myself, so I was failry certain it was an incompatibility with the new MySQL 5. I contacted support with my ISP, and they escalated it to a higher level. The reply I got back said they think it is an incompatibility as well, with the standard we don't support 3rd party apps, so check with them to see if they have an upgrade answer.
Has anyone had any luck with MySQL 5, or know of any patches to help this?
It's not a huge deal as it is not a commercial site I am making any money from it or anything, but I would like to get it back up & running without using any user files or logins etc.
Any assistance is appreciated.
If you would like to see what I am getting, the main Coppermine page is at
http://photos.tonyslinks.com.
Thanks!