[solved] Regnow doesnt get updated

[fahimw]

hi,

everytime i try to update it says database is up to date. while regnow is sending me emails about new items. can someone pls help.

thanks

[abyansoft]

same as your issue, I send email to support. I am still waiting for response.

Regards,

Ahmed

[abyansoft]

I used the script URA for one week, I paid $27, I lost almost $100 a day, due to bad support, and because of this issue of not updating!.

I cannot stand more lose.

do not say write to support, I wrote and got useless response.

thanks...

[mohamed]

read this
http://www.phpsugar.com/forum/viewtopic.php?f=9&t=2893

hi,
you can update directly from regnow.

1- find this line on file "admin/update.php" :
"define('_UPDATE_PATH','http://www.phpsugar.com/updates/regnowfeed.ura');"

2- replace it with this line:

"define('_UPDATE_PATH','http://dc1datafeed.regnow.com/srv/rs.aspx?&afid=XXXX');"
where XXXX is your Affiliate ID

Mohamed Abd Allah
http://www.4downloads.net

[fahimw]

I tried this and it loads but then crashes and it takes half an hour or so loading bt then it stops any ideas????????

[fahimw]

i still cannot update anyone can help please? admin..

[abyansoft]

start with empty ura_items table.

before you do anything I prefer to empty the ura_items table from phpmyadmin, this is to delete old obselete products.


use the same hack as above but instead of using the link from regnow

"define('_UPDATE_PATH','http://dc1datafeed.regnow.com/srv/rs.aspx?&afid=XXXX');"

use the csv file you get from regnow feed.

upload the csv file from regnow feed to your server, put it in the admin directory
the file is this CSV_Feed_xxxxxx.csv, put the name of the file as the update url.

"define('_UPDATE_PATH','CSV_Feed_xxxxxx.csv');"

xxxxx is your affiliate ID.

one other thing here make sure you change the line 95 in update.php to match the number of your affiliate digits:

$trialurl = substr($csv->getValue($row, 15), 0, strlen($trialurl)-5);

to
$trialurl = substr($csv->getValue($row, 15), 0, strlen($trialurl)-6);

since my affiliate number is six digits,

If yours is 5 digits, leave it as it is.

It worked for me this why.

The bad thing here, you have to download the file from regnow, then upload it to your server every couple of days.

regards

Ahmed

[roland]

I tried this and it loads but then crashes and it takes half an hour or so loading bt then it stops any ideas????????

sounds like 8Mb memory limit for the PHP script has been reached.

add the following to the top line of your update.php

ini_set("memory_limit","40M");


it may work with less memory, but I found 40Mb was good for me

Cheers
Roland

[fahimw]

wow thanks that worked 20 items added

[ermisoglu]

Should be more than 20 items. According to my calculations there are 6510 products are missing.
Can you tell me the count of your ura_items table?

select count(productid) from ura_items;

What I suggest here to drop your ura_items table and create it again with usdprice field varchar(7) because there are some products with price 1200.65 which needs more than 5 chars.

drop table ura_items;
create it as you see in the standart sql file with usdprice column varchar (7).

However rating,date hits,coupon etc fields will remain empty since regnow datafeed doesn't have that fields.

To solve all these problems I build 2 sql scripts toinsert those missing items and to delete the adscititious items. you can contact me if you would like to receive those scripts. ermisoglu@hotmail.com. With this you wont need to empty your table and loose the relevant fields.

Deniz.

[fahimw]

Hi ermisoglu

i tried it now and it says up to date you are right it is missing something.

i have sent you the email requesting for the sql code.

thanks

[fahimw]

I have tried all these methods nothing works.

help please

[POSTiGA]

Hello,

any news from PhpSugar about that ?:(

[Andrew]

Please retry. We updated the database manually today.

[POSTiGA]

Appreciate it