Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Do both 1.6 RC5 and 1.6 ST versions use same Database tables?

I'm gonna overwrite my existing 1.6RC5 files with 1.6ST files without changing any databases or tables. Because I need the data in the existing database. Do both versions use same database table structure?

Comments

  • Nope. But they are pretty similar. Taking a quick look at the 1.6ST upgrade.sql (included ni the 1.6st archive) it runs the following:

    ALTER TABLE `%TABLE_PREFIX%ticket` ADD `topic_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `priority_id`;

    ALTER TABLE `%TABLE_PREFIX%ticket` ADD INDEX ( `topic_id` );

    ALTER TABLE `%TABLE_PREFIX%ticket` CHANGE `topic` `helptopic` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

    ALTER TABLE `%TABLE_PREFIX%groups` ADD `can_create_tickets` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `dept_access`;

    ALTER TABLE `%TABLE_PREFIX%staff` ADD `auto_refresh_rate` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `max_page_size`;

    ALTER TABLE `%TABLE_PREFIX%config` ADD `ticket_notice_active` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `message_autoresponder`;

    ALTER TABLE `%TABLE_PREFIX%config` ADD `enable_captcha` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `use_email_priority`;

    ALTER TABLE `%TABLE_PREFIX%config` ADD `log_ticket_activity` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `strip_quoted_reply`;

    ALTER TABLE `%TABLE_PREFIX%config` ADD `staff_ip_binding` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `enable_daylight_saving`;

    ALTER TABLE `%TABLE_PREFIX%staff` CHANGE `signature` `signature` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

    ALTER TABLE `%TABLE_PREFIX%department` CHANGE `dept_signature` `dept_signature` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

    ALTER TABLE `%TABLE_PREFIX%email_template`
    ADD `ticket_notice_subj` VARCHAR( 255 ) NOT NULL AFTER `ticket_autoresp_body` ,
    ADD `ticket_notice_body` TEXT NOT NULL AFTER `ticket_notice_subj`;

    INSERT INTO `%TABLE_PREFIX%kb_premade` (`premade_id`, `dept_id`, `isenabled`, `title`, `answer`, `created`, `updated`) VALUES
    ('', 0, 1, 'Sample (with variables)', '\r\n%name,\r\n\r\nYour ticket #%ticket created on %createdate is in %dept department.\r\n\r\n', NOW(), NOW());


    You would find the sql files located in the 1.6st archive located at: upload\setup\inc
  • inckka;29267 said:
    I'm gonna overwrite my existing 1.6RC5 files with 1.6ST files without changing any databases or tables. Because I need the data in the existing database. Do both versions use same database table structure?
    I am right now in inckka situation, tried to run those queries but I am getting

    #1146 - Table 'database.%TABLE_PREFIX%ticket' doesn't exist

    Not sure what am I doing wrong :confused:

    Anyone's help is welcome


    _______________________________________________________________________________________________________
    I have finally learned what "upward compatible" means. It means we get to keep all our old mistakes. Free hosting
  • You have to change %TABLE_PREFIX% to whatever you used as your table prefix. [Typically this is ost_.] View the tables in your database and you should be able to figure out what you used fairly quickly. Alternatively [and this is probably faster and easier] you can look at your osticket configuration file. Depending on when you installed [ie what your first version was] and if you renamed the config file it could be settings.php, ostconfig.php, or ost-config.php. The config file is located in the /include directory. Just search the file for "TABLE_PREFIX".
Sign In or Register to comment.