HI.
I get this error :
You have an error in your SQL syntax near '"3b.test_posts" where date >= 'Mon, 31 Jul 2006 01:45:46 +0200'' at line 2


why..
best regard
joe

What database are you using? It seems that it doesn't like the table name in double quotes. Does it work with single quotes?

Hi metalhead.
I am using phpMyAdmin and you can see it here :
http://www.44safe.com/news/

"Does it work with single quotes?"
I dont now that you mean.

My config_imap.php looks like this
<?php

/* the newsserver you want to connect to */
$newsserver = "http://news.readfreenews.net";

/* the newsserver port */
$port = 119;

/* the groups you want to get */
$newsgroups[] = "3b.test";

And in the config_sql.php,i have thoose the $dbtype = "mysql";

best regard
Joe
( sorry..bad english..iàm from denmark

I was referring to the quotes ("") around the name of the database table. Could you please send me an email, I think it's better to continue our conversation that way. Thanks.

Hi,

Did you ever manage to get it to work with mySql? I've done a lot of hacking and so far haven't gotton it to work.

Now when it executes imap_search it takes about 20 mins to complete, and then fails on an sql syntax error. Surely the 20 mins delay isn't right.... it even did this when I changed it to search for messages on a set date. Also, because of the delay I haven't been able to fix all the sql errors - I simply can't wait 20 mins to test each change :)

Thanks,
Dave.

If you're using a slow newsserver, 20 minutes isn't unreasonable. If you drop me an email with the error message, I'll try to help you.

OK, im having this issue as well, with mysql db. issue is
1. doesnt like double or single quotes
2. doesnt like "." in the table name.

Somehow we have to setup some sort of alias for the DB. Ill see what I can do by inserting a script to suck out all the periods when it deals with mysql.