Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Ausgirl

Members
  • Posts

    922
  • Joined

  • Last visited

Everything posted by Ausgirl

  1. Hello, Yes, Ive updated my site to 060817 every time I try and import the sql I get this lovely message: Error SQL query: ALTER TABLE orders_products ADD products_returned tinyint( 2 ) unsigned default '0'; MySQL said: #1060 - Duplicate column name 'products_returned' :blink: Any ideas as to why? Thanks
  2. [/b]Hello, I had to restore my site. Since doing so I now have this error in admin/catalog/Categories / Products: 1054 - Unknown column 'cd.categories_seo_url' in 'field list' select c.categories_id, cd.categories_name, cd.categories_seo_url, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name [TEP STOP] I think I need to upload the sql changes again. Do I? If so, where do I find the database changes? All I found was this: ALTER TABLE `categories_description` ADD `categories_seo_url` VARCHAR( 100 ) NOT NULL; ALTER TABLE `products_description` ADD `products_seo_url` VARCHAR( 100 ) NOT NULL; But I think that is for updating only. I tried running it & it came up with an error. I did not install this mod I had someone install it for me as it was just a bit to complicated for me. Ive only gotten this error since having my site restored. In my store when you click on a product I get the 404 error message. Simple instructions on how to fix would be appreciated. Thanks [b] Errors fixed now, thanks
  3. Hello, I had to restore my site. Since doing so I now have this error in admin/catalog/Categories / Products: 1054 - Unknown column 'cd.categories_seo_url' in 'field list' select c.categories_id, cd.categories_name, cd.categories_seo_url, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name [TEP STOP] I think I need to upload the sql changes again. Do I? If so, where do I find the database changes? All I found was this: ALTER TABLE `categories_description` ADD `categories_seo_url` VARCHAR( 100 ) NOT NULL ; ALTER TABLE `products_description` ADD `products_seo_url` VARCHAR( 100 ) NOT NULL ; But I think that is for updating only. I tried running it & it came up with an error. I did not install this mod I had someone install it for me as it was just a bit to complicated for me. Ive only gotten this error since having my site restored. In my store when you click on a product I get the 404 error message. Simple instructions on how to fix would be appreciated. Thanks
  4. I got this from another thread here. Try this: In the file admin/includes/classes/split_page_results.php Insert: if ($offset < 0) { $offset = 0 ; } Just before this line: $sql_query .= " limit " . $offset . ", " . $max_rows_per_page; } If you see the errors displayed on your store pages (not in the admin), you might also need to make this change in /includes/classes/split_page_results.php Insert: if ($offset < 0) { $offset = 0 ; } Just before this line: $this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;
  5. Thanks for picking that up Anita. Its all good now, Thank You :)
  6. Nope, That didnt work either. I dont know whats wrong with it. (refering to Jacks last post with a code to change for me)
  7. Yes, thats the one, here is the url of the page the errors pop up on https://www.myshop.com/admin/link_categorie...&action=new so, even though the errors say: Warning: reset() [function.reset]: Passed variable is not an array or object in /home/wwwshop/public_html/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/wwwshop/public_html/admin/includes/classes/object_info.php on line 18 The problem lies here link_categories.php, is that right. Thanks
  8. Stewps here Jack, (No, that's why I was asking you where the problem was at. You would need to note what file you are in at the time of the failure as well as what it is you are doing. The code segment could be determined from there. Jack) I wasnt in any file. I was in Admin, click links Manager then click links catagory then click add catagory button and thats when the errors pop up on the top of the page. Thanks
  9. Hello, I get this error whenever I try and edit a product category: Fatal error: Call to undefined function tep_get_category_seo_url() in /home/wwwshop/public_html/admin/categories.php on line 1060 Any ideas on how to fix? Much appreciated Thanks
  10. Do you know what code that would be? Is it an SQL problem maybe? It doesnt seem to effect the way it works at all. Everything works well. :)
  11. Tried it but it didnt work. Errors are on lines 17 & 18 in here. Warning: reset() [function.reset]: Passed variable is not an array or object in /home/wwwshop/public_html/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/wwwshop/public_html/admin/includes/classes/object_info.php on line 18 This is the file code below: <?php /* $Id: object_info.php,v 1.6 2003/06/20 16:23:08 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ class objectInfo { // class constructor function objectInfo($object_array) { reset($object_array); while (list($key, $value) = each($object_array)) { $this->$key = tep_db_prepare_input($value); } } } ?>
  12. I shall give it a try and do that when my other little problem is fix. Thanks Jack
  13. No, In: Link Categories->New Category (when I click the new category button)
  14. The strangest thing happened. My site monitor errors have disappeared. I didnt even do anything? Strange. If they pop back, I'll post again. Thanks Jack
  15. Its the same, I click on add catagory button and I get those last 2 errors still: Warning: reset() [function.reset]: Passed variable is not an array or object in /home/wwwshop/public_html/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/wwwshop/public_html/admin/includes/classes/object_info.php on line 18 I thought of adding the feature link as a product. Wouldnt you have to set it as a download product (so not to get charged postage)? If the answer to the question was no (for charging) I was going to ask you if you would be able to impliment this in the future but you have already considered this so I dont have to know :) It makes perfect sense.
  16. Might be a silly question but how do I turn the check log size option to off ? Do I uncheck this box? Log File - If this option is checked, the sitemonitor.txt log file will be updated indicating the changes, if any, that were found. Or just put the log file size to 0? Or maybe neither? Thanks
  17. I downloaded site monitor 7 Jan 2007 When I click on update on either of these: Execute Sitemonitor & Delete Reference File, I get this lovely error: Warning: filesize() [function.filesize]: stat failed for sitemonitor_log.txt in /home/wwwshop/public_html/admin/includes/functions/sitemonitor_functions.php on line 59 Warning: opendir(/home/username/public_html) [function.opendir]: failed to open dir: No such file or directory in /home/wwwshop/public_html/admin/includes/functions/sitemonitor_functions.php on line 71 Warning: readdir(): supplied argument is not a valid Directory resource in /home/wwwshop/public_html/admin/includes/functions/sitemonitor_functions.php on line 73 Reference file creation failed. I tried deleting the set_time_limit(0); as stated in install file but it made no difference. I disabled cron jobs, it made no difference. Have I forgotten something some where or could this be a server thing as stated in previous posts? Thanks
  18. Also, I was wondering if its possible to be able to charge listings to display in the featured link section? If so, how would one go about doing that? Thanks
  19. Hey Jack, Ive been over every thread in this post. As far as I can see the fix abouve seemed to fix all three errors for others. (unless I have missed the fix for the last 2) Here is what I did but it hasnt worked (I have no idea where to place the code, Im just guessing) From this: */ class objectInfo { // class constructor function objectInfo($object_array) { reset($object_array); while (list($key, $value) = each($object_array)) { $this->$key = tep_db_prepare_input($value); } } } ?> To this: */ class objectInfo { // class constructor function objectInfo((array)$object_array) { reset((array)$object_array); while (list((array)$key, (array)$value) = each((array)$object_array)) { $this->$key = tep_db_prepare_input((array)$value); } } } ?> I just placed it on one line at a time to try it. ( all I got was errors) I didnt do all of them then save it. I just posted it like this so you can see which lines I added the (array) to. Hope I haven't confused you. Thanks :)
  20. Im still searching...searching...searching :) how or where it was added! So true, I dont know what Im doing, I just give it a go & see what happens. But I'll let you know. Im sure it is there somewhere.
  21. I tried it, I lost Admin & get this lovely error: Fatal error: Only variables can be passed by reference in /home/wwwshop/public_html/admin/includes/classes/object_info.php on line 18 I get the same no matter what line I do it on. Anyway, 3am here, so Ill worry about it later 2day. I'll have another look over the threads. So many people have had the same error so Im sure the fix is there somewhere. If I find it Ill post it so that people dont have to look as far back. Its 1/2 fixed, anyway thanks Jack
  22. This is mine, I changed this: $Icnfo_array = array_merge($link_categories, $links_count); To this: $Icnfo_array = array_merge((array)$link_categories, (array)$links_count); It got rid of the first error, now for the other two. Do I just stick the (array) thing in those files as well? :)
  23. Quite a few people have had this problem, seems that no one has answered and these people have not posted whether or not they found a fix. Maybe they learnt to live with it. However I did find this: QUOTE(peteruittilburg @ Jun 30 2006, 03:04 AM) Also sometimes the errors are: Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/sites/site81/web/adminshop/links.php on line 733 Warning: reset() [function.reset]: Passed variable is not an array or object Mine is different from the one above. But the bottom two are the same. So Im not sure if it will fix my problem. Will it? As my problem is catagories not links. in /home/sites/site81/web/adminshop/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/sites/site81/web/adminshop/includes/classes/object_info.php on line 18 The first error refers to line 235 in admin/links.php: $lInfo_array = array_merge($links, $category); My knowledge of PHP is not that great, but I think it means that arrays $links and $category don�t exist. Looking into this file, I can�t find something like: $links = array(); $category = array(); --------------------------------------------- It might be that there is nothing loading from the database. Find this code around line 733CODE $category = tep_db_fetch_array($categories_query); $lInfo_array = array_merge($links, $category);and change it toCODE $category = tep_db_fetch_array($categories_query); if (tep_db_num_rows($categories_query) < 1) echo ('No database entry found<br>'); $lInfo_array = array_merge($links, $category);Save it and update your browser. Do you get the error displayed? Jack Then he came back with this answer: peteruittilburgJun 30 2006, 10:59 PM QUOTE(Jack_mcs @ Jun 30 2006, 01:27 PM) Save it and update your browser. Do you get the error displayed? Jack Hi Jack, Please see my posting 508. It is an PHP4 versus PHP4 problem How does one find this? My eyes hurt, Ive probably blinked and missed it. Thanks
×
×
  • Create New...