Community Forum

If you have questions about my software, chances are this forum has the answers.

You'll need to register before you can post on the forum to ask your question or to answer another one. A reply will be posted to each and every question that is asked so there is no need to double post or bump your post. I do my best to answer promptly but in some cases it may take a day or two. If you bump your post, it may be removed. Bear with me and I`ll get your question answered quickly.

Here are a few tips to help you to get your questions answered more rapidly.

IMPORTANT: Posts in English only. I don't have a translator and I'll be unable to understand your message properly and will probably delete it.
SEARCH: Use the search option to see if your question has been answered on the forum before now or if there is an answer in the documentation of your software.
PERSONAL SUPPORT: If you have purchased a commercial version of any software, using the contact option at the licence centre ensures a faster response.
AUTO DELETION: Accounts older than 5 days, with no posts or topics, are automatically deleted. Only register if you are thinking of posting.
LINKS: Any links posted are not clickable and must be copied / pasted into your browser address bar.

You are not logged in.

#1 gcut76 17-10-2019 20:43:29

I just installed the script and everything seems fine, the crons are set and work properly, except for the follow up mailing. My server timezone and the sofware are the same (gmt+2) but it seems that the script is about 2h earlier. Do I need to set up something in the messages.php file?

Thanks a lot
Giacomo

#2 msworld 18-10-2019 07:35:00

Do you have the correct timezone in the settings?

#3 gcut76 18-10-2019 17:36:12

Yep! Gmt+2 timezone on my vps and even on the script settings.

If I use GMT it works properly, but is not my timezone

Last edited by gcut76 (18-10-2019 17:37:48)

#4 msworld 21-10-2019 01:44:06

It does sound like the crons are running on a different timezone.

#5 gcut76 21-10-2019 05:03:06

Actually I'm making the tests just running the php files.

I made a test even with the crons, and the other functions work fine (broadcasts and bouncers).
If the crons are running on different timezone wouldn't also fail the other two files?

Last edited by gcut76 (21-10-2019 05:09:49)

#6 msworld 22-10-2019 05:30:09

What about the mysql timezone? Is that the same as your PHP timezone?

In the 'control/connect.php' file add the timezone adjustment:

define('DB_TIMEZONE', '+02:00');

or set it to a blank value:

define('DB_TIMEZONE', '');

Does that make any difference?

#7 gcut76 22-10-2019 16:44:33

Yep!

mysql timezone is the same as my system timezone (gmt+2)

I already set different values (including the blank one) with that line: not a difference at all.

sad sad sad

I live in Paris (now is actually GMT+2) but in the settings I have set Paris GMT+1

The only way I get this working is setting GMT -1 - pretty odd indeed

Last edited by gcut76 (22-10-2019 16:49:05)

#8 msworld 23-10-2019 05:05:01

