Tweet
I recently upgraded my Opencart from 1.5 to 3.x I downloaded the most recent extension from the C&P Gethub site.
Copied all files to their respective directories. When I try to install it from the Payments Extension area in Opencart I get an error. It was working a couple years ago but they have not been using it so I disabled the store url. and am now resurrecting it with the updated version and theme. The database is the same. Note: I created a sample store with a the new version to test out a new theme and used the same database to connect to. I'm not sure if that caused any a problem with regards to the tables in the DB. Anyway I wanted to give you guys as much info as you needed to make an assessment.
I created an Admin login and can provide login credentials for you privately if would like to take a look. Any help would be appreciated.
Here is the error:
*Fatal error*: Uncaught exception 'Exception' with message 'Error: Invalid
default value for 'cnpaccountsinfo_crtdon'<br />Error No: 1067<br />CREATE
TABLE IF NOT EXISTS `cnpaccountsinfo` ( `cnpaccountsinfo_id` int(11) NOT
NULL AUTO_INCREMENT, `cnpaccountsinfo_orgid` varchar(100) NOT NULL,
`cnpaccountsinfo_orgname` varchar(250) NOT NULL,
`cnpaccountsinfo_accountguid` varchar(250) NOT NULL,
`cnpaccountsinfo_userfirstname` varchar(250) NOT NULL,
`cnpaccountsinfo_userlastname` varchar(250) NOT NULL,
`cnpaccountsinfo_userid` varchar(250) NOT NULL, `cnpaccountsinfo_crtdon`
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `cnpaccountsinfo_crtdby`
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY
(`cnpaccountsinfo_id`) )' in /var/www/vhosts/
courageworldwide.org/httpdocs/store/system/library/db/mysqli.php:40Stack
trace: #0 /var/www/vhosts/
courageworldwide.org/httpdocs/store/system/library/db.php(45):
DB\MySQLi->query('CREATE TABLE IF...') #1 /var/www/vhos in
*/var/www/vhosts/courageworldwide.org/httpdocs/store/system/library/db/mysqli.php
<http://courageworldwide.org/httpdocs.../db/mysqli.php>* on
line *40*
Copied all files to their respective directories. When I try to install it from the Payments Extension area in Opencart I get an error. It was working a couple years ago but they have not been using it so I disabled the store url. and am now resurrecting it with the updated version and theme. The database is the same. Note: I created a sample store with a the new version to test out a new theme and used the same database to connect to. I'm not sure if that caused any a problem with regards to the tables in the DB. Anyway I wanted to give you guys as much info as you needed to make an assessment.
I created an Admin login and can provide login credentials for you privately if would like to take a look. Any help would be appreciated.
Here is the error:
*Fatal error*: Uncaught exception 'Exception' with message 'Error: Invalid
default value for 'cnpaccountsinfo_crtdon'<br />Error No: 1067<br />CREATE
TABLE IF NOT EXISTS `cnpaccountsinfo` ( `cnpaccountsinfo_id` int(11) NOT
NULL AUTO_INCREMENT, `cnpaccountsinfo_orgid` varchar(100) NOT NULL,
`cnpaccountsinfo_orgname` varchar(250) NOT NULL,
`cnpaccountsinfo_accountguid` varchar(250) NOT NULL,
`cnpaccountsinfo_userfirstname` varchar(250) NOT NULL,
`cnpaccountsinfo_userlastname` varchar(250) NOT NULL,
`cnpaccountsinfo_userid` varchar(250) NOT NULL, `cnpaccountsinfo_crtdon`
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `cnpaccountsinfo_crtdby`
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY
(`cnpaccountsinfo_id`) )' in /var/www/vhosts/
courageworldwide.org/httpdocs/store/system/library/db/mysqli.php:40Stack
trace: #0 /var/www/vhosts/
courageworldwide.org/httpdocs/store/system/library/db.php(45):
DB\MySQLi->query('CREATE TABLE IF...') #1 /var/www/vhos in
*/var/www/vhosts/courageworldwide.org/httpdocs/store/system/library/db/mysqli.php
<http://courageworldwide.org/httpdocs.../db/mysqli.php>* on
line *40*
Comment