I am having a nightmare trying to fix something that has been working until recently, but suddenly stopped working.
I had a price comparison section on my site which read external xml files, inserted the values into the database, and then queried them in various ways.
I have been doing this sith simpleXML and I set up a cron job which worked perfectly. However last week something was done on the server as it stopped working. My webhost set the values to "on" to ensure that external xml files could be read: allow_url_fopenOnOn
I also requested the correct new syntax for the cron job since it no longer seemed valid which was provided to me.
So the methodology for this is:
Open a connection to the database
Drop the table where prices are going to be inserted
Create a new table for the prices to be inserted
Create a foreach loop
Read each xml file with simpleXML and insert the values into the table in the database
The cron job is set to occur every 5 minutes
It creates the table in the database but it doesn't insert the values
The scripting is correct because the values are inserted if I call the file manually
I can insert predefined values using the cron job, but it just wont insert the values from the xml files.
I have tested it over and over again and it is precisely the values from the xml files.
can someone please help! I'm going out of my mind