Database schema version (3.0.2) does not match... [SOLVED]

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
User avatar
frazelle09
Joomla! Explorer
Joomla! Explorer
Posts: 347
Joined: Thu Feb 22, 2007 5:27 am
Location: Mexicali, Baja California, Mexico
Contact:

Database schema version (3.0.2) does not match... [SOLVED]

Post by frazelle09 » Sat Feb 23, 2013 2:44 am

Database schema version (3.0.2) does not match CMS version (3.0.3).
i just updated my 3.0.2 to 3.0.3 by overwriting my site and now get the above error for the db. Is there a way to fix this?

Have a great evening! :)
Last edited by frazelle09 on Sat Feb 23, 2013 5:32 am, edited 1 time in total.
"The earth is one country and mankind its citizens." 
Bahá'u'lláh
"La tierra es un sólo país y la humanidad sus ciudadanos."

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27894
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Database schema version (3.0.2) does not match...

Post by imanickam » Sat Feb 23, 2013 2:49 am

Try the following:
  • Go to the Extension Manager
    Click on the link Database on the left panel
    Click on the button Fix
Note: Hope you have taken a back-up of your site files and the database content before attempting the upgrade
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
ex-Joomla! Translations Coordination Team
Eegan - Support the poor and underprivileged

User avatar
frazelle09
Joomla! Explorer
Joomla! Explorer
Posts: 347
Joined: Thu Feb 22, 2007 5:27 am
Location: Mexicali, Baja California, Mexico
Contact:

Re: Database schema version (3.0.2) does not match...

Post by frazelle09 » Sat Feb 23, 2013 3:03 am

Thanks, imanickam, you are really on top of things. i performed the above actions and get

0 SQL=ALTER TABLE `v302_content` CHANGE `title_alias` `title_alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';


When i run Check Database again i get>
Database schema version (3.0.2) does not match CMS version (3.0.3).
Database update version (3.0.2) does not match CMS version (3.0.3).
Table 'v302_content' does not have column 'title_alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'v302_content' does not have column 'title_alias' with type 'VARCHAR(255)'. (From file 1.7.4-2011-11-23.sql.)
Table 'v302_associations' does not have column 'id' with type 'INT(11)'. (From file 3.0.3.sql.)
The items that refer to column 'title_alias' were also present the first time i ran the Check db.

Thanks again for trying to help. Have a great evening! :)
"The earth is one country and mankind its citizens." 
Bahá'u'lláh
"La tierra es un sólo país y la humanidad sus ciudadanos."

User avatar
frazelle09
Joomla! Explorer
Joomla! Explorer
Posts: 347
Joined: Thu Feb 22, 2007 5:27 am
Location: Mexicali, Baja California, Mexico
Contact:

Re: Database schema version (3.0.2) does not match...

Post by frazelle09 » Sat Feb 23, 2013 3:13 am

Code: Select all

 Table 'v302_associations' does not have column 'id' with type 'INT(11)'. (From file 3.0.3.sql.)
Yea! Got this one fixed! Used phpMyAdmin. Almost there - only 4 more to go!

Have a wonderful evening! :)
"The earth is one country and mankind its citizens." 
Bahá'u'lláh
"La tierra es un sólo país y la humanidad sus ciudadanos."

User avatar
frazelle09
Joomla! Explorer
Joomla! Explorer
Posts: 347
Joined: Thu Feb 22, 2007 5:27 am
Location: Mexicali, Baja California, Mexico
Contact:

Re: Database schema version (3.0.2) does not match...

Post by frazelle09 » Sat Feb 23, 2013 3:18 am

i know next to nothing about programming, but i think this alias thing has been depreciated in 3.0, but shouldn't the command be

Code: Select all

SQL=ALTER TABLE `v302_content` [u]CREATE[/u] `title_alias` `title_alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; 
instead of

Code: Select all

     0 SQL=ALTER TABLE `v302_content` [u]CHANGE[/u] `title_alias` `title_alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; 
?

because this 'title_alias' doesn't even exist...

Have a happy evening! :)
"The earth is one country and mankind its citizens." 
Bahá'u'lláh
"La tierra es un sólo país y la humanidad sus ciudadanos."

User avatar
frazelle09
Joomla! Explorer
Joomla! Explorer
Posts: 347
Joined: Thu Feb 22, 2007 5:27 am
Location: Mexicali, Baja California, Mexico
Contact:

Re: Database schema version (3.0.2) does not match...

Post by frazelle09 » Sat Feb 23, 2013 3:42 am

Question> Can i go to myPhpAdmin, click on the table Content, from the Tabs, select, Insert, and from the bottom, change Continue with Insertion as New Row from 2 to 1 and click Go? Will this add a new, blank row?

Have a super evening! :)
"The earth is one country and mankind its citizens." 
Bahá'u'lláh
"La tierra es un sólo país y la humanidad sus ciudadanos."

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27894
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Database schema version (3.0.2) does not match...

Post by imanickam » Sat Feb 23, 2013 4:16 am

I believe that you have upgraded your site and skipped some versions in between during this process.

The column title_alias is indeed deprecated in 3.0. However, it is present in 2.5. So, logically thinking, this would be dropped eventually in the schema update. I have not checked the SQL statements in the update process.

As for as phpMyAdmin is concerned, the option you are referring to will not add new blank rows, it will show you blank form for you to fill for the row to be inserted.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
ex-Joomla! Translations Coordination Team
Eegan - Support the poor and underprivileged

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Database schema version (3.0.2) does not match...

Post by sovainfo » Sat Feb 23, 2013 4:47 am

The commands are correct as they are, in J173 the title_alias existed. And needed to be changed. title_alias is dropped in 3.0.0. The sql scripts are to be run in numeric order.

Don't understand why these errors appear in the Database tab. Maybe remove the files from administrator/components/com_admin/sql/updates/mysql.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

User avatar
frazelle09
Joomla! Explorer
Joomla! Explorer
Posts: 347
Joined: Thu Feb 22, 2007 5:27 am
Location: Mexicali, Baja California, Mexico
Contact:

Re: Database schema version (3.0.2) does not match...

Post by frazelle09 » Sat Feb 23, 2013 5:31 am

Thanks, guys! sovainfo, i removed the 2 scripts and of course now only get the problems with the schema between 3.0.2 and 3.0.3.

Yea! Now, hitting the Fix button returns>

Database table structure is up to date.

Solved. Thanks to all and have a super evening! :)
"The earth is one country and mankind its citizens." 
Bahá'u'lláh
"La tierra es un sólo país y la humanidad sus ciudadanos."


Locked

Return to “Migrating and Upgrading to Joomla! 3.x”