Product Description Cut Off

[Kerrigan]

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

 

 

Thanks for the quick fix on your contribution. Can't wait to see that put into practice. I'm not sure that "odd" is the word for it. I don't know what is going on. I tried taking an admin/categories.php from a new install (the stock version) and uploaded it over the one that I have now. I added a long description through the admin panel using that categories.php and it worked!!! The bad thing is that I don't know what changes I had made to that categories.php. I wonder if anything else is going to be messed up now? I guess that I will find out in time...or I guess that I could compare the two files...

[♥kymation]

Use Winmerge or something like it to find the differences. Somewhere in that code is a limit on the length of the description string. Unfortunately there are many ways to do that, so I can't just tell you what to look for. If you find something suspicious, post it here.

 

Regards

Jim

[Kerrigan]

Use Winmerge or something like it to find the differences. Somewhere in that code is a limit on the length of the description string. Unfortunately there are many ways to do that, so I can't just tell you what to look for. If you find something suspicious, post it here.

 

Regards

Jim

 

Thanks so much again Jim. You the man! I can get some sleep now! :D I used Winmerge to compare the two files and this was missing from the newer category.php that I was using, from line 974-979:

 

$category_path_string = '';
           $category_path = tep_generate_category_path($cInfo->categories_id);
           for ($i=(sizeof($category_path[0])-1); $i>0; $i--) {
             $category_path_string .= $category_path[0][$i]['id'] . '_';
           }
           $category_path_string = substr($category_path_string, 0, -1);

 

Do you think that was it? The only modification I personally made to this file was to an addon to change the date each product was added to the catalog. I don't know if I am going to put it back in or not. I think that I changed all that I wanted to change concerning that and don't want to take a chance in messing anything up again...

[♥kymation]

That should only mess up the category path. Well, I guess it can do other weird things as well. Nice to know.

 

You can always add your changes back in one at a time, and test after each addition. That's one way to find a bug like this, although usually not the easiest way. It's not that bad if you haven't made a lot of changes to that file. Or you can only add back the mods that you really need. It's all up to you.

 

Regards

Jim