Read count doesn't work after MySQL update

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/71206?pagenum=1
05 November 2025, 01:38

Topic


kerryww
Read count doesn't work after MySQL update
13 June 2017, 03:29


After updating Access to MySQL the Read counter has since failed to work . In the new posts the Read entry is just blank. The old Reads still work. The site is at http://www.orientbeachforum.com/forum.asp?FORUM_ID=4

Also having a problem with the photo gallery mod whereby 3 thumbnail images are shown instead of one. This is at http://www.orientbeachforum.com/photo_gallery.asp?action=search&range=all

Just a warning, there is some nudity in the photo gallery.
Thanks for any ideas.
Kerry Whitfield

 

Replies ...


HuwR
13 June 2017, 04:02


How did you do the migration?

For the read count, my guess would be that the default value for T_VIEW_COUNT is possibly not set to 0
kerryww
13 June 2017, 08:07


Originally posted by HuwR
How did you do the migration?

For the read count, my guess would be that the default value for T_VIEW_COUNT is possibly not set to 0

You're right, it was set to NULL. I reset it to 0 and bingo...
Thanks for your help. Much appreciated.
HuwR
13 June 2017, 11:44


no problem. unfortunately I don't know much about the photo gallery problem, do you have a test login you can email me and I can take a quick look
kerryww
13 June 2017, 21:50


Details emailed.
HuwR
14 June 2017, 03:17


Thanks, will try and take a look later see if I can see anything obvious
HuwR
17 June 2017, 03:40


Did you get my email about the plesk panel? I don't appear to be able to get at the forum files
© 2000-2021 Snitz™ Communications