Jump to content

envy2000

Members
  • Content count

    98
  • Joined

  • Last visited

Posts posted by envy2000


  1. Help please.. i am getting this echo from the specials block

     

    1054 - Unknown column 's.customers_group_id' in 'where clause'

     

    select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' and s.customers_group_id=2 order by s.specials_date_added desc limit 10

     

    everything else seems to be working great. thanks!


  2. hey there i have several products that i would like to feature as attributes throughout the catalog. ex

     

    i have a bunch of fishing rods, i want a 3 lures, and 3 reels to be used for all rods. i don't mind adding them in, but if i want to change the price of a lure it would be a real pain to go through 100+ rods and change the price.

     

    does this make sense?

     

    is there a contribution out there like this?


  3. thanks for the contrib.

     

    Did i do something wrong? I have 2 bugs:

     

    1)

    When i click on a new order and [shipping] it's empty under the

     

    Qty Shipped > Cost > Producst row

    when i hit refresh the items in the order appears..

     

    2)

    I have 2 items. i change the qty of one item to 0 but the invoice total doesn't change. is this a bug? should it be lower now?

     

    Thanks for your help


  4. anyone?

    >i had the affiliate working great, but now when i create an account at >affiliate_signup.php i get redirected to another blank affiliate_signup.php >page. no message, and no account created. anyone have any ideas?

     

    i found this only happens when i am not logged in as a customer. do you have to create a customer account and log into it first?

     

    you can check it out here. www.paintballgear.ca/catalog


  5. hello all,

     

    i had the affiliate working great, but now when i create an account at affiliate_signup.php i get redirected to another blank affiliate_signup.php page. no message, and no account created. anyone have any ideas?

     

    thanks for the great module.

     

    sorry that last one copied weird.


  6. anyone?

     

    >i had the affiliate working great, but now when i create an account at >affiliate_signup.php i get redirected to another blank affiliate_signup.php >page. no message, and no account created. anyone have any ideas?

     

    we were going to annouce the affiliate program today. :(


  7. hello all,

     

    i had the affiliate working great, but now when i create an account at affiliate_signup.php i get redirected to another blank affiliate_signup.php page. no message, and no account created. anyone have any ideas?

     

    thanks for the great module.


  8. elari,

     

    any ideas?

     

    SQL-query :

     

    INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0)

     

    MySQL said:

     

     

    Duplicate entry '1-1' for key 1

     

     

     

    1054 - Unknown column 'date_finished' in 'field list'

     

    select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified, customers_fax, customers_ip_order, customers_ip_order_host, customers_ip_confirm, customers_ip_confirm_host, customers_status, customers_status_name, customers_status_image, customers_status_discount, date_finished, orders_status_closed, orders_status_need_conf, orders_status_need_conf_password from orders where orders_id = '100'

     

     

     

    here's the table...

     

    Field Type Attributes Null Default Extra Action

    customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext

    language_id int(11) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext

    customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext

    customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext

    customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

    customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext

    customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

    customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext

    customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext


  9. thanks for the help. i went to install the sql you provided through phpmyadmin and got this

     

    Error

     

    SQL-query :

     

    INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0)

     

    MySQL said:

     

     

    Duplicate entry '1-1' for key 1

     

    here's the table...

     

    Field Type Attributes Null Default Extra Action

    customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext

    language_id int(11) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext

    customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext

    customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext

    customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

    customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext

    customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

    customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext

    customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext

    customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext

     

     

     

    --------

     

    You are right nobody forced me to use it. i just wanted to warn people of limited experience not to try installing this.

     

     

    yes this is why all osc files are in a separate osc_files that MUST be compared to the file you have.

    most change made are indicated in files

     

    most contributions that i have seen provide just the code changes, not the full install files. this may confuse people. i have never seen the DOS cont before, so i was not sure if it is a part of this or not. I think that it's not a bad way to do it, it was really easy with Beyond Compare, but i think the challenge for people comes when the aren't sure if it is another contribution or this one.

     

    Basically i think OSC needs a module install application like postnuke. it's slick. :)

     

    thanks for your help.

     

    Ryan


  10. fatal error fixed. application_top_elari_cs.php must be after general.php include in application_top.php

     

    now i am getting this when i check out orders.

     

    1054 - Unknown column 'orders_status_need_conf' in 'field list'

     

    select orders_status_id, orders_status_name, orders_status_need_conf, orders_status_need_conf_id, orders_status_final from orders_status where language_id = '1'

     

    [TEP STOP]

     

     

    People, i would not recommend installing this. It looks great, and i don't mean to slag a free contribution that someone has worked hard on, but... there is no seperation between this contribution and other contributions, so you either have to install all the contributions that elari has used, or go through and remove all references to them. This is tough, because it's not documented what code belongs to what contribution. is the above error for customer_status, or from one of these that have been included:

     

    - helpdesk 1.0 (snowman)

    - Product Listing Hack v.2 (Paul Crovella / John Poynton)

    - quantity displayed if allowed (elari)

    - cod customer confirmation (elari)

    - staffelpreise (jurgen)

    - support ticket from Dave

    - all product printable catalog 1.5

    - easy populate

    - Advanced multilanguage guestbook (elari)

    - Gsm logo and ringtones

    - Easy news 1.1

    - Faq System

    - list order content in admin

    - login box / my account modified elari for support ticket

    and some other i forgot...

     

    CAUTION!!!


  11. elari, i have installed the 2&3x sql and am trying to insert this, but i get this error...

     

     

    Error

     

    SQL-query :

     

    INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0)

     

    MySQL said:

     

     

    Unknown column 'customers_status_price_level' in 'field list'

     

    Back


  12. michelle,

     

    found the problem, i am such a dork. it wasn't the date, -1 for testing purposes works fine. you actually have to send it first though. doh! thanks.

     

     

    i seem to be having one more problem from the affiliate side. i get logged out when i am logged in as an affiliate and click build link, or go to send a message. i am using the auto login module. would that affect this?

     

    Thanks for all your help

     

    Ryan

×