Article bug/error
Asked Modified Viewed 2,359 times
An for me unusual error just happen!
I was saving an article, and then it deleted it instead of saving it.
Even in preview it deleted the article! It just went... *pouf* Gone...
Any idea on how i can fix this?
Site is Rianas Hjerterum
I was saving an article, and then it deleted it instead of saving it.
Even in preview it deleted the article! It just went... *pouf* Gone...
Any idea on how i can fix this?
Site is Rianas Hjerterum
Edited by HopeyS on 12-11-2007 20:00,
No one here that can help?
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
First: Any article or a specific one?
Second: Did you re-upload ../administration/articles.php?
Second: Did you re-upload ../administration/articles.php?
All! Everyone.
It's impossible to put in any one. They just don't appear.
And yes i tried to reupload a fresh article.php. Did not do anything. They still *Pouf's* Gone..
It's like they wont enter...
Hard to explain.
But yeah it's like a pack of gum. When you open it, you would expect the gum to be there! But it's not! The package is empty..
Same here with the articles.
It's impossible to put in any one. They just don't appear.
And yes i tried to reupload a fresh article.php. Did not do anything. They still *Pouf's* Gone..
It's like they wont enter...
Hard to explain.
But yeah it's like a pack of gum. When you open it, you would expect the gum to be there! But it's not! The package is empty..
Same here with the articles.
Edited by HopeyS on 16-11-2007 04:43,
Could it be the database did'nt install it self as i should when installing fusion?
And how would i then fix that?
And how would i then fix that?
Tutteluuu??? Help pleace!... Or something...
answered
No idea exactly,
but one question
Can you EDIT any article (and save the changes?)
One thing that comes to mind, is the id of the articles has run out.
Try changing
articles
article_id SMALLINT(5) => article_id MEDIUMINT(8)
in phpMyAdmin.
but one question
Can you EDIT any article (and save the changes?)
One thing that comes to mind, is the id of the articles has run out.
Try changing
articles
article_id SMALLINT(5) => article_id MEDIUMINT(8)
in phpMyAdmin.
No because there are no articles! Because somehow they disappears, while trying to put them in!
So a bit hard to edit them when they are not there *S*
And change it into?
That one?
So a bit hard to edit them when they are not there *S*
And change it into?
Quote
article_id SMALLINT(5) => article_id MEDIUMINT(8)
answered
OK, no articles at all?
Well, if there's no articles present, you can try previewing (don't save) this in a custom page
This will drop articles and articles_cats table, and create new ones, that will hopefully solve your problem.
Note, don't do this if you have made any articles, if so, backup the articles table first so you might restore it, OK?
Well, if there's no articles present, you can try previewing (don't save) this in a custom page
This will drop articles and articles_cats table, and create new ones, that will hopefully solve your problem.
Code Download source
<?php
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."articles");
$result = dbquery("CREATE TABLE ".$db_prefix."articles (
article_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
article_cat SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
article_subject VARCHAR(200) NOT NULL DEFAULT '',
article_snippet TEXT NOT NULL,
article_article TEXT NOT NULL,
article_breaks CHAR(1) NOT NULL DEFAULT '',
article_name SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
article_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
article_reads SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
article_allow_comments TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
article_allow_ratings TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (article_id)
) TYPE=MyISAM;");
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."article_cats");
$result = dbquery("CREATE TABLE ".$db_prefix."article_cats (
article_cat_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
article_cat_name VARCHAR(100) NOT NULL DEFAULT '',
article_cat_description VARCHAR(200) NOT NULL DEFAULT '',
article_cat_sorting VARCHAR(50) NOT NULL DEFAULT 'article_subject ASC',
article_cat_access TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (article_cat_id)
) TYPE=MyISAM;");
?>
Note, don't do this if you have made any articles, if so, backup the articles table first so you might restore it, OK?
Quote
OK, no articles at all?
Nope - none what so ever!
But this code worked!
I have just made an test category, and an test article. And this time it saved it!
So now it works.
So now all i have to get fixed is the rest of what i have posted here resently. In wish no one has answered yet.
But thanks a bunch sveinungs :)
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
- Views 0 views
- Posts 9 posts
- Votes 0 votes
- Topic users 3 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions