darrin65 0 Report post Posted February 22 Since I updated from 13.0.2 to 13.0.3, the preview for my media works as usual. But when I click on it to see the full doc/photo it goes to the next screen and says "loading" but the media file never opens. This has never happened before and I'm hoping someone might have an idea what happened between the upgrade. Any help would be appreciated. https://www.duttongenealogy.com Share this post Link to post Share on other sites
theKiwi 0 Report post Posted Tuesday at 01:04 AM Can you post a userID and password so people can log in and take a look? Roger Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 04:33 AM Roger, Thank you for the reply. The userID: guest and p/w: 19Herbert27 can be used for access. Thank you again, Darrin Share this post Link to post Share on other sites
Rob Severijns 0 Report post Posted Tuesday at 07:26 AM Darrin, Looks like the link to the thumbs are all OK. The links to all the actual media files are broken. Are you sure the settings in Paths and Folders is correct (Setup >> Configuration >> General Settings)? You could install the Mod Unused Media to check if media files are present in the media folders on the server but not registered with TNG. Good luck, Rob Share this post Link to post Share on other sites
theKiwi 0 Report post Posted Tuesday at 12:07 PM The console shows some errors Take a look at the tables for the site using phpMyAdmin from your cPanel, and see if the collation of all of the tables is the same - I think this problem is the same as is caused by an upgrade to TNG creating a new table in a different collation than all the rest. So if one table has a different collation, open that table in phpMyAdmin and use the Operations tab to change its collation to match all the others. Does that fix the problem? Roger Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 12:25 PM Roger, I took a look at the tables on phpMyAdmin (something I've rarely messed with because I could easily take my site down not knowing what I'm doing!) But just looking at each table, nothing looks different from what I can see. Thanks a lot for the reply! Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 12:55 PM Rob, I took a look at the settings in the Paths and Folders and they are all correct. Actually I remembered that this happened to me 2 different times after I upgraded from 12.3 to 13.02. I could see the preview but it wouldn't load the actual media. Thinking maybe I missed something during the upgrade I re-ran the "upgrade_db12x-13x.php" and everything started displaying fine. The second time the media stopped displaying, I re-ran the dbupgrade and things were fine again. After I tried what you suggested this time without any luck, I tried re-running the "upgrade_db13x-13x.php" but that didn't take care of it this time. After looking through the tables for one that might have a different collation as Roger suggested and things looking fine I'm at a loss. Would it be possible to revert back to version 13.0.2 when everything was working....? Share this post Link to post Share on other sites
Ken Roy 0 Report post Posted Tuesday at 01:00 PM You are missing the new table that was added in TNG 13 - tng_media_tags if I remember correctly. So somehow your database upgrade needs to be run You may need to download the TNG 12 upgrade zip and run the database upgrade again. Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 01:04 PM Hi Ken, Ok, TNG 12.0 correct? Share this post Link to post Share on other sites
theKiwi 0 Report post Posted Tuesday at 02:37 PM 1 hour ago, darrin65 said: Hi Ken, Ok, TNG 12.0 correct? You could get the upgrade for TNG 11 to 13.x and upload the bbupgrade script from that - it might contain some redundant steps, but won't do any harm if it does, and it will do the needed steps. Make sure to go to TNG Admin ------> Setup ------> General Settings ------> Table Names and make sure they're all filled in too. Roger Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 08:16 PM Ok great, I'll give that a shot and see how things go. Thank you for the response. Darrin Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 09:21 PM 6 hours ago, theKiwi said: You could get the upgrade for TNG 11 to 13.x and upload the bbupgrade script from that - it might contain some redundant steps, but won't do any harm if it does, and it will do the needed steps. Make sure to go to TNG Admin ------> Setup ------> General Settings ------> Table Names and make sure they're all filled in too. Roger I gave that a go, all tables are filled in, but there is still no table named " tng_media_tags". Everything works as it did before, just no loading of any of the media. Darrin Share this post Link to post Share on other sites
theKiwi 0 Report post Posted Tuesday at 10:52 PM This is what I have - a total of 37 tables Roger Share this post Link to post Share on other sites
Ken Roy 0 Report post Posted Tuesday at 11:06 PM 1 hour ago, darrin65 said: but there is still no table named " tng_media_tags". Everything works as it did before, just no loading of any of the media. Sorry Darrin, i should have double-checked. The new table is tng_image_tags Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 11:12 PM 13 minutes ago, theKiwi said: This is what I have - a total of 37 tables Roger I have 42 tables, the extras being from Census Plus. Ken is correct, I don't have the "Image Tags" table. Evidently when I ran the dbupgrade script from TNG 11 to 13.x as suggested, that didn't add that table. However, it did revert the template I was using to template 14, and I can't even remember how long ago I used that. Darrin Share this post Link to post Share on other sites
darrin65 0 Report post Posted Tuesday at 11:28 PM 21 minutes ago, Ken Roy said: Sorry Darrin, i should have double-checked. The new table is tng_image_tags No problem Ken. I got the gist of what you meant. Thanks. Share this post Link to post Share on other sites
Ken Roy 0 Report post Posted Tuesday at 11:56 PM Darrin, I looked at the phpMyAdmin screen above https://tng.community/index.php?/forums/topic/15312-media-doesnt-display-since-1303-update/&do=findComment&comment=80371 and it shows the tng_image_tags table. Are you connected to the correct database in TNG ? Share this post Link to post Share on other sites
darrin65 0 Report post Posted Wednesday at 01:28 AM 1 hour ago, Ken Roy said: Darrin, I looked at the phpMyAdmin screen above https://tng.community/index.php?/forums/topic/15312-media-doesnt-display-since-1303-update/&do=findComment&comment=80371 and it shows the tng_image_tags table. Are you connected to the correct database in TNG ? Ken, Since I know next to nothing I asked support at Simply Hosting. He said I was connected to the database that had the tng_image_tags table, but oddly enough it's still not listed in my Setup-General Settings-Table Names. He logged in as admin, ran the dbupgrade that Roger suggested since I still had it in my public_html and also ran the 13.0.2-13.x dbupgrade and now media is displaying fine. Even more odd, the tng_image_tags table still isn't listed in my table names. I changed my template back to the one I was using and things are back to normal. SMH Share this post Link to post Share on other sites