latestnews v1.1.3 Problem

[jamie_coull]

hi guys,

 

i am have trouble installing the following contribution:

 

 

latestnews v1.1.3

http://www.oscommerce.com/community/contri...rch,Latest+News

 

 

i get the following error in my index.php

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_DISPLAY_LATEST_NEWS' at line 1

SELECT * from latest_news WHERE status = 1 ORDER BY date_added DESC LIMIT MAX_DISPLAY_LATEST_NEWS

[TEP STOP]

 

 

and another error in the admin

 

1146 - Table 'jamiecoull_MTS1.latest_news' doesn't exist

select news_id, headline, content, status from latest_news order by date_added desc

[TEP STOP]

 

 

i have gone over the install.txt about 100 times and its driving me mad!

 

please help :)

[Guest]

Looks like you didn't import the MySQL commands for this contrib. That would account for both errors.

 

-jared

Edited July 23, 2005 by jcall

[jamie_coull]

thanks mate.... ill go try again :)

[jamie_coull]

hey... when i try input the latest_news.sql throught myPHPAdmin i get the following error:

 

 SQL-query:

# Insert configuration items into the configuration table.
INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, date_added )
VALUES (
'Latest News', 'MAX_DISPLAY_LATEST_NEWS', 3, 'maximum number of items to display in the Latest News box', 3, NOW( )
)

 

MySQL said: Documentation

#1146 - Table 'jamiecoull_OScom.configuration' doesn't exist

 

do i need to make a jamiecoull_OScom.configuration myself?

 

note, this is the first time i have used myPHPAdmin!!

[jamie_coull]

no worries... i sorted it myself!

 

was stupid and made a new SQL querys.. into a new datebase!