Post by straightlight » Fri Oct 27, 2017 7:55 pm

See if your system/library/db folder does actually exist and if you do see the mpdo.php and mysqli.php files ...

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by esprit1st » Fri Oct 27, 2017 10:25 pm

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.

Newbie

Posts

Joined
Sun Feb 17, 2013 6:57 am

Post by straightlight » Fri Oct 27, 2017 10:30 pm

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.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by esprit1st » Sat Oct 28, 2017 11:41 pm

Just followed the post as suggested. Same behavior as before. :(

Newbie

Posts

Joined
Sun Feb 17, 2013 6:57 am

Post by straightlight » Sat Oct 28, 2017 11:50 pm

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.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by dookable » Thu Nov 23, 2017 7:16 pm

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

New member

Posts

Joined
Thu Sep 04, 2014 11:29 pm

Post by straightlight » Thu Nov 23, 2017 9:56 pm

See the most recent actions in the access logs of your webserver regarding site redirection loops and provide them on your next reply.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by jpernas » 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 :)

Jesús P. A.
__________________
SEO Coruña
Enjoying OC 3.0.2


User avatar
Newbie

Posts

Joined
Mon Jun 06, 2016 4:56 pm

Post by jpernas » Fri Feb 02, 2018 11:23 pm

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 :)

Attachments

meta-title.jpg

meta-title.jpg (27.35 KiB) Viewed 1883 times


Jesús P. A.
__________________
SEO Coruña
Enjoying OC 3.0.2


User avatar
Newbie

Posts

Joined
Mon Jun 06, 2016 4:56 pm
Who is online

Users browsing this forum: No registered users and 55 guests