On 2004-10-02, Tony Earnshaw <[EMAIL PROTECTED]> wrote:
Anybody ever had to do this before and has a prescribed solution?
Yes, right here on this list, in fact!
http://sourceforge.net/mailarchive/message.php?msg_id=1270517
Great, I created the MySQL squirrelmail DB and the tables, but how do I auth to MySQL with the script?
O.k., I found out how to do that by myself ("sukkel"). Even though I have the correct parameters (dir/file, etc.)
But the thing gives a string of errors, even though I have the correct parameters at the start: _____________________________________________________________________
Scalar found where operator expected at ./flat2sql.pl line 65, near ""DELETE FROM $db.$abook_table WHERE owner = "$username" (Missing operator before $username?)
Huh. Surprising.... unescaped quotes. Did this even get tested by its authors?? You need to change such lines from this:
print "DELETE FROM $db.$pref_table "
. "WHERE user = "$username" and prefkey like "___sig" . $del_ext . "___";\n"
if ( defined $opts{delete} );
to this:
print "DELETE FROM $db.$pref_table "
. "WHERE user = \"$username\" and prefkey like \"___sig\" . $del_ext . \"___\";\n"
if ( defined $opts{delete} );
Note that backslashes.
------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl -- squirrelmail-users mailing list Posting Guidelines: http://squirrelmail.org/wiki/wiki.php?MailingListPostingGuidelines List Address: [EMAIL PROTECTED] List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