Strange. I can`t see anything wrong on my test setups, so unsure at the moment what is causing the problem.

#9 gcut76 23-10-2019 18:39:36

Pretty strange indeed. Here's some pics:

https://i.ibb.co/CmYBw8f/01.png
https://i.ibb.co/t34QvmV/02.png
https://i.ibb.co/SBzpFS6/03.png

Everything seems fine, exept for the follow up

Last edited by gcut76 (23-10-2019 18:40:08)

#10 mirkosabia 24-10-2019 21:04:03

Hi guys, I got the same problem here. I have installed Maian Responder on my hosting service, the time displays correctly but the follow up feature is not working properly: I set an email to be sent immediately and one to be sent after 1 day, but the email is sent after 22 hours. Not a biggie, but still.

This is a great script anyways! I love it!!!

#11 msworld 25-10-2019 16:49:12

Thanks, glad you like it. I'm afraid I'm not sure what the issue is. I have messages regularly running on my test servers and they all come through ok. I'll run some more tests with the next update.

#12 gcut76 31-10-2019 06:32:39

Hi David,

I've been making some tests on the offset settings in the connect.php file, and I see that the delay values like -01:00, -02:00 are working fine, but the advance values (like mine - that now is +01:00) doesn't

Maybe that's the issue?

#13 msworld 31-10-2019 16:38:45

Possibly. You would need to run some tests with your database to see why the + values don't work.

#14 mirkosabia 01-11-2019 09:55:08

I'm trying the software on three different hosting services, and the same issue comes. I think I will give up.
I will check if it will work for me in the future with some updates.

Thanks a lot for your time David!

#15 gcut76 01-11-2019 09:58:43

I really don't know what to check, is it possible that + values don't work? What could be the issue?

#16 msworld 01-11-2019 10:31:30
gcut76 wrote:

I really don't know what to check, is it possible that + values don't work? What could be the issue?

Ok, let's see what happens:

Create a test file, call it 'test.php' with the following:

<?php

include(dirname(__file__) . '/control/connect.php');
include(dirname(__file__). '/control/classes/class.db.php');

$DB       = new db();
$DB->db_conn();

$q = $DB->db_query("SELECT CURDATE() AS `d`, CURTIME() AS `t` FROM `" . DB_PREFIX . "settings`");
echo '<pre>' . print_r($DB->db_object($q), true) . '</pre>';

$q = $DB->db_query("SET `time_zone` = '+01:00'");
$q = $DB->db_query("SELECT CURDATE() AS `d`, CURTIME() AS `t` FROM `" . DB_PREFIX . "settings`");
echo '<pre>' . print_r($DB->db_object($q), true) . '</pre>';

?>

Upload next to the index.php and access in your browser. Play around with the timezone setting. What do you see? It will be something like:

stdClass Object
(
    [d] => 2019-11-01
    [t] => 10:30:04
)
stdClass Object
(
    [d] => 2019-11-01
    [t] => 11:30:04
)
#17 gcut76 01-11-2019 17:14:22

Thank you for your help!

Here's what happens:

-- first stdClass Object changes properly
-- second stdClass Object doesn't change

I tried both negative as positive values, all work fine with the first values, but the second does not change. Disabling the DB_TIMEZONE values they stay the same.

stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:13:26
)
stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:13:26
)
#18 mirkosabia 01-11-2019 17:44:44

I tried the same thing and changing the time_zone values inside the test.php file, on the contrary, changes properly the second value and doesn't edit the first one. Here's the code with +02:00 set

stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:44:29
)
stdClass Object
(
    [d] => 2019-11-01
    [t] => 19:44:29
)

Last edited by mirkosabia (01-11-2019 17:45:29)

#19 gcut76 01-11-2019 17:51:21
mirkosabia wrote:

I tried the same thing and changing the time_zone values inside the test.php file, on the contrary, changes properly the second value and doesn't edit the first one. Here's the code with +02:00 set

stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:44:29
)
stdClass Object
(
    [d] => 2019-11-01
    [t] => 19:44:29
)

Same here smile

#20 msworld 03-11-2019 11:23:09
gcut76 wrote:

Thank you for your help!

Here's what happens:

-- first stdClass Object changes properly
-- second stdClass Object doesn't change

I tried both negative as positive values, all work fine with the first values, but the second does not change. Disabling the DB_TIMEZONE values they stay the same.

stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:13:26
)
stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:13:26
)

So, it doesn't work on your server. I`m afraid I have no idea why. sad This isn't related to Maian Responder btw, you would get the same result running it directly on your server.

#21 msworld 03-11-2019 11:24:51
mirkosabia wrote:

I tried the same thing and changing the time_zone values inside the test.php file, on the contrary, changes properly the second value and doesn't edit the first one. Here's the code with +02:00 set

stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:44:29
)
stdClass Object
(
    [d] => 2019-11-01
    [t] => 19:44:29
)

Database bug? Daylight savings related? No idea at the moment.

#22 gcut76 03-11-2019 20:08:04
msworld wrote:
gcut76 wrote:

Thank you for your help!

Here's what happens:

-- first stdClass Object changes properly
-- second stdClass Object doesn't change

I tried both negative as positive values, all work fine with the first values, but the second does not change. Disabling the DB_TIMEZONE values they stay the same.

stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:13:26
)
stdClass Object
(
    [d] => 2019-11-01
    [t] => 18:13:26
)

So, it doesn't work on your server. I`m afraid I have no idea why. sad This isn't related to Maian Responder btw, you would get the same result running it directly on your server.


I don't get it, what timezone settings should I play with? The one on the test.php file or the one on the connect.php file? What /test.php proper behaviour should be?

#23 msworld 04-11-2019 01:15:09
gcut76 wrote:

I don't get it, what timezone settings should I play with? The one on the test.php file or the one on the connect.php file? What /test.php proper behaviour should be?

See my previous post for what you should expect to see. If you specify +02:00 for example, the second time should be two hours faster. The test was to see if the native mysql timeone adjustment was working for you, but you`ve confirmed it isn`t as both are the same. So, what causes that? Server restriction? Mysql issue? I have no idea.

#24 gcut76 04-11-2019 06:02:11
MSWORLD wrote:

If you specify +02:00 for example.

Where? On the test.php file or on the control/connect.php file?

#25 msworld 04-11-2019 06:13:35

You are confusing me. smile

In the test file of course as per the code I gave you in a earlier post. You said you ran it and it made no difference? The test file will at least tell you if it works. If it doesn't work in that, it won't work in the connection file.

#26 gcut76 04-11-2019 06:24:38

If I play with the time_zone settings in the test.php file it changes properly the second value:

Setting:

 "SET `time_zone` = '+01:00'" 

Result:

 stdClass Object
(
    [d] => 2019-11-04
    [t] => 07:20:03
)
stdClass Object
(
    [d] => 2019-11-04
    [t] => 07:20:03
) 

Setting:

 "SET `time_zone` = '+02:00'" 

Result:

 stdClass Object
(
    [d] => 2019-11-04
    [t] => 07:23:52
)
stdClass Object
(
    [d] => 2019-11-04
    [t] => 08:23:52
) 
#27 msworld 05-11-2019 12:12:25

So, this would do exactly the same as the setting in the connection file as it's the same code. It's standard sql syntax.

#28 gcut76 05-11-2019 20:38:44

Well it does work, but it changes the first value instead of the second one.

Setting:

 define('DB_TIMEZONE', '+01:00'); 

in the connect.php file and

 $q = $DB->db_query("SET `time_zone` = '+01:00'"); 

Results:

stdClass Object
(
    [d] => 2019-11-05
    [t] => 21:30:02
)
stdClass Object
(
    [d] => 2019-11-05
    [t] => 21:30:02
) 

and setting +02:00

stdClass Object
(
    [d] => 2019-11-05
    [t] => 22:30:51
)
stdClass Object
(
    [d] => 2019-11-05
    [t] => 22:30:51
) 

But the issue remains, regardless of which value I enter follow up are sent 1h earlier. The only way to make it work is by setting GMT (like London or Dublin) from the settings, but doing so make broadcasts 1h earlier - I'm going crazy

#29 msworld 06-11-2019 16:19:57

I`m not sure what to check next. Looks like it's not going to work for you. Sorry. sad

#30 gcut76 06-11-2019 20:37:11

Oh, jeez!

Well not a big deal anyway, I will figure out some workaround.

Anyway, this may be helpful: at some point, I got this error log:

Enabled: 6 November 2019 @ 20:54:21
Code: 1298
Error: Unknown or incorrect time zone: 'Europe/Rome'
File: /responder/control/classes/class.db.php
Line: 456
Query: 

SET `time_zone` = 'Europe/Rome'

Last edited by gcut76 (06-11-2019 20:39:34)

#31 msworld 07-11-2019 17:06:00

That means the timezone isn`t supported by your database. It's not Maian Responder related.

I`ll be starting a new update soon and will run some tests, so if I figure out what is going on I`ll let you know.

Board footer

Maian Script World - Free PHP Software for Personal or Business Use.
© 2003-2019 Maian Script World & David Ian Bennett.

2Checkout.com is an authorized reseller of goods and services provided by Maian Script World

Free PHP Software / Responsive PHP Scripts / Lightweight PHP Software / White Label PHP Software