- Posts: 41
- Thank you received: 0
MarvinG wrote: Dima, i don't know whether i have it right, i try to set this in phpmyadmin as an event.
The command line you give me above, its for sql isn't it? So where to run it? I'm really null at sql & cron
i put: DELETE FROM f58dq_zhgooglemaps_markers WHERE createddate < NOW() - UNIX_TIMESTAMP(createddate) > 60
It is not accepting it.
---
If i creat a php file with the command and point cron to it, where should the php file be stored?
Please Log in or Create an account to join the conversation.
MarvinG wrote: Ok i just contact my host provider and they told me : It is the same, triggers, procedures, events or similar *automatic* queries are not permitted. This requires root privileges to be created in the mysql server.
So what option remains?
MarvinG wrote: Dima, i don't know whether i have it right, i try to set this in phpmyadmin as an event.
The command line you give me above, its for sql isn't it? So where to run it? I'm really null at sql & cron
i put: DELETE FROM f58dq_zhgooglemaps_markers WHERE createddate < NOW() - UNIX_TIMESTAMP(createddate) > 60
It is not accepting it.
---
If i creat a php file with the command and point cron to it, where should the php file be stored?
Please Log in or Create an account to join the conversation.
MarvinG wrote: Latest update from my host provider: Hi there, No, it should work with cronjob. Just make a script that would delete the specific record you need and set the cronjob to execute the specific script.
Can you help me by giving me an example how to do it? I've been searching google for it and till now i can't find a clear explanation about how to do it.
MarvinG wrote: Ok i just contact my host provider and they told me : It is the same, triggers, procedures, events or similar *automatic* queries are not permitted. This requires root privileges to be created in the mysql server.
So what option remains?
MarvinG wrote: Dima, i don't know whether i have it right, i try to set this in phpmyadmin as an event.
The command line you give me above, its for sql isn't it? So where to run it? I'm really null at sql & cron
i put: DELETE FROM f58dq_zhgooglemaps_markers WHERE createddate < NOW() - UNIX_TIMESTAMP(createddate) > 60
It is not accepting it.
---
If i creat a php file with the command and point cron to it, where should the php file be stored?
Please Log in or Create an account to join the conversation.
MarvinG wrote: My host provided help me with the cron command but how should the .php file looks like?
MarvinG wrote: Latest update from my host provider: Hi there, No, it should work with cronjob. Just make a script that would delete the specific record you need and set the cronjob to execute the specific script.
Can you help me by giving me an example how to do it? I've been searching google for it and till now i can't find a clear explanation about how to do it.
MarvinG wrote: Ok i just contact my host provider and they told me : It is the same, triggers, procedures, events or similar *automatic* queries are not permitted. This requires root privileges to be created in the mysql server.
So what option remains?
MarvinG wrote: Dima, i don't know whether i have it right, i try to set this in phpmyadmin as an event.
The command line you give me above, its for sql isn't it? So where to run it? I'm really null at sql & cron
i put: DELETE FROM f58dq_zhgooglemaps_markers WHERE createddate < NOW() - UNIX_TIMESTAMP(createddate) > 60
It is not accepting it.
---
If i creat a php file with the command and point cron to it, where should the php file be stored?
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
© 2011- Жук Це-Це. Design by Dmitry Zhuk