Contribution Tracker
#41
Posted 12 September 2007 - 02:03 PM
You should revert back to version 1.5.5. It seems like curl is not enabled on your server. I will update the contrib with curl versions and no curl versions. i appologize for any inconvenience. I would guess you could go to admin/server_info and see if curl is enabled. You could also ask your server to turn curl on as from what I read is more secure than fopen.
lildog
#42
Posted 12 September 2007 - 02:05 PM
mrcrowley, on Sep 12 2007, 12:02 AM, said:
Warning: fopen(/catalog/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 23
Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 24
Warning: fclose(): supplied argument is not a valid stream resource in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 29
could not open XML input
WOW. I will look into those errors later today.
#43
Posted 12 September 2007 - 02:44 PM
lildog, on Sep 12 2007, 04:03 PM, said:
You should revert back to version 1.5.5. It seems like curl is not enabled on your server. I will update the contrib with curl versions and no curl versions. i appologize for any inconvenience. I would guess you could go to admin/server_info and see if curl is enabled. You could also ask your server to turn curl on as from what I read is more secure than fopen.
lildog
#45
Posted 28 September 2007 - 11:29 PM
lildog
#46
Posted 29 September 2007 - 12:58 PM
Quote
Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in /home/oscommer/public_html/new/admin/includes/functions/contrib_tracker.php on line 24
en http://www.oscommerce.com osCommerce, Open Source E-Commerce Solutions Copyright © 2007 osCommerce hpdl@oscommerce.com http://www.oscommerce.com/images/oscommerce_88x31.gif http://www.oscommerce.com http://addons.oscommerce.com/info/5198 Sat, 29 Sep 2007 07:42:47 -0400 http://addons.oscommerce.com/info/5272
habe diese tolle constrib mal installiert und bin echt begeistert
die Sprachdateien sind teilweise unvollständig gewesen. Ich habe versucht diese zu ergänzen
ein kleiner Bug in adminbereich behoben wenn Fehlermeldung
"1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '-20, 20' at line 1"
in admin/link.php
finde:
$where = '';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;
und ersetze durch:
$where = ' where ';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
else if ($showLinkStatus == 'All')
$where = '';
if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order;
]]> Sat, 29 Sep 2007 06:58:33 -0400 http://addons.oscommerce.com/info/3904 Sat, 29 Sep 2007 06:42:45 -0400 http://addons.oscommerce.com/info/5229 Fri, 28 Sep 2007 20:20:59 -0400 http://addons.oscommerce.com/info/4815
This version uses uses fopen if curl lib is not available. I also fixed a couple of problems with the links in the admin part. if a link was empty or not a url errors were generated. Moved functions to fuctions file. When clicking a contrib name in admin it now opens anew window to load OSCommerce page for that contribution.
]]> Fri, 28 Sep 2007 19:25:02 -0400 http://addons.oscommerce.com/info/5448 Fri, 28 Sep 2007 13:54:43 -0400 http://addons.oscommerce.com/info/5422 Fri, 28 Sep 2007 13:43:20 -0400 http://addons.oscommerce.com/info/4397 The email received to admin had no subject and message. The reason was with "require (file name)".
I have just moved the line 76 to the top and uploaded the file "product_reviews_write.php" under catalog.
All credit goes to the original contributor.
Great work! Thanks,
]]> Fri, 28 Sep 2007 03:31:46 -0400 http://addons.oscommerce.com/info/5241 It will bring every new register member to the confirmation page along with the code,
this open the system for new member using a false email.
This update will fix so they could only use the link in their email.
Run this update AFTER you have Auto Fill Activation Code Installed!]]> Fri, 28 Sep 2007 03:23:24 -0400 http://addons.oscommerce.com/info/5300 Thu, 27 Sep 2007 22:56:09 -0400 http://addons.oscommerce.com/info/4269
This is a full package. Upgrade instructions assume version 3.2 is installed.]]> Thu, 27 Sep 2007 21:12:48 -0400 http://addons.oscommerce.com/info/4715
1) Acceso al admin del TPV desde el mismo modulo de pago.
2) Ya no se perderan mas los pedidos, ya que el proceso de notificación funciona perfectamente. Aunque no vuelvan a la tienda este pedido se guardará.
3) Nuevo campo de terminal para poder aceptar los dos terminales por excelencia el 1 y el 2 que segun la sucursal puede cambiar. Esto permitirá a la vez trabajar con casi cualquier modulo de servired, con terminal 1 y 2 exceptuando los que trabajen con la firma antigua que cada vez son menos...
Para dudas, errores o informacion, mi mail/msn (atencion_clientes@hotmail.com)
Saludos desde Barcelona España.]]> Thu, 27 Sep 2007 20:48:35 -0400 http://addons.oscommerce.com/info/3998
Change in..
Admin/configure.php and html_output.php. It works for me anyway.
It is just a small txt file inside zip.
Thanks to previous guys.]]> Thu, 27 Sep 2007 18:35:38 -0400 http://addons.oscommerce.com/info/5350
If upgrading from a previous version, the column products_abfs_class in the products table needs to be modified to store up to 6 characters.]]> Thu, 27 Sep 2007 17:04:15 -0400 http://addons.oscommerce.com/info/3661 Thu, 27 Sep 2007 01:09:56 -0400
Warning: fclose(): supplied argument is not a valid stream resource in /home/*****/public_html/*****/admin/includes/functions/contrib_tracker.php on line 29
could not open XML input
anu ideas???
Thanks
Mark
#47
Posted 29 September 2007 - 02:53 PM
#48
Posted 30 September 2007 - 03:45 AM
Let me know if this works.
lildog
#49
Posted 30 September 2007 - 04:33 AM
lildog, on Sep 30 2007, 03:45 AM, said:
Let me know if this works.
lildog
I am getting the same problem as above:
Warning: fopen(/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in /homepages/21/d202393536/htdocs/wii/Backup/includes/functions/contrib_tracker.php on line 23
Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in /homepages/21/d202393536/htdocs/wii/Backup/includes/functions/contrib_tracker.php on line 24
There is nothing in my rsscache folder. Here is the full code:
Warning: fopen(/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in /homepages/21/d202393536/htdocs/wii/Backup/admin/includes/functions/contrib_tracker.php on line 23
Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in /homepages/21/d202393536/htdocs/wii/Backup/admin/includes/functions/contrib_tracker.php on line 24
en [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] osCommerce, Open Source E-Commerce Solutions Copyright © 2007 osCommerce hpdl@oscommerce.com [url="http://www.oscommerce.com/images/oscommerce_88x31.gif"]http://www.oscommerce.com/images/oscommerce_88x31.gif[/url] [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] [url="http://addons.oscommerce.com/info/1484"]http://addons.oscommerce.com/info/1484[/url]
this contribution messes up OSC in unexpected ways.
all pages displaying thumbnails will generate a HTTP error 500 (Internal Server Error) on machines running the latest PHP (5.2.4)
you won't get the error in a browser, but all robots will be snubbed.
test before using!]]> Sat, 29 Sep 2007 18:17:46 -0400 [url="http://addons.oscommerce.com/info/1558"]http://addons.oscommerce.com/info/1558[/url] Sat, 29 Sep 2007 16:13:30 -0400 [url="http://addons.oscommerce.com/info/2896"]http://addons.oscommerce.com/info/2896[/url]
===============================
Hi.. i would like to know what is cron & where to set it automatically? i've search in the forum regarding this great contribution but i couldnt find it.. pls help
thanx
no file attached!]]> Sat, 29 Sep 2007 13:04:01 -0400 [url="http://addons.oscommerce.com/info/1077"]http://addons.oscommerce.com/info/1077[/url]
I've attached an updated CGIF class which is available from [url="http://sourceforge.net/tracker/index.php?func=detail&aid=1537502&group_id=114602&atid=668888"]http://sourceforge.net/tracker/index.php?f...amp;atid=668888[/url]]]> Sat, 29 Sep 2007 10:50:20 -0400 [url="http://addons.oscommerce.com/info/5272"]http://addons.oscommerce.com/info/5272[/url]
habe diese tolle constrib mal installiert und bin echt begeistert
die Sprachdateien sind teilweise unvollständig gewesen. Ich habe versucht diese zu ergänzen
ein kleiner Bug in adminbereich behoben wenn Fehlermeldung
"1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '-20, 20' at line 1"
in admin/link.php
finde:
$where = '';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;
und ersetze durch:
$where = ' where ';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
else if ($showLinkStatus == 'All')
$where = '';
if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order;
]]> Sat, 29 Sep 2007 06:58:33 -0400 [url="http://addons.oscommerce.com/info/3904"]http://addons.oscommerce.com/info/3904[/url] Sat, 29 Sep 2007 06:42:45 -0400 [url="http://addons.oscommerce.com/info/5229"]http://addons.oscommerce.com/info/5229[/url] Fri, 28 Sep 2007 20:20:59 -0400 [url="http://addons.oscommerce.com/info/4815"]http://addons.oscommerce.com/info/4815[/url]
This version uses uses fopen if curl lib is not available. I also fixed a couple of problems with the links in the admin part. if a link was empty or not a url errors were generated. Moved functions to fuctions file. When clicking a contrib name in admin it now opens anew window to load OSCommerce page for that contribution.
]]> Fri, 28 Sep 2007 19:25:02 -0400 [url="http://addons.oscommerce.com/info/5448"]http://addons.oscommerce.com/info/5448[/url] Fri, 28 Sep 2007 13:54:43 -0400 [url="http://addons.oscommerce.com/info/5422"]http://addons.oscommerce.com/info/5422[/url] Fri, 28 Sep 2007 13:43:20 -0400 [url="http://addons.oscommerce.com/info/4397"]http://addons.oscommerce.com/info/4397[/url] The email received to admin had no subject and message. The reason was with "require (file name)".
I have just moved the line 76 to the top and uploaded the file "product_reviews_write.php" under catalog.
All credit goes to the original contributor.
Great work! Thanks,
]]> Fri, 28 Sep 2007 03:31:46 -0400 [url="http://addons.oscommerce.com/info/5241"]http://addons.oscommerce.com/info/5241[/url] It will bring every new register member to the confirmation page along with the code,
this open the system for new member using a false email.
This update will fix so they could only use the link in their email.
Run this update AFTER you have Auto Fill Activation Code Installed!]]> Fri, 28 Sep 2007 03:23:24 -0400 [url="http://addons.oscommerce.com/info/5300"]http://addons.oscommerce.com/info/5300[/url] Thu, 27 Sep 2007 22:56:09 -0400 [url="http://addons.oscommerce.com/info/4269"]http://addons.oscommerce.com/info/4269[/url]
This is a full package. Upgrade instructions assume version 3.2 is installed.]]> Thu, 27 Sep 2007 21:12:48 -0400 [url="http://addons.oscommerce.com/info/4715"]http://addons.oscommerce.com/info/4715[/url]
1) Acceso al admin del TPV desde el mismo modulo de pago.
2) Ya no se perderan mas los pedidos, ya que el proceso de notificación funciona perfectamente. Aunque no vuelvan a la tienda este pedido se guardará.
3) Nuevo campo de terminal para poder aceptar los dos terminales por excelencia el 1 y el 2 que segun la sucursal puede cambiar. Esto permitirá a la vez trabajar con casi cualquier modulo de servired, con terminal 1 y 2 exceptuando los que trabajen con la firma antigua que cada vez son menos...
Para dudas, errores o informacion, mi mail/msn (atencion_clientes@hotmail.com)
Saludos desde Barcelona España.]]> Thu, 27 Sep 2007 20:48:35 -0400
Warning: fclose(): supplied argument is not a valid stream resource in /homepages/21/d202393536/htdocs/wii/Backup/admin/includes/functions/contrib_tracker.php on line 29
could not open XML input
#50
Posted 30 September 2007 - 10:54 AM
lildog, on Sep 30 2007, 04:45 AM, said:
Let me know if this works.
lildog
No file is being created in the rsscache folder, the permissions are set to 777.
Mark
#51
Posted 30 September 2007 - 11:36 PM
This is the line that is failing in admin/contrib_tracker.php:
vWritePageToFile('http://feeds.feedburner.com/osCommerce_Contributions?format=xml' DIR_WS_CATALOG. 'rsscache/contrib_rss.html');
I need to know what the value for DIR_WS_CATALOG. 'rsscache/contrib_rss.html' is on your system: on mine it is /catalog/rsscache/contrib_rss.html.
Here is the first couple of lines of the function that are failing. There is not much to fail here.
function vWritePageToFile($sHTMLpage, $sTxtfile ) {
$sh=curl_init($sHTMLpage);
$hFile=fopen($sTxtfile, 'w');
$sHTMLpage is the OSCOmmerce feed url it is correct unless you changed it.
$sTxtfile is DIR_WS_CATALOG. 'rsscache/contrib_rss.html make sure this is the correct path
curl_init($sHTMLpage)- When I looked this up it suggest trying a trailing slash on some servers. SO try this:
change: admin/includes/functions/contrib_tracker.php
vWritePageToFile('http://feeds.feedburner.com/osCommerce_Contributions?format=xml' DIR_WS_CATALOG. 'rsscache/contrib_rss.html');
to:
vWritePageToFile('http://feeds.feedburner.com/osCommerce_Contributions?format=xml' DIR_WS_CATALOG. 'rsscache/contrib_rss.html/');
And then there is fopen($sTxtfile, 'w'); this creates and opens the file.
Carefully check your paths I believe this is the problem.
let me know
lidog
#52
Posted 01 October 2007 - 02:13 PM
It is working perfectly now, thank you
Mark
lildog, on Oct 1 2007, 12:36 AM, said:
This is the line that is failing in admin/contrib_tracker.php:
vWritePageToFile('http://feeds.feedburner.com/osCommerce_Contributions?format=xml' DIR_WS_CATALOG. 'rsscache/contrib_rss.html');
I need to know what the value for DIR_WS_CATALOG. 'rsscache/contrib_rss.html' is on your system: on mine it is /catalog/rsscache/contrib_rss.html.
Here is the first couple of lines of the function that are failing. There is not much to fail here.
function vWritePageToFile($sHTMLpage, $sTxtfile ) {
$sh=curl_init($sHTMLpage);
$hFile=fopen($sTxtfile, 'w');
$sHTMLpage is the OSCOmmerce feed url it is correct unless you changed it.
$sTxtfile is DIR_WS_CATALOG. 'rsscache/contrib_rss.html make sure this is the correct path
curl_init($sHTMLpage)- When I looked this up it suggest trying a trailing slash on some servers. SO try this:
change: admin/includes/functions/contrib_tracker.php
vWritePageToFile('http://feeds.feedburner.com/osCommerce_Contributions?format=xml' DIR_WS_CATALOG. 'rsscache/contrib_rss.html');
to:
vWritePageToFile('http://feeds.feedburner.com/osCommerce_Contributions?format=xml' DIR_WS_CATALOG. 'rsscache/contrib_rss.html/');
And then there is fopen($sTxtfile, 'w'); this creates and opens the file.
Carefully check your paths I believe this is the problem.
let me know
lidog
#53
Posted 01 October 2007 - 02:52 PM
Thank you for your reply. Where was the path wrong and is this something I could make more user friendly in the contrib so others do not encounter the same problem or just make more clear in the install intructions?
mark27uk3, on Oct 1 2007, 02:13 PM, said:
It is working perfectly now, thank you
Mark
#54
Posted 01 October 2007 - 07:50 PM
lildog, on Oct 1 2007, 03:52 PM, said:
Thank you for your reply. Where was the path wrong and is this something I could make more user friendly in the contrib so others do not encounter the same problem or just make more clear in the install intructions?
My path was set incorrectly in catalog/configure.php
Maybe it would be worth putting an example of an absolute url in the install docs just to reinforce the point.
Mark
#55
Posted 02 October 2007 - 12:21 AM
mark27uk3, on Oct 1 2007, 07:50 PM, said:
Maybe it would be worth putting an example of an absolute url in the install docs just to reinforce the point.
Mark
I still can't get it to work. I don't know what you did to get the paths correct. I am running OSC 2.2 rc1. I don't have a catalog/configure.php file. I do have a catalog/includes/configure.php file.
Can you clue me in to what you did to correct this?
Thanks
Lionel
#56
Posted 02 October 2007 - 06:46 AM
Thanks
#57
Posted 02 October 2007 - 07:06 AM
Ok open your catalog/admin/includes/configure.php and look for DIR_WS_CATALOG and change it too this:
define('DIR_WS_CATALOG', '/home/myaccountname/public_html/'); // absolute path required
Obviously make sure you change the account name to mactch your own.
Mark
#58
Posted 02 October 2007 - 08:22 AM
What I did was change all instances of
DIR_WS_CATALOG. 'rsscache/contrib_rss.html
with
DIR_FS_CATALOG. 'rsscache/contrib_rss.html
Which I think does the same thing as you have done.
But now I got this error.
I'm using RC1.
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/***/public_html/shop/admin/contrib_tracker.php on line 331 Warning: reset() [function.reset]: Passed variable is not an array or object in /home/***/public_html/shop/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/***/public_html/shop/admin/includes/classes/object_info.php on line 18
#59
Posted 02 October 2007 - 09:43 AM
#60
Posted 02 October 2007 - 12:08 PM
Anyways to fix it this is what I did
In catalog & admin / contrib_tracker.php
I changed all instances of
DIR_WS_CATALOG. 'rsscache/contrib_rss.html
to
DIR_FS_CATALOG. 'rsscache/contrib_rss.html
There was 6 in total
For the PHP5 thing, in admin/contrib_tracker.php
I changed
$sInfo_array = array_merge($admin_quer, '');
To
$sInfo_array = array_merge((array)$admin_quer);
Seems to be working ok now









