Author Topic: How do I check if Database Schema is correct? and fix it..  (Read 1755 times)

tez

  • Jr. Member
  • **
  • Posts: 130
How do I check if Database Schema is correct? and fix it..
« on: March 22, 2013, 03:43:12 am »
Is there any easy way to update database schema to be correct? I've being doing a test upgrade from 2.0.8e to 2.0.20b and I suspect a few differences, one being a VARCHAR column which is too long so it wants to be changed to TEXT.

Should be able to just check database integrity when you're sure you haven't messed with table structure and set it to "correct".

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27897
  • Always on vacation
    • Jenkin Hill Internet
Re: How do I check if Database Schema is correct? and fix it..
« Reply #1 on: March 22, 2013, 10:04:09 am »
Tools/Tools & migration/Install or if necessary update tables
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.8.5 10338 on Joomla 3.9.22 PHP 7.4.9