Trying to import from forum mysql

[prepress forums]

I am trying to get the list import from mySQL as opposed to exporting it, then importing it from a csv.  The domains are on the same server, so localhost is good I think, even though other site is on another IP and domain than listmailpro.  Both are on same server so localhost should be fine.

But when I put in all the info, go import, I get this error:

admin-30-Table 'MyDatabaseName.lm_lists' doesn't exist

What is admin-30-Table?  Is it saying I need to create a table to import into?  I just don't get this but exporting and importing all the time is getting old??

Please advise.

[DW]

Hi JP,

I believe this is a former bug.  Please update your files with the latest available and let me know if the problem continues.  The "admin-30" is the error number I use for debugging.  It means the error occurred in admin.php and allows me to find the exact line it occurs.

The bug was basically a problem with failing to global and specify the $link var for mysql_query() in a common function that reads custom fields for a list:

Code: [Select]

function getcfields($list,$xtra=''){
 global $ltable, $link;
 if($xtra=='users') $terse = 1;
 $cmd = "select field1,field2,field3,field4,field5,field6,field7,field8,field9,field10 from $ltable where listnum = '$list' limit 1";
 $lrow = mysql_query($cmd,$link) or die('admin-30-'.mysql_error());
Regards

[prepress forums]

Hi Dean,

i am on v1.87d but when I try and go to the download (members area) it does not allow ne in.  Then, I do a lost password request, it says it sent a message, but nothing ever comes.  So, for a few days I am trying to get updates.  I have emails where you used to send them to me.  I have emails with my user & password, but it doesn't work.

Please help me get current software.  Thanks.  user for members is "sam"

[prepress forums]

OK, I got in but the v1.87d looks like it is the most current one that you are posting there.  So, do I need to hack this change into 1.87d to get this fixed?  Also, never mind the password issue, I have it resolved now.

[DW]

Hi Sam,

If using the latest files you still cannot import your users please submit a bug report and I will investigate.

Regards

[prepress forums]

What I'm trying to do is import the addresses from my phpbb forum once a week or so.  I would even more prefer it is the database was integrated so that one list was my phpbb members and was directly linked to that database and table.  If my members execute a remove, request, or have bounces, I want them deleted from the forums user DB.

If my members can't receive or do not want mail, I want to delete their accounts.  I thought I could do this pretty easy but maybe that was phpList where I read that.  The membership requires valid email and contact from the forums.  Maybe I need another script for this?

I'm not sure if the import is really going to do that.  I also notice from its message admin-30-Table 'MyDatabaseName.lm_lists' doesn't exist that it seems to be expecting a table named "lm_lists" in my phpbb database?  So, I am not sure that I even have the right understanding about this ability to import.  I actually need to LINK or USE another table rather than to import it?  

Please advise how I can do what I am saying here.  Thanks.

[DW]

JP,

The admin-30 'lm_lists' error is a bug which, if it's not fixed in the latest available files, I can fix with access.

There is not currently a way to use an external database table for an actual list.  What I recommend at this time is a small custom PHP script run each day before ListMail's dailymail to update your list(s) with data from the external database.  This way you can schedule an email and it will be sent to a freshly updated user list.

I can be employed to create such a script for phpBB for about $40. Removed users can stay removed or be completely removed from phpBB as you prefer.

Regards

[prepress forums]

>> DW Writes:

>> I can be employed to create such a script for phpBB for
>> about $40. Removed users can stay removed or be
>> completely removed from phpBB as you prefer.

Hi Dean,

Yes, Lets do this.  I need help with this and need to improve my method here.  If I could pull my email list from my phpBB user table, even with a click would be good, could automate that with a cron later if I can ever get my cron working.. I have a new dedicated and I'm not so familiar with all of it yet, learning.

Then my next issue is handling the bounces.  Now I am manually doing them and it's too much to deal with.  I have read about bounce cgi etc. but not sure how that helps if your true data source is in a database elsewhere... Since the data is in the phpBB I am stuck going back and forth to delete bad email address accounts.  The way my forums work, if your email doesn't take my mail, you get deleted.  So, as long as I could come up with a sound process, I would like the bounced mail when certified as no good to just delete the record from users table in phpBB.

[DW]

Hi JP,

If we can get ListMail's bounce processing working the integration script can check for bounced and removed users and remove them from the forum.

You can send me $40 here and securely submit your info here.  Please include your access information and a link back to this post in your support ticket.  Also useful would be the list # you intend to use with the integration.  I will be extremely careful with any existing data during creation and testing of the script.

Regards and thanks

[prepress forums]

The lost password feature on your members support link hasn't worked for months.  I am again digging trying to find my password for it.  I know I have it but it looks like has been changed since I purchased.  I did find the first one from purchase and it doesn't work.

[DW]

JP, I just tested it and received my details.  Does the process -say- it is delivering your details, but they never arrive?  Could the messages (from noreply @listmailpro.com) be being filtered by your host/ISP or email client?  I will attempt to forward your details via email.  Thanks for your order.

Regards

[prepress forums]

Hi DW,

I have a guess, if this works for you and all is testing well.  It definitely does NOT work for me.  My URL has a hyphen in it and on very rare occasion I have run into issues where that caused a problem with scripts executing.  Either a possible parsing or filtering problem.

I can test this by changing my email to one that has no hyphen.  Then, see if that works.  Change it back, see if doesn't.  Then I will let you know.  

Yes, it does say it worked and has sent my details.  No, it never arrives and isn't in a spam trap, I have you whitelisted too..

[ifsbos]

Same problem here.
I just downloaded the latest version and having this problem importing from .cvs or mysql

admin-30-Table 'blogtele_artdb.lm_lists' doesn't exist

How do i fix this problem? Thanks.

This happens after entering the db details on import users from mysql.

Is there a patch?

[ifsbos]

OK, I figured out what the problem was and I hope this helps you if you're experiencing the same thing. The root of the problem is not the program, which is great, it's how you export the file.

On your phpmysql be sure to export your db as
CSV for MS Excel
and checkmark the x Put fields names in the first row
Excel edition
(windows)

When I did this and uploaded the .csv file to the directory, the program processed it fine. I only chose the firstname, lastname and email which is all I needed for my mailing list.

It worked beautifully. So if you're having the same admin-30 error msg it's because the the regular CSV export file is messed up.

Regards.

[DW]

In fact there is a known issue with importing via MySQL in recent versions:

http://listmailpro.com/forum/index.php?topic=1688.0

Regards