Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - mike2

Pages: 1 ... 9 10 [11] 12 13
151
I really love this code and feature!

I've really started using it and it works well.  One problem I'm running into now is that I have around 10 tracked links / lists that I want to continue to append to when someone clicks the link.

The problem is doing 10 or so every day is getting cumbersome.  If there was some way to link the "tracked links" and "lists" together and have one page that does them all at once or better yet get processed right before daily mail runs would be NICE!

I'd be willing to Donate a small amount to make this feature available, I bet there are a couple others... Any interest in this?

152
General Help & How-To / Error after upgrading to 1.85
« on: December 12, 2005, 11:17:51 am »
Dean, this is exactly what happened.  There was a hard drive issue.

Fixed it, and reuploaded a backup.  Please checkout the support ticket for my next request, thanks a ton!

153
Yes I saw the ticket and just updated it with some additional stuff, check it out and let me know, thanks.

At first glance I wonder if its my version of mysql, as its 3.23.58 ???

I'm thinking some of the upgrade commands didn't work (not supported), but it's just a guess.

154
General Help & How-To / Error after upgrading to 1.85
« on: December 12, 2005, 06:33:04 am »
Dean,

Any luck finding out anything on my server?

This is kind of critical, I mail everyday and people are going to start getting mad if they can't unsubscribe.   Please let me know something asap!

155
Dean,

Any luck finding out anything on my server?

This is kind of critical, I mail everyday and people are going to start getting mad if they can't unsubscribe.   Please let me know something asap!

156
Ok I went ahead and submitted my server info for you to check out.  Please let me know what you find asap, thanks.  Go ahead and check out this problem as well, thanks.

157
General Help & How-To / Error after upgrading to 1.85
« on: December 10, 2005, 12:36:45 pm »
Ok I went ahead and submitted my server info for you to check out.  Please let me know what you find asap, thanks.

158
General Help & How-To / Error after upgrading to 1.85
« on: December 10, 2005, 10:08:33 am »
I thought I'd try an myisamchk, here's what I get (some errors):

Quote
[root@ns1 maoptin]# myisamchk -r *
myisamchk: error: 'lm_chtmld.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_chtmld.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_chtmld.MYI'
Data records: 24
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_chtml.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_chtml.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_chtml.MYI'
Data records: 4
- Fixing index 1
         
---------

myisamchk: error: 'lm_codes.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_codes.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_codes.MYI'
Data records: 15
- Fixing index 1
- Fixing index 2
- Fixing index 3
         
---------

myisamchk: error: 'lm_config.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_config.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with keycache) MyISAM-table 'lm_config.MYI'
Data records: 1
         
---------

myisamchk: error: 'lm_errord.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_errord.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_errord.MYI'
Data records: 28
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_error.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_error.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_error.MYI'
Data records: 4
- Fixing index 1
         
---------

myisamchk: error: 'lm_follow.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_follow.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_follow.MYI'
Data records: 11
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_hits.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_hits.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_hits.MYI'
Data records: 62
- Fixing index 1
         
---------

myisamchk: error: 'lm_links.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_links.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_links.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2
- Fixing index 3
         
---------

myisamchk: error: 'lm_lists.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_lists.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_lists.MYI'
Data records: 4
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_saved.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_saved.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_saved.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_schedule.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: -1 when opening MyISAM-table 'lm_schedule.MYD'

---------

- recovering (with sort) MyISAM-table 'lm_schedule.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_selectd.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: -1 when opening MyISAM-table 'lm_selectd.MYD'

---------

- recovering (with sort) MyISAM-table 'lm_selectd.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_select.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_select.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_select.MYI'
Data records: 1
- Fixing index 1
         
---------

myisamchk: error: 'lm_sendp.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_sendp.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_sendp.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2
         
---------

myisamchk: error: 'lm_sendq.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_sendq.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_sendq.MYI'
Data records: 173645
- Fixing index 1
         
---------

myisamchk: error: 'lm_sent.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_sent.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_sent.MYI'
Data records: 51
- Fixing index 1
         
---------

myisamchk: error: 'lm_users.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

myisamchk: error: 'lm_users.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair

---------

- recovering (with sort) MyISAM-table 'lm_users.MYI'
Data records: 364043
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
[root@ns1 maoptin]#
[root@ns1 maoptin]#
[root@ns1 maoptin]# mysql -p

159
General Help & How-To / Error after upgrading to 1.85
« on: December 10, 2005, 09:59:26 am »
As far as I know everything was working fine before the update.

I don't use phpmyadmin, but I know how via the command line.  Tried to repair the table, no luck, here's what i get:

Quote
[root@ns1 tmp]# mysqlcheck -re maoptin lm_chtmld -p
Enter password:
maoptin.lm_chtmld
error    : Incorrect information in file: './maoptin/lm_chtmld.frm'


And:

Quote
[root@ns1 tmp]# mysqlcheck -r maoptin -p
Enter password:
maoptin.lm_chtml                                   OK
maoptin.lm_chtmld
error    : Incorrect information in file: './maoptin/lm_chtmld.frm'
maoptin.lm_codes                                   OK
maoptin.lm_config                                  OK
maoptin.lm_error                                   OK
maoptin.lm_errord                                  OK
maoptin.lm_follow                                  OK
maoptin.lm_hits                                    OK
maoptin.lm_links                                   OK
maoptin.lm_lists                                   OK
maoptin.lm_saved                                   OK
maoptin.lm_schedule                                OK
maoptin.lm_select                                  OK
maoptin.lm_selectd                                 OK
maoptin.lm_sendp                                   OK
maoptin.lm_sendq                                   OK
maoptin.lm_sent                                    OK
maoptin.lm_users                                   OK


And this is what I get when doing it in "mysql", even when I switch to the DB I get an error:

Quote
mysql> use maoptin;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'lm_chtmld'
Database changed
mysql> REPAIR TABLE lm_chtmld;
+-------------------+--------+----------+----------------------------------------------------------+
| Table             | Op     | Msg_type | Msg_text                                                 |
+-------------------+--------+----------+----------------------------------------------------------+
| maoptin.lm_chtmld | repair | error    | Incorrect information in file: './maoptin/lm_chtmld.frm' |
+-------------------+--------+----------+----------------------------------------------------------+
1 row in set (0.00 sec)



Any other suggestions before I setup a temporary access for you to get in and look?

160
Quote from: "webshaman"
Did you try the test above from DW?


I just tried his test and I get nothing at all, no email, nothing.

Also, can you please check this out as I am getting the same kind of error I describe above when clicking on a "confirm link", which is serious.

Here's the thread I started in the general forum:
http://listmailpro.com/forum/index.php?topic=1005.0

161
General Help & How-To / Error after upgrading to 1.85
« on: December 09, 2005, 03:11:51 pm »
Error after upgrading to 1.85:

I've been seeing this error in a couple places:
Quote
admin-60-Incorrect information in file: './maoptin/lm_chtmld.frm'


The most seriously when I got an email from someone who tried to confirm their subscription via email, he emailed me this and indeed when I tried to click his confirm link I got the same message.  Note he did actually get subscribed to the list.  Here's what he emailed to me:

Quote
Hi

Your script is toast. Slap the programmer (well at
Least don't give them any more pizza today :)

admin-60-Incorrect information in file: './maoptin/lm_chtmld.frm'


Michael Relfe


Please Help, this is somewhat urgent.  I have also PM'd and emailed you this.

This also sort of relates to this thread:  
http://listmailpro.com/forum/index.php?topic=721.0

UPDATE:  I just checked and it's worse then I thought, when clicking a remove link, I get the same thing.  I'm guessing something didn't get updated correctly for me?

162
Ok, I am still having a problem with this script for some reason...

I just updated to 1.85 because I thought that removing the undocumented URL feature to aol would fix my problem but it hasn't.

Now all I get back in my email from the script is this:
Quote
admin-60-Incorrect information in file: './maoptin/lm_chtmld.frm'


I looked at a raw view of the email I get back from aol and in every URL right after the equal sign is "3D", looks like this:
Quote
http://ma-enews.com/cgi-bin/to.cgi?l=3Dmaadop


Somehow somewhere things are getting converted to ascii or something, because when looking at the raw view of the message I see this:
Quote
=93The Short Book on the Offer in
Compromise and IRS Liens and Levies!=94


The =93 and =94 above were originally quotes ( " " ).

I am using Pegasus for my email program, could this be the problem?  I am thinking someone Pegasus is doing this and of course when I then bounce it to my aolcomplaint email address it's not right.

I know I could change my aol white list address, but it'd be easier to fix this problem (maybe), because I want to see the original message sometimes.

I am going to telnet into my server and read the email in pine next time to see if I can tell if pegasus is adding the 3D.  Otherwise I'll just need to remove the "3D" string from the URL in the script.

UPDATE:

Ok, when I bounce this mail to my yahoo email address or back to myself, the "3D" isn't there, now I am lost...

On a side note Dean, when testing a link tracking link before saving it, I get the same error:
Quote
admin-60-Incorrect information in file: './maoptin/lm_chtmld.frm'


Well, now I can't re-duplicate that error, but it showed up once when I first started setting up "Link tracking", which was just today after updating to 1.85.

163
webshaman,

I am receiving the email from the script just fine.  But my email is showing that the email address isn't getting removed due to my URL not being formatted properly.  (Which I believe is because of an older setting that I set a while back, but can't find out how to un-set.)

I looked at the /tmp files because I run my own server(s).  I doubt if you are in a shared environment you can do this (or at least you shouldn't be able to).  

But if you look at the script, that is where it stores the files (email) for processing.  You can probably change the directory to a temporary directory under your home directory and then stop the script from deleting the files.  You would/should then be able to see them.  

As for your problem, make sure the email address you set $my_email to is correct and you kept the "\" before the "@" sign else it won't work.

164
I'm actually not sending HTML e-mail.  A long time ago I set an option to automatically add the HTML part for aol addresses and have never changed it.

What I send my message it looks like a normal link:
http://ma-enews.com/cgi-bin/to.cgi?l=maadop

But upon examining the email returned by AOL's feedback loop, every URL in my message looks like:
<a href=3D"http://ma-enews.com/cgi-bin/to.cgi?l=3Dmaadop">h=
ttp://ma-enews.com/cgi-bin/to.cgi?l=3Dmaadop</a>

So, I'm guessing this has to be Listmail adding this.  I know I really no longer need that option because most Newer AOL browsers actually make the hyperlinks work properly by default, but I can't seem to find that option anywhere anymore...

165
Development, Suggestions / Possible bug found?
« on: November 22, 2005, 12:17:02 pm »
I just noticed while working on another listmail project that I may have found a small bug...

I've been uploading single opt-in leads to email my confirmation request to attempt to get them to double-opt-in.  I just noticed in the /tmp directory of my server that there are some files there over a week old owned by apache.

Upon examining these files, they are the lead files I have been importing.  I'm guessing these should be getting deleted after importing but aren't.  Not a HUGE deal, but on a shared server if someone could get access to these files it may not be good.

Pages: 1 ... 9 10 [11] 12 13