Post by mikell » Wed Apr 22, 2015 1:39 am

Salut comunitatea OC!

am nevoie sa modific preturile , asffel incat sa fie crescute toate cu 5%. Eu am facut direct din bd. astfel

Code: Select all

$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = 'price*(5/100+1)'WHERE product_id = '" . (int)$product_id . "'");

dar am o eroare..

unde gresesc :(

Active Member

Posts

Joined
Sun Sep 01, 2013 4:37 pm

Post by opencartromania » Wed Apr 22, 2015 2:45 am

Salutare!

Gresit calculul ptr. procent.

incearca asta, ptr. un produs anume

Code: Select all

$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price+(price*.05) WHERE product_id = '" . (int)$product_id . "'");
pentru toate:

Code: Select all

$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price+(price*.05)");
sau

Code: Select all

$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price*1.05 WHERE product_id = '" . (int)$product_id . "'");

Code: Select all

$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price*1.05");
Succes!

User avatar
Active Member

Posts

Joined
Wed Sep 25, 2013 9:26 pm


Post by mikell » Wed Apr 22, 2015 3:36 am

Salut OpenCartRomania!
Multumesc.
Am incercat oricare din modalitati sugerte si am o eroare asemanatoare:

Code: Select all

Eroare

Pare sa fie o eroare in comanda SQL. Eroarea MySQL de mai jos, daca e vreuna, poate sa te ajute la diagnosticarea problemei.

ERROR: Înșiruire de punctuație necunoscută @ 6
STR: ->
SQL: $this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price+(price*.05)")


SQL query:

$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price+(price*.05)")

MySQL zice: Documentație
#1064 - 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 '$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price+(price*.05' at line 1 
pt

Code: Select all

$this->db->query("UPDATE `" . DB_PREFIX . "product` SET price = price+(price*.05)");

Active Member

Posts

Joined
Sun Sep 01, 2013 4:37 pm

Post by opencartromania » Wed Apr 22, 2015 4:24 am

Salutare...

Nu ai fost deloc explicit!

Codul trimis nu este ptr. phpmyadmin ci ptr. a fi apelat din model.

Ptr. phpmyadmin:

Code: Select all

UPDATE `prefix_product` SET price = price*1.05
Unde prefix = prefix tabela... (doar daca ai prefix, daca nu:)

Code: Select all

UPDATE `product` SET price = price*1.05
Succes!
ps: sfat personal: fa un back-ul in prealabil la baze, tabele sunt operatii oarecum riscante... (mai mult, problema a mai fost discutata de cateva ori pana acum...)

User avatar
Active Member

Posts

Joined
Wed Sep 25, 2013 9:26 pm


Post by mikell » Thu Apr 23, 2015 12:57 am

multumesc OpencartRomania!
sper sa functioneze!
o sa incerc acum

Active Member

Posts

Joined
Sun Sep 01, 2013 4:37 pm
Who is online

Users browsing this forum: No registered users and 4 guests