Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 Mark, all of my code in both of those files is exactly the same as you have listed. I also tried uploading an old categories.php file from backup and that didn't do anything. I wonder if I should just go back through everything again...not sure if there is anything else that I can do... Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 I just went through everything that I initially did and did it again and it still hasn't fixed the problem. :blink: Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted January 26, 2010 Share Posted January 26, 2010 when was the last time it worked correctly, or has it ever? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 when was the last time it worked correctly, or has it ever? Last time it worked correctly was before I transferred everything over to a new host... Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted January 26, 2010 Share Posted January 26, 2010 Last time it worked correctly was before I transferred everything over to a new host... The only thing I can imagine is that the new host has the products_description table, products_description field set for that amount of characters, but if you can put them there with phpMyAdmin then that would disprove the theory. I'm at a loss... Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 The only thing I can imagine is that the new host has the products_description table, products_description field set for that amount of characters, but if you can put them there with phpMyAdmin then that would disprove the theory. I'm at a loss... Yeah, I am at a loss too. I really appreciate your help though Mark. Is there anyone else who is able to help? Does anyone know where I could get paid help from? Not sure that will be any better, but I am willing to try anything now. What if I just enter all of the product descriptions in through phpMyAdmin? Does anyone know the code I would use to get a (') or a (") in phpMyAdmin? I mean, at least that was working... Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted January 26, 2010 Share Posted January 26, 2010 In phpMyAdmin go ahead and use all the quotes you want. I use a lot of double quotes. I can't remember using any single quotes but I am pretty sure phpMyAdmin will handle them correctly. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 In phpMyAdmin go ahead and use all the quotes you want. I use a lot of double quotes. I can't remember using any single quotes but I am pretty sure phpMyAdmin will handle them correctly. Well, they look great in the phpMyAdmin, but when I go to my store, double quotes look like this: “ and single quotes look like this: ’ Is there a way to fix this in phpMyAdmin? Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted January 26, 2010 Share Posted January 26, 2010 Well, they look great in the phpMyAdmin, but when I go to my store, double quotes look like this: “ and single quotes look like this: ’ Is there a way to fix this in phpMyAdmin? No, that is likely caused by the same problem that is keeping you from entering your descriptions. Have you looked into the possibility that your new server has a much different version of php or mysql that is causing the problem? My double quotes show normal in the db when viewed with phpMyAdmin and print out normally in the product descriptions. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 The only thing else that I could think of that may have caused a problem was using Easy Populate. I had to use it to reinstall all of my product information when I transferred the store from the old host to the new one. I looked at the Easy Populate file and it has the full description for each product. Could there of possibly of been an error involved in this though? Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted January 26, 2010 Share Posted January 26, 2010 The only thing else that I could think of that may have caused a problem was using Easy Populate. I had to use it to reinstall all of my product information when I transferred the store from the old host to the new one. I looked at the Easy Populate file and it has the full description for each product. Could there of possibly of been an error involved in this though? I considered using Easy Populate but never did because of several factors. One of which was the handling of multiple mixed quotes within descriptions. I ended up writing a custom program to transfer the data using tabbed delimited files and not csv. I just think that Excel jacks around with the data too much and it is much cleaner in a flat text file. Not that this helps with your problem. Sorry Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 No, that is likely caused by the same problem that is keeping you from entering your descriptions. Have you looked into the possibility that your new server has a much different version of php or mysql that is causing the problem? The old host uses 5.1.42 and the new host uses 5.0.45 Does this make a big difference? Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted January 26, 2010 Share Posted January 26, 2010 The old host uses 5.1.42 and the new host uses 5.0.45 Does this make a big difference? I can't say Kerri, you will have to rely on someone with that area of experience. Hopefully someone will answer... Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 I can't say Kerri, you will have to rely on someone with that area of experience. Hopefully someone will answer... Which version do you use, where there are no problems with quotation marks? If someone could just tell me how to fix that, I would be able to use my store at least... Link to comment Share on other sites More sharing options...
Guest Posted January 26, 2010 Share Posted January 26, 2010 Yes, when I click on the "Preview" button, all of the text is there. Something happens between there and when I press the "Update" button. Most of it just disappears. I am really baffled by it... :( If the full description is on the preview then the problem is probably with the hidden field. Around line 700 or so of admin/categories.php look for echo tep_draw_hidden_field('products_description[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_description[$languages[$i]['id']]))); That is how it should be. Link to comment Share on other sites More sharing options...
Kerrigan Posted January 26, 2010 Author Share Posted January 26, 2010 If the full description is on the preview then the problem is probably with the hidden field. Around line 700 or so of admin/categories.php look for echo tep_draw_hidden_field('products_description[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_description[$languages[$i]['id']]))); That is how it should be. That's exactly the way it is Brian... Link to comment Share on other sites More sharing options...
Kerrigan Posted January 27, 2010 Author Share Posted January 27, 2010 That's exactly the way it is Brian... Is anyone at all able to help?? :( Link to comment Share on other sites More sharing options...
♥kymation Posted January 27, 2010 Share Posted January 27, 2010 The problem with quotes in the database points to a collation problem. Using phpMyAdmin, look at the structure of the products_description table. What collation is used? Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
Kerrigan Posted January 27, 2010 Author Share Posted January 27, 2010 Looks like this guy had a similar problem and never got an answer: http://www.oscommerce.com/forums/topic/350790-products-description-max-letters-allowed/page__p__1467565__hl__product%20description%20length__fromsearch__1entry1467565 I wonder if it has anything to do with the free template that I am using... Link to comment Share on other sites More sharing options...
Kerrigan Posted January 27, 2010 Author Share Posted January 27, 2010 The problem with quotes in the database points to a collation problem. Using phpMyAdmin, look at the structure of the products_description table. What collation is used? Regards Jim Hey Jim! Thanks so much for replying. I was wondering if that had something to do with it. The collation is set at: utf8_general_ci What should I change it to? Link to comment Share on other sites More sharing options...
♥kymation Posted January 27, 2010 Share Posted January 27, 2010 Look in admin/includes/languages/english.php (or whatever language you are using in your admin.) You should have a line something like this: define('CHARSET', 'iso-8859-1'); You need to match the type specified in there or there will be trouble. If it's the same as I have shown, try one of the latin1 collations in the database (latin1-general-ci will probably work). If it's different, you will need to figure out the matching collation. Once you have that changed, try entering a long description (with quotes) in the admin and see what happens. Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
Kerrigan Posted January 27, 2010 Author Share Posted January 27, 2010 Look in admin/includes/languages/english.php (or whatever language you are using in your admin.) You should have a line something like this: define('CHARSET', 'iso-8859-1'); You need to match the type specified in there or there will be trouble. If it's the same as I have shown, try one of the latin1 collations in the database (latin1-general-ci will probably work). If it's different, you will need to figure out the matching collation. Once you have that changed, try entering a long description (with quotes) in the admin and see what happens. Regards Jim My code in the admin/includes/languages/english.php is exactly like you have it above. I went in to the phpMyAdmin and changed it to the latin1-general-ci, put in the full code (with quotations) and they still came out looking weird in the store: “ †’ Before you go away Jim, I have some other questions for you regarding your review email contribution. I'm not quite sure how to "run the request_review.sql file in your database management program's SQL box, or run the lines in that file in the SQL command line" as you said in the readme file. I have done everything else, but don't know how to do that. That really is a nice idea... Link to comment Share on other sites More sharing options...
♥kymation Posted January 27, 2010 Share Posted January 27, 2010 You should have a similar line in catalog/includes/languages/english.php. Check that it is the same. Also, if you are using a template, those sometimes change the encoding in a different place, sometimes buried in the HTML. So check that by using view > source in your browser. You should have a line that looks like this: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> I hadn't planned on giving up yet. This is an interesting problem that I'd like to solve. In phpMyAdmin, click on the Import button, browse to your copy of request_review.sql, then click go. That's all it takes. Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
Kerrigan Posted January 27, 2010 Author Share Posted January 27, 2010 You should have a similar line in catalog/includes/languages/english.php. Check that it is the same. Also, if you are using a template, those sometimes change the encoding in a different place, sometimes buried in the HTML. So check that by using view > source in your browser. You should have a line that looks like this: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> I hadn't planned on giving up yet. This is an interesting problem that I'd like to solve. In phpMyAdmin, click on the Import button, browse to your copy of request_review.sql, then click go. That's all it takes. Regards Jim Thanks for not giving up Jim. The catalog/includes/languages/english.php is correct, as is the html code. In regards to the importing of the request_review.sql, here's the error I got: Error SQL query: ALTER `orders` ADD `reminder_sent` tinyint( 1 ) NOT NULL default '0' AFTER `orders_status` MySQL said: #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 '`orders` ADD `reminder_sent` tinyint(1) NOT NULL default '0' AFTER `orders_statu' at line 1 Sorry to have you working on two things at once. :-" Thanks! Link to comment Share on other sites More sharing options...
♥kymation Posted January 27, 2010 Share Posted January 27, 2010 The easy one first. There's another way to add that column to the orders table. Open that table in phpMyAdmin. Under the listing, where it says Add 1 field(s)...., click Go. Enter reminder_sent as the Field, tinyint as the Type, 1 for Length/Values, and 0 for the Default. That should fix that line. Now you'll need to open that SQL file and copy everything after the line that was giving the error and paste it into a SQL box in phpMyAdmin. Hopefully it won't give you any further errors. Your first problem is looking odder by the minute. The strange characters you are seeing are typical of an encoding mismatch. That happens when you are using (for example) UTF-8, but telling the web browser to show it as 8859-1. I'm somewhat puzzled that this doesn't seem to be the case here. Is your admin/categories.php stock or has it been modified? Is it possible to put up a copy of the stock version for testing? Don't forget to backup the modified version before you do this. If the stock version will run, try adding a long description using that version. Regards Jim See my profile for a list of my addons and ways to get support. 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.