Author Topic: 1.86 error --- Unknown column 'addopts' in 'field list' (Read 2925 times)

Angler · « **on:** March 21, 2006, 05:14:00 am »

Hi Dean,

My LMP is not accessible. I receive the response:

Unknown column 'addopts' in 'field list'

Any ideas?

BGSWebDesign · « **Reply #1 on:** March 21, 2006, 08:31:55 am »

Hi,

I think you should post this under the: "v1.86 Testing" thread that is in Suggestions, Comments, Development.

That is where it belongs, it is for discussing bugs/issues with v. 1.86 - DW will probably move it, but in the future - you should post the issues there...

Good luck - seems there is a slight bug in v. 1.86... so far...

DW · « **Reply #2 on:** March 21, 2006, 11:49:13 am »

The correct SQL query is definitely in the upgrade script:

Code: [Select]

mysql_query("ALTER TABLE $ltable ADD addopts VARCHAR(100) NOT NULL;");

What I suspect is happening is that your host does not allow you to use the ALTER TABLE MySQL command and so this upgrade command failed. Please ask your host to give you the correct permission then submit your info to me so I can make sure your database is in order...

I think in the future I should do a "permission check" before upgrade operations...

Regards

bhl007 · « **Reply #3 on:** March 22, 2006, 06:34:41 am »

:cry:

the exactly same error happen to me once I login..

Am waiting for the host to do it.

Angler · « **Reply #4 on:** March 22, 2006, 06:42:03 am »

I have my own server.. but the problem resolved itself. Go figure!

Maybe the script wasn't completely installed. Dunno.. when I logged in later, the script updated itself and it works!

Bounce still doesn't work.

Dean, what's the charge for just setting up my bounce feature? I'm running a CPANEL and WHM server.

bhl007 · « **Reply #5 on:** March 22, 2006, 07:31:38 am »

Ya, you are right. I just restarted the computer, and login again, at this time I saw this message.

Upgrade detected!
Please wait while your database is updated
It is very important that you do not interrupt this process
DB Version: 1.85 New DB Version: 1.86
Done!

happy to see that, but will this "Unknown column 'addopts' in 'field list' " message create problems in the future mailing?

And, bounce back I'm not sure yet, since my dailymail haven't reach the time.

Dean, I already submit ticket for you to go in and double check the database and mysql

Besides, the new features"Loop followups. Automatically reset users at end of sequence to first followup each day before dailymail"

If I setup my 7 days follow up, and tick this feature. Does it means that after 7 days it will loop back to the first message and all subscriber in this list will receive again starting from first message?

If yes, then it can loop forever right? the loop will stop only when uncheck this feature right?

Great.

DW · « **Reply #6 on:** March 22, 2006, 10:11:44 pm »

I forgot to mention that the error could also occur if you fail to browse to the Login page to automatically update the database after replacing your files.

If you do not see the error when browsing to the List Settings page there should be no future related problems.

Quote

Dean, what's the charge for just setting up my bounce feature? I'm running a CPANEL and WHM server.

This would probably take me all of 2 minutes, but you could donate a few bucks if you like. Send me access info by email. Note that providing "/usr/bin/wget" is available you should be able to set up bounce.cgi under CPanel quite easily with the help files:
http://listmailpro.com/help/cgi_cpanel.html

Quote

If I setup my 7 days follow up, and tick this feature. Does it means that after 7 days it will loop back to the first message and all subscriber in this list will receive again starting from first message?

Each user will be reset when they reach the end of the list independently of other users.

Quote

If yes, then it can loop forever right? the loop will stop only when uncheck this feature right?

Yes, it will loop continuously for all users as they reach the end of sequence. With a delay of 0 for all messages users should receive one message per day without a break.

Regards

Angler · « **Reply #7 on:** March 23, 2006, 04:52:19 am »

Quote

Dean, what's the charge for just setting up my bounce feature? I'm running a CPANEL and WHM server.

This would probably take me all of 2 minutes, but you could donate a few bucks if you like. Send me access info by email. Note that providing "/usr/bin/wget" is

-------------------------

Done! Check your PayPal account!

bhl007 · « **Reply #8 on:** March 24, 2006, 04:30:06 am »

