In my database, there is a table which shows the landing pages, and what I want to do is to classify if the traffic is from SEO channel. When the landing page is exactly equal to the pattern /countrycode/index.aspx, then…
I have problem loading some data from a CSV file to my table in the database and got an error said : #1044 - Access denied for user 'A WEIRD USER'@'localhost' to database 'MY DATABASE' As I know phpmyadmin logged…
I made a backup of site through cpanel-ftp and also made a backup of database through phpmyadmin. Now I copied all site files in c:xampphtdocs and also imported database in localhost phpadmin ( changed site urlhomepage url to local host…
I am currently working on a Django based service that will gather users' data from their Shopify shops and provide some insights. I use PostgreSQL as my DB server. The problem I am facing is whether it is more efficient…
When I deploying my Laravel project on free host called 000webhostapp.com, I got this error: SQLSTATE[HY000] [2002] Connection refused (SQL: select * from posts order by created_at desc limit 10) I tried by creating a database there and also I…
This is my query in Postgresql: SELECT C.id, S.domen, B.name, C.source_id, ST.name FROM "calls" C INNER JOIN "site" S ON S.id=C.site_id INNER JOIN "sources" ON sources.id=C.source_id INNER JOIN "brand" B ON B.id = S.id_brand INNER JOIN "source_types" ST ON ST.id…
In order to conduct a Market Basket Analysis on the sales data in magento, i need to retrieve the products that are included in each invoice from magento. So far this is what i got. SELECT tblInvoice.increment_id AS orderId, tblLine.product_id…
I want to connect and Request from MSSQL using nodejs to link it with magento. I Am trying to fix it for days now but it ends on the same way... This is my Error Code: Connected { RequestError: Requests…
I have the following table with child parent relationship. ID Title PageID IsParent ParentID IsActive 1 Dashboard 2125 True NULL True 2 Site Analytics 22 False NULL True 3 SEO Management 1 NULL NULL True 4 Mail Management 32 NULL…
I have a table item name which is like this : Microsoft Word Adobe Premiere Paint Mozila Firefox Adobe Photoshop CS7 Windows Movie Maker I want to select the data (table product, column name) become like this : Microsoft Word…