Tony Posted October 20, 2009 Report Share Posted October 20, 2009 One problem fixed, and another surfaces. I'm not sure if they're related, but I just corrected the "custom meta" field in General Settings to fix the site's layout problem (after upgrade to TNG 7.12 and changing to template #7), and now am receiving an error when I try to access any individual. The error is...Cannot execute query: SELECT tng_albums.albumID, albumname, description FROM (tng_albums,) WHERE entityID="F47" AND gedcom="HemSearch" AND .albumID=tng_albums.albumID ORDER BY albumnameI really don't know PHp or MySql, but judging be the number of occurances of the word "album" above, does it have something to do with that?If anyone can help, that would be great. If you want to look at it yourself, its www.hemsearch.juxon.net, login "visitor", pswd "visitor". Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted October 20, 2009 Report Share Posted October 20, 2009 One problem fixed, and another surfaces. I'm not sure if they're related, but I just corrected the "custom meta" field in General Settings to fix the site's layout problem (after upgrade to TNG 7.12 and changing to template #7), and now am receiving an error when I try to access any individual. The error is...Cannot execute query: SELECT tng_albums.albumID, albumname, description FROM (tng_albums,) WHERE entityID="F47" AND gedcom="HemSearch" AND .albumID=tng_albums.albumID ORDER BY albumnameI really don't know PHp or MySql, but judging be the number of occurances of the word "album" above, does it have something to do with that?If anyone can help, that would be great. If you want to look at it yourself, its www.hemsearch.juxon.net, login "visitor", pswd "visitor".Did you run the dbupdatexxx.php file that is part of the upgrade? Quote Link to comment Share on other sites More sharing options...
Tony Posted October 20, 2009 Author Report Share Posted October 20, 2009 Did you run the dbupdatexxx.php file that is part of the upgrade?Yes, and then deleted it afterwards. The database was functioning fine after the upgrade, although the page layout were all messed up. UPDATE... I just checked the Table Names in setup and saw that the new names I had assigned to the new tables were gone. Perhaps as I was desperately copying files with the template switch to #7 I somehow copied over where this information is stored? What do you think happened, so I don't do it again? Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted October 20, 2009 Report Share Posted October 20, 2009 Yes, and then deleted it afterwards. The database was functioning fine after the upgrade, although the page layout were all messed up. UPDATE... I just checked the Table Names in setup and saw that the new names I had assigned to the new tables were gone. Perhaps as I was desperately copying files with the template switch to #7 I somehow copied over where this information is stored? What do you think happened, so I don't do it again?Tony,The table names are store in the config.php file. Initially this file is in your TNG install directory, unless you setup a Config Path and moved the configuration files. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.