Category description length (varchar 255) can increase?

[altinmas]

How can I increase the Category description length from 255 to bigger chars?

[Ap0s7le]

By all means, I have a script that does that for you if interested.

Let me know :)

-Casey

[altinmas]

Thanks Ap0s7le ,
Sure :D , Please give it to me .
I can not change it from mysql...

Best regards.

[Ap0s7le]

I know a lot of people would love to have this. I should charge like 5 bucks haha

Here it is, I've never really had issues with it. This was a rewrite, as I'm not home with my original.

Content visible to registered users only.

[gmschmitz]

Anyone had any luck with this, I tried it out and got some errors when trying to run it unless I'm trying to run it wrong. I just put in the include folder and then tried to access that page. Any suggestions.

Gary
http://www.us-realestatedirectory.com

[anon]

Content visible to registered users only.

you know, *descriptions* of errors are a pretty handy tool and guide to go by. Just so unfortunate that you haven't provided any.

Rob

[gmschmitz]

I posted it and was thinking the same thing, so I had to go try it again :

Warning: main(init.php): failed to open stream: No such file or directory in /home/www/us-realestatedirectory.com/include/longdes.php on line 26

Warning: main(init.php): failed to open stream: No such file or directory in /home/www/us-realestatedirectory.com/include/longdes.php on line 26

Warning: main(init.php): failed to open stream: No such file or directory in /home/www/us-realestatedirectory.com/include/longdes.php on line 26

Warning: main(): Failed opening 'init.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/www/us-realestatedirectory.com/include/longdes.php on line 26

Fatal error: Call to a member function on a non-object in /home/www/us-realestatedirectory.com/include/longdes.php on line 32

[gmschmitz]

Maybe it's because it's in the include folder and the init.php is not. Should I put it in the main folder and try to access it again.

Gary

[neurosis4u]

for me it works... run the script from your Main Folder...

[gmschmitz]

I ran it from my main folder and it said it worked, but it only still shows 255 chars. so I'm not quite sure what happened. I'm still playing around with it. Just trying not to screw up my data base in the mean time. :)

[gmschmitz]

Now if I try to run it again I get a error:

Duplicate column name 'DESC_LONG', so it's like it workrd the first time, it's just when I went to add more that 255 char to a description it still cuts it off.

Gary

Ok I see what it did it made the Description for the links more than 255 I was trying to make the description for the Categories more than 255 char. I think I just need to change the script and where it says "{$tables['link']['name']} " I need to change it to {$tables['category']['name']}
I think I'll give it a shot.

[gmschmitz]

Worked just fine, changed all {$tables['link']['name']} to "

{$tables['category']['name']}

Now my description for each Catergory can be long, and I have added the Category description to the top of the Category page. Now I just have to write the content.

[Optimit]

Glad to see you got it working. If you had to do something different than above, you might post it here to help others in the future.

[gmschmitz]

Here is the code as I said above, what was changed was anywhere it said {$tables['link']['name']} I changed it to {$tables['category']['name']}

The above code in the second post is if you want to change the description in the links.

Content visible to registered users only.[/code][/quote]

[jeeplaw]

Content visible to registered users only.

How can I go about adding the description to the top of the category page?