No News is Bad news! ;)

[spaceghost65]

Hi Thorsten!

This is not a major issue, but i am having trouble getting news items to display on the home page of my install of phpmyfaq 2.0.3 They were not displaying on my previous version either of 1.6. I only receive the "no news is good news" message.

some things that may help with a troubleshoot :
the news items are visible from the admin panel, there are about 5 with no expiration dates set. The "activate" box is checked. I can post, edit and delete news items from the admin panel, although every once in a while when posting it will kick me out and log me off completely.

Everything else works great! Thanks for reading my post.

[Thorsten]

Hi,

can which database do you use and can you post one of the news items as SQL here?

bye
Thorsten

[spaceghost65]

what up player.

Running phpmyfaq 2.0.3 on MySQL MySQL 4.1.11

I ran an export of the table so if to rebuild this table the commands would be as:

Code: Select all

CREATE TABLE faqfaqnews (
  id int(11) NOT NULL default '0',
  lang varchar(5) default NULL,
  header varchar(255) NOT NULL default '',
  artikel text NOT NULL,
  datum varchar(14) NOT NULL default '',
  author_name varchar(255) default NULL,
  author_email varchar(255) default NULL,
  active char(1) NOT NULL default 'y',
  date_start varchar(14) NOT NULL default '00000000000000',
  date_end varchar(14) NOT NULL default '99991231235959',
  `comment` char(1) NOT NULL default 'n',
  link varchar(255) default NULL,
  linktitel varchar(255) default NULL,
  target varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

With the insert statement:

Code: Select all

INSERT INTO faqfaqnews VALUES (1, 'en', 'Welcome!', 'Welcome....\r\n', '20071115160520', '', '', 'y', '00010101000000', '99991231235959', 'n', '', '', '');

[Thorsten]

Hi,

how many news items for display did you set at he configuration panel? The data set looks okay.

bye
Thorsten

[spaceghost65]

for some reason it wasn't writing that var to the db. I would set it and hit save but it wouldn't update the db. I went in and set it by hand and that got them to display. Thanks , problem resolved.