Hi - I'm trying to update an old installation which from the Changelog I think is 0.5.1 or 0.5.2.
I run the installer, go to page 2, see the schema fail and then select 0.5.1 in the dropdown box. But the error persists.
I've searched various terms but haven't come up with anything - grateful for any suggestions you might have.
Cheers
Error message reads:
------
Database schema update failed.
DB Schema: NOT OK(Database schema differs)
Missing table 'cache_index'
Missing table 'cache_thread'
Missing table 'cache_messages'
Missing columns in table 'contacts': words
Missing table 'dictionary'
Missing table 'searches'
Missing table 'system'
You should run the update queries to get the schema fixed.
-----
Is there another way for me to add these tables? Apologies for being dim, I'm new to database admin.
You need to run the news sql files in the <RC root>/SQL folder.
thank you I will look into this now
which files? This is what I have [screenshot]
hm wait it's the dated ones in mysql right? All of them?
OK I now understand that I can run these commands within phpMyAdmin by selecting the database, going to SQL, opening each of the dated files that pertains, copying the code within, pasting it into the box and pressing 'Go'.
My installer still says this:
DB Schema: NOT OK(Database schema differs)
Missing table 'cache_index'
Missing table 'cache_thread'
Missing table 'cache_messages'
Missing columns in table 'contacts': words
Missing table 'dictionary'
Missing table 'searches'
Missing table 'system'
- but the installation seems to be functioning and I can verify that those tables do in fact exist.