User login

ECommerce 3 upgrade, still in 4.7 errors

Annoying.

warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/agaric_example/public_html/auction2007/includes/database.mysql.inc on line 345.
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/zingspac/public_html/auction2007/includes/database.mysql.inc on line 345.
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/agaric_example/public_html/auction2007/includes/database.mysql.inc on line 345.
user warning: 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 'ASC LIMIT 0, 5' at line 1 query: SELECT node.nid, price, node.title AS node_title, node.changed AS node_changed, ec_product.price AS ec_product_price FROM dru_node node LEFT JOIN dru_term_node term_node ON node.nid = term_node.nid LEFT JOIN dru_term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (node.status = '1') AND (node.type IN ('product')) AND (term_node.tid IN ('5','10','6','8','12','11','7','13','9')) AND (UPPER(node.title) NOT LIKE UPPER('%LIVE AUCTION ONLY%')) ORDER BY ASC LIMIT 0, 5 in /home/agaric_example/public_html/auction2007/includes/database.mysql.inc on line 121.

That was fixed (at least that last problem) by enabling the ec_views module, which must have gotten split out from some other module in the later version of e-commerce for 4.7.

I also got Server Error 500 and blank screens at various points. Everything was resolved in the end, to produce another release of the hacked up zing auction.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.