Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by KennethS

  1. After plucking out certain lines Ive come up with these being the main cause of the white screen, commenting them out fixes the 2 top tools but the density checker still does nothing at all:


    	else {
     $density_url = tep_db_prepare_input($HTTP_POST_VARS['density_url']);
     $use_meta_tags = tep_db_prepare_input($HTTP_POST_VARS['use_meta_tags']);
      $use_partial_total = tep_db_prepare_input($HTTP_POST_VARS['use_partial_total']);
     include(DIR_WS_FUNCTIONS . 'seo_density.php');
     $ttl_words = 0;	
     $dens = kda($density_url, $ttl_words, $use_meta_tags, $use_partial_total);



    I am also getting these 2 errors after commenting them out when using the Search Engine Position tool:


    Warning: fopen("http://www.google.com/search?as_q=enter+search+word(s)&num=10&hl=en&ie=UTF-8&btnG=Google+Search&as_epq=&as_oq=&as_eq=&lr=&as_ft=i&as_filetype=&as_qdr=all&as_nlo=&as_nhi=&as_occt=any&as_dt=i&as_sitesearch=&safe=images&start=0", "r") - Success in seo_google_position.php on line 44
    Unable to open remote file http://www.google.com/search?as_q=enter+search+word(s)&num=10&hl=en&ie=UTF-8&btnG=Google+Search&as_epq=&as_oq=&as_eq=&lr=&as_ft=i&as_filetype=&as_qdr=all&as_nlo=&as_nhi=&as_occt=any&as_dt=i&as_sitesearch=&safe=images&start=0. 
    Warning: Supplied argument is not a valid File-Handle resource in seo_google_position.php on line 107


    Atleast now we have narrowed it down to the problem code.


    Hope this helps,



  2. koltz I am having the exact same problem and my OSC is the current version only modified with about 50 contributions and a few tweaks of my own. I tried re-installing it completely from scratch and I had the same result, even re-uploaded all of the files again. Mine comes to a completely white page with no source whatsoever, so Im thinking it is some kind of incompatability with either something I have installed or PHP. Im still messing with this problem so if anyone else figures it out please let us know on here.


    Thanks in advance,


    Kenneth Southern

    ZDP Media Group Inc.

  3. PHP Version: 4.1.2 (Zend: 1.1.1)

    Oscommerce 2.2 MS2


    My files arent corrupt because everything else works perfectly. I've done quite a few modifications though but this seems to be seo_assistant.php not outputing anything. Someone earlier in this topic had the same problem it seems.

  4. no it did not at the time, I went ahead and as you said moved the table definitions to their correct file and added the require for database_tables.php.

    It still comes up as a blank white page for seo_assistant.php. It's really odd because it's not loading anything and Ive tried a couple different browsers with the same results.

  5. I think Jack is saying this support forum is for your basic OSC installation and addons offered here. Some work based on OSC (mostly patches and addons that can be found here) are floating around and it's too hard to keep track of or give support for something he does not use due to changes in the code he cant forsee.

  6. I seem to also be getting the same problem as Koltz, just a blank page for seo_assistant.php.


    Any ideas on a fix would be great.


    Also...Include the 2 Table definitions in your catalog/admin/application_top.php file. I had to do that to get OsCommerce to recognize that the Table's existed.




  7. Thanks,


    Ive already discovered the problem. It was a variable clashing and since there were 2 comments (tests) I made before I removed the code to display or post them it was displaying that number by default in my orders. Just incase anyone else has this problem I suggest completely disabling comments for the simple reason of the error and the obvious reason Acheron posted above.




  8. Nevermind, It's still broken, the problem is arising from this bit of code:


    WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'");


    If I delete these 2 lines (I dont use multilingual anyway) It works and even shows the products in a list etc.

    But after closer examination and creating a second bundle it combines all of the subproducts. In other words both bundles contain the exact same thing, which is a combination of things added seperatly too each. Any help with this line would be appreciated.

  9. I think you should definently release a new version, but heres a problem ive just ran into. For some odd reason my "comments" are displaying the number '2' in the box when a person checks out after installing this poll contrib. Is this something to have to do with conflicts of variables?

  10. Ive finally got it working. There is an error Im guessing with the syntax of some lines. If anyone else is having the same error I was having just ask (But be warned I dont use the stock level part of the code) and i will post the code I changed.


    Ive now hit the problem of Options/Attributes with the Bundle code. I have certain materials that have the option to be downloaded (Electronic Copy), and then an option for printed and sent to them (Hard Copy). However if I created bundles and they choose "Electronic Copies" they cannot download all of the internal parts of the bundle. Any solution to this other than zipping them all up?

  11. Hello,


    Ive had a chance to re-install it all, got the same error as before. Decided to try to bit of code from product_info.php and got pretty much the same error again.


    This product contains the following items:1064 - You have an error in your SQL syntax near 'WHERE pb.bundle_id = and language_id = '1'' at line 6

    SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb WHERE pb.bundle_id = and language_id = '1'

    [TEP STOP]


    Its a very odd problem, I inserted your exact code incase your wondering what code I used in product_info.php. The rest of the code I pulled from the contribution file "install_bundles.txt". Thanks for all your help!



  12. Ive already restored a backup of my code already but I can give you very close to the error. It was something like this:


    1064 - SQL Query Syntax Error near 'language_id = "1".


    Someone in the latter end of this thread was receiving the exact same error as me. It was in product_info.php in this code.


    INNER JOIN products_bundles pb


    ON pb.subproduct_id=pd.products_id


    WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'");



    It was giving the error on that last line. If you happen to not see any errors could you post that block of code from your product_info.php file and Ill give it one more try before putting it on the back burner.


    Thanks very much,


  13. Well, I took your advice and doublechecked "form_check.js.php" for the statement that is supposed to remove it but it was there. Everything else works perfectly and if that function refreshes the page correctly after changing the country, I would think the rest would work?

  14. Love the contrib. This may sound tedious but is there any way for to fix this problem with it, or maybe be fixed in a later release:


    You go to create account, you have Unites States/Alabama already selected.

    If you pick for instance Canada it automatically makes the Province Alberta,

    but if you pick for instance...France that has no state/province, it leaves Alabama in but turns it into a text box. Is there anyway to have this deleted like the password field?





  15. Hi All,


    Im getting this error while trying to enter a new product in the admin:


    ? 1064 - You have an error in your SQL syntax near 'where products_id = '0' and language_id = '1'' at line 1

    select products_head_title_tag fromproducts_description where products_id = '0' and language_id = '1'

    [TEP STOP]


    Directly after "Products Page Title:", Ive been stareing at it for a while now but I really dont see the problem, and im even using the categories.php from the admin part of the contribution and still the same error. And help would be appreciated.



    ZDP Media Group.