1
Kainaij
Need "Random Quotes 1.0.1" module help...
  • 2005/3/23 21:35

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


I have quotes that are longer that 254 characters in length, yet this module cuts off my quotes after this limit. How can I fix this or is there an alternetive.

2
JasonMR
Re: Need "Random Quotes 1.0.1" module help...
  • 2005/3/23 22:33

  • JasonMR

  • Just can't stay away

  • Posts: 655

  • Since: 2004/6/21


This is due to the DB structure. You need to change line 18 in randomquote/sql/mysql.sql from

texto varchar(255NOT NULL default '',


...to

texto text NOT NULL default '',


Uninstall and reinstall the module.


BUT, if you have already added a bunch of quotes, and don't want to loose them, the procedure is a little tedious.

First dump the table YOURDBPREFIX_citas (you only need the INSERT statemtents).

Next uninstall the module (DB tables don't get updated via update script I've been told).

Then reinstall, and run the INSERT statments.


This works, as I just tested it Thanks for posting this question. Just noticed this the other day, and hadn't bothered looking into it, up to now, due to your posting THANX

3
Kainaij
Re: Need "Random Quotes 1.0.1" module help...
  • 2005/3/23 22:49

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


Thank you very much for the speedy reply. Works like a charm.

4
JasonMR
Re: Need "Random Quotes 1.0.1" module help...
  • 2005/3/23 22:55

  • JasonMR

  • Just can't stay away

  • Posts: 655

  • Since: 2004/6/21


Was a pleasure as I said, needed to do this for myself, so I was a little egoistic here

Login

Who's Online

124 user(s) are online (111 user(s) are browsing Support Forums)


Members: 0


Guests: 124


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits