Latest News: (loading..)

shuffled

Members
  • Content count

    27
  • Joined

  • Last visited

About shuffled

  • Birthday 04/12/1973

Profile Information

  1. Receiving the following on regular account creation. Double checked my 14a, 14b, and 14c instructions and they match the install instructions. 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 '1,1' at line 1 insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, valid_address, personal_details_valid) values ('3', '0', now()),1,1 Code that was used on create_account.php: // social login start tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, valid_address, personal_details_valid) values ('" . (int)$customer_id . "', '0', now()),1,1"); // social login end Facebook and Google logins both work. Thank you for the contribution!
  2. I downloaded and installed this contribution without any problems. :thumbsup: Does anyone know how to limit what products get included in the feed? Say, I just want to include 2 out of 3 categories, is it possible to exclude the third category? If so, what file(s) should we look at?
  3. Jim, My hosting provider included the package with my hosting account. It looks like they install version 2.2ms2. I'm going to assume that this is prior to the RC versions and begin the process of upgrading. *sigh* Thanks, Doug
  4. Jim - I sat down last night to start going through everything, and while my Admin panel loaded and I could access the Products Specifications in the configure tab, I could not access it in the Catalog tab. I also cannot access Categories/Products in the Catalog tab. On both, the file stops short at the same line... For products specifications, the address bar reads /myadminfoldername/products_specifications.php?........ and it ends at: <!-- body_text //--> <td width="100%" valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading">Groups</td> <td class="pageHeading" align="right"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="40"></td> <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="smallText" align="right"> <form name="search" action="http://mywebaddress/./myadminfoldername/products_specifications.php?osCAdminID=notpostingthis" method="get">Search for Group: <input type="text" name="search"> And the Categories / Products loads the same way and ends at the same line: <!-- body_text //--> <td width="100%" valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading">Categories / Products</td> <td class="pageHeading" align="right"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="40"></td> <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="smallText" align="right"> <form name="search" action="http://mywebaddress/./myadminfoldername/categories.php?osCAdminID=notpostingthis" method="get">Search: <input type="text" name="search"> Any ideas on where I might have gone wrong? Im not able to locate anything in "beyond compare" and I looked for any files I may have missed when I FTP'd the new files via FileZilla. The catalog side works great by the way. Those that I let "peak" at the site really like the look of your add. Doug
  5. Jim, Thanks for the heads up. The error was definitely where you said it would be... From my script guy... "In the admin/includes/boxes/catalog.php file, when the array statement for the product specifications link was added, the " ); " from the more_catagories statement should have been replaced with " <br>' . " The " ); " in the more_catagories statement was throwing the error. Once I replaced it with the " <br>' . " the admin was working." Thanks again.. Doug
  6. I pulled up both tables in myphpadmin and under maintenance checked both tables and they check out OK. My script guy did a "view source" from the Admin panel and he says it looks like the script stops short for some reason. Here is what I see: Below is the code from the "view source". Note I changed my domain name, admin folder name, and OSCADMINID number in case that could be used against me... <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html dir="ltr" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>osCommerce Online Merchant Administration Tool</title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="SetFocus();"> <!-- header //--> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><img src="images/oscommerce.gif" border="0" alt="osCommerce" title=" osCommerce " width="204" height="50"></td> <td align="right"><a href="http://www.oscommerce.com" target="_blank"><img src="images/header_support.gif" border="0" alt="Support Site" title=" Support Site " width="50" height="50"></a> <a href="my_address/./"><img src="images/header_checkout.gif" border="0" alt="Online Catalog" title=" Online Catalog " width="53" height="50"></a> <a href="my_address/./my_admin_folder/index.php?osCAdminID=a_number_im_not_posting"><img src="images/header_administration.gif" border="0" alt="Administration" title=" Administration " width="50" height="50"></a> </td> </tr> <tr class="headerBar"> <td class="headerBarContent"> <a href="my_address/./my_admin_folder/index.php?osCAdminID=a_number_im_not_posting" class="headerLink">Administration</a></td> <td class="headerBarContent" align="right"><a href="http://www.oscommerce.com" class="headerLink">Support Site</a> | <a href="my_address/./" class="headerLink">Online Catalog</a> | <a href="my_address/./my_admin_folder/index.php?osCAdminID=a_number_im_not_posting" class="headerLink">Administration</a> </td> </tr> </table><!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="125" valign="top"><table border="0" width="125" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <!-- configuration //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='my_address/./my_admin_folder/configuration.php?gID=1&selected_box=configuration&osCAdminID=a_number_im_not_posting'"> <a href="my_address/./my_admin_folder/configuration.php?gID=1&selected_box=configuration&osCAdminID=a_number_im_not_posting" class="menuBoxHeadingLink">Configuration</a> </td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="menuBoxContent"><a href="http://my_address/./my_admin_folder/configuration.php?gID=1&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">My Store</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=2&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Minimum Values</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=3&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Maximum Values</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=4&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Images</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=5&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Customer Details</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=7&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Shipping/Packaging</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=8&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Product Listing</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=9&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Stock</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=10&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Logging</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=11&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Cache</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=12&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">E-Mail Options</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=13&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Download</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=14&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">GZip Compression</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=15&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Sessions</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=8675309&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">More Categories</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=1610&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Products Specifications</a><br></td> </tr> </table> </td> </tr> <!-- configuration_eof //-->
  7. Sorry about the repost, but I realized I posted this on the "old" message thread.... I installed this contribution last night. At first, my catalog did not display correctly, but then we found a stray </table> in the stylesheet (likely my own error). When I logged into my admin side however, nothing shows up except the configuration box. Clicking the links inside the configuration box does nothing. The last item listed in the configuration box is products specifications, but again all links do notyhing. I have all of my files backed up and I used "Beyond Compare 3" to see if I did not "copy" over this code properly. I did not notice anything right away other than two other contributions I have installed which are Easy Populate and More Category Boxes. Thoughts? Doug
  8. I installed this contribution last night. At first, my catalog did not display correctly, but then we found a stray </table> in the stylesheet (likely my own error). When I logged into my admin side however, nothing shows up except the configuration box. Clicking the links inside the configuration box does nothing. The last item listed in the configuration box is products specifications, but again all links do notyhing. I have all of my files backed up and I used "Beyond Compare 3" to see if I did not "copy" over this code properly. I did not notice anything right away other than two other contributions I have installed which are Easy Populate and More Category Boxes. Doug
  9. Well I thought things were great. I am not getting any errors, but my new boxes do not show up on the site at all. I can toggle the default category box on and off with true/false. I can also use the program under the catalog. I have named 3 boxes and clicked the "enable" radio button and selected several categories for each. Even after clicking "update", I do not see the new boxes on the site.
  10. Disregard, thanks to Peter's advice, I went back and downloaded the English version of the file and uploaded both categories_more.php files and the error went away.
  11. I believe I screwed up my install, though the instructions seemed pretty straightforward. I am not a programmer, so keep your responses simple please. After modifying my files and then importing the sql file, I logged into my admin and went to "more categories" under the catalog tab and go this error: 1146 - Table 'chipzonecatalog.categories_more_languages' doesn't exist select * from categories_more, categories_more_languages where enabled = 1 and languages_id = '1' and box_id_language= '1' [TEP STOP] Any help would be greatly appreciated!
  12. Brian, I applied the one code correction and my test went through. I had a friend of mine on his computer do a test with his card and it processed fine. Im assuming I am ok now. 111 pages in here and without knowing code, its hard to decipher what it is I do and do not need besides having done everything listed in the install guide. Thanks for the addon! Its a lifesaver for someone like myself with no coding experience. Doug
  13. Brian, Thank you for the response & the program. Im sure Im going to enjoy it once I figure things out! Were you referring to this fix: require(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; $order_totals = $order_total_modules->process(); // load the before_process function from the payment modules $payment_modules->before_process(); Thank you Doug
  14. I set everything up (I thought) to directions. I ran the WPP_Diagnostics program and results were: ---------------------------------------------------------------------- Paypal Website Payments Pro Diagnostics Program by Brian Burton (dynamoeffects) Basic Tests Using at least PHP 4.3.0? Yes Does your store have an SSL certificate installed and working? Yes Is cURL installed? Yes Does cURL work? (Simple HTTP test) Yes API Certificate installed? Yes API Certificate directory protected? Yes API Username in place? Yes API Password in place? Yes XML Document "doDirectPayment.xml" exists? Yes XML Document "doExpressCheckout.xml" exists? Yes XML Document "getExpressCheckoutDetails.xml" exists? Yes XML Document "setExpressCheckout.xml" exists? Yes XML Document "transactionSearch.xml" exists? Yes Advanced Diagnostics Able to connect to PayPal through cURL? Yes Received a valid response? Yes Did PayPal respond without errors? (If not, errors are below) Yes Success! Congratulations! This contribution appears to be correctly installed on your store! Please note that if you're still having problems with your installation, it is most likely because you didn't completely integrate all of the code. ------------------------------------------------------------------------ I ran a test transaction with my wife's card on a test product I set up for $1. I had the following error returned to me on the site: Warning: Invalid argument supplied for foreach() in /home/shuffled/public_html/store/includes/modules/payment/paypal_wpp.php on line 977 Warning: Invalid argument supplied for foreach() in /home/shuffled/public_html/store/includes/modules/payment/paypal_wpp.php on line 885 Warning: Cannot modify header information - headers already sent by (output started at /home/shuffled/public_html/store/includes/modules/payment/paypal_wpp.php:977) in /home/shuffled/public_html/store/includes/functions/general.php on line 33 Anyone have a similar problem? Im sure I missed something on the install, but Im a newbie so what did you expect. This is my first run at any sort of script or programming. Thanks, Doug
  15. Thank you Glen for your help.