kirilkirkov / ecommerce-codeigniter-bootstrap Goto Github PK

Do u have discount codes integrated and what about a demo?

hi
thank for sharing good source but i am running this code if am facing index.php problem each and every open page from admin.

http://localhost/shopping/admin/publish Problem
http://localhost/shopping/index.php/admin/publish right

SQL Injection bugs on filtering search result.

Proof of concept:
adding 9999999999999999%27andextractvalue(0x00,concat(0x7e,%27injected%27))--+ on category parameter and order_price parameter. I've checked other parameter is ok (no problem).

Link 1:
http://localhost/?category=9999999999999999%27andextractvalue(0x00,concat(0x7e,%27injected%27))--+&in_stock=&search_in_title=&order_new=&order_price=&order_procurement=&brand_id=&quantity_more=&added_after=&added_before=&search_in_body=&price_from=&price_to=

Link 2:
http://localhost/?category=&in_stock=&search_in_title=&order_new=&order_price=9999999999999999%27andextractvalue(0x00,concat(0x7e,%27injected%27))--+&order_procurement=&brand_id=&quantity_more=&added_after=&added_before=&search_in_body=&price_from=&price_to=

Another bugs
the order_price parameter actually doesnt work, when you put some number it will give an error. at this line there is a problem but I couldn't predicting what method are you mean for this line:

Public_mode.php line 121
$this->db->order_by('CAST(price AS DECIMAL(10.2)) ' . $big_get['order_price']);

Hi.. just installed the project... really cool and interesting.. i'm struggling to change the default language to english. please help me with this.

Hi.. I have uploaded a product but product image is not showing in admin as well as frontend
http://prntscr.com/hpx7zu
http://prntscr.com/hpx8pb
http://prntscr.com/hpx9ip

i think the issue is appearing do to using "DIRECTORY_SEPARATOR forward slash" if i change it to "/" then image are showing correctly.
please advise what i have to do ..
please help

Hi,
I found a section to activate PayPal payment gateway at the URL: /admin/orders?settings
However, I could not setup Paypal API user and secret key in the admin dashboard. Is it in the source code, if yes, where is the location of configuration file?
Could you please guide me.
Thanks

@kirilkirkov i have the similar problem as @laayis had,

I have cloned the repo. When i try to asses the site over the browser it i cannot pull the css, what am i doing wrong? I have set my Base Url like this $config['base_url'] = 'http://localhost/shoppingcart/'; "shoppingcart" is what i renamed the clone repo to.

after adding the following in .htaccess file

RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L]

CSS is still not showing. I can not have the application in root folder as have other projects also.

When I try to import the database.sql file into my DB, I get these errors:

[ERROR in query 20] Incorrect table definition; there can be only one auto column and it must be defined as a key
[ERROR in query 21] Table 'supershop.users_public' doesn't exist

Why is the choose payment method stuck on Cash On Delivery? Please advice. I would like to use bank and paypal.

What am I trying to do.. is to update the text of 3rd template forskolin 1020
Can you guide me how to do it or is there any way to do it?

Hi,
when I click on a product to show the details, I get a 404 error.
The link is something like /ANTAB222_213 where 213 is products.id

I have tried also /home/viewProduct/213 and /shop-product_213 but I get always 404 error

What I can check? Thank's

P.S. All others routing work correct, the .htaccess is NOT modified and mod_rewrite is active

I do not want to install MySQL, can it link with SQLite? that is easy to install thanks.

does the multi vendor function i the system settings work?
i have enabled this feature but unable to see any difference in the administration panel, or on the publish product page as any additional input fields etc...

Cant find any login page

I have changed the default language currency (via the backend) to GB/GBP
When viewing products, the price currency shows as Euro's

Ideally i need all prices to be £ british pound sterling

The current CI Cart library is deprecated and it will be remove on the next CI updates.
https://www.codeigniter.com/userguide3/libraries/cart.html

Are you using the Cart library?

