-
🔑 If you are looking for your serial number / activation key code ⟶ Serial Recovery.
📺 If you are looking for documentation or videos ⟶ Have a look at the Tutorial Videos / Frequently Asked Questions / Knowledge Base.
🎟️ You can also contact us privately (please be patient) ⟶ Contact Customer Service.
[MLM] Error inserting record from TrackClicktoDB()
- Thread starter hans
- Start date
fotofriendly
Member
Has there been any progress on this?
I have exactly the same problem with MBMv7.6 purchased today with MLMv2.2.2
I have exactly the same problem with MBMv7.6 purchased today with MLMv2.2.2
fotofriendly
Member
I believe it may have something to do with my other posting regarding Templates not saving & your comment obout read-only folders.
I noticed that one template (& only one) did save. For some reason it looks blank on the Message tab but in Preview shows:
1146: Table 'xxxxxxxxxxx.tbl_mlm_sub_clk_test' doesn't exist
This then gets posted to self when the template is saved?!
I noticed that one template (& only one) did save. For some reason it looks blank on the Message tab but in Preview shows:
1146: Table 'xxxxxxxxxxx.tbl_mlm_sub_clk_test' doesn't exist
This then gets posted to self when the template is saved?!
Please attach that template to a new support ticket.
fotofriendly
Member
...sorry, I deleted it from the folder in an attempt to clear the problem!
jgoodnough
New Member
Same error for me...
I'm getting the same error. I just upgraded and installed 7.6 with 2.2.2 yesterday. The error is "1146: Table 'actona6_aalm.tbl_mlm_sub_clk_test' doesn't exist" It repeats as an email message endlessly until I disable click-through tracking in MBM prefs. Other than the error everything seems to be working o.k. I've checked the db online and it's working o.k. I can subscribe and unsubscribe.
I'm getting the same error. I just upgraded and installed 7.6 with 2.2.2 yesterday. The error is "1146: Table 'actona6_aalm.tbl_mlm_sub_clk_test' doesn't exist" It repeats as an email message endlessly until I disable click-through tracking in MBM prefs. Other than the error everything seems to be working o.k. I've checked the db online and it's working o.k. I can subscribe and unsubscribe.
fotofriendly
Member
...that's the one!
...& I thought I was going insane. I have opened a ticket on this issue, so I hope it can be resolved (& made public) very soon.
Otherwise, this is the best emailing software I have come across in years ...& I have tested & bought a few...!!!
...& I thought I was going insane. I have opened a ticket on this issue, so I hope it can be resolved (& made public) very soon.
Otherwise, this is the best emailing software I have come across in years ...& I have tested & bought a few...!!!
It has been more than a month since I heard for the first time of this error but nobody so far has provided any valuable info to get it reproduced here. This error happens with very few installations and I don't know the reason.
Note that I am the first one wishing to fix it.
Note that I am the first one wishing to fix it.
fotofriendly
Member
If I saved Deliveries & Lists ...can I paste them back into a fresh install?
Thought this might help to clear the issue...
Thought this might help to clear the issue...
jgoodnough
New Member
O.k. Here's the details of my experience.
I was unable to use the "install MLM" menu feature in MBM. It would not complete the install on my ISP's server. Close but no cigar. I also found it necessary to change the hostname to "localhost" because I was unable to communicate with the server until I made that change. Once I did I was able to run the INIT command and the database and tables were created without any problems. I used the "recipients/upload to server" command to upload a double opt-in list I collected through iContact (I'm soooo done with them!) to the new mysql db. That worked fine. I also added a second db of ongoing customers that are not double opt-in and I segregate for that purpose. A short while after uploading the db's I began receiving error message emails that said "1146: Table 'actona6_aalm.tbl_mlm_sub_clk_test' doesn't exist" The time between messages varied from 20-30 seconds to 10-12 minutes. I began to wonder if something I was doing locally on my computer was provoking it. I was in the middle of creating an HTML based email to send to a sub-set of my double-opt-in list. The emails continued to ring-in until I had 17 of them. At that point I decided I had to take action to stop them so I went into preferences in MBM and deactivated "click through tracking" which was set on automatic. The error emails ceased immediately after that.
This morning after a restart I reactivated "click through tracking" and I haven't gotten any more error emails so far. I have not been able to send a test message either to see if tracking is working but hopefully it will be o.k.
I guess my question is wouldn't the INIT command have created the table for all the data it needed at the same time it created the db file?
I was unable to use the "install MLM" menu feature in MBM. It would not complete the install on my ISP's server. Close but no cigar. I also found it necessary to change the hostname to "localhost" because I was unable to communicate with the server until I made that change. Once I did I was able to run the INIT command and the database and tables were created without any problems. I used the "recipients/upload to server" command to upload a double opt-in list I collected through iContact (I'm soooo done with them!) to the new mysql db. That worked fine. I also added a second db of ongoing customers that are not double opt-in and I segregate for that purpose. A short while after uploading the db's I began receiving error message emails that said "1146: Table 'actona6_aalm.tbl_mlm_sub_clk_test' doesn't exist" The time between messages varied from 20-30 seconds to 10-12 minutes. I began to wonder if something I was doing locally on my computer was provoking it. I was in the middle of creating an HTML based email to send to a sub-set of my double-opt-in list. The emails continued to ring-in until I had 17 of them. At that point I decided I had to take action to stop them so I went into preferences in MBM and deactivated "click through tracking" which was set on automatic. The error emails ceased immediately after that.
This morning after a restart I reactivated "click through tracking" and I haven't gotten any more error emails so far. I have not been able to send a test message either to see if tracking is working but hopefully it will be o.k.
I guess my question is wouldn't the INIT command have created the table for all the data it needed at the same time it created the db file?
I believe I have found the problem. Download MLM v2.2.3 and upload the 'lm_functions.php' to your server.
jgoodnough
New Member
I downloaded the update and installed with no problems. Now however it seems all my tracking is gone. I sent a small group of messages (15) and tracking is not working for any of them. I did reactivate the tracking option in the prefs, but it seems not to have worked. Any suggestions on a course of action?
jgoodnough
New Member
I didn't say "deleted the tracking data". I said "reactivated the tracking option" in the MBM preferences. I had turned it off originally when I began to get the stream of error emails. Once I uploaded and installed the new version of lm.functions.php I turned the "click through tracking" pref back on so MLM would track when recipients had received and opened messages.
So to reiterate...at this point the new message that I sent out has no tracking data. This message was sent after I installed the new lm.functions.php patch. Nothing shows up in the tracking window at all. No message, no data. Older messages still do but not the new one.
So to reiterate...at this point the new message that I sent out has no tracking data. This message was sent after I installed the new lm.functions.php patch. Nothing shows up in the tracking window at all. No message, no data. Older messages still do but not the new one.