Articles disappear when saving
Asked Modified Viewed 4,392 times
asked
I tried to get some help in an existing thread, but didn't get an answer.
My problem is, that some of our articles are long, and now they start to disappear from the database, when we want to update them.
We did not install anything that could cause this problem, as it came out of nowhere.
My problem is, that some of our articles are long, and now they start to disappear from the database, when we want to update them.
We did not install anything that could cause this problem, as it came out of nowhere.
Quote
I have set the article_article as longtext, but the problem still occur; whenever we try to edit/post a long article (we're talking veeeeeery long), it's empty when we try to preview, and all the data in the article is then lost.
I have looked in this forum for hours, and on other mysql sites, but are unable to find a solution.
I am dying to solve this issue, and would be forever thankful to he/she who can help
answered
This will be my last bump..- since it's impossible to get an answer, even if it's a "don't know", from the crew, I am considering changing CMS system.
Having a major problem, and asking for help three times without an answer, is just to much.
I have always been a fan of this system, but the recent lack of support is just not good enough.
Having a major problem, and asking for help three times without an answer, is just to much.
I have always been a fan of this system, but the recent lack of support is just not good enough.
answered
May be its database/hoster problem?
answered
I contacted my host, because I get this message:
Your PHP MySQL library version 5.0.27 differs from your MySQL server version 5.1.35. This may cause unpredictable behavior.
However, my host said that isn't the problem, but that's all the "support" they could give me.
Your PHP MySQL library version 5.0.27 differs from your MySQL server version 5.1.35. This may cause unpredictable behavior.
However, my host said that isn't the problem, but that's all the "support" they could give me.
answered
What exactly happens?
Do only old articels which get updated get cut, or are also new articels get cut?
Edit: and with which version do you work?
Do only old articels which get updated get cut, or are also new articels get cut?
Edit: and with which version do you work?
Edited by mawe4585 on 06-09-2009 13:45,
answered
New articles as well, when they reach a certain length.
So I'm thinking it is a matter of changing some setting in the database, but I have no clue how to do that - and what needs to be changed.
So I'm thinking it is a matter of changing some setting in the database, but I have no clue how to do that - and what needs to be changed.
answered
how long ist that article exactly? how many letters?
Maybe that is what you are searching(from mysql.com):
Maybe that is what you are searching(from mysql.com):
Quote
The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. You can change the message buffer size by changing the value of the max_allowed_packet variable, but you must do so for both the server and your client program. For example, both mysql and mysqldump allow you to change the client-side max_allowed_packet value. See Section 7.5.3, “Tuning Server Parameters”, Section 4.5.1, “mysql — The MySQL Command-Line Tool”, and Section 4.5.4, “mysqldump — A Database Backup Program”. You may also want to compare the packet sizes and the size of the data objects you are storing with the storage requirements, see Section 10.5, “Data Type Storage Requirements”
Edited by mawe4585 on 06-09-2009 13:58,
answered
Letters: 340512
The funny part is, that the article is showing now. But if I go to the article-administration, and preview the article, the entire text disappears from the input field...
This is the screenshot from one of the articles that are to big:
The funny part is, that the article is showing now. But if I go to the article-administration, and preview the article, the entire text disappears from the input field...
This is the screenshot from one of the articles that are to big:
answered
Quote
MaWe4585 wrote:
how long ist that article exactly? how many letters?
Maybe that is what you are searching(from mysql.com):Quote
For example, both mysql and mysqldump allow you to change the client-side max_allowed_packet value. See Section 7.5.3, “Tuning Server Parameters”, Section 4.5.1, “mysql — The MySQL Command-Line Tool”, and Section 4.5.4, “mysqldump — A Database Backup Program”. You may also want to compare the packet sizes and the size of the data objects you are storing with the storage requirements, see Section 10.5, “Data Type Storage Requirements”
max allowed packet is 104,857,600
answered
so if you open it with phpmyadmin, its there completely? but it doesn't show correctly in phpfusion?
answered
It's in phpmyadmin, but it also stay saved in Fusion, if only I preview (and the code disappears) and not hit the save button.
It is pretty complicated huh?
It is pretty complicated huh?
— 8 months later —
answered
Before I move on and try another CMS, I would like one last shot at this - because I like this CMS and the friendly users.
So please guys - I'm on my knees :)...
So please guys - I'm on my knees :)...
answered
If it's any help, I just looked into the articles database.
When I change articles_articles datatype from longtext to blob, I can suddenly preview...?
When I change articles_articles datatype from longtext to blob, I can suddenly preview...?
— 2 months later —
Category Forum
Content Administration - 8Labels
None yet
Statistics
- Views 0 views
- Posts 13 posts
- Votes 0 votes
- Topic users 4 members
4 participants
StefanN 10
- Junior Member, joined since
- Contributed 15 posts on the community forums.
- Started 3 threads in the forums
- Started this discussions
mawe4585 10
- Member, joined since
- Contributed 84 posts on the community forums.
- Started 34 threads in the forums
PolarFox 8
- Veteran Member, joined since
- Contributed 1,633 posts on the community forums.
- Started 29 threads in the forums
Dawan 10
- Member, joined since
- Contributed 110 posts on the community forums.
- Started 33 threads in the forums
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions