Re: [phpslash-users] mail list database error

[Sam W. <h0...@ne...>]

Hi Tigran,

It should not be the extra 'story' in the FROM clause - this simply
tells MySQL to map fields like story.story_id to their full table names
(psl_story.story_id in that case).

I could be wrong because I'm not looking at the code right now (out of
office) but I think the query should be returning the stories in reverse
chronological order. If that is the case then try the query below:

	SELECT story.story_id,
		story.title,
		story.dept,
		story.date_available,
		story.intro_text,
		story.body_text,
		psl_author.author_name AS name
	FROM psl_story story,
		psl_author
	WHERE psl_author.author_id = story.user_id
	AND story.date_available >= 1041400800
	AND story.date_available <= 1046152800
	ORDER BY story.date_available DESC;

Cheers,

Sam.

On Tue, 2003-02-25 at 05:34, Tigran wrote:
> At 01:39 PM 2/24/2003, nathan r. hruby wrote:
> >On Mon, 24 Feb 2003, Tigran wrote:
> >
> > > I get this error when I try to send a new newsletter to the list
> > >
> > > ERROR: Database error: MySQL Error (1054). Please contact the webmaster and
> > > report the exact error message. Session halted.
> > >
> > > is this a known bug?
> > > Ideas how to fix it?
> > >
> >
> >Error 1054 seems to be a missing field or table in the database.  did you
> >load the database correctly?  can you use mysql from the command lien (or
> >phpmysql) to so a SHOW COLUMNS ON psl_mailinglist;
> >
> 
> Yup yup
> I'm using phpmyadmin and I can see psl_mailinglist
> I see 4 columns id, email, name, and date_created
> 
> There's also psl_mailinglist_frequency
> I see 3 columns id, frequency, and dayback
> 
> >-n
> >--
> >------
> >nathan hruby
> >na...@ds...
> >------
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> phpslash-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpslash-users
-- 
Sam Williams <h0...@ne...>
Salter Projects Limited