Jump to content

jwen

Members
  • Content count

    57
  • Joined

  • Last visited

Posts posted by jwen


  1. error info of "paypal IPN" under "admin -> Customers".

     

    the error messenger as below:

    Status-> All

    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

     

    select p.txn_id, p.parent_txn_id, p.paypal_id, p.txn_type, p.payment_type, p.payment_status, p.pending_reason, p.mc_currency, p.mc_fee, p.payer_status, p.mc_currency, p.date_added, p.mc_gross, p.payment_date from paypal as p order by p.paypal_id DESC limit -20, 20

     

    Status-> Completed

    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

     

    select p.txn_id, p.parent_txn_id, p.paypal_id, p.txn_type, p.payment_type, p.payment_status, p.pending_reason, p.mc_currency, p.mc_fee, p.payer_status, p.mc_currency, p.date_added, p.mc_gross, p.payment_date from paypal as p where p.payment_status = 'Completed' order by p.paypal_id DESC limit -20, 20

     

    Status-> Pending

    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

     

    select p.txn_id, p.parent_txn_id, p.paypal_id, p.txn_type, p.payment_type, p.payment_status, p.pending_reason, p.mc_currency, p.mc_fee, p.payer_status, p.mc_currency, p.date_added, p.mc_gross, p.payment_date from paypal as p where p.payment_status = 'Pending' order by p.paypal_id DESC limit -20, 20

     

    The other error messengers are similar. I'v tried to reinstalled and checked the code couple times but still no luck. Iv already made a post seeking for help but that did not help a lot and i have to try again and post here looking for luck. The oringinal post link here. Please anyone help! I dont wanny give it up. Thanks a lot!

     

    Regards,

    jay


  2. What a fantastic layout! I love the way u display your images!! If u dont mind can u show me which contribution do that thing or i have to do it manually please?

     

    Basically, play around with the numbers in IE first. Get it to look good with IE by changing the height to a higher number. see mine is 96.

    Then, once IE looks good, you can set it up to resize correctly in Firefox by changing the "i" variable. Mine is set to 8, play with yours.

     

    Thanks Chris! I tried with different number but nothing seems change. I think the 'over size' image produces the problem.

     

    Also, may i recommend making your product images smaller? My screen resolution is 1280x1024 and the pic took up my whole page. for my store, i use 640x480 size pics, this is a good size... Or simply let the autothumbnailer do the work by setting a width and height specification in your image definition. I would show you how, but my code is completely different than the stock page because I have additional contribs installed.

    Thanks for your recommendation. My store currently beening tested only. I will resize all my images after its open. I just trying to find out a solution whether the problem can be fixed. Then sometimes we need to display really large images it will do the job. But I do appreciate your images layout! :thumbsup:


  3. Hi! I installed the great contribution n everything works fine except for using different explorers. It works perfectly in FireFox but a little bit problem when using IE. In IE when click the thumbnails it does display the actuall pixel image but without the scroll bar even the image is bigger than the screen. Any idea please?

    you may try to access the link by yourself by clicking the right handside image. Many thanks!


  4. Hi! I just installed the latest PWA. Normal procedure goes well, but when uses an existed email address it produce an error page: "Not Found

    The requested URL /~toustar.co.uk/login.php/login/fail/reason/An+account+already+exists+for+the+email+address+<i>test@test.com</i>.++You+must+login+here+with+the+password+for+that+account+before+proceeding+t

    o+checkout. was not found on this server."

     

    Also, after the order being proceeded checkout_success.php can not display.

     

    Any idea whats wrong with that please! Thanks a lot!

     

    Regards,

    jay


  5. I hadn't forgot about you. I just haven't had the time. But I looked at the file and made thenecessary changes. It works fine in my shop now. It should work in yours as long as you have V 2.5.5 installed.

     

    Jack

     

    Thanks a lot Jack! I really really appreciate for your help! I didn't mean u forgot about me, I just felt sorry to trouble u time and time again.

     

    Your new moded file received. It works fine, everything ok now.

    I compared the file you moded and the one I did and I found is my fault to replace a similar wrong part of code which produce the problem. Sorry about that!

     

    Very thanks again!

     

    Regards,

    jay


  6. Hi Jack, Thanks for your file, though it still not work.

     

    I tried to remember whats different from the oringinal mod instruction, and the only thing is when I followed the step "CHANGES TO ALL FILES" in file "Install_Catalog.txt", lines of two file(advanced_search_result.php and advanced_search.php) to be moded comes not as exact the same as:

    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
    <title><?php echo TITLE; ?></title>

    but one line more included like:

    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <title><?php echo TITLE; ?></title>

    Code of the two file needs to be moded is exactly the same, while I dont know how to deal with it and just directly replaced them with the code:

    // BOF: WebMakers.com Changed: Header Tag Controller v2.5.2
    // Replaced by header_tags.php
    if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
     require(DIR_WS_INCLUDES . 'header_tags.php');
    } else {
    ?> 
     <title><?php echo TITLE; ?></title>
    <?php
    }
    // EOF: WebMakers.com Changed: Header Tag Controller v2.5.2

    Not sure if that make any difference, or just lost the support of SSL for advanced search? The advanced search function seems ok. I dont know whether these change make something to do with the problem of my categories.php file.

    Anyway, really appreciate your help! Thanks!

     

    Regards,

    jay


  7. On line 75, before

    //HTC BOC

    add this line

    		 $sql_data_array = array('categories_name' => tep_db_prepare_input($categories_name_array[$language_id]));

    . There was also another problem with the display part of the file but I can't test it right now. I will send you the changed file. Try it with the above change only and then the changed file if that doesn't do it. If neither work, let me know what the problem is and I will take a closer look.

     

    Jack

     

    Thanks for bearing my question!

     

    I try add the one line code above in my categories.php file, but it makes none difference.

    Not received the changed file yet, gonna try it when got it. Thanks again!

     

    Regards,

    jay


  8. Hi Jack, Thanks for the contribution! Its a wonderful tool indeed.

     

    I installed the latest version (Header Tags Controller v2.5.5 complete) couple days earlier. But now I found my "Catalog" section of the administration panel can not display. After replaced back a clean categories.php file it works, then I switch back the modified one and found its the only 'Categories/Products' (under 'Catalog' section) part can not be displayed.

     

    The problem should rely on the admin/categories.php file, but Im too new to php to sort it out anyway. Any help please!

     

    My store almost a clean one, two mods installed before HTC, but that seems nothing to do with the problem.

    Mods installed:

    Ultimate SEO URLs v2.1c

    World Zones v1.9A


  9. I think its nothing to do with the AttributesWizzard contribution because the problem relied on the admin/categories.php file. Displays any other sections (under 'Catalog' of admin panel) is fine (including 'Manage Price Lists' and 'Product Options') except for 'Categories/Products' section. Currently Im still wondering wots wrong it relied on, but I know it relates to the mod (Header Tags Controller v2.5.5) i installed earlier.


  10. Hiya, I just installed ur hack and found my "Catalog" section of the administration panel can not display. I followed the instructions step by step and checked several times but still doubt whats wrong. Any help please!

×