[solved] Regnow doesnt get updated
Board index / General Chat / Other Products / Ultimate Regnow Affiliate (Deprecated)
19 posts • Page 1 of 2 • 1, 2
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
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
- fahimw
- Verified Customer
- Posts: 163
- Joined: Mar 06, 2009 6 pm
- Reputation points: 0
same as your issue, I send email to support. I am still waiting for response.
Regards,
Ahmed
Regards,
Ahmed
- abyansoft
- Verified Customer
- Posts: 7
- Joined: Apr 04, 2009 1 pm
- Reputation points: 0
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...
I cannot stand more lose.
do not say write to support, I wrote and got useless response.
thanks...
- abyansoft
- Verified Customer
- Posts: 7
- Joined: Apr 04, 2009 1 pm
- Reputation points: 0
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
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
- mohamed
- Verified Customer
- Posts: 6
- Joined: Mar 17, 2009 11 pm
- Reputation points: 0
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
- Verified Customer
- Posts: 163
- Joined: Mar 06, 2009 6 pm
- Reputation points: 0
i still cannot update anyone can help please? admin..
- fahimw
- Verified Customer
- Posts: 163
- Joined: Mar 06, 2009 6 pm
- Reputation points: 0
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
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
- abyansoft
- Verified Customer
- Posts: 7
- Joined: Apr 04, 2009 1 pm
- Reputation points: 0
fahimw wrote: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
- roland
- Verified Customer
- Posts: 11
- Joined: Apr 15, 2008 3 am
- Reputation points: 0
wow thanks that worked 20 items added
- fahimw
- Verified Customer
- Posts: 163
- Joined: Mar 06, 2009 6 pm
- Reputation points: 0
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.
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.
- ermisoglu
- Verified Customer
- Posts: 6
- Joined: Apr 09, 2009 10 am
- Reputation points: 0
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
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
- Verified Customer
- Posts: 163
- Joined: Mar 06, 2009 6 pm
- Reputation points: 0
I have tried all these methods nothing works.
help please
help please
- fahimw
- Verified Customer
- Posts: 163
- Joined: Mar 06, 2009 6 pm
- Reputation points: 0
Hello,
any news from PhpSugar about that ?:(
any news from PhpSugar about that ?:(
- POSTiGA
- Verified Customer
- Posts: 6
- Joined: Jul 01, 2009 10 am
- Reputation points: 0
Please retry. We updated the database manually today.
PHP Melody v3.0
New Series Module? Publish series and episodes right from PHP Melody's Dashboard -->
https://demo.phpmelody.com/admin/series.php
New Series Module? Publish series and episodes right from PHP Melody's Dashboard -->
https://demo.phpmelody.com/admin/series.php
-
Andrew - Founding Developer
- Posts: 7504
- Joined: Jul 07, 2007 1 pm
- Reputation points: 428
19 posts • Page 1 of 2 • 1, 2
Who is online
Users browsing this forum: No registered users and 11 guests