News module: error!

[Oldeman]

I have just installed the new 'news module' for displaying a news box on the homepage. However the instruction in the 'read.me' file are very short and I think something about creating a table in the database is missing, because I receive next error:

 

 

1146 - Table 'catalog.002_news' doesn't exist

 

select count(*) as total from 002_news

 

Does somebody know where I can find the right instructions?

 

Regads,

Liesbeth

[mazza]

Contact the contributor. The contribution is missing the sql-stament that you need to insert to database. And could you post the sql-statement here when/if you get it.

[Oldeman]

Herewith the reaction of the contributor!

 

Hello,

 

I?ve forgotten to do the Dump of the table in the package. Sorry.

here are the lines for the Database:

 

--- snip ---

#

# Tabellenstruktur f?r Tabelle `002_news`

#

 

DROP TABLE IF EXISTS 002_news;

CREATE TABLE 002_news (

id_news bigint(13) NOT NULL auto_increment,

ueberschrift varchar(250) default NULL,

kurztext longtext,

autor varchar(100) default NULL,

von date default NULL,

bis date default NULL,

langtext longtext,

bild varchar(30) default NULL,

weiter enum('Y','N') NOT NULL default 'N',

PRIMARY KEY (id_news)

) TYPE=MyISAM;

 

#

# Daten f?r Tabelle `002_news`

#

 

INSERT INTO 002_news (id_news, ueberschrift, kurztext, autor, von, bis, langtext, bild, weiter) VALUES (33, 'Athlon nun doch mit 333 FSB?', 'Der Prozessor soll am 7. Oktober vorgestellt werden und noch auf dem Thoroughbred-Kern beruhen.<BR> rnHersteller AMD hat erste Muster seines K8-basierten Desktop Athlon XP-Chips mit 512 KByte L2-Cache auf der CeBIT in Shanghai vorgestellt.', 'U.F.O', '0000-00-00', '0000-00-00', 'Die CPU unterst?tzt einen Front Side Bus von 333 MHz und ist im 0,13 Mikronverfahren hergestellt. Derzeit plant der Intel-Rivale den Chip erst im vierten Quartal ins Rennen zu werfen.<BR>rnDen Massenmarkt soll der Prozessor jedoch erst im Januar oder etwas sp?ter in 2003 erreichen. <BR>rnDer Prozessorhersteller scheint den Zeitpunkt f?r die CPU mit 512 KByte L2-Cache (Codename Barton) noch etwas rausz?gern zu wollen. So will AMD am 7. Oktober erst noch einmal einen Athlon XP mit einem verbesserten Front Side Bus und 256 KByte L2-Cache pr?sentieren. Der in !

0,13 Mikron-Technik gefertigte Athlon XP 2700+ soll einen FSB von 333 MHz anstatt bisher 266 MHz mitbringen', 'aafrog1.jpg', 'Y');

 

--- snip ---

 

Cu Konstanze

[Oldeman]

Stil there seem to be some problems in the admin part:

 

- no status; no possibility to activate the news message

- after adapting the specific languages files, there are still a lot of German terms

- after saving a news item the results are displayed in the left bottom corner????

 

Has some one already a good working news module?

 

Regards,

Liesbeth

[oddie]

nice crontrib

 

it would be nice to see it in english, cause the only things that i understand is the sql statsments, nothing else :(

[ssyfrig]

Hi

 

very short readme :( but it works :?

 

greez Sven

[Frold]

Well I have just downloaded the news2_1 and i work in my admin part. I can edit and add news but it will not being show on my default.php page. I?m using an old oscommerce 2.2 version that is from the middel of August 2002.

 

Can anybody help me to fix the problem? I would like to edit and add news easely trought the admin part!!!

[jalil]

Has some one already a good working news module?

 

Hello Liesbeth,

 

Try this other news contribution, it works for me:

 

http://www.oscommerce.com/downloads.php/co...ions,649/type,3

 

Regards,

Jalil