Ro-Che Posted August 24, 2006 Share Posted August 24, 2006 www.film-time.com I have just got my oscommerce shop and would like to make some small changes and enhancements. Any help would be great and thanks in advance. I am currently inputting my stock (only about 1,000 or so to go!) that part seem to be going fine. I did touch 1 or 2 things that I should not have ! Which was the specails (specails button) this was meant for my offers of reduced goods? This is what now comes up:- 1064 - 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 '-9, 9' at line 1 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 s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9 ------------------------------------------------------------------------------------------------- Could any one tell how and is it easy because I just want to mess my site up to change the grey areas to a dark blue. Also the top part of the site where it says - film-time.com / Time for a film - how hard would it be to put a banner I think it's called along the top. Another one quite a bit of my stock I want to sell for ?2 each or 3 for ?5 - how could this be add up and is it hard. Last one - the part where it says "Your no1 source for great movies online! Congratulations you have just found the internets leading supplier of DVD and VHS movies. We offer competitive prices on superb entertainment products that you wont find elsewhere" Where do I change this to the text I want. ------------------------------------------------------------------------------------------ Yes sorry I did say last one just thought of the other one sorry - the stock I have I would like people to see how many I have in stock. ****************************************************************** Thanks alot in advance J www.film-time.com Link to comment Share on other sites More sharing options...
tkeats Posted August 24, 2006 Share Posted August 24, 2006 I did touch 1 or 2 things that I should not have ! Which was the specails (specails button) this was meant for my offers of reduced goods? Specials IS for products on sale... This is what now comes up:- 1064 - 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 '-9, 9' at line 1 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 s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9 Without knowing what you changed I can not say. However before each change you should backup both the files and the database. That being said, if you can recall what you changed, change it back and it should work. Could any one tell how and is it easy because I just want to mess my site up to change the grey areas to a dark blue. For changing look n feel like font color/size/face and table colours see the file stylesheet.css and make changes slowly until you understand what each one does. (Yes, it can be tiresome, however its better then not being able to fix something later, and yes, BACK IT UP) Also the top part of the site where it says - film-time.com / Time for a film - how hard would it be to put a banner I think it's called along the top. Yes, this is possible. Read the documentation from the download page, or if your stubborn and don't want to read... (slaps his hands to be nice) Look for a file called oscommerce.gif, this is your 'banner' or 'logo' at the top. You should however find the file that loads it and change the actual name of the file. (no, its not hard but I am not going to hand all the answers on a silver platter) Another one quite a bit of my stock I want to sell for ?2 each or 3 for ?5 - how could this be add up and is it hard. See the contributions section, or play with the attributes section (you can buy one, or add 2 more for $x) although the attributes doesnt allow for easy inclusion of additional products, you would have to add each one into a drop down. (potentially adding each product to the attributes section 2 or 3 more times.. which is a little easier then inputing more into the product tables. Or simply offer packages of 3, you can always change the packages if they don't sell, or have them email you if they want a specific combination, then add it as its unique product (ie 3 john wayn movies, or 3 Star Wars movies) Last one - the part where it says "Your no1 source for great movies online! Congratulations you have just found the internets leading supplier of DVD and VHS movies. We offer competitive prices on superb entertainment products that you wont find elsewhere" Where do I change this to the text I want. Huh? where do you want this added? you're not very clear on this... Yes sorry I did say last one just thought of the other one sorry - the stock I have I would like people to see how many I have in stock. You HAVE gone through the admin section carefully, have you not? Again, I encourage you to visit the osCommerce wiki, the knowledgebase and download the codumentation (sic) in the area that you originally downloaded the files (see downloads) Oh, and good luck. Thomas A signature is something that reflects its user. - The dictionary The question is not, 'to code, or not to code' the question is, 'if we do not code, are we really alive?' -- anonymous Link to comment Share on other sites More sharing options...
mariavargas Posted August 24, 2006 Share Posted August 24, 2006 Bummer, bummer :o That happened to me and no one responded to me, so I had to re-install into a new directory and copy all of my previous files to the new one and don't copy the configure.php file. I'm sure there's a correct way to do this, but as I said, no one came to my aid. I did get one tip, that was to export each table in your mySQLadmin for later importing, which again, I got unclear advise on how to do and when I asked for more explanation, was ignored. The problem is that when you deleted the specials, you have to leave at least one product, add your own, then delete the last one! Because when you delete them all, it gets removed completely from the database. :blush: Good Luck! MV www.film-time.com I have just got my oscommerce shop and would like to make some small changes and enhancements. Any help would be great and thanks in advance. I am currently inputting my stock (only about 1,000 or so to go!) that part seem to be going fine. I did touch 1 or 2 things that I should not have ! Which was the specails (specails button) this was meant for my offers of reduced goods? This is what now comes up:- 1064 - 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 '-9, 9' at line 1 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 s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9 ------------------------------------------------------------------------------------------------- Could any one tell how and is it easy because I just want to mess my site up to change the grey areas to a dark blue. Also the top part of the site where it says - film-time.com / Time for a film - how hard would it be to put a banner I think it's called along the top. Another one quite a bit of my stock I want to sell for ?2 each or 3 for ?5 - how could this be add up and is it hard. Last one - the part where it says "Your no1 source for great movies online! Congratulations you have just found the internets leading supplier of DVD and VHS movies. We offer competitive prices on superb entertainment products that you wont find elsewhere" Where do I change this to the text I want. ------------------------------------------------------------------------------------------ Yes sorry I did say last one just thought of the other one sorry - the stock I have I would like people to see how many I have in stock. ****************************************************************** Thanks alot in advance J www.film-time.com Link to comment Share on other sites More sharing options...
tkeats Posted August 24, 2006 Share Posted August 24, 2006 Strange, I often run with no specials.. and don't have any problems.. Do you mean the whole table is removed? :boggles-the-mind: Thomas A signature is something that reflects its user. - The dictionary The question is not, 'to code, or not to code' the question is, 'if we do not code, are we really alive?' -- anonymous Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.