I am trying to add a product
..What's happening

when i try and add a product, i get an db error brand_id can not be null

A PHP Error was encountered

Severity: Warning

Message: mkdir(): Invalid path

Filename: drivers/Session_files_driver.php

Line Number: 136

Backtrace:

File: C:\usb\root\application\third_party\MX\Loader.php
Line: 173
Function: _ci_load_library

File: C:\usb\root\application\third_party\MX\Loader.php
Line: 190
Function: library

File: C:\usb\root\application\third_party\MX\Loader.php
Line: 153
Function: libraries

File: C:\usb\root\application\third_party\MX\Loader.php
Line: 65
Function: initialize

File: C:\usb\root\application\third_party\MX\Base.php
Line: 55
Function: __construct

File: C:\usb\root\application\third_party\MX\Base.php
Line: 60
Function: __construct

File: C:\usb\root\application\third_party\MX\Controller.php
Line: 4
Function: require

File: C:\usb\root\application\third_party\MX\Modules.php
Line: 123
Function: include_once

File: C:\usb\root\application\core\MY_Controller.php
Line: 4
Function: spl_autoload_call

File: C:\usb\root\index.php
Line: 292
Function: require_once

Does the system support multi-vendors?

An error occurred upon ordering a product. sql dump file might be outdated?

INSERT INTO confirm_links (link, for_order) VALUES ('b32b34e77178a22906292252dcc5db96', 1235)
Filename: models/Publicmodel.php
Line Number: 303

i'm getting this error while uploading the SQL file to my database.
please check it

Hi. When publishing or updating a product, brand index is not saved on DB so it's always zero and therefore clicking on a brand name will not pull up products associated with it. Also, a product or products will only show when its category or the parent of that category is clicked - only on two levels. Is it possible for you to fix this so that all the way up to the highest category they would still show when said category is clicked? Oh and can't edit languages on admin panel, but of course it works when changed from site_lang.php. Thank you.

Hi there
Your Shopping runs good, just need to check the following things
a.- css, js and images files are inside public folder then file SL.php need to be updated.
b.- Checking your shopping.sql looks like there is no table questions required to the FAQ section.

Cheers!

@kiril, any ideeas for create virtual products as books(epub) or others?
I am thinking how to modify the code to do that.
Thanks in advance !!!

Do you have a login and registration modules for this?

When i run this cms in my local xampp server, it works fine. but when i run in remote server with chrome browser, it refuse to execute language js file all.js.

As a result, BUY or ADD TO SHOPPING CART not work.
at present the language js file all.js called by loader controller.
After huge google search and some research, it can be solved by the following way:

create a language folder into assets folder and.. folder strcture is
assets
--language
----englisg
------js
--------all.js
now it works in chrome

if any body has another solution, pls reply.

Im trying to change the default Language currency from $ to £ and also change the image

There is no way to create a new language and set the new language as default

