Search found 60 matches

Search found 60 matches

Re: PHP / MySQL error with new fields

Perfect! Thank you very much for the help!

Jump to post
  • Thu Jul 12, 2012 6:43 pm
  • Replies 11
  • Views 737
Re: PHP / MySQL error with new fields

admin/model/catalog/product.php (the addition and update query) $this->db->query("DELETE FROM " . DB_PREFIX . "product_morelinks WHERE product_id = '" . (int)$product_id . "'"); $data['product_morelinks'] = array($data['product_morelinks']); foreach ($data['product_morelinks'] as $value) { $this->db...

Jump to post
  • Thu Jul 12, 2012 3:11 pm
  • Replies 11
  • Views 737
Re: PHP / MySQL error with new fields

Primary keys must be unique so you need to drop it from product_id. Done. I realised that the sql statement wasn't saying the data must be inserted into the array. I've fixed it so that can now add the fields, aand pull them back, but I'm still getting one last error. If a product doesn't have a ro...

Jump to post
  • Thu Jul 12, 2012 6:41 am
  • Replies 11
  • Views 737
Re: PHP / MySQL error with new fields

I'm still not getting any love from this error :(

Jump to post
  • Wed Jul 11, 2012 10:02 pm
  • Replies 11
  • Views 737
Re: PHP / MySQL error with new fields

Done. Tried it now, but it's still giving the same error: Notice: Error: Duplicate entry '42' for key 'PRIMARY' Error No: 1062 INSERT INTO product_morelinks SET product_id = '42', link1 = '1', link2 = '1' in C:\xampp\htdocs\site\system\database\mysql.php on line 49 EDIT: I also deleted that entry fr...

Jump to post
  • Tue Jul 10, 2012 6:48 pm
  • Replies 11
  • Views 737
Re: PHP / MySQL error with new fields

qahar wrote:Just wondering, where is the morelinks_id ?
Why would it need that when it's based on referencing the product id?

Jump to post
  • Tue Jul 10, 2012 5:22 pm
  • Replies 11
  • Views 737
PHP / MySQL error with new fields [SOLVED]

OC version: 1.5.1.3 I've created a new table in the database, which will hold some additional info on products. It's 95% there, but something is still wrong. I can pull from the database, but I cannot write to it. The problem seems to be with my statement in model, but I'm not 100% sure. admin/model...

Jump to post
  • Tue Jul 10, 2012 4:10 pm
  • Replies 11
  • Views 737
Re: The best search system?

So there's no search system for OpenCart that can do this?

Jump to post
  • Mon Jun 25, 2012 7:42 pm
  • Replies 2
  • Views 561
The best search system?

I've found that OpenCart's current search system doesn't scale well, and can give A LOT of inaccurate results. What I'm looking for is a search system that does the following: Easily scalable as I use well over 6000 products Searches tags Searches heading Searches module DOES NOT SEARCH DESCRIPTION ...

Jump to post
  • Mon Jun 18, 2012 7:13 pm
  • Replies 2
  • Views 561
Re: Easier image uploader?

Thanks for the suggestion, Merry, but I've gone that route before. While it works for general info, it's not really suitable for images.

Jump to post
  • Mon Jun 18, 2012 7:09 pm
  • Replies 5
  • Views 1118
Re: Easier image uploader?

Thanks for the suggestion. I tried it out now, but it's just not what I need.

Jump to post
  • Wed Jun 13, 2012 5:20 am
  • Replies 5
  • Views 1118
Easier image uploader?

Is there a way to have an easier image uploader? I'm managing a site with over 5000 products. Every time I upload a main image, or additional images, I need to: 1. Open manager 2. Click on correct folder 3. Click upload 4. Find image, and upload 5. Have the image manager refresh, and sometimes reloa...

Jump to post
  • Wed Jun 13, 2012 3:55 am
  • Replies 5
  • Views 1118
Re: Showing list price

florinsith wrote:You could use specials. Use the normal price in oc for list price , and then add a special special price (your price).
I thought about it, but would prefer not to. Our prices are dependent on the exchange rate, so they're always changing and bulk updating specials is a pain.

Jump to post
  • Sat Jun 02, 2012 2:07 am
  • Replies 2
  • Views 464
Showing list price

For OpenCart 1.5.1.3+, is it possible to show the list price for a product?

For example:
List price (crossed out)
Our price (which is actually the normal price in OC)

Jump to post
  • Fri Jun 01, 2012 1:10 am
  • Replies 2
  • Views 464
Re: [MOD] Apsona ShopAdmin - import, export and reporting

Is there any indication as to when Apsona will be updated with new features, and to work with OpenCart 1.5.2+? This is the only thing stopping me from upgrading to 1.5.3.1.

Jump to post
  • Mon May 28, 2012 6:01 am
  • Replies 165
  • Views 72932
An uber supplier / vendor extension?

I've been looking through some of the vendor/supplier extensions, but nothing seems to come close to what I actually need. Let me explain (all of these tie together): Supplier system You'll be able to add in new supplier information, such as: *Supplier name *Account code with supplier *Sales e-mail ...

Jump to post
  • Sun May 27, 2012 7:27 pm
  • Replies 0
  • Views 426
Multi-store sharing a cart

Is there a way to link the cart, and wishlist, of a multi-store store? I saw one user offering a sort of service, but at 120 pounds...which is a lot. For anyone that doesn't know, let me explain: If you have a store on sub-domain 1, and 2, their carts aren't shared at all. This should allow you to s...

Jump to post
  • Sun May 27, 2012 5:19 am
  • Replies 1
  • Views 320
More intelligent wishlist?

OC version: 1.5.1.3 Is it possible to have a more intelligent Wishlist system for OpenCart? At present it's just a holding area for products. What I'd actually like it to do is the following: 1. notify the customer about price drops 2. notify the customer if an item is on sale 3. notify the customer...

Jump to post
  • Sun May 27, 2012 5:14 am
  • Replies 0
  • Views 235
More newsletters and Mailchimp?

Is it possible to have more than 1 newsletters subscription, and then syncing these to mailchimp? At present, from what I can see, OC allows for 1 general newsletter. What I'd like to do is offer multiple options, such as: *General *Games *Electronics *Food The customer will then be able to subscrib...

Jump to post
  • Sun May 27, 2012 5:12 am
  • Replies 3
  • Views 735

Search found 60 matches