Tuler Posted June 30, 2015 Report Share Posted June 30, 2015 I tried upgrading from 3.06 to 3.10 and received an error that I needed to add 77 indexes. In researching I found that the indexes are there but they have a prefix of ox_ in front of the name that the script is looking for. Is there anyway to update the script to look for the index name with the prefix instead of me having to update 77 indexes to upgrade? Quote Link to comment Share on other sites More sharing options...
Richard Foley Posted July 1, 2015 Report Share Posted July 1, 2015 I think you'll probably find that configuration setting under: Configuration -> Global Settings -> Database -> Advanced Settings -> Table names prefix Quote Link to comment Share on other sites More sharing options...
Tuler Posted July 2, 2015 Author Report Share Posted July 2, 2015 Thank you for the reply. This actually has to do with the naming of the indexes, not the tables. Somewhere in the installation procedures the script looks for a name of the indexes without a prefix, yet it appears that if converting from OpenX there is a prefix on the index names. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted February 24, 2017 Report Share Posted February 24, 2017 Probably the easiest solution would be to script up the dropping & re-creation of the indexes with the prefix it's expecting. 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.
Note: Your post will require moderator approval before it will be visible.