Error in EXT update from 2.6.1 to 2.7.2

Post Reply
User avatar
elviseras
Sponsor
Sponsor
Posts: 509
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

Error in EXT update from 2.6.1 to 2.7.2

Post by 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?

User avatar
elviseras
Sponsor
Sponsor
Posts: 509
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

Re: Error in EXT update from 2.6.1 to 2.7.2

Post by 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

User avatar
support
Site Admin
Posts: 3786
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error in EXT update from 2.6.1 to 2.7.2

Post by 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.

User avatar
elviseras
Sponsor
Sponsor
Posts: 509
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

Re: Error in EXT update from 2.6.1 to 2.7.2

Post by 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 :D :D


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'

User avatar
support
Site Admin
Posts: 3786
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error in EXT update from 2.6.1 to 2.7.2

Post by 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`;

User avatar
elviseras
Sponsor
Sponsor
Posts: 509
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

Re: Error in EXT update from 2.6.1 to 2.7.2

Post by 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 ??

User avatar
support
Site Admin
Posts: 3786
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error in EXT update from 2.6.1 to 2.7.2

Post by support »

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

User avatar
elviseras
Sponsor
Sponsor
Posts: 509
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

Re: Error in EXT update from 2.6.1 to 2.7.2

Post by elviseras »

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

Post Reply