Page 13 of 13

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Fri Oct 27, 2017 7:55 pm
by straightlight
See if your system/library/db folder does actually exist and if you do see the mpdo.php and mysqli.php files ...

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Fri Oct 27, 2017 10:25 pm
by esprit1st
There is no such folder in the 1.5.6.4 installation. However, it is in the 2.2.0.0 update. So I uploaded the 2.2 files, then uploaded the upgrade improvement, then switched the db-driver to mpdo. Then ran the update. Still, the same undefined error message after it finished the 1000 fine.
I am still not getting any errors in the logfiles during the update.
After the interrupted update I get this message in the browser when I load the shop homepage:
Error: A theme has not been assigned to this store!
and these error messages in the log:

Code: Select all

[Fri Oct 27 16:18:39.732030 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732073 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732099 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732113 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732130 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732144 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732160 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732170 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732186 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732213 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732231 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732241 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732257 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732266 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732284 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732293 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732362 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732376 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732440 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DB_PORT - assumed 'DB_PORT' in opencart/shop/system/config/catalog.php on line 13
[Fri Oct 27 16:18:39.732467 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732478 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[Fri Oct 27 16:18:39.732585 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 70
[Fri Oct 27 16:18:39.732600 2017] [:error] [pid 12439] PHP Notice:  Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in opencart/shop/system/startup.php on line 76
[...]
(removed the rest of the same errors from above)
Thanks so much for your help! I hope we'll find out whats wrong here.

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Fri Oct 27, 2017 10:30 pm
by straightlight
Follow these instructions: viewtopic.php?f=199&t=198781&p=699560&h ... ON#p699560 and ensure to add each of the mentioned definitions missing into your config.php and admin/config.php file.

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Sat Oct 28, 2017 11:41 pm
by esprit1st
Just followed the post as suggested. Same behavior as before. :(

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Sat Oct 28, 2017 11:50 pm
by straightlight
Then, you need to switch your DIR_MODIFICATION path to the new destination where Opencart has moved it from the admin dashboard form. If the path has already been moved and this error still persists, which I don't doubt, then specify the original path of: system/storage folder . This should resolved the problem.

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Thu Nov 23, 2017 7:16 pm
by dookable
I have tried to run this script on a fresh install, all works fine front end but I cannot access admin, it keeps sending me back to the install/index.php even though I have deleted the install folder.

When I first went to admin, it ran some more scripts but every tie I tried after that, it just wanted ti run the scripts, so deleted the folder.

Any suggestions, please.

Updated from 1.5.5.1 to 2.2.0.0

Mant thanks..

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Thu Nov 23, 2017 9:56 pm
by straightlight
See the most recent actions in the access logs of your webserver regarding site redirection loops and provide them on your next reply.

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Fri Feb 02, 2018 12:07 am
by jpernas
I think that Qphoria has done a great job.

I tried the script in a clean installation of opencart 1.5.6.4 and, in less than 5 minutes, I had a perfect clean installation of opencart 2.2.0.0

I'm doing the migration in "local" with a Xampp 5.6.32 server (Windows version) ... so making the memory extension and waiting time modifications in php.ini have not been a problem.

Excited, I tried to update a version with the complete database. But in this case I found an error:

Code: Select all

Error Code(0): Error: Duplicate column name 'meta_Title'
Error No: 1060
ALTER TABLE `product_description` ADD `meta_title` VARCHAR(255) NOT NULL AFTER `tag` in C:\xampp\htdocs\tienda1564\system\library\db\mysqli.php on line 40
And the same with the table 'category_description'

Code: Select all

Error Code(0): Error: Duplicate column name 'meta_Title'
Error No: 1060
ALTER TABLE `category_description` ADD `meta_title` VARCHAR(255) NOT NULL AFTER `description` in C:\xampp\htdocs\tienda1564\system\library\db\mysqli.php on line 40
Can you lend me a hand with this?

I have seen that labelshop founded some close error message... but not with a column.

I would appreciate a little help or clues to manage this.

Thank you in advance :)

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PLEASE

Posted: Fri Feb 02, 2018 11:23 pm
by jpernas
Well, I will answer myself. ;D

Finally I have solved the error.

Actually, it was simply a modification that must have been made at some point. The column "meta_Title" had been added to these tables ... and this caused duplicity.

I deleted those columns, re-run the script and it works! :D

I hope it will be useful to others.
jpernas wrote:
Fri Feb 02, 2018 12:07 am
I think that Qphoria has done a great job.

I tried the script in a clean installation of opencart 1.5.6.4 and, in less than 5 minutes, I had a perfect clean installation of opencart 2.2.0.0

I'm doing the migration in "local" with a Xampp 5.6.32 server (Windows version) ... so making the memory extension and waiting time modifications in php.ini have not been a problem.

Excited, I tried to update a version with the complete database. But in this case I found an error:

Code: Select all

Error Code(0): Error: Duplicate column name 'meta_Title'
Error No: 1060
ALTER TABLE `product_description` ADD `meta_title` VARCHAR(255) NOT NULL AFTER `tag` in C:\xampp\htdocs\tienda1564\system\library\db\mysqli.php on line 40
And the same with the table 'category_description'

Code: Select all

Error Code(0): Error: Duplicate column name 'meta_Title'
Error No: 1060
ALTER TABLE `category_description` ADD `meta_title` VARCHAR(255) NOT NULL AFTER `description` in C:\xampp\htdocs\tienda1564\system\library\db\mysqli.php on line 40
Can you lend me a hand with this?

I have seen that labelshop founded some close error message... but not with a column.

I would appreciate a little help or clues to manage this.

Thank you in advance :)