Giter VIP home page Giter VIP logo

Comments (3)

dart-com-ua avatar dart-com-ua commented on June 30, 2024

here we go:

how this can be?

INSERT INTO `toc_manufacturers_info` (manufacturers_id, languages_id, manufacturers_url, manufacturers_friendly_url, url_clicked, date_last_click, manufacturers_page_title , manufacturers_meta_keywords, manufacturers_meta_description) VALUES 
(1, 1, 'http://www.apple.com', 'apple', '0', NULL, '', '', ''),
(2, 1, 'http://www.dell.com', 'dell', '0', NULL, '', '', ''),

->>>>(3, 1, 'http://www.hp.com', 'hp', '0', NULL, '', '', ''),
(4, 1, 'http://www.lenovo.com', 'lenovo', '0', NULL, '', '', ''),
(5, 1, 'http://www.sony.com', 'sony', '0', NULL, '', '', ''),

->>>>(3, 1, 'http://www.hp.com', 'hp', '0', NULL, '', '', ''),
(4, 1, 'http://www.lenovo.com', 'lenovo', '0', NULL, '', '', ''),
(5, 1, 'http://www.sony.com', 'sony', '0', NULL, '', '', ''),

(6, 1, 'http://www.samsung.com', 'samsung', '0', NULL, '', '', ''),
(7, 1, 'http://www.htc.com', 'htc', '0', NULL, '', '', ''),
(8, 1, 'http://www.blackberry.com', 'blackberry', '0', NULL, '', '', ''),
(9, 1, 'http://www.nokia.com', 'nokia', '0', NULL, '', '', ''),
(10, 1, 'http://www.lg.com', 'lg', '0', NULL, '', '', ''),
(11, 1, 'http://www.motorola.com', 'motorola', '0', NULL, '', '', '');

from tomatocart-v2.

dart-com-ua avatar dart-com-ua commented on June 30, 2024

How the fuck this can be?

INSERT INTO `toc_categories_description` (categories_id, language_id, categories_name, categories_description, categories_url, categories_page_title, categories_meta_keywords, categories_meta_description)

You will use "categories_description" or no? If there's no bug in sample data then it's the bug in initial table structure

How you can develop the whole script if you don't even checked integrity of imported data? It's over my imagination :(
Who will test this if nobody even can install it?

from tomatocart-v2.

dart-com-ua avatar dart-com-ua commented on June 30, 2024

How the fuck it can work? It will never insert you incremental values TWICE. Merge these two commands!

INSERT INTO `toc_categories_description` (categories_id, language_id, categories_name, categories_url, categories_page_title, categories_meta_keywords, categories_meta_description) VALUES
(1, 1, 'Laptop', 'laptop', '', '', ''),
(2, 1, 'Desktops', 'desktops', '', '', ''),
(3, 1, 'Monitors', 'monitors', '', '', ''),
(4, 1, 'Printers & Scanners', 'printers-scanners', '', '', ''),
(5, 1, 'HP', 'hp', '', '', ''),
(6, 1, 'BROTHER', 'brother', '', '', ''),
(7, 1, 'EPSON', 'epson', '', '', ''),
(8, 1, 'CANON', 'canon', '', '', ''),
(9, 1, 'iPod & Camera', 'ipod-camera', '', '', ''),
(10, 1, 'Phones', 'phones', '', '', '');


INSERT INTO `toc_categories_description` (categories_id, language_id, categories_name, categories_url, categories_page_title, categories_meta_keywords, categories_meta_description) VALUES
(1, 2, 'чмФшо░цЬм', 'laptop', '', '', ''),
(2, 2, 'хП░х╝ПцЬ║', 'desktops', '', '', ''),
(3, 2, 'цШ╛чд║хЩи', 'monitors', '', '', ''),
(4, 2, 'цЙУхН░цЬ║ & цЙлцППф╗к', 'printers-scanners', '', '', ''),
(5, 2, 'цГацЩо', 'hp', '', '', ''),
(6, 2, 'хЕДх╝Я', 'brother', '', '', ''),
(7, 2, 'чИ▒цЩочФЯ', 'epson', '', '', ''),
(8, 2, 'ф╜│шГ╜', 'canon', '', '', ''),
(9, 2, 'iPod & цХ░чаБчЫ╕цЬ║', 'ipod-camera', '', '', ''),
(10, 2, 'цЙЛцЬ║', 'phones', '', '', '');


INSERT INTO `toc_categories_description` (categories_id, language_id, categories_name, categories_description, categories_url, categories_page_title, categories_meta_keywords, categories_meta_description) VALUES
(1, 1, 'Laptop', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'laptop', '', '', ''),
(2, 1, 'Desktops', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'desktops', '', '', ''),
(3, 1, 'Monitors', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'monitors', '', '', ''),
(4, 1, 'Printers & Scanners', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'printers-scanners', '', '', ''),
(5, 1, 'HP', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'hp', '', '', ''),
(6, 1, 'BROTHER', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'brother', '', '', ''),
(7, 1, 'EPSON', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'epson', '', '', ''),
(8, 1, 'CANON', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'canon', '', '', ''),
(9, 1, 'iPod & Camera', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'ipod-camera', '', '', ''),
(10, 1, 'Phones', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'phones', '', '', '');


INSERT INTO `toc_categories_description` (categories_id, language_id, categories_name, categories_description, categories_url, categories_page_title, categories_meta_keywords, categories_meta_description) VALUES
(1, 2, 'чмФшо░цЬм', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'laptop', '', '', ''),
(2, 2, 'хП░х╝ПцЬ║', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'desktops', '', '', ''),
(3, 2, 'цШ╛чд║хЩи', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'monitors', '', '', ''),
(4, 2, 'цЙУхН░цЬ║ & цЙлцППф╗к', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'printers-scanners', '', '', ''),
(5, 2, 'цГацЩо', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'hp', '', '', ''),
(6, 2, 'хЕДх╝Я', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'brother', '', '', ''),
(7, 2, 'чИ▒цЩочФЯ', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'epson', '', '', ''),
(8, 2, 'ф╜│шГ╜', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'canon', '', '', ''),
(9, 2, 'iPod & цХ░чаБчЫ╕цЬ║', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'ipod-camera', '', '', ''),
(10, 2, 'цЙЛцЬ║', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis,', 'phones', '', '', '');

from tomatocart-v2.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.