Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Richard Bailey

Archived
  • Posts

    95
  • Joined

  • Last visited

Posts posted by Richard Bailey

  1. I managed to frig the above but now get:

     

    Warning: main(includes/functions/downloads_controller.php) [function.main]: failed to open stream: No such file or directory in /var/www/html/includes/functions/general.php on line 1345
    
    Warning: main(includes/functions/downloads_controller.php) [function.main]: failed to open stream: No such file or directory in /var/www/html/includes/functions/general.php on line 1345
    
    Fatal error: main() [function.require]: Failed opening required 'includes/functions/downloads_controller.php' (include_path='.:/php/includes:/usr/share/php:/usr/share/pear') in /var/www/html/includes/functions/general.php on line 1345

  2. This is just what I have been looking for, for years!!!

     

    Thank you!!

     

    When I run:

     

    CODE

    UPDATE `orders` SET `reminder_sent` = `1`

     

     

    I get:

     

    CODE

    SQL query:

     

    UPDATE `orders` SET `reminder_sent` = `1`

     

    MySQL said: Documentation

    #1054 - Unknown column '1' in 'field list'

     

     

    Any ideas?

     

    Rich

  3. I hope this inappropriate but I see synergies between this proposed contribution and ?RecoverCartSales?.

     

    What I propose (I am not a coder unfortunately) is an interface similar to that of unsold carts, but which emails successful customer with a personalised request for feedback/ request for product review in the hope of drawing the customer back in for repeat purchases/ to create review content and SE feed?.

     

    What do you think? would this be an easy adaptation/ addition of the RecoverCartSales code base?

     

    To the creators and support team!!! ?RecoverCartSales? is the best of the best!!! Brilliant!!!

     

    Rich

  4. I hope this inappropriate but I see synergies between this proposed contribution and ?unsold Carts?.

     

    What I propose (I am not a coder unfortunately) is an interface similar to that of unsold carts, but which emails successful customer with a personalised request for feedback/ request for product review in the hope of drawing the customer back in for repeat purchases/ to create review content and SE feed?.

     

    What do you think? would this be an easy adaptation/ addition of the unsold cards code base?

     

    To the creators and support team!!! ?Unsold Carts? is the best of the best!!! Brilliant!!!

     

    Rich

  5. Hi guys - been using SPAW with my OSC for about a year now it rocks... however my main prob is with the customer order comments...

     

    Right now they are being written using SPAW but when the customer logs into the site the HTML is not shown...

     

    Im sure its simple but I guess what I need to do is either switch off SPAW for the ORder updates or switch on HTML for the customer site coments.... does anyone know how to do either?

     

    Cheers in advance!!

     

    RIch

  6. Hi guys,

     

    Had been using the old non Geko compatible SPAW for a while... so now trying 2 upgrade for Firefox ;)

     

    Followed the install as carefully as possible but get this error whenever I try and visit /admin/

     

     

    Fatal error: Cannot redeclare class spaw_util in /var/www/html/spaw/class/util.class.php on line 16

     

    Line 16 is

     

    16 {

    17 // checks browser compatibility with the control

    18 function checkBrowser()

    19 {

     

    Anyone got any ideas?!

     

    Rich

  7. Im trying 2 install this great looking cont into CRE Loaded but get the following error:

     

    1054 - Unknown column 'o.orders_prefix' in 'field list'

     

    select o.orders_id,o.orders_prefix,h.comments,MIN(h.date_added) from orders o, orders_status_history h where o.orders_id in (1,2) and h.orders_id = o.orders_id and o.orders_status = 1 group by o.orders_id

     

    Does this mean my database structure dosnt match...

     

    Rich

  8. Great contribution!!!!

     

    Quick question really, regarding the key word density what is "Partial total" and when you say a recomended KD is around 6% is this inc or ex "Partial total" and "meta tags"?

     

    Only I guess this makes a pretty large difference!

     

    Thanks again!!!

     

    Rich

  9. infact to look at it the culprit appears to be the term "features" its all of my descriptions with this phrase in it which are screwed...

     

    the html is:

     

    </div>
     <div class="SubCategory">
    	 Features and benefits</div>
     <div class="ProductDescription">
    	 <ul>
       <li>Revolutionary Drawing Organization Features </li>

  10. GREAT CONTRIB!!!!

     

    One small problem I am finding is there appears to be tabs present in my product descriptions. If I try importing the tabbed file using excel after a few products they are out of sync....

     

    I know google supports other delimitations such as "Tilde (~)" is it possible to get the feeder to use one of these as they are less likely to be contained with my descriptions...

     

    Chrs & thanks again!

     

    Rich

  11. Hi all !

     

    I just tried 2 install this contribution ontop of the Loaded OSc www.phesis.co.uk.

     

    So i go all the way through making the changes, everything hunkey dorey. Everything is all saved up I check the listing - as u would expect everything is just as it as before I started, as I havnt run the sql queries yet. However I guess it indicates i havnt made 2 many typos in the hack.

     

    Then I run the sql queries and get:

     

    1064 - You have an error in your SQL syntax near '.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(' at line 1

     

    select p.products_image, pd.products_name, p.products_model, m.manufacturers_name, pd.products_description p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '23' order by p.products_model , pd.products_name limit 0, 10

     

    [TEP STOP]

     

    Does anyone have any idea what is going wrong here... was it 2 tall an order 2 try and get it 2 work with loaded?

     

    Cheers

     

    Rich

×
×
  • Create New...