mysql> source /root/dbDump.sql;
Query OK, 0 rows affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' at line 14
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected, 1 warning (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 28 rows affected (0.00 sec)
Records: 28 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

@kiril,
When you try to delete a language already added, you obtain an error like this

Error Number: 1054
Unknown
column
'bg' in 'where clause'
DELETE FROM translations WHERE abbr = bg
Filename: modules/admin/models/Adminmodel.php
Line Number: 163
I think you didnt know about that yet
I modified the function in Adminmodel.php and loooks like below and works.

public function deleteLanguage($id) { $this->db->select('abbr'); $this->db->where('id', $id); $res = $this->db->get('languages'); $row = $res->row_array(); $this->db->trans_start(); $this->db->query('DELETE FROM languages WHERE id = ' . $this->db->escape($id)); $this->db->query("DELETE FROM translations WHERE abbr = '$row'"); $this->db->query("DELETE FROM cookie_law_translations WHERE abbr = '$row'"); $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { return false; } return true; }`
I changed the query for delete translations and cookie_law_translations a little bit
I hope is useful

Can not locate folders needed:

Please advise,

How can I add my own custom slider which only shows pictures not products like yours

I am trying to download the zip file but it restarts after reaching 4 MB. I don't know why it is happening.

Query SQL:

CREATE TABLE vendors (
id int(11) NOT NULL,
name varchar(50) DEFAULT NULL,
url varchar(50) NOT NULL,
email varchar(50) NOT NULL,
password varchar(100) NOT NULL,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Messaggio di MySQL: Documentazione

#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

What is the link to login to the admin panel and add products area? I do not see any login links in the home page.

First of all, thanks for the wonderful program.
Now the question, is there any way to set a language other than English as the default language?
Thank you

At step 3, i set config base_url is empty but it dont work

$config['base_url'] = '';

Some id Column in some table aren't auto increment, made some issues when editing status because duplicating of 0 value.

List of table with id not auto increment:
orders_clients
bank_accounts
confirm_links
vendors_orders_clients

Clicking on an item or product information pulls up the latest item saved and not the selected item. Product URL for every item is the same on the DB. Thanks.

is it easy to add product fields to the add a new product page? i would like to add Size/Weight plus some more possibly.

What am I trying to do..
i only have the ability to use payment type cash on delivery. how can i setup paypal and use payment type paypal?

INSERT INTO confirm_links (link, for_order) VALUES ('a33ae444a460438dba0fdd5403d32e0a', 1236)

A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: third_party/MX/Base.php

Line Number: 55

since i switch to test env.

DEV ENV :

A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES)

Filename: mysqli/mysqli_driver.php

Line Number: 201

Backtrace:

File: /usr/share/nginx/www/caseland.store/public_html/application/third_party/MX/Loader.php
Line: 109
Function: DB

File: /usr/share/nginx/www/caseland.store/public_html/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /usr/share/nginx/www/caseland.store/public_html/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /usr/share/nginx/www/caseland.store/public_html/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /usr/share/nginx/www/caseland.store/public_html/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /usr/share/nginx/www/caseland.store/public_html/application/third_party/MX/Modules.php
Line: 123
Function: include_once

File: /usr/share/nginx/www/caseland.store/public_html/application/core/MY_Controller.php
Line: 4
Function: spl_autoload_call

File: /usr/share/nginx/www/caseland.store/public_html/index.php
Line: 293
Function: require_once

It seems that the Products table is missing the "vendor_id" field.

I setup everything. working fine.

So I added one category(mobile) first. then added product(iphone).

go to site and checked. category name is showing up. but iphone is not showing up on hamepage. or I clicked it in mobile category. still nothing.

This query:

CREATE TABLE IF NOT EXISTS orders(idint(10) unsigned NOT NULL AUTO_INCREMENT,order_idint(11) NOT NULL,productstext NOT NULL,dateint(10) unsigned NOT NULL,referrervarchar(255) NOT NULL,clean_referrervarchar(255) NOT NULL,payment_typevarchar(255) NOT NULL,paypal_statusvarchar(10) DEFAULT NULL,processedtinyint(1) NOT NULL DEFAULT '0',viewedtinyint(1) NOT NULL DEFAULT '0' COMMENT 'viewed status is change when change processed status',confirmedtinyint(1) NOT NULL DEFAULT '0',discount_code varchar(20) NOT NULL PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1

And this is the issue
3 errors were found during analysis.

A comma or a closing bracket was expected. (near "(" at position 572)
Unexpected beginning of statement. (near "id" at position 573)
Unrecognized statement type. (near "ENGINE" at position 581)

Dear kirilkirkov,
thanks for all your efforts for developing this shopping cart script.
But the template folder in root directory is missing. Could you please upload it?
Thanks and regards,
Santhosh.

currently the view product page shows the price as: price/currency. which view file is this so we can swap them around to show: currency/price?

Product is not getting added in shopping cart. it shows Still no items in your cart

Is it possible to enable shopping only for registered users?