Search found 18 matches

Page 1 of 1

Search found 18 matches

Re: phpmyadmin Help

uksitebuilder wrote:
Tue Oct 24, 2017 4:27 pm
I believe the searching for spaces SQL query should be:

Code: Select all

SELECT * FROM oc_url_alias WHERE keyword LIKE '% %'
Worked perfect. Thank you

Thread can be closed.

Jump to post
  • Tue Oct 24, 2017 10:38 pm
  • Replies 5
  • Views 953
Re: phpmyadmin Help

You should be able to enter SQL code for both: How can i find the lines with a empty field? SELECT * FROM oc_product WHERE image='' I think will work. That's two single quotes '. How can I find the fields with spaces like per example (product -1.jpg) SELECT * FROM oc_url_alias WHERE keyword LIKE % ...

Jump to post
  • Tue Oct 24, 2017 12:34 am
  • Replies 5
  • Views 953
phpmyadmin Help

I need to find this info in a DB of a, Opencart shop. However I don't know if i must do it with SQL or with operators 1) Products without image - table: oc_product column: image - eg (images/photo1.jpg) How can i find the lines with a empty field? 2) Friendly SEO URLS with a space table: oc_url_alia...

Jump to post
  • Mon Oct 23, 2017 11:10 pm
  • Replies 5
  • Views 953
lastest products in OC 2.X?

Where can I manage lastest products module in Opencart 2?
Thank you

Jump to post
  • Wed Dec 02, 2015 12:39 am
  • Replies 1
  • Views 260
How to install vQmod with override engine?

How can I install vQmod with override engine, seems hard since override engine edits index.php

Any help?

Jump to post
  • Tue Oct 27, 2015 7:08 pm
  • Replies 1
  • Views 332
Re: [RELEASED] Override Engine for OpenCart

How can I install vQmod with override engine?

Jump to post
  • Tue Oct 27, 2015 7:07 pm
  • Replies 320
  • Views 198636
[Upgrade] 2.0.1.1 to 2.3.1 Getting orders in strange format

Hello, Im upgrading from 2.0.1.1 to the 2.3.1 version, all goes right but when I go to check orders and prices I see this: http://s18.postimg.org/g8qvmlb9l/image.png http://s18.postimg.org/sekoaqfd5/image.png http://s1.postimg.org/pfdxge8gf/image.png Tried to import orders with the tool and with Exc...

Jump to post
  • Mon Oct 26, 2015 6:54 pm
  • Replies 0
  • Views 688
Login with PayPal "uthorization Code is invalid"

Hello, Im trying to integrate the Login with PayPal module in my shop, but when I loggin it shows a blank page in: http://www.myshop.com/index.php?route=module/pp_login/login&scope=address+profile+email+https%3A%2F%2Furi.paypal.com%2Fservices%2Fexpresscheckout+phone&code=MzFaPKXZ4K-vtvsQfdEp...

Jump to post
  • Fri Oct 09, 2015 5:48 pm
  • Replies 2
  • Views 521
borrar

borrar

Jump to post
  • Sun Sep 27, 2015 9:22 pm
  • Replies 0
  • Views 213
Colorbox external html

Hi,

How can I load a external page with colorbox in Opencart 2.0?

Thank you :) :)

Jump to post
  • Wed Apr 29, 2015 6:30 pm
  • Replies 0
  • Views 205
'filter_sub_category' => false, - Not working

In my shop when you go to a category with subcategories it shows all products and I want to change Link: http://bit.ly/VTgLhT I edited the category.php controller to this but its not working: foreach ($results as $result) { $data = array( 'filter_category_id' => $result['category_id'], [b]'filter_su...

Jump to post
  • Fri Aug 29, 2014 2:01 am
  • Replies 0
  • Views 548
Products appearing in main category and subcategory [SEO]

Hi, The products of my shop are appearing (twice) in main category and subcategory Example: Food for Dogs of Cheese (product) -> showing in -> Dogs (main category) and -> Food for Dogs (Subcategory) Is this bad for SEO? Its affecting to my link juice? Link to my shop: http://www.allsens.es OC ver: 1...

Jump to post
  • Wed Jul 30, 2014 2:20 am
  • Replies 0
  • Views 251
Google Sitemap Blank page?

Hello,

When I go to the opencart google sitemap of my site ..."route=feed/google_sitemap' it generates a blank page, how can I solve?

Ver : 1.5.2.1
Upgrade

thank you

Jump to post
  • Thu Mar 21, 2013 9:34 am
  • Replies 0
  • Views 268
Solve missing orders PayPal standard (1.5.5.1)

Hello,

If you can solve it I'll pay you $4 via Liberty Reseve (is not much but its all that I can pay in this moment)

User must be trusted here.

Jump to post
  • Mon Mar 18, 2013 12:20 pm
  • Replies 3
  • Views 1039
Get page numer to show in title (help!) (Opencart Bug)

Hello, How can I get the numer of the page to show in title? (DEFAULT) http://www.Site.com/brand -> Title Brand http://www.Site.com/brand?page=2 -> Title Brand I would like it http://www.Site.com/brand -> Title Brand (/Page 1) http://www.Site.com/brand?page=2 -> Title Brand - Page 2 If someone helps...

Jump to post
  • Sat Mar 16, 2013 6:52 pm
  • Replies 0
  • Views 124
Custom Title [SEO] Optimization

Hello, I installed a vQmod wich I want to customize to optimize my site <file name="catalog/controller/product/category.php"> <operation> <search position="replace"><![CDATA[$this->document->setTitle($category_info['name']);]]></search> <add><![CDATA[ $newTitle = $category_info['...

Jump to post
  • Sat Mar 09, 2013 3:18 pm
  • Replies 0
  • Views 136
Duplicate Content - How to solve?

Hello,

I have Opencart 1.5.5.1 with SEO URLS , well, the problem is that I have a lot of products in my site and some categories have two pages and first page is titled as first page ,check this pic


How can I add 'Page 2' in the title? I think it would solve the problem

Thank you very much!

Jump to post
  • Sat Mar 09, 2013 3:09 pm
  • Replies 0
  • Views 126

Page 1 of 1

Search found 18 matches