Ivanio Posted November 19, 2009 Posted November 19, 2009 Hello, i don't know where to post this Topic, so i post it here. No problem if the moderators move it in other place. I have installed different contribs: 1. STS 4.5.8 2. Simple Multiple Images (Unlimited) with Fancy Popups V1.1.5 + OSCThumb 3. RSS Feed v2.2 + RSS Feed v2.2a 5. X-sell v2.6updated 6. Country State selector ajax 1.5.5 + World Zones v2.8 + Limit Countries 2.2 7. Ultimate SEO URLS v2.8 8. Header Tags SEO v3.1.7 9. Sitemap SEO v1.5 10. SEO Assistant v2.2 11. Blacklist v1.1 12. NIF v1.1 13. Admin_level_account_with_categories_2.3.4 14. Anti Robot Registration Validation v3.1.1 15. TIM's Safer Database Input Method + Security Pro v1.0.2 + IP trap v4 + SiteMOnitor v1.9 16. QTPro v4.6.1 The problem is, when i go to edit some product, on the bottom of the product edit page appears an warning: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/27/d222028027/htdocs/testsite1/admin/includes/functions/database.php on line 99 and after it appear a list of products from the same category. I found this issue after installing QTPro, but then i have restored the site to the point 12 (the issue disappeared), then i have restored the site to the point 13 and the issue appears again. So i think the problem is in the instalation of Admin Level Accounts contribution. Anybody knows how to resolve this? thanks Quote
steve_s Posted November 23, 2009 Posted November 23, 2009 Hello, i don't know where to post this Topic, so i post it here. No problem if the moderators move it in other place. I have installed different contribs: 1. STS 4.5.8 2. Simple Multiple Images (Unlimited) with Fancy Popups V1.1.5 + OSCThumb 3. RSS Feed v2.2 + RSS Feed v2.2a 5. X-sell v2.6updated 6. Country State selector ajax 1.5.5 + World Zones v2.8 + Limit Countries 2.2 7. Ultimate SEO URLS v2.8 8. Header Tags SEO v3.1.7 9. Sitemap SEO v1.5 10. SEO Assistant v2.2 11. Blacklist v1.1 12. NIF v1.1 13. Admin_level_account_with_categories_2.3.4 14. Anti Robot Registration Validation v3.1.1 15. TIM's Safer Database Input Method + Security Pro v1.0.2 + IP trap v4 + SiteMOnitor v1.9 16. QTPro v4.6.1 The problem is, when i go to edit some product, on the bottom of the product edit page appears an warning: and after it appear a list of products from the same category. I found this issue after installing QTPro, but then i have restored the site to the point 12 (the issue disappeared), then i have restored the site to the point 13 and the issue appears again. So i think the problem is in the instalation of Admin Level Accounts contribution. Anybody knows how to resolve this? thanks Hi I would suggest pasting code from that file here from lines 95-105 testsite1/admin/includes/functions/database.php Steve Quote
Ivanio Posted December 18, 2009 Author Posted December 18, 2009 Hi I would suggest pasting code from that file here from lines 95-105 testsite1/admin/includes/functions/database.php Steve Hello Steve, here is the code from lines 54-105 : function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') { reset($data); if ($action == 'insert') { $query = 'insert into ' . $table . ' ('; while (list($columns, ) = each($data)) { $query .= $columns . ', '; } $query = substr($query, 0, -2) . ') values ('; reset($data); while (list(, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= 'now(), '; break; case 'null': $query .= 'null, '; break; default: $query .= '\'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ')'; } elseif ($action == 'update') { $query = 'update ' . $table . ' set '; while (list($columns, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= $columns . ' = now(), '; break; case 'null': $query .= $columns .= ' = null, '; break; default: $query .= $columns . ' = \'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ' where ' . $parameters; } return tep_db_query($query, $link); } function tep_db_fetch_array($db_query) { return mysql_fetch_array($db_query, MYSQL_ASSOC); } function tep_db_result($result, $row, $field = '') { return mysql_result($result, $row, $field); } Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.