Error in EXT update from 2.6.1 to 2.7.2

[elviseras]

Hi, Sergey,

We are encounter following error to upgrade RK from v2.6.1 to v2.7.2 (To run Database EXT Auto Update Script)

Processing...
ALTER TABLE `app_ext_processes` ADD `javascript_in_from` TEXT NOT NULL AFTER `disable_comments`, ADD `javascript_onsubmit` TEXT NOT NULL AFTER `javascript_in_from`
1054
Unknown column 'disable_comments' in 'app_ext_processes'

In Database Auto update MAIN Scrip (run before) all is fine without any error

Any suggestion?

[elviseras]

Addicionally, to login following errors show in Dashboard page:

Warning: Use of undefined constant TEXT_EXT_XML_IMPORT - assumed 'TEXT_EXT_XML_IMPORT' (this will throw an Error in a future version of PHP) in ..\..\plugins\ext\ext_menu.php on line 70

Warning: Use of undefined constant TEXT_CUSTOM_CSS - assumed 'TEXT_CUSTOM_CSS' (this will throw an Error in a future version of PHP) in ..\..\includes\functions\menu.php on line 308

Warning: Use of undefined constant TEXT_DOCUMENTATION - assumed 'TEXT_DOCUMENTATION' (this will throw an Error in a future version of PHP) in ..\..\includes\functions\menu.php on line 346

Warning: Use of undefined constant TEXT_NEWS - assumed 'TEXT_NEWS' (this will throw an Error in a future version of PHP) in ..\..\includes\functions\menu.php on line 348

[support]

Strange. Open phpMyAdmin and run next query:

Code: Select all

ALTER TABLE `app_ext_processes` ADD `disable_comments` TINYINT(1) NOT NULL AFTER `redirect_to_items_listing`;

Once it's done run again:

Code: Select all

ALTER TABLE `app_ext_processes` ADD `javascript_in_from` TEXT NOT NULL AFTER `disable_comments`, ADD `javascript_onsubmit` TEXT NOT NULL AFTER `javascript_in_from`

Let me know if it works.

About "Warning: Use of undefined constant TEXT_EXT_XML_IMPORT " make sure constant TEXT_EXT_XML_IMPORT is exist in language file.

[elviseras]

Hi Sergey...

make sure constant TEXT_EXT_XML_IMPORT is exist in language file

You're right, it was our problem with the translation file. Thank you


But for script error, to open phpMyAdmin and run first query, next error shows:

#1054 - Unknown column 'redirect_to_items_listing' in 'app_ext_processes'

[support]

Are you sure it was 2.6 version?
see install\db_updates\ext\ext_2.4.sql
redirect_to_items_listing and disable_comments columns added there.

Probably it was not run on previous update.
Try to run

Code: Select all

ALTER TABLE `app_ext_processes` ADD `redirect_to_items_listing` TINYINT(1) NOT NULL DEFAULT '0' AFTER `success_message`;
ALTER TABLE `app_ext_processes` ADD `disable_comments` TINYINT(1) NOT NULL AFTER `redirect_to_items_listing`;

[elviseras]

Yes, It was 2.6.1 version....

To run new first query, ahother error shows:

#1054 - Unknown column 'success_message' in 'app_ext_processes'

Uff... How we test/run correct script updates from v2.4 ??

[support]

Try to run script in phpmyadmin install\db_updates\ext\ext_2.4.sql

[elviseras]

Thanks a lot, Sergey, I think we have already been able to solve it. Your help is always very valuable !!