minor error:

once I add in a new list, I browse current list, can find my list

However, after logout and login again, can't find the list

I then have to browse other list in Current List: , then only can see

the newly created list

Besides, if a list don't have follow up at all and I want to add in

the saved set from other list, it will show up nothing, i have to try

2nd time to get the saved set appear in drop down box for me to

choose

Also, once I add followup to the list and save, it do appear.

But later when I came back, the followup disappear.
Sometimes refresh a few times later will appear again..
It seems that it already save to database, but not show up at the

interface here...

SOmetimes 2 same follow up appear, i delete one of them, and click on

Followups again, but found that it still appear, delete again, it

come out error:

Error: Followup not found (already deleted?)

DW · « **Reply #9 on:** March 25, 2006, 01:06:20 am »

Is this a new occurrence with your regular browser which never before had troubles?

If non-standard, may I ask what browser, OS, and cache settings you are accessing ListMail with?

Are you accessing the web through a proxy server?

This very much seems like a caching issue. If it is widespread, which I don't (yet) believe it is, it may be able to be fixed with some PHP cache settings... I will need to recreate the issue, however, in order to prove that anything was fixed - and I can't seem to do that from here as of yet.

With no intention of downplaying or skirting this issue I have not received any similar reports with the new version. While I'm not sure if very many users are running it yet I do know of a few who have reported it working as expected.

Please send me more information about your browsing method and I will do my best to solve (or at least explain) the problem.

Regards

bhl007 · « **Reply #10 on:** March 25, 2006, 06:18:05 am »

Hi,

I use Firefox
Never use proxy
caching and cookie setting are default setting.

Yes, never before happen in the older version of LMP.

Problem: I'm not sure whether is caching problem, i thought is the database update already, but some area not shown.

I do clear cache before, same problem happen.

For example: xyz (I think I will put it in flash video file to let u watch. Hard to describe here...)

new update>>> weird, at the moment i try to find out the problem, no problem happen at all...

I have to wait until having problem, then can capture the screen activity to you.

DW · « **Reply #11 on:** March 28, 2006, 09:34:41 am »

Albert,

Quote

I suspect it's the Google Web Accelerator Software that I install that cause this problem...

Yes, I believe Google Web Accelerator is the problem here. I suspect that it enables far more caching than your browser default. Is there any way you can turn it off just for LMP?

Quote

Btw, if in list 1 I need to have 2 followup at day 1, should I put the * * * at both column or no need to put * * * in both column

Two followups on one day is only possible in v1.86. When saving a followup set up for this, with a duplicate seq #, the other followup cron and delay will be automatically updated so they are the same. Therefore, it should not be possible to set the cron and delay to different values for followups on the same day.

Regards

bhl007 · « **Reply #12 on:** March 28, 2006, 04:16:00 pm »

I have already uninstall Google Web Accelerator.

It not only causing problem in LMP, but also forum(not able to login)

thanks.

bhl007 · « **Reply #13 on:** April 04, 2006, 07:51:50 am »

Hi, found that the follow up using duplicate sequence not working

List 2: ListName
97 total users (0 new), 0 followups sent

For this list, I use daily followup (7 day message), then loop back to the beginning of the sequence.

I want 2 message to be send out every day, thus I use duplicate sequence.
But, the follow up of this list stop working...

Help
:cry:

--------
Also, the When 100% of users are at end of sequence reset users and load saved set * setName

what if at that particular list don't have followup at all, will the script still make it go to load the saved set?
-------

DW · « **Reply #14 on:** April 04, 2006, 10:16:36 am »

Quote

Hi, found that the follow up using duplicate sequence not working

List 2: ListName
97 total users (0 new), 0 followups sent

For this list, I use daily followup (7 day message), then loop back to the beginning of the sequence.

I just tested this with 4 followups (2 seq #s, 1 and 2) and Loop Followups enabled. Running dailymail many times resulted in two followups every day as expected.

I think there might be a problem with Daylight Savings Time taking effect in the spring causing dailymail to be skipped a day. This might happen if the new 23h 55m limit on dailymail is incorrectly calculated.

If you think it's necessary I can troubleshoot your reported problem further with access.

Regards