OpenCart Community

Qphoria wrote:

ebmarques wrote:The same with me.
My store is down, my Website is down.
I am so mad with OpenCart!!! Amateurs!!! It is unacceptable to release a new version without testing!!!
In spite of hiring someone to fix it I will move to WordPress with an Ecommerce plugin.
BYE BYE OpenCart!!!

It's just amateur to to blindly update your live site with a bleeding edge version for no reason.

OSWorX wrote:

Qphoria wrote:

ebmarques wrote:The same with me.
My store is down, my Website is down.
I am so mad with OpenCart!!! Amateurs!!! It is unacceptable to release a new version without testing!!!
In spite of hiring someone to fix it I will move to WordPress with an Ecommerce plugin.
BYE BYE OpenCart!!!

It's just amateur to to blindly update your live site with a bleeding edge version for no reason.

Maybe, but how many of the users using OC are NO amateurs??

AhmedSabri wrote:The update model does not work properly, so before upgrade edit "upgrade.php" in the model directory and change the line number 25 from

Code: Select all

$line = str_replace("CREATE TABLE `oc_", "CREATE TABLE `" . DB_PREFIX, $line);

to

Code: Select all

$line = str_replace("CREATE TABLE `oc_", "CREATE TABLE IF NOT EXISTS `" . DB_PREFIX, $line);

OR

change the line number 125 from

Code: Select all

preg_match_all('#create\s*table\s*if\s*not\s*exists\s*`(\w[\w\d]*)`#i', $sql, $table);

to

Code: Select all

preg_match_all('#create\s*table\s*`(\w[\w\d]*)`#i', $sql, $table);

After upgrade check your store settings becouse maybe you will lost the content of the home page and some data like user API key and some other data.

CREATE TABLE `oc_cart` (
`cart_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`session_id` varchar(32) NOT NULL,
`product_id` int(11) NOT NULL,
`recurring_id` int(11) NOT NULL,
`option` text NOT NULL,
`quantity` int(5) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`cart_id`),
KEY `cart_id` (`customer_id`,`session_id`,`product_id`,`recurring_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

TRUNCATE TABLE oc_customer_activity;

starconfig wrote:So is there any solution to create api ? probably deleted due to upgrades

I just copy api data from opencart.sql to SQL query and it works for me

Code: Select all

-- Table structure for table `oc_api`
--

DROP TABLE IF EXISTS `oc_api`;
CREATE TABLE `oc_api` (
  `api_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `key` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  PRIMARY KEY (`api_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oc_api_ip`
--

DROP TABLE IF EXISTS `oc_api_ip`;
CREATE TABLE `oc_api_ip` (
  `api_ip_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_id` int(11) NOT NULL,
  `ip` varchar(40) NOT NULL,
  PRIMARY KEY (`api_ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oc_api_session`
--

DROP TABLE IF EXISTS `oc_api_session`;
CREATE TABLE `oc_api_session` (
  `api_session_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_id` int(11) NOT NULL,
  `token` varchar(32) NOT NULL,
  `session_id` varchar(32) NOT NULL,
  `session_name` varchar(32) NOT NULL,
  `ip` varchar(40) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  PRIMARY KEY (`api_session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;