Here is the quick fix, not from me but total credits and respect to Jim the developer of phpfreenews (http://www.phpfreenews.co.uk) :
Jim wrote:
When I installed it, I was asked to supply table prefixes, database name, etc. I entered a database name of cute and left the table prefixes as cute_ (which the default).
However! The software created the tables WITHOUT the prefix!
So, to enable login you need to edit
\inc\db\mysql.class.php and change line 146 from
$query .= 'from '.$this->prefix.$arg['table']."\n";
to
$query .= 'from '.$arg['table']."\n";
But this will only fix login (as I discovered). To effect a more permanent solution you need to set the $this->prefix value to nothing, and the easiest way to do this is to edit the data/config.php file and set:
$config_dbprefix = "";
(around line 29).
It then seems to work properly.
Hope this helps.
Jim
I've tried it out and it worked for me.
Thank you,
Sunburst
