| Author |
Message |
Tommy B.
Joined: 24 Feb 2006
Posts: 7
|
|
 Max size of 65536 for full story? |
 |
Hi!
As I am using CuteNews as a full scale CMS (meaning I even put galleries into it), but now I ran into a small
problem. Once the full story reaches 65536 characters, every following character is simply not saved to the
database. Is this a limit to mysql? Or can this be fixed in cutenews?
I am using CuteNews 2.5.4 and did not test whether this also occurs on short story. In fact I didn't test
strawberry yet - maybe this issue has been fixed in it. There was no such problem on the original flat-file based
CuteNews.
Also I wanted to ask whether there is an similar option to [pagebreak], known from the original cutenews
(can't recall whether it was a hack or was implemented into 1.3.6)?
Thanks in advance.
|
|
| Fri Feb 24, 2006 1:54 am |
  |
 |
Guest
|
| |
|
Please login to hide the ads.
|
|
|
|
|
Tommy B.
Joined: 24 Feb 2006
Posts: 7
|
|
| |
|
Allright. Fixed the problem.
It was the mysql database. The table "cute_story" was set to "text", both for short and full. This makes mysql
save only 2^16 which results in 65536 bytes. Settings "text" to "longtext" makes it save 2^32, which is more
than 4 mb of data and fixes the problem.
Maybe the tables created during installation should be set to "longtext" by default? I don't see any reason not
to do this.
My [pagebreak] question still remains though 
|
|
| Fri Feb 24, 2006 2:44 am |
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
|
| Fri Feb 24, 2006 3:40 pm |
|
|
Tommy B.
Joined: 24 Feb 2006
Posts: 7
|
|
| |
|
Wow! Thank you very much. I think I should dig deeper in this forum - there are so many things hidden 
|
|
| Fri Feb 24, 2006 5:28 pm |
|
|
scottdallas
Joined: 04 May 2006
Posts: 2027
Location: US |
|
| |
|
you aren't kiddin tommy b.. i found this site and have been completely consumed in the inner workings of cutenews.ru for weeks now. i have to understand it all. my life was complete with cutenews til i found cutenews.ru! ahhhhh i could never go back now.. but im late and scrambling to keep up! how long has this project been going?
_________________
www.scodal.com is an example of cnr as a social forum - www.scottdizzle.com is an example of cnr as a personal website to share whatever cool stuff i feel like. i have another, but it's nsfw. pm me  |
|
| Fri May 26, 2006 9:14 am |
  |
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
 | | how long has this project been going? |
I think the first version of CuteNews.RU was released in December 2004 based on Cutenews 1.3.6 and AJ-Fork.
The first version with txtSQL database was released in September 2005.
Based on this version I released my (experimental) CuteSQL (with MySQL database) on October 7th, 2005.
A few days later the first official version of CuteNews.RU with MySQL support was released in October 2005.
|
|
| Mon May 29, 2006 7:29 pm |
|
|
RDM
Joined: 12 Jan 2007
Posts: 40
|
|
| |
|
I have the same problem .. i changed in mysql from TEXT to LONGTEXT but the problem is still there. It not show the whole news.. short and full. It's like someone cut them after 730 characters.. or 736 i don t know for sure how many.
http://hiphop-generation.com/index.php is my site. I really don't know why this is happen.. Please give some help.
|
|
| Tue Jan 16, 2007 6:17 pm |
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
Using TEXT in MySQL it should save 65536 characters by default. I have no idea why it only saves 730 characters in your case. Did you install any other plugin?
|
|
| Tue Jan 16, 2007 9:04 pm |
|
|
RDM
Joined: 12 Jan 2007
Posts: 40
|
|
| |
|
I wrote u a PM.. please check Fi-DD .. thanks.
By the way .. i just checked in mysql and there is the whole news saved.. only on site shows me just 730 characters or less...
|
|
| Tue Jan 16, 2007 9:16 pm |
|
|
|
